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

Welcome to Chandoo.org

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

My name is Chandoo. My mission is to make you awesome in your work. 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 once again.

Latest Tips & Tutorials

Formula Forensics 043: Rankifs or Conditional Rank

Learn how to develop a Conditional Rank or Rankifs formula in Excel

October 19, 2017

How to Distribute Players Between Teams – Evenly

Learn how to use Solver to allocate players evenly to Teams.
A Solver Tutorial.

October 12, 2017

Conditional Formatting – Chart Data Labels

Learn how to conditionally format Chart Data Labels without VBA

October 9, 2017

Histograms & Pareto charts in Excel – tutorial, tips and downloadable template

Time for some statistics and charting fun. Let’s learn all about histograms and Pareto charts in Excel 2016. You will learn

What, why and when?
How to set up and customize histograms
How to use Pareto charts?
How to create dynamic histograms?
Creating histograms in old Excel (2013 or prior versions)

Sounds interesting? Let’s get started then.

October 5, 2017

Find out if a number has repetitive digits [formula homework]

Time for a quick formula finesse check. Let’s say you have a number in A1. What formula can you use to find out if it has duplicate digits.

For example, if A1 has 123405, then answer should be FALSE

and if A1 has 123455, then answer should be TRUE

Go ahead and post your answers (formulas, VBA or M script) in the comments section.

October 3, 2017

D’oh – Visualizing Homer’s favorite sayings in Power BI

Before we begin:

Today is the last day for enrolling in our Power BI Play Date. Don’t miss out on this amazing opportunity to learn, use and benefit from Power BI at your work. Check out my online class and sign up before the doors close at midnight. Click here.

Let’s get our Simpsons on then.

D’oh, How often Homer says his favorite things?

Here is the visualization to explore Homer’s (and other character’s) favorite sayings in 27 years worth of Simpsons episode. Click on the image to play.

September 29, 2017

Keep Calm and Power BI [Breathing Exercise Vizzes]

We are in the midst of my Power BI Play Date course launch. I have opened the enrollments for this program last week and there is a tremendous response to this program. To celebrate the new course launch and show you the lighter side of it, let me share a few breathing exercises built in Power BI.

September 27, 2017

Power BI Play Date is here. Come, join us for a play

Hello friends,

It’s here. Power BI Play Date – our online training program is now ready for your consideration. Please take a few minutes to read this to know all about the program. If you are ready to join, click here.

Check out below show reel to see some of the reports you can create in our course. It is #AWESOME.

September 20, 2017

Topics

Formulas

Beginner
Tables & Structural Referencing
Cell referencing
Excel operators
IF

Intermediate
SUMIFS, COUNTIFS
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
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

Excel & Power BI for you

Beginner

Intermediate

Advanced

Power BI

Beginner

If you are new to Excel or have never used it, use below links to come up to speed.

Structural Refs

Essential Formulas

Pivot Tables Intro

Intermediate

Have been using Excel for a while? Check out these tutorials to learn more and become awesome.

Pivots from Multiple-Tables

Multi-column Lookups

Interactive charts

Advanced

Work with Excel a lot and know your game well? We have some very-advanced topics for you too. Check out:

Excel challenges

Advanced Charting

Data Tables & Simulations

Power BI

Power BI is the most exciting thing to happen for your data since spreadsheets. If you are looking for a new skill to learn this year, I highly recommend Power BI. Check out below tutorials and get started today.

Introduction to Power BI – your first tutorial

Introduction to Power Query

Power BI Example – Commonwealth games tracker

Power Mondays – Learn all about Power BI, Power Query & Power Pivot

What people say about Chandoo.org

I have been using Excel since Excel 4 days, but understood the true potential of Excel only after learning at Chandoo's site a few months ago. His contents, language, topics covered and methodologies are unmatchable. His website has been a great inspiration. This guy is amazing. Great regards to Chandoo.

Vivek K

Long time Excel user

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

=VLOOKUP(chandoo, on_social_media,TRUE)

Get FREE Excel & Power-BI Newsletter

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

Get Started

Online Classes

About

Downloads

© 2018 All rights reserved