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

Latest Tips & Tutorials

Contest: Visualize KPI data

Here is a quick visualization challenge for you.

There are 25 KPIs and each has a base value, current month, corresponding month values. The KPIs also have targets.

The data looks like this:

Download the data:

Click here to download the data for this contest.

Rules for this contest:

Visualize this data using one Excel chart (one chart per KPI is ok too).
You may omit any any data
You can use interactive charts.
Do not use add-ins or VBA to make your charts

Go ahead and make your chart(s).

Read This »

October 23, 2015

CP047: Best Excel tools for Entrepreneurs

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | Spotify | RSS

In the 47th session of Chandoo.org podcast, let’s see how Excel can make you an awesome entrepreneur.

What is in this session?

In this podcast,

Why Excel for entrepreneurs
Key areas of a business owner’s work
- Projects & to dos
- Finances
- Customers & marketing
- Planning & strategy
- Processes & workflows
5 features of Excel that help
Conclusions

Read This »

October 22, 2015

Formula Forensics No. 039 – Find the Cell Address for a value (2D & 3D Reverse Lookup)

Find the Cell Address for a value from a 2D or 3D Range
(2D & 3D Reverse Lookup)

Read This »

October 15, 2015

Formula Forensics No. 038 – Find Which Worksheet a Max or Min Value is located on

Learn how to find which worksheet a max or min value occurs on using this neat formula

Read This »

October 14, 2015

CP046: Gantt charts & project planning using Excel

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | Spotify | RSS

In the 46th session of Chandoo.org podcast, let’s talk about gantt charts and project plans.

What is in this session?

In this podcast,

A brief intro to Excel 2016
What is a Gantt chart?
How Gantt charts can help us?
How to create Gantt charts in Excel
- Using bar charts with invisible series
- Using conditional formatting and formulas
- Using ready-made templates
Resources on Gantt charts & project planning
Conclusions

Read This »

October 8, 2015

Use NUMBERVALUE() to convert European Number format

If you deal with customers or colleagues in Europe, often you may see numbers like this:

1.433.502,50
9.324,00
3,141593

When these numbers are pasted in Excel, they become text, because Excel can’t understand them.

Here is a simple way to convert the European numbers to regular ones.

Use NUMBERVALUE() Function.

Read This »

October 6, 2015

Excel is 30!!! – what was your earliest memory of Excel? [weekend poll]

This week Excel turned 30. As per wikipedia,

Microsoft released the first version of Excel for the Macintosh on September 30, 1985

Let’s celebrate 30 years of Excel by reliving your first memory of it. Share your earliest memory of Excel in the comments section.

Read This »

October 2, 2015

Imagine you are looking customer data like below and want to sort them by performance. If you sort the data by any one column, you will not get full picture of performance. To understand which customers rank low on performance, you need to defined a weighed sort, the kind of sort where you assign weights to each attribute (customer age, recent purchases and rate of returns) and come up with single score to sort them all.

Sounds interesting? Watch below video to understand how to do weighted sorting in Excel.

Read This »

October 1, 2015