Chandoo.org - Learn Excel, Power BI, Charting, Dashboards and VBA online

Latest Tips & Tutorials

How many Excel themed cryptic crossword clues can you solve? [Easter Eggs 2018]

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.

Read This »

March 29, 2018

Quick tip: Rename headers in pivot table so they are presentable

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.

Just type over the headers / total fields to make them user friendly.

See this quick demo to understand what I mean:

So simple and effective.

Read This »

March 15, 2018

One Control Three Cells

Learn a technique to control multiple cells with 1 Control.

Read This »

March 5, 2018

Stay on top of money with this awesome household budget spreadsheet [downloads]

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.

Read This »

March 1, 2018

How windy is Wellington? – Using Power Query to gather wind data from web

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.

Read This »

February 22, 2018

This year, become a Very Table Genius

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).

Read This »

January 11, 2018

2018 Calendar, daily planner Excel templates [free downloads]

Here is a New year gift to all our readers – free 2018 Excel Calendar & daily planner Template.

This calendar has,

One page full calendar with notes, in 4 different color schemes
Daily event planner & tracker
1 Mini calendar
Monthly calendar (prints to 12 pages)
Works for any year, just change year in Full tab.

Read This »

January 3, 2018

Merry Christmas and Happy New Year 2018 [Holiday Card]

Hellow there…

I wish you a merry Christmas & Happy New Year 2018. May your holidays be filled with joy, togetherness, celebrations and fulfillment. May your new year be filled with hope, energy and awesomeness.

I want to tell you how thankful I am for all your support in this year. Each time you click, visit, read, comment, share, view, listen, purchase, subscribe, follow, question, discuss or email, my heart is filled with gratitude and happiness. Thank you for all the love and support. 2017 has been another amazing year in Chandoo.org journey and I owe this to you.

Read This »

December 22, 2017