Skip to content
Skip to content
Menu
Alchemex
  • Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
Alchemex

Learn how to forecast with scenarios using what-if analysis tools in Excel

By admin on March 19, 2016

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 switch to any of these new scenarios to view results differently.
For example: Suppose you want to create a budget but you are uncertain of your revenue, you can define different possible values for the revenue and then switch between scenarios by applying any of the what-if analysis tools.
Note: You are welcome to download the workbook to practice.
Applies To: Microsoft® Excel® 2010 and 2013.
1. Click the Projection worksheet.
2. Set up the Best Case scenario:
On the Data tab, in the Data Tools group, click what-if analysis.
Click Scenario Manager, then click Add.
Click in the scenario name text box and enter “2nd Quarter Best Case”.
Click in the Changing cells text box and select the D6:D8.
Press and hold down the Ctrl key then select D10:D11.

 Click OK.
Enter values for the 2nd Quarter Best Case.

Click OK.
3. Set up the Worst Case scenario:
Click Add.
Click in the scenario name text box and enter “2nd Quarter Worst Case”.

Click OK.
Enter values for the 2nd Quarter Worst Case.

Click OK and then Close.
4. To view the scenarios:
On the Data tab, in the Data Tools group, click what-if analysis.
Click Scenario Manager and then click 2nd Quarter Best Case and click Show, Close.
On Data tab, in the Data Tools group, click what-if analysis.
Click Scenario Manager and then click 2nd Quarter Worst Case and click Show, Close.
5. To view a scenario summary.
On the Data tab, in the Data Tools group, click what-if analysis.
Click Scenario Manager.
Click the Summary button then click OK.
As you can see, scenarios give you different views of the same data and also helps in simplifying your forecasting process.
The post Learn how to forecast with scenarios using what-if analysis tools in Excel appeared first on Sage Intelligence.

Powered by WPeMatico

Post navigation

Understanding the additional options of the ZeroingII Add-in when using Sage Intelligence
Use the Sampling Analysis tool in Excel to easily select random numbers.

Recent Posts

  • Why Working In Excel Works
  • Alchemex Welcomes Velixo 6 For MYOB Advanced
  • Welcome to Velixo Reports Version 4.2
  • Part 3 of 3: Learn how to create a Management Pack in Sage 50cloud Intelligence
  • Part 3 of 3: Create and customize reports easily with the Financial Report Designer

Search

Contact Us

Phone: +61 2 9890 2339
Email: sales@alchemex.com.au
Address: PO Box 212, Deaken West, Canberra, Australia, 2600
©2025 Alchemex | WordPress Theme by SuperbThemes.com