Here’s a question I posed to some college students recently:
Let’s say you cover the Town of East Middleburgtown. The mayor announces that this year’s town budget comes in at $12.6 million. Last year’s budget was $11.4 million. What is the percent change? Better yet, what’s the formula for figuring it out?
If you don’t know [...]
Filed under: Analysis, Excel by Anthony on Oct 14, 2009
4 Comments »
Whenever I analyze data in Excel, I format the spreadsheet to make it easier to read. A little attention to fonts, boxes and shading can help people understand the key data faster.
One way to give yourself some flexibility with formatting is to combine text and the results of a formula in a single cell. [...]
Filed under: Excel, Workflow by Anthony on Oct 4, 2009
1 Comment »
