Welcome to Chandoo.org. New here?

Thank you so much for visiting us & taking first step to become awesome in Excel. Please use below links to navigate our site.

Homework: Can you extract dates from text?

Homework: Can you extract dates from text?

So who is up for a challenge? Can you use only formulas and extract dates buried inside text?

  1. Download this file.
  2. In column C, write a formula such that you can extract the date in column B
  3. If you succeed, post your solution here as a comment.
  4. If you fail, drink some coffee, start afresh.
Continue »

One race, Every medalist ever – Interactive Excel Visualization

One race, Every medalist ever – Interactive Excel Visualization

During London 2012 Olympics, Usain Bolt reached the 100mts finish line faster than anyone in just 9.63 seconds. Most of us would be still reading this paragraph before Mr. Bolt finished the race.

To put this in perspective, NY Times created a highly entertaining interactive visualization. Go ahead and check it out. I am sure you will love it.

So I wanted to create something similar in Excel. And here is what I came up with.

Continue »

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

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.

Continue »

Formula Forensics No. 026 – Highlight Only Duplicate Entries

Formula Forensics No. 026 – Highlight Only Duplicate Entries

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

Continue »

Sorting values in Olympic Medal Table style [Quick Tip]

Sorting values in Olympic Medal Table style [Quick Tip]

It is Olympic season. Everyone I know is tracking the games and checking their country’s performance. One thing that we notice when looking at medal tally is,

A single Gold medal is worth more than any number of Silver medals. Like wise, a single Silver medal is worth more than any number of Bronze medals.

So, when you look at the ranking of countries, you see countries with single Gold medal higher up than countries with lots of Silver and Bronze medals (but no Gold).

Continue »

Excel Salary Survey Dashboards – Choose the winner [poll]

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

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

Making your dashboards interactive [Dashboard Essentials]

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.

Continue »