Monthly Archives: October 2013

Trick or Treat?

Posted on October 30, 2013 by

This is Halloween…  This is Halloween… Seems to me that Halloween is not just for kids.  Let’s go to your co-workers’ desk and say “Trick or Treat”!  If you do not get the Treat, you may do the following Trick … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Open an embedded Excel file during a slide show in PowerPoint?

Posted on October 27, 2013 by

Well, this is not an Excel Tips at all… but it’s really nice to know. Have you tried to open an embedded Excel file in a slideshow of PowerPoint, but failed…?  You may probably go back to Normal View and … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | 11 Comments

Working with Objects

Posted on October 20, 2013 by

From a simple textbox, a rectangle to a chart, you may have experience in moving/resizing/aligning or even selecting multiple objects in excel.  It could be really time consuming and the result may not be good looking still. :O Have you … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , | Leave a comment

Convert unit of measurement from one system to another system

Posted on October 19, 2013 by

如何在EXCEL轉換量度單位? Have you ever wanted to convert Degree Celsius to Degree Fahrenheit or Meter to Mile in Excel? Yes, I did.  What I did was to first Google the formula for such conversion, and then apply the formula manually in … Continue reading →

Rate this:

Posted in Formula | Tagged | Leave a comment

Fill in the blanks – quickly

Posted on October 12, 2013 by

How to fill up all the blank cells in a Table in less than 1 minute??? The table on the left is a typical output from Pivot Table.  The blank cells help to make the table more “reading-friendly”.  However they … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | 7 Comments

Do you need TIME?

Posted on October 7, 2013 by

To convert [hour:minute] into number of hours quickly. If you are working in HR field, you may need to calculate wages for part-time staff whose salary is paid on hourly basis.  So you need to convert 8:45 (8 hrs 45 … Continue reading →

Rate this:

Posted in Formula | Tagged | 2 Comments

Quickly highlight the differences in two columns – Go to Special

Posted on October 6, 2013 by

There are many ways to find out the cells in column B which are different from the cells in column A, e.g. using Conditional Formatting, Using formula in column C.  These methods require some knowledge in Formula.  Nevertheless, It could … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Another useful tips with Go to Special – Visible cells only

Posted on October 3, 2013 by

This is an extension of the previous post that talks about Go to Special -> Visible cells only Apart from Copy ONLY unhidden rows/columns, another situation we used to run into is probably deleting or modifying hidden cells unintentionally.  Sound … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment