Learn Excel
How to learn Python as an “Excel person”?
Python is a great programming language to learn for anyone in data profession. For people with prior Excel skills and a little bit of programming bent, Python
May 24, 2022
Welcome to Chandoo.org.
My mission is to make you AWESOME in your work.
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.
Excel Challenges
Can you split “The Hangover” expenses? [Excel Homework]
Can you split the atom? No, ok, how about splitting the expenses then?
In this homework challenge, can you take a look at the expenses of wolf-pack and tell me who owes who & how much?
May 19, 2022
Learn Excel
What is LAMBDA? 4 Practical examples to REALLY understand it
Excel’s LAMBDA() Function let’s you create and share your own functions. It is a true game changer. Learn how to use it with 4 practical examples in this article.
April 8, 2022
Learn Excel
FREE 2022 Calendar & Monthly Planner Printable Template
Do you want a stylish, interactive and useful monthly calendar & planner template? Then please use below link to download it. A new year gift to you from Chandoo.org ?
January 5, 2022
personal
Merry Christmas & Happy New Year 2022
On behalf of my family, our staff, volunteers & well-wishers, Let me wish you a very happy Christmas & prosperous new year 2022. Here is a small holiday card from Chandoo.org HQ.
About this year’s card: We went to the beautiful Queenstown this October to celebrate my 40th (XL Birthday!!!) and took this picture just before sunset. The kids are now taller than mum and as tall as me. We will be taking family pictures sitting down from now on, so that they don’t look like giants.
December 23, 2021
Excel Howtos
How to write complex Excel formulas (hint: it’s a lot like LEGO)
Writing advanced formulas is a lot like LEGO. Use what you already have and combine them in creative ways. Let me demo with 5 examples.
December 9, 2021
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).
August 2, 2021
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.
July 28, 2021
Latest Video
for more videos…
Learn Excel Step by Step
Everything from Power Query to Dashboards, Shortcuts to Formulas, Pivots to Charts in one course.
Topics
Formulas
BeginnerTables & Structural Referencing
Cell referencing
Excel operators
IF
IntermediateSUMIFS, COUNTIFS
XLOOKUP NEW
VLOOKUP
INDEX + MATCH lookups
AdvancedMulti-condition lookups
Array Formulas
OFFSET
INDEX
Lists100+ Excel Formulas list
Top 10 formulas
15 Everyday formulas
Challenges & Home workExcel Homework
Pivot Tables & Data Analysis
BeginnerExcel Pivot Table Tutorial
Multi-table pivots with data model
Advanced
Advanced Pivot Tables
Distinct count in Pivots
Ranking values in Pivots
GETPIVOTDATA
How to use slicers
Lists35 shortcuts & tricks for data analysis
Top 10 pivot table tricks
15 quick & powerful ways to analyze business data
ResourcePivot Tables Page
Charting
BasicsHow to pick right charts
Why bar charts should start at 0
Add a line to column chart
Correlation vs. Causation
ExamplesHand-drawn charts
Budget vs. Actual chart
Interactive charts
Chart typesHistograms & Pareto charts
Forecasting with charts
Gantt chart
Funnel chart
5 star chart
Indexed charts
Panel charts - Small multiples
AdvancedTarget 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 & TricksCharting 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
Excel & Power BI for you
Beginner
Intermediate
Advanced
Power BI
Beginner
If you are new to Excel or have never used it, use below links to come up to speed.
Intermediate
Have been using Excel for a while? Check out these tutorials to learn more and become awesome.
Advanced
Work with Excel a lot and know your game well? We have some very-advanced topics for you too.
Check out:
Excel challenges
Advanced Charting
Data Tables & Simulations
Power BI
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.
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.
=XLOOKUP(chandoo, on_social_media)
Get FREE Excel & Power-BI Newsletter
One email per week with Excel and Power BI goodness. Join 100,000+ others and get it free.
Online Classes
© All rights reserved.