fbpx

Archive for May, 2010

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

Published on May 10, 2010 in Learn Excel
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.

Continue »

Important Update: Dilbert is gone!

Published on May 7, 2010 in blogging
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.

Continue »

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

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.

Continue »

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

Published on May 5, 2010 in Charts and Graphs
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…

Continue »

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

Published on May 4, 2010 in Learn Excel
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 this: My initial reaction to this requirement was “hmm… that is not possible“. But before shooting the email back to client, I got curious and checked if excel data validation […]

Continue »

Excel Links – Project Management Edition

Published on May 3, 2010 in excel links

It has been quite a while since we had an excel links post. It doesn’t mean that I am not reading anything new on excel or charting. I have been reading lots of awesome articles and useful content and sharing it on my google reader recommendation list. But it is just that I have been […]

Continue »