fbpx
Login to online classes

Welcome to Chandoo.org.
My mission is to make you AWESOME in your work.

Get your FREE Excel Book
Join my Excel Course
Read Tips & Tricks
Welcome message from Chandoo
Watch welcome message

Hello, Namaste & Kia Ora. Welcome to Chandoo.org. 

My name is Chandoo. My mission is to make you awesome in Excel and Power BI.
I do this by sharing Excel & Power BI tutorials, examples, tips, videos and articles on this website. I live in Wellington, New Zealand with my beautiful wife Jo & our twins Nishanth & Nakshatra. Take a minute to browse various topics of the site to see how I can help you.

Thank you and welcome.

Remove duplicate combinations in your data [quick tip]

By now, we know how to remove duplicates from data. You can use the Remove Duplicates button to do that.

But do you know that we can use remove duplicates button to get rid off duplicate combinations too?

Remove duplicate combinations – Tutorial

To remove duplicate combinations in your data, just follow below 4 steps:

  1. Select your data
  2. Click on Data > Remove Duplicates button
  3. Make sure all columns are checked
  4. Click ok and done!

See this demo:

Read This »
August 7, 2015

CP041: 6 charts you’ll see in hell – v2.0

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | Spotify | RSS

In the 41st session of Chandoo.org podcast, Let’s take a trip to data hell and meet 6 ugly, clumsy, confusing charts. I am revisiting a classic Chandoo.org article – 6 Charts you will see in hell.

What is in this session?

In this podcast,

  • Quick announcement about Awesome August
  • 6 charts you should avoid
  • 3D charts
  • Pie / donut charts with too many slices
  • Too much data
  • Over formatting
  • Complex charts
  • Charts that don’t tell a story
  • Conclusions
Read This »
August 6, 2015

Save time with custom ribbons in Excel [tutorial]

A significant portion of our time in Excel is spent navigating between various ribbon tabs and clicking buttons. Wouldn’t it be better if you can combine all the frequently used features in to one ribbon? Something like above:

Read on to learn how to create, edit and share custom ribbons in Excel.

Read This »
August 5, 2015

Calculate sum of top 10 values [formulas + homework]

Analyzing top n (or bottom m) items is an important part of any data analysis exercise. In this article, we are going to learn Excel formulas to help you with that.

Let’s say you are the lead analyst at a large retail chain in Ohio, USA. You are looking at the latest sales data for all the 300 stores. You want to calculate the total sales of top 10 stores.  Read on to learn the techniques.

Read This »
August 4, 2015

How to highlight overdue items

We, adults can’t escape three things:

  1. Deadlines
  2. Demanding bosses (replace with customers or nagging spouses or naughty kids)
  3. Taxes

While I can’t help you with demanding bosses or taxes, when it comes to deadlines, I have the right tool for you.

A tracker that highlights all overdue items so that you know where to focus your attention.

Let’s learn how to use awesome powers of Excel to find-out which items are due. You can apply these concepts to nail down over due invoices, pending project tasks or scheduling workforce.

Read This »
August 3, 2015

How to create dynamic sparklines for latest 30 days

Sparklines are fun and very insightful. They are easy to create, easy to maintain and fit into any dashboard.

But there is one tiny problem with them. Usually we have a lot of data, but we don’t to visualize all of it. We just want to visualize latest 30 days trend or last 12 months trend or QTD or something similar. What then?

In this video, learn a powerful and very simple way to create dynamic sparklines using Excel.

Read This »
August 2, 2015

Clean data quickly with Flash Fill

Excel has many powerful & time-saving features. Even by Excel’s standard, Flash Fill is magical. Introduced in 2013, Flash Fill is a rule engine to Excel’s fill logic. Every time you type something in a cell, Excel will try to guess the pattern and offers to fill up the rest of cells for you. That is some serious time saving magic.

Let’s understand what Flash Fill is and few sample use cases.

Read This »
August 1, 2015

CP040: Intro. to Power Query – What is it and how to get started – with Miguel Escobar

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | Spotify | RSS

In the 40th session of Chandoo.org podcast, Let’s talk about Power Query. I have the pleasure and fortune to catch up with Miguel Escobar (who along with Ken Puls runs PowerQuery.Training website) and talk about this very exciting piece of technology and how it can make our life simpler.

