How To Manage Scenarios In Excel For Mac


show more Managing scenarios provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training show less
please wait ...

Managing scenarios

Most of the time you'll use Excel to summarize existing data. If you're a manager or a project leader who needs to account for possible future scenarios, what the Excel team refers to as 'what-if' analysis, you have one of two options: First, you can create a worksheet for every combination of variables. The other easier way is to perform what-if analysis by creating scenarios. So why would you want to create a scenario? Well, a scenario is used when there's more than one possible future, in other words if you wanted to get a loan from a bank, you might not know what the interest rate is.

The interest rate would determine how much you can borrow, or at the very least your monthly payment, so you can build in scenarios, for example different loan amounts, different rates, different terms, and so on. So how do you create a scenario? Well, in Excel 2011, you go up to the Data tab on the Ribbon, and then in the Analysis group, click What-If, and then click Scenario Manage...

Managing scenarios
Video duration: 4m 59s 6h 32m Beginner

Viewers:

Managing scenarios provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training

Subject:
Business
Software:
Excel for Mac
Author:
please wait ...