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.
Let’s say you have data like this in a spreadsheet. Don’t roll your eyes, I am 102% sure, right at this moment, someone is (ab)using Excel to create similar messy data.
How do you reshape it to one column?
You could use formulas, VBA or Power Query. Let’s examine all these methods to see what is best. All these methods assume your data is in a range aptly named myrange.
Nishanth & Nakshatra, my kids are now 8 years old and learning mathematics at school. Very soon (from this Saturday), they will have 2 weeks of school term break. As a stay at home dad, I shudder at the thought of school holidays. So this time, I have an evil plan. I made maths worksheets for them. Everyday, I will print one and ask them to complete.
If you are a stay at home parent and want to keep your kids busy for a few minutes every day, grab a copy of this and give it a go. Keep in mind that the workbook uses RANDBETWEEN(), so the numbers change every time. If you have multiple kids, print multiple copies. There are no answer sheets, so when you need to check the answers, you too must calculate them by hand.
It is Easter time. This is the first Easter we are celebrating in our new house. So it is bound to have so many special memories. For last 10 years (wow, it has been a decade of tradition), I have been running Excel based egg hunts every Easter. It all started in 2009, when I was living in Sweden (where Easter is a BIG thing). I had to share the enthusiasm with someone, so I made our first Easter egg hunt on the blog.
This year, join me on an Excel themed cryptic crossword clues – Easter egg hunt. Don’t forget to share your scores and explanations in the comments.
Pivot tables are fun, easy and super useful. Except, they can be ugly when it comes to presentation. Here is a quick way to make a pivot look more like a report.
See this quick demo to understand what I mean:
So simple and effective.
I believe in frugal living and paying yourself first. One of the simple ways to achieve this is by using a budget. You know how much money you get. Once you can track (or estimate) how much you are spending, it is easy to see how much you are paying your future self and what wiggle room you have. So in the spirit of making you awesome in life, not just Excel, let me share a simple but elegant household budget spreadsheet.
Here is a screenshot of the budget.
Let’s take a whirlwind trip to coolest little capital – Wellington. It is a windy place, so hold on to your hats and spreadsheets.
Almost everyone who spends more than 2 days in Wellington would agree that it is a windy place. But how windy is Welly? In this two part series, we will use Power Query, Excel charts and coffee to answer that question.
But, first let’s start with a joke.
What happens when you throw a boomerang in Frank Kitts Park?
You will have to buy another one, coz you are not getting that one back.
Let’s start the new year with a bang.
Excel Tables were introduced more than a decade ago, but a lot of people don’t know them or under utilize them. So start this year by becoming a very table genius.
What is Excel Table?
Excel tables are a simple and elegant way to structure and store your data. Let’s say you have staff details like below. Instead of calling it like A1:E72, you can convert this data in to a table and call it, you guessed it right, covfefe (or more coherent option like – staff).
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.
