Monthly Archives: September 2014

Are you sure you have input a date correctly in Excel?

Posted on September 28, 2014 by

Although they sound like basic questions, I am quite surprised that many colleagues are not aware of the different ways to input date in Excel “correctly”.  I would like to understand the situation of other Excel users by putting a poll … Continue reading →

Rate this:

Posted in Excel Basic | Tagged | Leave a comment

2D SUMIF with two variables – one on column and one on row

Posted on September 20, 2014 by

SUMIF is a commonly used function to give you sum of a range that meets a specific criterion.  For the example above, if you want to know the total expense of Department 1 in Jan, you can use SUMIF: The Syntax … Continue reading →

Rate this:

Posted in Formula | Tagged , , , | 10 Comments

Clear or Delete? A hassle-free way to clear everything in a cell

Posted on September 13, 2014 by

Do you have a habit of right-click a cell and Delete it rather than pressing the “Delete” button on keyboard? If you do have this habit, I guess you possibly are frustrated by the following experience before:

Rate this:

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

How Excel formula can save your time?

Posted on September 6, 2014 by

Extract number from a text string This post is about two things: How a poor system set up could drive you crazy? Why being good in Excel could save you lots of time in workplace? Another real work example.  I was … Continue reading →

Rate this:

Posted in Formula | Tagged , , , , , , | 4 Comments