15. Using Excel’s Business-Modeling Tools

At times, it’s not enough to simply enter data in a worksheet, build a few formulas, and add a little formatting to make things presentable. In the business world, you’re often called on to divine some inner meaning from the jumble of numbers and formula results that litter your workbooks. In other words, you need to analyze your data to see what nuggets of understanding you can unearth. In Excel, analyzing business data means using the program’s business-modeling tools. This chapter looks at a few of those tools and some analytic techniques that have many uses. You find out how to use Excel’s numerous methods for what-if ...

Get Excel® 2013 Formulas and Functions now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.