Excel Tips Category
Dashboarding Fun - Display Smileys in your excel dashboards
By Chandoo at 7 August, 2008, 4:19 pm | 6 Comments

Dashboards are daily staple for some of us who need to report status to our bosses, present them in weekly meetings or generally CC half the world with what is up on our end.
There are several ways in which you can spice up the dashboard, one of the simple things to do is, to [...]
Doing the NY times Olympic medals by country year visualization in excel
By Chandoo at 6 August, 2008, 4:16 pm | 10 Comments

When I saw the Olympic medals won by each country by year infographic on nytimes my jaw almost dropped, go ahead see it and come back, I am sure you will love it too.
It is one of the coolest visualizations I have seen in the recent past and I see infographics all the time, [...]
Excel links of the week : ‘what can excite you most’ [Aug 4]
By Chandoo at 4 August, 2008, 4:11 pm | 2 Comments
Passion, excitement, inspiration or love - whatever you choose to call it, is the key reason we do remarkable things. Take a minute break here, think about the most significant moments in your life.
What is common in all of those moments?
I am sure your answer will be Passion or excitement, love, inspiration.
I want to [...]
Conditionally play sounds when a cell value changes
Blog reader Richard asks through email:
I’m a non-programing user of Excel. I import stock prices, using what is called ( I believe) a dde link, into my spreadsheets,from a trading program.
I would like to add a feature to my spreadsheets that, like conditional formatting, alerts me to a price change in a cell, but with [...]
Excel can be Exciting - 15 fun things you can do with your spreadsheet in less than 5 seconds
By Chandoo at 1 August, 2008, 10:38 am | 33 Comments

Who said Excel takes lot of time / steps do something? Here is a list of 15 incredibly fun things you can do to your spreadsheets and each takes no more than 5 seconds to do.
Happy Friday
1. Change the shape / color of cell comments
Just select the cell comment, go to draw [...]
Read More >>Want to Feed RSS to your Excel Sheet? Read this!
By Chandoo at 30 July, 2008, 5:56 pm | 9 Comments

RSS feeds are everywhere. So much that you cannot avoid them in your data processing, analytics or day to day spreadsheet needs.
If you can get the RSS feeds to excel sheet you can do pretty interesting things with it, like:
Prepare a sheet to watch deals on Amazon, Craigslist, Deals2buy and other favorite sites
Watch news, [...]
Excel Links of the week

Here is a quick round up of excel posts from few of the awe some blogs around the web:
At PTS Blog, Jon provides excellent tutorial on adding target lines to your bar charts to show target vs. actual performance. He has several other tweaks for your category axis as well, just read the other posts [...]
