fbpx
Login to online classes
Welcome to Chandoo.org - We make you awesome in Excel & Power BI

Welcome to Chandoo.org 😃🙏

Welcome message from Chandoo
Play Video
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.

Free Excel Tips Newsletter

Latest Tips & Tutorials

Excel Pivot Tables
Excel Howtos

Excel Pivot Tables Tutorial : What is a Pivot Table and How to Make one

Excel pivot tables are very useful and powerful feature of MS Excel. They are used to summarize, analyze, explore and present your data. In plain English, it means, you can take the sales data with columns like salesman, region and product-wise revenues and use pivot tables to quickly find out how products are performing in each region.

In this tutorial, we will learn what is a pivot table and how to make a pivot table using excel.

Read This »
February 4, 2020
Happy Holidays - 2020
personal

Merry Christmas & Happy New Year 2020

Hello readers,

On behalf of my family, our staff, volunteers & well-wishers, Let me wish you a very happy Christmas & prosperous new year 2020. Here is a small holiday card from Chandoo.org HQ. This year, we have a new addition to our family – Excel, bichon-poodle puppy has been with us for a little over one month and already became a big part of our lives.

Read This »
December 24, 2019
VBA Macros

Filter as you type [Quick VBA tutorial]

Filtering a list is a powerful & easy way to analyze data. But filtering requires a lot of clicks & typing. Wouldn’t it be cool if Excel can filter as you type, something like above.

Let’s figure out how to do this using some really simple VBA code.

Read This »
December 10, 2019
Charts and Graphs

Celebrate with spider web chart [Halloween Fun]

It’s Halloween time. As adults, we can’t go trick or treating. We can of course dress up in costumes and entertain others. But what about the poor spreadsheets. Don’t they deserve some of this fun too?

Hell yeah! So I made a spider web generator in Excel. Just use it to make a spooky cob web pattern and add it to your report / dashboard / time sheet or whatever else. Surprise your colleagues.

Read This »
October 31, 2019
Click for more articles...

Latest Video

Play Video

for more videos…

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

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

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

Conditional Formatting in Excel

Intro to Excel

Tables

Structural Refs

Essential Formulas

Pivot Tables Intro

Budget vs. Actual ChartHave been using Excel for a while? Check out these tutorials to learn more and become awesome.

Advanced Excel

Pivots from Multiple-Tables

Multi-column Lookups

Interactive charts

VBA & Macros

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

Training calendar & dashboard in Excel

Array formulas

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

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 Youtube Linkedin

© 2019 All rights reserved