Excel Tips & Tricks: Convert Horizontal Data to Vertical & Vice Versa

Category: , , , , , By Aiman Shaharuddin
Just something that I discovered today, while helping out a friend. How can I convert horizontal data into vertical? After googling in the internet, I got the answer:

1> Highlight and copy the desired data (horizontal or vertical)
2> Left click the desired location to copy the data to.
3> Right click >> Paste special
4> Check on the Transpose and OK

And, voila!! your data is transposed.. ^_^
 

Dogs can read too!!

By Aiman Shaharuddin
 

Right or Left Brain

By Aiman Shaharuddin
Are you a left brainer or right brainer? Try to look at the picture below:



So, is the girl turning clockwise or anti-clockwise?

If you think it's turning clockwise, then you use your right brain most. On the other hand, if you see it's turning anti-clockwise, then you are a left brainer. Then, try to change it. (if you can)

At first, I got it anti-clockwise, was able to change to clockwise, but not able to change to anti back. Haha.

What's the difference? Read more about it here.

*correction: I've made the changes, it's supposed to be the other way. Clockwise:Right brain, Anticlockwise:Left brain.
 

"W00t" word of the year!!

By Aiman Shaharuddin
Believe it or not, the word "w00t", spelled with two zeros, is the word of the year 2007 in Merriam-Webster, based on the votes from their visitors:


It's funny but true. Most of the time, this word is used in games especially in World of Warcraft. I think, the gamers must have been plotting something and made it happen. Haha. Good job!!

Example usage: "w00t!! I won the contest!!"


 

Woman 101: Basic to understand woman

By Aiman Shaharuddin
I received a forwarded email today. Something to cheer up the ladies. ^_^


THE SILENT TREATMENT
A man and his wife were having some problems at home and were giving each other the silent treatment. Suddenly, the man realized that the next day, he would need his wife to wake him at 5:00 AM for an early morning business flight. Not wanting to be the first to break the silence (and LOSE), he wrote on a piece of paper,
"Please wake me at 5:00 AM".
He left it where he knew she would find it.

The next morning, the man woke up, only to discover it was 9:00 AM and he had missed his flight. Furious, he was about to go and see why his wife hadn't wakened him, when he noticed a piece of paper by the bed. The paper said,
"It is 5:00 AM .. Wake up."
Men are not equipped for these kinds of contests.


WIFE VS. HUSBAND
A couple drove down a country road for several miles, not saying a word. An earlier discussion had led to an argument and neither of them wanted to concede their position. As they passed a barnyard of mules, goats, and pigs, the husband asked sarcastically,
"Relatives of yours?"
"Yep," the wife replied,
"in-laws"


WOMEN'S REVENGE
"Cash, check or charge?" I asked, after folding items the woman wished to purchase. As she fumbled for her wallet I noticed a remote control for a television set in her purse.
"So, do you always carry your TV remote?" I asked.
"No," she replied,
" but my husband refused to come shopping with me, and I figured this was the most evil thing I could do to him legally."


WORDS
A husband read an article to his wife about how many words women use a day... 30,000 to a man's 15,000. The wife replied,
"The reason has to be because we have to repeat everything to men..."
The husband then turned to his wife and asked,
"What?"


CREATION
A man said to his wife one day,
"I don't know how you can be so stupid and so beautiful all at the same time."
The wife responded,
"Allow me to explain.
God made me beautiful so you would be attracted to me;
God made me stupid so I would be attracted to you!"
 

Sales.. Public sector.. hmmm

By Aiman Shaharuddin
Sigh, just received my assignment. I've been told that I've been assigned into sales in public sector. For the 1st month, I'll be shadowing my mentor, following him around. Right now, I'm trying to request to go into other department if possible.
 

Life goes on..

By Aiman Shaharuddin
It's been a while since I last updated my blog. A lot have happened I think. Haha. Don't know where to start. Oh well, I just finished my training in TeamBlue. At last, 10 weeks of training is done. It was long yet fun. I've learned a lot, made a lot of friends, got to know a few people from IBM. And, tomorrow, I have to start to hunt for jobs within IBM. I'm still not sure where I want to be. Maybe, I have to start my research tonight, to decide where to go. There will be interviews tomorrow with the manager from a few departments. I have to be prepared by then. ^_^
 

Money.. Money.. Money..

By Aiman Shaharuddin
Officially, today I received my 1 month salary. And it's my first. The first half month salary that I received before raya doesn't count. Haha. Anyway, I have to start managing my own money, where I want it to be spent, how I want to spent it, and how much. Haha. Sounds hard. Yes, it is hard, since I want to use some and save some for the future. Haha.

My initial plan was, I want to save 50% of my salary, but it seems that it is a little bit ridiculous. I have to pay for my car, I need money for lunch, shopping, entertainment, gym, gas, etc.... Haha. I'll try to manage myself. Self control is important. It is IMPORTANT!! I'll try my best. Starting with using excel to budget my spending. ^_^
 

Eid Mubarak!!

By Aiman Shaharuddin
Selamat Hari Raya Aidil Fitri. Maaf Zahir n Batin. ^_^ sorry if I said it a bit too late. Haha. This year's raya is a bit short for me I guess and nothing much happened since I don't have any kampung to go to. But, oh well.

On Friday, the day before raya, Me & my mama went to IKEA to shop for some more stuff to put in our house, especially for our unfinished kitchen that has been 1-2 years in production. Haha. But before that, I went to the Post Office to send a package to my dear friend. ^_^ I sent her kuih raya, Jem Tart & Almond London. I hope it will arrive in 1 piece. hehe.

Then, on Saturday, Raya day, we woke up in the morning & went to solat aidilfitri. Then we had our breakfast and we went straight to my grandma's house just nearby. We continue eating a little bit more, then we had the salam2 & maaf2 ceremony, as well as bagi duit raya. haha. As someone who has just received his salary, I gave my sisters RM50 each. So generous of me. Haha. ^_^. Then the day just went on. Nothing interesting.

On Sunday, me & my mama went to IKEA again to buy more stuff. I bought 2 table for my room. At last, I have my own study table. ^_^. but it will be delivered on Monday.

So, actually, eventhough this was my first raya after 4 years of raya at the States. It was OK. But I really missed rayaing at US, with all my friends. haha. It was really fun. ^_^

 

Break Fast at Restaurtant Al-Andalus with Vandy Alums

By Aiman Shaharuddin



It seems the pictures are a bit blurry. Sorry about that. ^_^
 
<< Newer Posts Older Posts >>