Excel Links of the Week [Oct 06]

What a Monday it is. Most of the us woke up to find that whatever we have been accumulating for the last few years in investment gains has been wiped out (BSE Sensex at 2 year low, Dow slips below 10000). Not a very pleasant way to start the week, but then may be this [...]

Major Updates to Google Docs Spreadsheets App - Menus, Named Ranges, Toolbar

Google Docs - spreadsheet application has introduced some major upgrades to their editor today.
Some of the key changes include:

Introduction of menus to access all spreadsheet functions / features by category: Now the spreadsheet app menus look more like Excel 2003 menus. Looks like Google is trying hard to close gap between the two applications.
Improved [...]

Come, Lets Celebrate - Photographic Fridays # 16

That is Pittsburgh downtown from Mt. Washington during the night time. It looked like a huge party down there.

Deal or No Deal - Download and Play the Popular TV Game Show in Excel

Ever since we moved to Seattle we have been watching TV game show - Deal or No Deal (for lack of better things to do in the hotel) The game provides an interesting look at human nature and risk taking abilities. People who wouldn’t risk their retirement savings or jobs would go to these game [...]

Info-graphics of the week [Oct 3]

Every week Pointy Haired Dilbert celebrates the art of visualization by featuring 5 of the coolest and most awesome visualizations floated around the web. Click here to browse the full archives of featured cool infographics.
US Electoral College Vote Prediction Tracker - Cool Interactive Visualization

With each media house providing its own predictions on the 2008 US [...]

Display decimals only when the number is less than 1 [Excel number formatting tip]

Here is a quick excel number formatting tip. If you ever want to format numbers in such a way that it shows decimal values only if the number is less than 1 you can use conditional custom cell formatting (do not confuse with conditional formatting).
Here is an example:

In such cases you can use conditions in [...]

Visualizations at Seattle Public Library - What Community is Reading?

Seattle Public Library’s Central branch not only boasts unique architecture but also world class visualizations of library data. On the level 5 of the building they have six large LCD display screens dedicated to provide visualizations of data like what people are reading, which books are checked out in the last hour etc. See them [...]

6 charts you will see in hell

Hot Thermometer Charts in Excel - here is a cool way to do them

Select & Show One Chart from Many

Tracking mutual fund / Stock portfolios using excel - howto

Sorting Text in Excel using Formulas