星期六的深夜 - 王力宏

Macros in EXCEL

Sometimes, working life can be SUPER boring especially when no job is assigning to you. However, i do appreciate the working experience that i am gaining from G&P company; they are priceless~

The work that i am dealing with now, is more to data analysis and modelling. When we talk about data analysis, that simply means you are dealing with tonnes and tonnes of numbers! And through this internship, i have learned to use Macro function in repeating the steps that i want in Excel. It is awesome! Saving my time!~

EXAMPLE

If let say you are having a range of monthly data from year 1990-2005 and your task is to plot monthly graphs.

---> Macros is of GREAT help in selecting only a certain month that you desired~!

Step 1: Make sure your data is sorted accordingly (by months and years). Now, point your cursor on Jan-90 as shown in Figure 1.

Figure 1

Step 2: Go to “View” and click on “Macros”, then select “Use Relative References” as shown in Figure 2. [NOTE: Do not remove the cursor on Jan-90]

Figure 2

Step 3: Click on “Record Macro…” from “Macros” function. Then, insert a shortcut key in the pop-up menu, let say, Ctrl + “w” as shown in Figure 3. [NOTE: Do not remove the cursor on Jan-90]

Figure 3

Step 4: Highlight rows from Feb-90 to Dec-90, then right click to delete them as shown in Figure 4.

Figure 4

Step 5: Now, point your cursor at Jan-91, then click "Stop Recording" as shown in Figure 5.

Figure 5

Step 6: By pointing the cursor on Jan-91, you may now press on "Ctrl+w" (the shortcut key that you set earlier) repeatedly until your task is done. Finally, only the data for the month of January are selected while the rest of the data are deleted automatically using “Macros” function. DONE~!

***Macros is a very useful function in repeating any task you want. Most importantly, be very certain of your desired starting and ending points***

"You're Gorgeous Just The Way You Are"

This is such an encouraging and educative video~
Thank you bro "Fei Keen" for telling me this~! ^^
This has reminded me to complain less about my life and learn to appreciate more~
I'll REMEMBER that whenever i feel helpless, hopeless, stressed or depressed...
Thanks bro~!!! :)

Only Words...

Words are so powerful..
Sometimes, they can be really wonderful and make you happy..
But sometimes, they can be very harmful and hurt you badly..

Most people that know me, they like to make jokes about me or even tease me..
But i know it well, they do it because they know i won't get angry easily..
But of course, everyone has a limit in accepting jokes..so do i..
Until some extent if i keep quiet about the things that you're saying, that simply means, i'm either not agreeing with your statement, i didn't hear that or i'm simply a bit angry and trying to calm myself down by changing a new topic..
I realised, not many people can understand me in this..eventhough we have been knowing each other for years..

And i always thought, things can be solve only if the problem/uneasy feeling is being told..but things aren't just that simple..
I know, i can be really rude in spilling out my bad feelings sometimes..
And i just did that to 2 person last night..one is my mum and one is YOU..
Well, i should just admit that my EQ is so damn low...i can't help it...

I don't normally spill out my feelings unless i really have to..
This time, i really have to because if i don't, i know i'm really gonna break down in no time..

First of all, sorry mum.. I shouldn't have shouted at you last night when helping you out..i know i always do that because i have no patience in explaining things over and over again while i know you're actually not paying attention.. I'll try my best to change this bad habit.. Sorry..

Secondly, sorry to YOU as i really didn't know that a few sentences can be so hurtful to YOU.. I know, what's done cannot be undone, especially to YOU.. My bad.. (>.<)

Thirdly, i ought to say sorry to Ting as well.. I know i did hurt your feelings a few times in the UK for spilling out my feelings.. I did right? But i must say, you're very patience in dealing with me.. Thank you so much~ Well, i'm gonna be your roommie soon, if i'm ever hurting your feelings again, do let me know k? You know, i like to discuss problems and solve that with you instead of putting it in heart.. :)

Lastly, sorry bro.. I FFK you yesterday night and you knew why... I know you've tonnes to spill out and so do i.. But i really dunno how to say.. Well, i may be a good listener (to you only...maybe?) but not a good spiller.. I know you're very busy in your mega project lately..and i can't get to help you at all..really sorry.. When you're free, just give me a ring.. I promise, i will never FFK you this time.. :)

Alright, that's all for the sorries.. I shall balance out with some thank you(s) too~

THANK YOU Kok Hoong!! You've been really wonderful and had really lessen my burden~ You've always been thoughtful and helpful to me.. Really thank you~! I know you don't like me saying this but i really mean it and wanna say it.. :)

"Fei Keen"~!! You've always showing your concern in knocking on my windows whenever you see me in MSN.. I really appreciate that~ But today, i'm really not in the mood of chatting.. That was why i only chatted for awhile.. Anyway, you're gonna be back real soon~! Do enjoy to the fullest in the UK while you still can lo~ ^^

I'm not sure whether you'll be reading this or not.. But well, i'm really happy in receiving your email today.. What a surprise~! Thanks for the song, the photos and your stories~ I'm so touched that you actually remember me because of that band~ Miss you all so much~!! :)

Kellie, i really wanna say thank you for inviting me to watch the MTV World Stage (Hoobastank rocks!! You're right, that girl was Pixie Lott..i just found that out from the newspaper today..haha) and The Proposal (great movie!!and i'm kinda shocked that you actually forgotten watching that with me and asking me to watch it for the second time..lolz)~ Well, i hope you did had fun for the PAINtball as well~ Oh ya, please forgive me for the stupid things that i did last week (fetching you).. :p See you tomorrow~ :)

Serene, Shea Yeong, Jason, Eeffie and Ken, how i wish you guys are here now with me.. I want Hoegaarden, Kronenberg and Carlsberg Export please....... I'm missing the eating & drinking sessions with you guys so much~!!

Alright..it's time for me to 反省 and also to heal myself.....by dreaming.....