Cricketing Heat Map

Heat maps are pretty versatile. They have been used for everything ranging from charting home prices to changes in the stock market. (Average Listing Price for US states, week ending Feb 17, 2010. Source : www.trulia.com) (SNP performance, Feb 19, 2010. Source : www.finviz.com/map.ashx) Inspired by the last ball win over the South Africans yesterday night, I wondered if some of that ...

Continue Reading

Cricketing Heat Map

Conditional Formatting and Custom Format – Use More than Three Colors

Posted on 16 September 2009

Conditional Formatting and Custom Format  - Use More than Three Colors
Conditional formatting (in pre Excel 2007 versions) had a limitation of only allowing for upto three conditions for formatting cells. A quick way to include more than three conditions when using conditional formatting is to use the custom format feature in tandem with it. Conditional formatting can be used to specify the first three conditions and then upto three additional conditions can be specified using custom format - giving us 6 different colors to work with. ...
Continue Reading

Comments (1)

Conditional Formatting In Excel

Posted on 22 March 2009

Conditional Formatting In Excel
Conditional Formatting is one of the most useful features of Microsoft Excel. And while most people are happy to use it for changing the color of the text in a particular cell, there are endless ways in which it can be extended. Here are a few: Hide errors Remember when you had a copy a complicated formula onto 40,000 cells and some of them gave you the dreaded #DIV! error. That did really ...
Continue Reading

Comments     

Excel Dashboard : Data Organization

Posted on 23 August 2008

Excel Dashboard : Data Organization
Having our first view of the data More often that not, dashboards get prepared with a large amount of data. Even if that’s not the case, it always makes send to have your data nicely laid out. That way, whenever you have to go back and check the accuracy of the data, it becomes so much easier. Let’s work with an example. Suppose we've just been provided with one year’s worth of sales and target numbers for the regional and ...
Continue Reading

Comments (1)

Subscribe

Keep up with the latest stories - Delivered right to your inbox
feedburner

Translate

English flagItalian flagKorean flagChinese (Simplified) flagPortuguese flagGerman flagFrench flagSpanish flagJapanese flagArabic flagRussian flagDutch flagHindi flagFilipino flagIndonesian flagThai flagTurkish flagPersian flag
treeemap software for excel


ARCHIVES