What is in this session?

In this podcast,

  • Welcome
  • Miguel’s introduction, background and current projects
  • What is Power Query
  • How to install it
  • Sample use cases of Power Query
  • What is Power BI
  • Resources for learning Power Query – Books & Courses
Read This »
July 30, 2015
Click for more articles...

Latest Video

for more videos…

Learn Excel Step by Step

Everything from Power Query to Dashboards, Shortcuts to Formulas, Pivots to Charts in one course.

Topics

Formulas


Beginner
Tables & Structural Referencing
Cell referencing
Excel operators
IF

Intermediate
SUMIFS, COUNTIFS
XLOOKUP NEW
VLOOKUP
INDEX + MATCH lookups

Advanced
Multi-condition lookups
Array Formulas
OFFSET
INDEX

Lists
100+ Excel Formulas list
Top 10 formulas
15 Everyday formulas

Challenges & Home work
Excel Homework

Pivot Tables & Data Analysis


Beginner
Excel Pivot Table Tutorial
Multi-table pivots with data model

Advanced
Advanced Pivot Tables
Distinct count in Pivots
Ranking values in Pivots
GETPIVOTDATA
How to use slicers

Lists
35 shortcuts & tricks for data analysis
Top 10 pivot table tricks
15 quick & powerful ways to analyze business data

Resource
Pivot Tables Page

Charting


Basics
How to pick right charts
Why bar charts should start at 0
Add a line to column chart
Correlation vs. Causation

Examples
Hand-drawn charts
Budget vs. Actual chart
Interactive charts

Chart types
Histograms & Pareto charts
Forecasting with charts
Gantt chart
Funnel chart
5 star chart
Indexed charts
Panel charts - Small multiples

Advanced
Target vs. Actual progress - Biker on a hill chart
Stacked chart with indicators
Cropped chart - when some values are too big
Jitter plot
Joy plot
Step chart
Dynamic chart with check boxes

Lists & Tricks
Charting shortcuts & tricks
Using shapes in charts
Awesome chart titles with this trick
Use chart themes and styles
Use selection pane to work with charts faster

Power BI

More Topics

Excel & Power BI for you

What people say about Chandoo.org

A relative told me about your website since I need help creating pivot tables, I learned how to do it in a matter of minutes thanks to your tutorial. Where have you been all of my excel troubled life, I look forward to viewing your videos on youtube as well as on your site. You are going to make me EXCELLENT at Excel!
Soulful Sista
Excel Sister
Hi Chandoo, I just want to say I really appreciate your Excel tutorials and all your hard work that it took to compile the huge library of content. Your site has helped me gain a better understanding of Excel which has helped me in my job. You are helping the world!
Felix H
Accountant
Throughout my life as an administrative assistant; your site has been invaluable to me. And now that I’m a recruiter; it’s still an amazing resource for when I need to teach someone something quickly. You are a friggin’ Rock Star!!! Thank you for everything you do.
Jason S
Recruiter

Courses for you

training-calendar-view

Excel School

Learn how to work with data, make calculations, pivots, create amazing charts and powerful dashboards from scratch using Excel School + Dashboards program. Suitable for analysts, managers or professionals who need to use Excel often.

Excel School
vba-classes-from-chandoo

VBA Classes

Use VBA to automate your tasks and build powerful spreadsheet based apps. In this course, learn all about how to program with VBA, how to use the language and object model to your advantage. Suitable for people who build a lot of things with Excel.

VBA Classes
cg2018-games-viz-power-bi

Power BI

Power BI, the newest technology from Microsoft is a game changer. You can build rich, interactive and informative displays for your audience using Power BI. In this course, learn all about Power BI, Power Query and Power Pivot and how to combine them to achieve awesome results.

Power BI

=XLOOKUP(chandoo, on_social_media)

Facebook-f Twitter Youtube Pinterest

Get FREE Excel & Power-BI Newsletter

One email per week with Excel and Power BI goodness. Join 100,000+ others and get it free. 

Yes, sign me up

Get Started

Online Classes

About

Downloads

Twitter Facebook-f Youtube Linkedin-in

© All rights reserved.