If you want to make better charts and create lasting impressions, chances are you have heard about Jorge Camoes. He writes at excelcharts.com (previously charts.jorgecamoes.com). I have been reading Jorge’s blog for over 2 years now and have linked to his excellent articles on PHD several times. Jorge also has an Excel Dashboard Training Kit, which teaches us how to make a dynamic and comprehensive excel dashboard. The dashboard training kit is a culmination most of his lessons implemented in a practical way using Excel.

In this article, I review the product and tell you why you should get a copy of it.

Timeline charts are great for providing quick snapshots of historical events. And hardly a day goes by without some one making a cool visualization of a time line of this or that. Time lines are easy to read, present information in a logical manner and mostly fun.

So yesterday, I set out to mimic the iconic gadgets of all time in excel, just for fun. Then it strike me, why not make a visual time line of Microsoft Excel ? So I did that instead.

Do you know that you collapse or expand excel charts? Don’t believe me? Me neither. When I first realized that we can collapse / expand charts without writing any macros or lengthy formulas, I couldn’t wait to share it with all of you. This is such a simple yet powerful trick. See it for yourself.

The trick lies in using group / un-group data feature and carefully aligning charts with the cell grid. The whole process takes just about 2 minutes and produces wow factor worth a week. Go check it, now. Also, a downloadable template is included in the post.

So we are in 2010, dawn of a new decade. In fact everyday is a start of new decade, as my friend Jon reflects on twitter. So what are your plans for this year and decade? As for me, I haven’t really jotted down any new year resolutions. So I am using this post as […]

Along with Excel 2010, Microsoft released a free add-in called PowerPivot. According to MS, PowerPivot gives users the power to create compelling self-service BI solutions, facilitates sharing and collaboration on user-generated BI solutions in a Microsoft SharePoint Server 2010 environment, and enables IT organizations to increase operational efficiencies through Microsoft SQL Server 2008 R2-based management […]

Jennie, a sweet and ambitious lady set out to do 101 things in the next 1001 days. She took the inspiration from Day Zero Project. Not stopping there, she prepared a cute little excel sheet to keep track of all these new year resolutions and sent it to me.

I think this is a swell excel template if you want to keep track of your goals or new year resolutions or just manage a list.

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

Highlighting Repeat Customers using Conditional FormattingIn yesterday’s post we have learned how to conditionally format dates using excel. In this article, you will learn how to use these conditional formatting tricks to highlight repeat customers in a list of sales records.