Showing posts with label visualization. Show all posts
Showing posts with label visualization. Show all posts

Monday, July 27, 2009

Please use "thousands" formatting when doing Excel models

Drives me crazy when entrepreneurs create financial models with "/1000" in order to create a format to show a worksheet in thousands.

Don't do that! Makes editing the modeling really risky because it's hard to trace where this formula has been applied.

Just use a custom number format to show the numbers in thousands as necessary. Here's one that works:

_($* #,##0,_);_($* (#,##0,);_($* "-"_);_(@_)

Ok?

Tuesday, September 16, 2008

Wonderful visualization


The NYTimes, which really is tops for stuff like this, has another creative visualization, this time of the depressing loss of value by financial sector firms. (LINK)