Search

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

Play Video

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

Excel Howtos

### Sorting values in Olympic Medal Table style [Quick Tip]

It is Olympic season. Everyone I know is tracking the games and checking their country’s performance. One thing that we notice when looking at medal tally is,

A single Gold medal is worth more than any number of Silver medals. Like wise, a single Silver medal is worth more than any number of Bronze medals.

So, when you look at the ranking of countries, you see countries with single Gold medal higher up than countries with lots of Silver and Bronze medals (but no Gold).

Read This »
Excel Howtos

### How to use Date & Time values in Excel – 10 + 3 tips

Excel date time features are very handy and knowing how to use Excel date values can help you save a ton of time in your day to day spreadsheet chores. Let us prepare for your date with the sheet using these 10 handy tips.

Before jumping on to the tips, it helps to know how excel represents the date and time.

Microsoft Excel stores dates as sequential numbers … January 1, 1900 is serial number 1, and 28 July, 2021 is serial number 44405 because it is 44,405 days after January 1, 1900. Excel stores times as decimal fractions because time is considered a portion of a day.

Read on to learn more.

Read This »
Power BI

### Getting Started with Power BI – Sales Dashboard in one hour

Learn Power BI and create your own Sales Dashboard with this FREE Masterclass. Details inside.

Read This »
Learn Excel

### 6 Essential TEXT functions in Excel with 6 Everyday Examples

Excel text functions are essential for cleaning up data, extracting parts or combining results. Learn the most important functions and their usage in this article.

Read This »
Charts and Graphs

### How to create a fully interactive Project Dashboard with Excel – Tutorial

Do you manage projects? You are going to LOVE ? this one. In this in-depth tutorial, learn how to create a fully interactive & dynamic Excel Project Management dashboard. Sample files & video instructions are also provided.

Read This »
Power Pivot

### Getting Started with Power Pivot & DAX – FREE Live Masterclass

Watch the replay Getting Started with Power Pivot & DAX 15 useful measures Sample files Blank data file Completed workbook What is in this event?

Read This »
Learn Excel

### Extract data from PDF to Excel – Step by Step Tutorial

Recently I had to extract data from multiple credit card statements and combine them to one Excel table. In this tutorial, let me share you simple steps to deal with PDF data and extracting it to Excel.

Read This »
Learn Excel

### 10 Advanced IF formula tricks you must know

IF is the most used Excel function out there. Here are 10 advanced IF tricks to take your formulas to next-level ?

Read This »

## 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.

## 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

### 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

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.

### 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.

### Get FREE Excel & Power-BI Newsletter

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

#### Downloads

© All rights reserved.