All articles with 'downloads' Tag

Yummy WAFFLE chart in Power BI

Published on Sep 3, 2019 in Power BI, Power Query
Yummy WAFFLE chart in Power BI

Waffles are yummy, Power BI is awesome. The combination is going to send your taste-buds on a cruise. Learn how to make a yummy waffle chart in Power BI.

Continue »

Job Title Matching Problem [Excel Homework]

Published on Aug 30, 2019 in Excel Challenges, Power Query
Job Title Matching Problem [Excel Homework]

Howdy folks. Almost the end of August here. Let’s wrap it up with a nice little challenge, inspired from my recent consulting gig. Say you are looking at few job titles that look similar and want to match them to correct title.

Continue »

Free Excel Risk Map Template

Published on Aug 28, 2019 in Charts and Graphs, Project Management
Free Excel Risk Map Template

Risk comes from not knowing what you are doing. Warren Buffet If you ever ask a project manager what they are up to, they will tell you “I have no idea“. So risks are quite common in project management. That is why I made this awesome free Excel risk map template to keep track and […]

Continue »

How to extract common values in two tables? – Power Query Tip

Published on Aug 19, 2019 in Power Query
How to extract common values in two tables? – Power Query Tip

We, humans like to compare. Whether we are on Facebook or workbook, we want to compare. So how do you compare two tables and extract common values? Simple, use Excel Power Query. It can merge (a la join) tables and give you the common values.

Continue »

How-to highlight maximum value in Excel charts? [Quick tip]

Published on Aug 7, 2019 in Charts and Graphs
How-to highlight maximum value in Excel charts? [Quick tip]

Ever wanted to highlight maximum value in charts? Then this tip is for you.

Continue »

Pivot Tables from large data-sets – 5 examples

Published on Aug 2, 2019 in Pivot Tables & Charts
Pivot Tables from large data-sets – 5 examples

Let’s say you are starting at a large dataset with multiple columns. You need to make a pivot report from it for a client or manager. How would you go about it?

Continue »

How to conditionally format visuals in Power BI?

Published on Jul 30, 2019 in Power BI
How to conditionally format visuals in Power BI?

Do you know that you can apply conditional formatting rules to visuals in Power BI? In this post, let’s learn how to conditionally format visuals in Power BI. Something like this:

Continue »

Tour de France – Distance & Pace over time – Radial Charts

Tour de France – Distance & Pace over time – Radial Charts

This is an Excel replica of excellent Tableau visual on Tour de France winner data made by Marc Reid.

Last week I saw a stunning visualization on Tour de France using radial charts. I wanted to replicate it in Excel. So here we go.

Continue »

Make info-graphics with shape fill technique [Charting Tip]

Published on Jul 11, 2019 in Charts and Graphs
Make info-graphics with shape fill technique [Charting Tip]

This is a quick, fun and elegant way to make impressive charts. You can easily create info-graphic style charts in Excel using shape fill technique. Something like this:

Continue »

How to predict cricket scores [Excel + Machine Learning]

Published on Jul 2, 2019 in Analytics, Charts and Graphs, Learn Excel
How to predict cricket scores [Excel + Machine Learning]

Can we predict cricket match score in Excel? Using machine learning, ensemble modeling, multiple regression and Excel formulas we can. This tutorial explains how.

Continue »

Combine multiple Excel files using Power Query [Full example + download]

Published on May 30, 2019 in Power Query
Combine multiple Excel files using Power Query [Full example + download]

Say you want to combine multiple Excel files, but there is a twist. Each file has few tabs (worksheets) and you want to combine like for like, ie , all Sheet1s to one dataset, all Sheet2s to another dataset…

To make matters interesting each sheet has a different format.

What now?

Of course Power Query to the rescue.

Continue »

How to fake “Key influencers chart” in Excel?

Published on May 1, 2019 in Charts and Graphs
How to fake “Key influencers  chart” in Excel?

Recently, Microsoft Power BI introduced a very useful visualization, called key influencers visualization. As the name suggests, this is a chart of key parameters that effect a measure or outcome.

For example, you have customer satisfaction rating as a measure. Now you want to know which aspects of your data impact the ratings most? You can create the key influencer visual and Power BI finds all the top ranking influencers (using rules and machine learning).

But can we make it in Excel?

Let’s see…

Continue »

There is an Easter Egg in this Power BI report

Published on Apr 18, 2019 in Excel Challenges, Power BI
There is an Easter Egg in this Power BI report

Its Easter time. At Chandoo.org, I have tradition of publishing Easter Egg hunts since 2009. This is the first time our Easter egg hunt is on Power BI. Changing times, eh?

Continue »

VLOOKUP multiple matches – trick

Published on Apr 16, 2019 in Excel Howtos, Learn Excel
VLOOKUP multiple matches – trick

We all know that VLOOKUP can find first match and return the results. But what if you want all the matches? Use this simple trick instead.

Continue »

Source vs. Use of Funds – 14 charting alternatives

Published on Apr 10, 2019 in Charts and Graphs
Source vs. Use of Funds – 14 charting alternatives

Let’s say you manage a fund or charity. You get money from various places and you use that money for various reasons. How do you tell the story of source vs. uses of funds? In this post, let’s review 14 charting options. Source vs. Use of funds – Sample Data for this problem Let’s say […]

Continue »