Microsoft Excel Formulas and Functions (Office 2021 and Microsoft 365)

CHAPTER 19

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 ...