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.

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 »

Copy & paste visible cells only [Excel Trick]

Here is something annoying with Excel.

Open any Excel file with few columns of data. Hide some of those columns (select the columns and press CTRL+0). Now, copy a few rows of data. Paste it else where. Excel will paste the values in hidden columns too. We thought Excel would omit the values in hidden columns.

What the filter Excel?!? I thought we were friends, but you annoy me with some of these quirks.

Read This »

Awesome chart to visualize Salary Increases for 3,500+ people [Tutorial]

Game for some charting awesomeness?

Off late, I have been doing a lot of data analysis and visualization on performance ratings, salary hike, gender pay equality etc. Today let me share you an awesome way to visualize massive amounts of data.

Scenario: Your organization of 3,686 people recently went thru annual performance ratings & review process. At the end of it, everyone was offered some salary increase (from $0 to $24,000 per year). You have 7 business groups. How do you tell the story of all these salary hikes in one chart?

How about the one above?

Ready to know how to create this in Excel? Read on.

Read This »

Employee Performance Panel Charts – Excel vs. R

Recently, I had to make a bunch of panel charts. After wrangling with Excel (and a tiny bit of VBA) to create them, I wondered if we are suffering needlessly by being too loyal to Excel. I switched to R and could create these panel charts in almost no time (well, first I had to learn how to pivot the data using dplyr). Today, let me share the experience.

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)