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.
Here is a quick tip to start the week.
Often, we end up with a situation where a bunch of numbers are stored as text.
In such cases, Excel displays a warning indicator at the top-left corner of the cell. If you click on warning symbol next to the cell, Excel shows a menu offering choices to treat the error.
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
In the 18th session of Chandoo.org podcast, lets loose your Pivot table virginity.
Note: This is a short format episode. Less time to listen, but just as much awesome.
What is in this session?
Pivot tables are a very powerful & quick way to analyze data and get reports from Excel. But surprisingly, not many use them. Today, lets bust your pivot table virginity and understand the concepts like pivoting, values, labels, filters, groups and more.
In this podcast, you will learn,
Time for another quick Excel tip.
Lets say the park near your house rents tennis courts by hour. And they charge $10 per hour. At the end of an intense tennis playing week, Linda, the tennis court manager called you up and said you need to pay $78 as rent for that week.
How many hours did you play?
Of course 78/10 = 7.8 hours.
But we all know that 7.8 hours makes no sense.
We also know that 7.8 hours is really 7 hours 48 minutes.
So how to convert 7.8 hrs to 7:48 ?
Last week, we had an interesting homework problem – What is the average speed of this road trip?
We received more than 150 answers. But to my surprise, 57 of them are wrong. So today, lets learn how to calculate the average speed correct way.
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
In the 17th session of Chandoo.org podcast, lets leave Excel aside and talk about other MS Office apps.
Thats right. We will be learning 10 tips on how to use Word, Power Point, Outlook etc. Ready?
In this podcast, you will learn,
Today, lets learn how to create an interesting chart. This, called as network chart helps us visualize relationships between various people.
Demo of interactive network chart in Excel
First take a look at what we are trying to build.
Looks interesting? Then read on to learn how to create this.
Its homework time again. This time, lets tackle an interesting & everyday problem. Lets introduce our protagonist of the story – Jack. Jack likes long
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
In the 16th session of Chandoo.org podcast, lets review 3 very useful books for aspiring analysts.
What is in this session?
Analytics is an increasingly popular area now. Every day, scores of fresh graduates are reporting to their first day of work as analysts. But to succeed as an analyst?
By learning & practicing of course.
And books play a vital role in opening new pathways for us. They can alter the way we think, shape our behavior and make us awesome, all in a few page turns.
So in this episode, let me share 3 must have books for (aspiring) analysts.
for more videos…
Everything from Power Query to Dashboards, Shortcuts to Formulas, Pivots to Charts in one course.
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
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
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
If you are new to Excel or have never used it, use below links to come up to speed.
Have been using Excel for a while? Check out these tutorials to learn more and become awesome.
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 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.
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.
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.
One email per week with Excel and Power BI goodness. Join 100,000+ others and get it free.
© All rights reserved.
