This is first part of 2 part series on conditionally formatting dates in excel.

Conditional formatting is a very useful feature in Excel. You can use Conditional formatting to tell excel how to format cells that meet certain conditions. For eg. You can use conditional formatting to show all negative values in a range in red color. Today we will learn how to use conditional formatting to format dates.

Sales reports and dashboards are very common in any company. There are several ways in which you can visualize sales data to understand the trends and sales performance. So in November, I have asked you to visualize sales data using sample data. The visualization challenge #2, sponsored by Zoho Reports generated a huge buzz around the community and fetched 32 incredible entries. The response was so overwhelming that it took me almost 24 hours to write this post. Thanks everyone for participating and making this a huge learning experience for everyone. Personally I have learned several useful dashboard and charting tricks. I will be sharing some of these lessons with all of you in the coming weeks.

Ah, you thought I will let you go to the next decade without a “year in review” post? No so fast my friend, not so fast.

[This post is a bit long by our standards, but full of gooey excel goodness. So get a cup of coffee or choco and get going]

And if you are in a rush, here is my wish – Happy New Year 2010 🙂

Excel is very good for keeping track of your investments. Due to its grid nature, you can easily create a table of all the mutual fund holdings and monitor the latest NAVs (Net Asset Values) to see how your investments are doing. A while back we have posted a file on tracking mutual funds using excel. Today we are going to release an upgrade for that file.

Read the rest of this post to understand how this template works and download the free template.

Lets celebrate these holidays in PHD Style. By learning few excel formulas that you can use to find out dates for some of the popular public holidays like – labor day, memorial day etc. When is Labor Day (US) in 2010? Labor day (the US variant) is celebrated on first Monday of every September. It […]

Christmas and New year have always been a magical time for us. Even though we end up being in 2 different countries for most of the Christmases, we always cherish the time. It has a special romantic significance too, I proposed to Jo shortly after new year in 2001 (and did it almost everyday until […]

Have you ever wondered how to print excel sheets in one page across? so that when you print a large excel spreadsheet the output can be read one page after another. We can use the print settings in Excel to do this very easily. In this episode of quick tips we will learn how to do this with in 5 seconds.