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

Latest Tips & Tutorials

How to become really awesome in Excel? [Reader Questions]

Yusuf, one of the blog readers emailed me and asked “how I can bebome an expert in Excel”. I gave him some advice based on what I know. But I think My advice can be improved too. So I turn to you.
What do you think a person should do to become really awesome in Excel?

Share your thoughts, ideas and suggestions using comments. Suggest blogs, websites or books or anything that can help Yusuf (and countless others) really good in using Excel to become awesome in their work.

Read This »

May 10, 2010

Important Update: Dilbert is gone!

An important update and change to this blog name and logos. Please read to ensure that you are not feeling lost.

I had to change the site name from “Pointy Haired Dilbert” to “Chandoo.org”. While the change is triggered due to an email from Scott Adams, creator of Dilbert Strip, I have been mulling the change for a while and I think this is the right time for it.

Read This »

May 7, 2010

Data Tables & Monte Carlo Simulations in Excel – A Comprehensive Guide

If anybody asks me what is the best function in excel I am drawn between Sumproduct and Data Tables, Both make handling large amounts of data a breeze, the only thing missing is the Spandex Pants and Red Cape!

How often have you thought of or been asked “I’d like to know what our profit would be for a number of values of an input variable” or “Can I have a graph of Profit vs Cost”

This post is going to detail the use of the Data Table function within Excel, which can help you answer that question and then so so much more.

Read This »

May 6, 2010

Change Data Labels in Charts to Whatever you want [Quick Tip]

We all know that Chart Data Labels help us highlight important data points. When you “add data labels” to a chart series, excel can show either “category” , “series” or “data point values” as data labels.

But what if you want to have a data label that is altogether different, like this:

Of course you can point data labels to any cell. In this quick tip, we will learn how to do this, read on…

Read This »

May 5, 2010

How to Get “Either-Or” Condition in Data Validation?

In a recent consulting assignment I had a tricky data validation problem. The customer wanted to have an either-or condition in the data validation, like

Read This »

May 4, 2010