Business Solutions Tricks of the Microsoft Office 2007 Gurus

7. Data Analysis Tricks

IN THIS CHAPTER

Using a Range Snapshot to Watch a Cell Value

Using a Watch Window to Watch a Cell Value

Calculating Multiple Solutions to a Formula

Plugging Multiple Input Values into a Formula

Determining the Break-Even Point

Optimizing Profit and Margin

Highlighting Cells Above or Below a Certain Value

Highlighting Values Below the Median

Analyzing Cell Values with Data Bars

Applying Percentile-Based Icon Sets

All data has a story to tell. Whether it’s sales, expenses, statistics, inventory, or share prices, the data usually hides something interesting or important that you ought to know. However, even Office gurus understand that although it’s relatively easy to enter data into an Excel worksheet, it’s much harder ...