blogging
A quick personal update
How are you? I want to say hello and check in with you in these strange and scary times.
March 23, 2020
Menu
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.
Excel Howtos
18 Tips to Make you an Excel Formatting Pro
We can take any Excel workbook and format it until Christmas, and we would still not be done. But not many of us have so much of time or energy. So, today, lets talk formatting.
In this, you will learn how to
1) Use tables to format data quickly
2) Change colors of your worksheet in a snap
3) Use cell styles
4) Quickly clone formatting using format painter
5) Clear formats to begin with a clean-slate
6) Formatting shortcuts
7) Formatting options for print
and 8 ) Why you should not go overboard formatting and 10 other tips.
So go ahead and become a formatting pro.
March 19, 2020
Excel Howtos
How-to create an elegant, fun & useful Excel Tracker – Step by Step Tutorial
Do you want to create a simple, elegant and useful tracker using Excel? You can make trackers with features like tables, data validation rules and conditional formatting. In this page, I will explain the process for creating an Excel tracker.
March 17, 2020
Cool Infographics & Data Visualizations
Advanced Pivot Table Tricks for you
Excel Pivot tables make data analysis and visualization easy. With the help of these advanced pivot table skills, you can create powerful data analytics and reports. New
February 27, 2020
Excel Howtos
Excel Pivot Tables Tutorial : What is a Pivot Table and How to Make one
Excel pivot tables are very useful and powerful feature of MS Excel. They are used to summarize, analyze, explore and present your data. In plain English, it means, you can take the sales data with columns like salesman, region and product-wise revenues and use pivot tables to quickly find out how products are performing in each region.
In this tutorial, we will learn what is a pivot table and how to make a pivot table using excel.
February 4, 2020
Learn Excel
Make a random sentence with Excel formulas
Ever wanted to make a random sentence or text? You can use Excel formulas to make totally random sentences. This is a great way to generate test data or dummy data-sets.
January 28, 2020
Learn Excel
Free 2020 Calendar Template & Daily Planner
Happy New Year to all our readers. Let’s kick start 2020 with an awesome calendar, daily planner and monthly calendar template. Please visit the post page to download the 2020 Calendar Excel Template.
January 6, 2020
personal
Merry Christmas & Happy New Year 2020
Hello readers,
On behalf of my family, our staff, volunteers & well-wishers, Let me wish you a very happy Christmas & prosperous new year 2020. Here is a small holiday card from Chandoo.org HQ. This year, we have a new addition to our family – Excel, bichon-poodle puppy has been with us for a little over one month and already became a big part of our lives.
December 24, 2019
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.
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
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.