Welcome to Chandoo.org

Hi, I am Chandoo. Welcome to our site. My mission is to make you awesome in Excel & Power BI

Hello, Namaste & Kia Ora. 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. When I am not , I like to cook, walk, cycle, play with legos, entertain my wife & kids or read. Take a minute to browse various topics of the site below to see how I can help you.

Thank you and welcome once again.

Sign up for FREE Newsletter

Latest Tips & Tutorials:

How to undo in Power Query [Quick Tip]

Ever wondered how to undo in Power Query. If you try to press CTRL+Z or look for undo icon in Power Query (either in Excel ...
Read More
Formatting date & time values in Excel

How to use Date & Time values in Excel – a handy guide

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 ...
Read More

Which two teams qualify to next stage? [Excel Homework]

Time for some soccer fun in spreadsheets. Given a team points table like below: How would you figure out in Excel, which teams qualify for ...
Read More
Table styles to change the look & feel of your Excel tables

Excel Tables Tutorial & 13 Tips for making you a Data Guru

Excel table is a series of rows and columns with related data that is managed independently. Excel tables, (known as lists in Excel 2003) is ...
Read More

Best Excel Books & Power BI Books – 2018

So you have decided to up your game with Excel and / or Power BI this year and now ravenously looking for books to read ...
Read More

FIFA Worldcup 2018 Excel Tracker – FREE Download

FIFA world cup 2018 is around the corner. I love soccer, I love Excel, Let's marry them. Here is an awesome, free FIFA world cup ...
Read More

Data analysis with Excel

Analyzing data with formulas and pivot tables in Excel

Excel has many powerful features to analyze data. You can collect and clean data thru Power Query (get and transform data), maintain it in tables, calculate summaries thru formulas or pivot tables. Learn all about data analysis using below resources:

Visualization

Charting in Microsoft Excel

Charting is the key to successful business communication. Learn how to create powerful, beautiful and elegant charts using Excel. Start by picking right type of chart, then make it, remove any distractions and make it dynamic for best results. Learn how to work with Excel charts using below resources:

Dashboards & Reporting

Dashboards & Business Reporting in Excel

Dashboard is a one page report used in executive communication. Dashboards show business summary, KPIs, trends and insights in a crisp manner. Chandoo.org is a pioneer and best in the world when it comes to dashboard reporting. Learn how to make awesome dashboards using below resources:

VBA, Macros & Automation

VBA, Macros, Programming and automation in Excel

VBA is a programmable interface to Excel. Using VBA Macros, you can automate repetitive tasks, simplify complex processes and create powerful solutions for your business. Learn how to program in VBA, write macros and automate your work with these resources:

Power BI, Power Query and Power Pivot

Power Query, Power Pivot and Power BI

Power BI can help you gather data from anywhere, analyze it with DAX formulas, create interactive visualizations, share them with your audience on web, mobile or desktop easily. It is the newest revolution in the space of data analytics and reporting. Check out these resources to understand how to use Power BI today.

Full Length Video Courses

Online video training programs from Chandoo.org

If you like the content you have seen on this site, you are going to LOVE my online courses. They are detailed, informative, step-by-step and self-paced. I run courses on various topics to help people achieve their full potential. To date, more than 10,000 people have graduated from Chandoo.org online classroom and went on to become successful. Check out my courses below:

  • Excel School – Beginner to advanced Excel, formulas, charting, pivots & dashboards – Price from $97
  • VBA Classes – Beginner to advanced VBA, macros and integration – Price from $97
  • 50 ways to analyze data – Advanced analytics, visual analytics, data science with Excel, Power Query – Price $397
  • Power BI Play Date – Beginner to advanced Power BI, Power Query and Power Pivot – Price $299

Latest Posts, videos and tips:

Every week, I publish new content on all areas of Excel, Power BI and data analysis. Please use below links to access the latest posts: