From the course: Excel 2013 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Using Scenario Manager

Using Scenario Manager - Microsoft Excel Tutorial

From the course: Excel 2013 Essential Training

Start my 1-month free trial

Using Scenario Manager

“

In this worksheet called, Scenario, we're looking at a 2014 Budget Projection. As I scroll to the right, we had monthly totals, quarterly totals, and a grand total in column R. And scrolling left toward and then downward, we see the items being tracked here. Sources of Revenue, Cost of Goods, our Expenses, and at the bottom in row 35 and Net Profit. And the lower right-hand corner cell R35, the Gross Profit for the entire 12-month period projected. That same number is reflected in the upper left-hand corner, as I press Ctrl+Home at 450,000. We also see it here. A brief look at the formulas here, the February formulas for the entries we see here are based on the January entries with a 1% change. March at 1% change on February. Second quarter, our numbers are based on 3% changes. Ultimately, we might have a percent change in every cell here, but all the entries for example in the May column involve using the April numbers on a 3% change. April is based on March; March on February and so…

Contents