Best of Pointy Haired Dilbert – 2009
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 🙂
Track Your Mutual Fund Portfolio using Excel [India Only]
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.
How to Find Dates of Public Holidays using Excel
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 […]
Merry Christmas & Happy New Year 2010
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 […]
Print Worksheets in One Page Across [Quick Tips]
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.
The 1000th Post
It is not everyday that a blog boasts of 1000th post. After blogging for 1999 days ie 5 years 5 months 24 days, finally, this is my thousandth post.
While this is not a real mile stone or anything, I want to use this post to say thanks. Without you, this mile stone means nothing to me. 🙂
Best Charts to Compare Actual Values with Targets – What is your take?
Comparing values is one of the main reasons we make charts. Yesterday we have a post on using thermometer charts to quickly compare actual values with targets. Today we follow up the post with 10 charting ideas you can use to compare actual values with targets. Check out how bullet charts, thermometer charts, traffic lights, gauges, column charts, area charts can help you compare targets with actual performances. A review of best charting options when you need to compare.
Read the rest of the post to see the options and participate in poll.