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

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.

Latest Tips & Tutorials

Critical Path with Excel

Learn Excel

Calculating Critical Path using Excel Formulas [Project Management]

Do you know that we can easily calculate the critical path for a project using Excel formulas?

For a long time, it has been tricky to calculate the Critical Path using Excel formulas. But thanks to the arrival of new Dynamic Array functionality in Excel, we can now calculate critical path. In this article let me describe the approach with an example.

Put on your hardhats, this one is going to blow your minds.

October 3, 2023

One Pivot Table from Multiple Sheets of Data

Learn Excel

How to make a pivot table when you have data in multiple sheets [Tutorial]

Recently I had to create a Pivot report from monthly data. But there is a twist. The data is spread across multiple sheets, one for each month. Let me explain how I built the pivot for that scenario.

September 26, 2023

Introduction to Python in Excel

Learn Excel

Python is in Excel! – Here is a complete getting started guide for you

Python ? is in Excel now! Learn how to use Python in Excel with Sample data, 10 Code Examples and tips with this complete guide.

September 5, 2023

The ugly truth about Power BI (Chandoo.org Podcast Episode)

Chandoo.org Podcast Sessions

CP03: The Ugly Truth About Power BI (actually, 4 of them)

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | Spotify | RSS

Power BI is one of the most prominent data analytics technology out there.

Power BI is also one of the most marketed and hyped technology out there.

Unfortunately, both of these statements are true.

In a world where data is the buzz word, Power BI (or other similar platforms like Tableau) appeal to CXOs as panacea for all their data troubles.

But, just as any technology, Power BI too has it’s own shortcomings. So in this episode of my podcast, let’s uncover 4 ugly truths of Power BI.

August 24, 2023

Power Query - auto generate calendar tables

Power BI

How to “auto” generate calendar tables with Power Query – The best method

Calendar (or date) table is crucial for performing date intelligence calculations in Power BI.

Normally, you would find a reasonable calendar table in most data models. But occasionally I come across models where there is no calendar table.

So I present to you, the ultimate & best way to generate calendar table using Power Query.

August 22, 2023

top-10-accounting-kpis and how to calculate them with Excel

Financial Modeling

Top 10 Accounting KPIs and How to Calculate them in Excel?

We can calculate any Finance & Accounting KPI values using Excel easily. In this article, I am sharing the top 10 accounting KPI calculations. These

August 8, 2023

6 tips to help you get a $100k+ data job

Chandoo.org Podcast Sessions

CP02: Six Tips to get a Six Figure ($100,000+) Data Job

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | Spotify | RSS

So you want a 6 figure data job? In this podcast episode, I am going to share 6 strategies and tactics to land a $100k+ data job.

July 27, 2023

Chandoo.org Podcast Sessions

Top 5 Excel Skills you need to be a Successful Data Analyst in 2023 (podcast)

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | Spotify | RSS

Ladies & gentlemen… I have an exciting announcement. I am relaunching my podcast!!!

It only took me 7 years, but Chandoo.org podcast is now BACK! I am planning to make regular episodes on Excel, Power BI, SQL & Data Analytics.

In the 1st episode of Season 2 of Chandoo.org podcast I talk about, Top 5 Excel Skills you need to be a Successful Data Analyst in 2023.

July 13, 2023

Latest Video

Play 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

Power BI

The ugly truth about Power BI (Chandoo.org Podcast Episode)

CP03: The Ugly Truth About Power BI (actually, 4 of them)

Power BI - Chart Selection - Handy Guide

When & how to use the 30+ chart types in Power BI?

How to set up Power BI Tooltips

How to create interactive tooltips in Power BI (step by step)

Power BI Live Event - June 2021

Getting Started with Power BI – Sales Dashboard in one hour

announcing power bi online class from chandoo

Introducing Power BI Play Date – Online class to master Power BI (oh yeah, Power Query & Power Pivot too)

Excel & Power BI for you

Beginner

Intermediate

Advanced

Power BI

Beginner

Intermediate

Advanced

Power BI

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

=XLOOKUP(chandoo, on_social_media)

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

© All rights reserved.