Welcome to Chandoo.org - We make you awesome in Excel & Power BI

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.

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.

Read This »

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.

Read This »

VLOOKUP that fat table with ease [3 quick tips]

Time for some good, old fashioned VLOOKUP love. Let’s say you are writing VLOOKUP()s to get data from an unusually fat table, ie one with heaps of columns. You want to get to lookup ID in first column and get thingamajig in what is that column number. Well, better get counting from 1 and after 19 seconds and lots of squinting you arrive at column number 53 – which has thingamajig. 

If this sounds like your VLOOKUP routine, check out these three amazingly simple tips to save some time and effort with your lookups.

Read This »

Epic Introduction to Power BI

Yay, finally our first ever full length Power BI tutorial is up. In this 30 minute video tutorial, learn how to get some data in to Power BI and make a quick report to understand it. We will be creating this.

customer-service-db-pbi-v1

Let’s get started then.

Read This »

Introducing Power BI Play Date online class [Details inside]

Hello,

I have an exciting news for you. After learning and playing with Power BI for more than a year, I would love to share all this awesomeness with you on a play date. Of course, you don’t have to pack your sleeping bag and tooth brush. You can join me on this play date from the comfort of your couch and PJs. Stoked? Read on.

power-bi-play-date

Read This »

Convert unevenly spaced list to table [Data from Hell]

Introducing Data from Hell:

Watch out, its data from hell. In this new video series, we are going to examine some nutty, frustrating and fun data reshaping challenges and solve them using Excel. We will use Power Query, Formulas, VBA or other features as needed to free this data from damnation.

For our first installment, let’s reshape unevenly spaced list of values to a table.

Read This »

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.

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.

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.

=VLOOKUP(chandoo, on_social_media,TRUE)