Chandoo.org - Learn Excel, Power BI, Charting, Dashboards and VBA online

Latest Tips & Tutorials

2011 Calendar – Excel Template [Downloads]

Here is a 2011 new year gift to all our readers – a free 2011 calendar template.

(a little secret: just change the year in worksheet “Full” from 2011 to 2012 to get the next year’s calendar. It works all the way up to year 9999)

You can add notes to individual dates or complete month using the excel template very easily. There are 6 different calendar templates in the download file,

* 4 Yearly Calendar Templates with different color schemes.
* 1 Mini Calendar
* 1 Monthly Calendar (prints in 12 pages)

Go ahead and download the calendar files. Enjoy.

Read This »

December 17, 2010

Do you use (or make) Excel Dashboards? Tell us about yourself to win a free training kit

(You can win my latest Excel Dashboard Training kit free, read this post to find out how.)

Over at Jorge’s ExcelCharts blog, he started a very good discussion on Excel Dashboards: Who needs them anyway?.

Jorge has very good experience designing, working on and teaching about dashboards. So he uses all that skill to gaze in to a crystal ball, to understand who needs excel dashboards and why. In this post, I build on his argument and ask you the big question – “If you make or use Excel Dashboards, who are you?”

Read This »

December 16, 2010

6 Christmas Cards in Excel – Download and Spread Joy

Few days back, I have asked you to make a Christmas card in Excel (or any of your favorite festival’s card).

We got 6 entries for this contest. All the entries showed a lot of creativity to come up with beautiful cards using Excel. See the entries, download the excel files & find out who the winner is. Read the rest of this post.

Read This »

December 15, 2010

Excel Links – Next Dashboard Contest Edition

Almost an year ago, we had a memorable dashboard contest on Sales Dashboards. We got 32 beautiful, outstanding, well crafted entries and it was a lot of fun learning new tricks & meeting new members of our community. I am planning to have one more dashboard contest and I need your help.

I need you to suggest a topic for the contest (optional: and give some sample data)

Just drop a comment with your suggestions (and point to source data if any). We will have a dashboard contest on one of those topics.

Read the rest of this post to get some useful Excel related links.

Read This »

December 13, 2010

Mutant Cell Modeling Problem [Homework]

Today’s homework is inspired from an email I got from Simran, I have a mathematical problem, I do not know if it can be solved

Read This »

December 10, 2010

Make Dynamic Dashboards using Pivot Tables & Slicers [Video & Download]

Do you know that Excel 2010 makes creation of dynamic dashboards very simple?

Yes, that is right. Using slicers feature, you can create dynamic excel dashboards from your data in very little time. Today we are going to learn a technique that will help you create a dashboard like below.

Read rest of this post to find out how to construct a dynamic dashboard in Excel & download the example workbook.

Read This »

December 8, 2010

Merge Cells without Losing Data [Quick Tip]

Many of us face this problem. We have some data in a few cells. Either for alignment or structure, we would like to merge the cell contents in to one big cell. But Excel wont help as it cannot merge values from all cells.

Read This »

December 7, 2010

Make a Christmas Card, and you can Win a $50 Gift Card

Christmas is my favorite festival. It has certain magical feel to it. This year, it is going to be even more special, because we have 2 more hilarious, lovely people to share our joy with, not to mention over 16,000 of you to celebrate it with.

So naturally, I was excited when Fred suggested that we have a contest on this in our forums. So here we go.

Read This »

December 3, 2010