Using Excel’s business modeling tools
In this chapter, you will
Understand and build formulas for performing what-if analysis
Learn the details of Excel’s powerful Goal Seek tool
Understand, create, and work with scenarios
At times, it’s not enough to simply enter data into 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 ...