Monthly Archives: October 2013

Trick or Treat?

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?

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 | 7 Comments

Working with Objects

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

如何在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

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?

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

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

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