Showing posts with label useful tips. Show all posts
Showing posts with label useful tips. Show all posts

Saturday, November 03, 2012

EXCEL COLOURING OF CELLS BASED ON VALUE OF ANOTHER COLUMN OF CELLS

Say if we have the names of students in Column A of the excel spreadsheet and the description of their grades in Column B as follows: “Excellent”, “Pass” or “Fail”. You want the names of the students in Column A to appear “Yellow” if their grades are “Excellent”, “Green” as  “Pass” and “Red” as “Fail”. This is what you do:


Open up Microsoft Excel 2007

Sunday, July 01, 2012

How to determine size of air conditioner needed for Singapore HDB flat?

If you are looking to install or replace an air-conditioner and would like to know what the size of air-conditioner you need, you can follow the following steps:

1) Obtain the dimensions of your room in feet- i.e. length and width

2) Calculate the area of the room in square feet-i.e. by multiplying length and width you have calculated in 1).

Thursday, April 26, 2012

How to request Home Protection Scheme HPS certificate?

If you want to obtain your Home Protection Scheme HPS certificate, please follow the steps below:

a) Log in to your CPF account on CPF homepage
b) Go to "My Requests"
c) Check "Insurance" and then click "Proceed"

follow the next few steps and you should be able to request for your Home Protection Scheme HPS statement online.

Sunday, April 22, 2012

BX Error Code on Blogger

Dear Reader

If you find yourself logged out of your blogger account with a "BX Error code error", you may want to try the following resources which I did when faced with the aforementioned problem:

Wednesday, April 11, 2012

How to create a new image file from combining existing image files for Free?

I am not too good in using Photoshop or other image-editing software but today I manage to create an image from combining other existing image images I have for free. I am proud of this simple feat and wish to introduce this method to anyone who needs to combine several images, enlarge or scale down onto or along with other images.

Saturday, August 06, 2011

Online Video Convertor

I found this online video convertor useful as it can convert videos on websites into a number of formats users want. The website is found here.

Sunday, February 13, 2011

Convert Youtube Songs into MP3, MP4, WMA files Free and Easily

If you have a number of songs on Youtube which you like, how about converting all of these songs into your mp3, mp4 or wma files so that you can listen to them wherever you are?

Tuesday, February 08, 2011

AOL bought Huffingtonpost blog for US $315 million! How much is your blog worth?

Huffington post , world's number 1 blog (Alexa rank is 127, Google Pagerank is 8!) has been bought over by AOL for a whopping US $315 million! Wow, I never know that a blog can be valued at such high price. But Hufffington post, being Huffington post is really an immensely successful blog. Some readers of Huffington post are up in arms for the buy over and I really hope that Huffington post can truly add value to AOL.

Thursday, January 20, 2011

Create your own wedding photo montage using PhotoStory, a Free Software

For brides and bridegrooms to be, creating a wedding photo montage to show to your wedding guests at your wedding banquet is more often a necessity, hence when it comes to creating a wedding photo montage, what does the couple do after getting all the suitable great photos for their wedding photo montage?

Sunday, May 16, 2010

Check Hanyu Shuiping Kaoshi (HSK) results

More and more students in Singapore are taking part in the Hanyu Shuiping Kaoshi (HSK). This test gauges how competency the candidates are in the Chinese language. The test results are recognized internationally and students are tested on their listening, written and cloze passage skills.

If you have taken the HSK test, you can check your results
here.

Monday, May 10, 2010

How to win the $5 million TOTO draw?

Are you ready to win the $5 million TOTO lottery draw this coming Friday? Well, for today's draw, someone, ya 1 lucky person has bagged the cool $3 million top prize! Do not be disheartened if you are not this super-lucky soul, you could be the winner of the $5 million TOTO draw this coming Friday?

So how to win the coming TOTO lottery draw? Well, you would need to be unbiased and pick some numbers that are really unique. I can tell you for most people, their minds will still choose a few of their favorite numbers no matter how random they want their pick of the numbers to be. So how to choose more random numbers that fall outside the psyche of your brain? Well, the simplest and easiest way is to use an automated computer program.

You do not need to invest in a lot of money to buy a lottery program or a TOTO program to generate your lucky numbers. If you have a computer, most likely you would have the Microsoft Excel Program and in that program, there is a random function which can help you to generate random numbers at absolutely no cost at all. Here is the function to type in the formula bar of an Excel spreadsheet:

= Int(randbetween(1,45))

Insert this function 6 times to select 6 random numbers for the minimum bid at $0.50 for the TOTO draw and who knows, you could take home the $5 million this coming Friday.

And if you do win this amount using my tip above, do not forget me loh!

Total Pageviews