6
What-If Analysis
Many users are unaware of the What-If Analysis features in Excel, which can be used to find answers to questions in an automated fashion. I'll start lead off by I'll start by showing you how to use the Scenario Manager feature to both you to back up key inputs and compare the results of different sets of inputs. I'll then use the Goal Seek feature to automate solving for a missing input within a calculation. After that I'll show you how the Data Table feature can streamline situations where, normally, the user would need to rewrite formulas to handle a variety of inputs, such as comparing what a mortgage payment would be at two different interest rates and loan terms. We'll use the Forecast Sheet feature to project amounts ...
Get Exploring Microsoft Excel's Hidden Treasures now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
