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

Latest Tips & Tutorials

How fast can you finish this Excel Hurdles Challenge [Spreadsheet Olympics]

Watching the Olympic athletes run & jump all I could think of is,

What should I eat to jump & sprint like that?
How come I never heard about steeple chase?
Should we really have 3 bullet points in all lists?

But I digress. Coming back, when watching one of those hurdles events, I got an idea as sharp as Chinese table tennis team.

Why not create a hurdles game in Excel to measure how good you are with keyboard?

So ladies & gentleman, let me present you our very own Olympics hurdle run.

Read This »

August 10, 2012

Formula Forensics No. 026 – Highlight Only Duplicate Entries

Today Formula Forensics looks at a formula that Highlights Only the Duplicate Entries in a range.

Read This »

August 9, 2012

Excel Salary Survey Dashboards – Choose the winner [poll]

Recently, we published 66 dashboards visualizing Excel salaries around the world. Each of the contestants have put in great effort and hand-crafted these beauties. Now its time we picked a winner.

How does the voting work?

The voting has 2 components

Readers (that is you) pick a winner and runner-up using online voting.
Judges (2 of them) will also pick winners. Judges vote carries 20% weight.

Read This »

August 3, 2012

Making your dashboards interactive [Dashboard Essentials]

Everyone likes to be in control. Even my 2 year old daughter jumps with joy when she lays her hands on TV remote. She pushes the buttons and assumes it is working. It is another story that we rarely watch TV at home.

By adding an element of control, we can make our dashboard reports fun. Interactive elements like form controls, slicers etc. invite users to play with your dashboard, get involved and understand data by asking questions. That is why I recommend making dashboards interactive.

Today lets understand how you can make dashboards interactive.

Read This »

August 2, 2012

How to make Box plots in Excel [Dashboard Essentials]

Whenever we deal with large amounts of data, one of the goals for analysis is, How is this data distributed?

This is where a Box plot can help. According to Wikipedia, a box plot is a convenient way of graphically depicting groups of numerical data through their five-number summaries: the smallest observation (sample minimum), lower quartile (Q1), median (Q2), upper quartile (Q3), and largest observation (sample maximum)

Today, let us learn how to create a box plot using MS Excel. You can also download the example workbook to play with static & interactive versions of box plots.

Read This »

July 31, 2012

Visualize Excel salaries around world with these 66 Dashboards

Ladies & gentleman, put on your helmets. This is going to be mind-blowingly awesome.

See how many different ways are there to analyze Excel salary data. Look at these 66 fantastic, beautifully crafted dashboards and learn how to one up your dashboard awesomeness quotient.

Read This »

July 30, 2012