Menu
Close
The Scenario Manager is a feature in what-if analysis and you can use this to enhance your forecasting in Microsoft® Excel®. A scenario is a set of values that Excel saves and can automatically substitute in specific cells on a worksheet. You can create and save different groups of values on a worksheet, and then […]
When you examine business data in Microsoft® Excel®, you may want to discover the result of formulas if you provide different inputs. You can calculate the results of those changes by using a data table. Using data tables makes it easy to examine a range of possibilities at a glance. You can create one or two […]
In our previous tip, we showed you how to get a preferred result by using Goal Seek with a single input value. The solver command is also commonly known as the what-if analysis tool. In this week’s exercise we’ll use the example of an accountant using the solver command to determine how much revenue should […]
If you know the result you want from a formula, but you are unsure of what input value the formula requires to get that result, you can use the Goal Seek feature in Microsoft® Excel®. Goal Seek takes a result and determines possible input values that produce the result you are looking for. Data analysis […]
© Sage South Africa Pty Ltd 2020
.
All Rights Reserved.