After you decide on your budget projections for the coming year, you need to…build those projections into your Excel workbook.…You can use scenarios to store those projections and apply them without creating…multiple sets of similar data within a worksheet.…First I'll show you how to create a scenario.…In this case let's say that I'm anticipating a smaller value for…Accounts Receivable.…To create the Scenario I click the Data tab, click What-If Analysis and open…the Scenario Manager.…
Click Add and now I can type-in a scenario name.…And I'll just say LowAR, meaning Accounts Receivable.…I selected the cell that I wanted to change, cell D8.…And now that everything looks correct I can click OK.…And now I have the opportunity to change the value in cell D8.…Let's say that instead of 800,000 let's say that I have 700,000.…I can click OK to create the scenario and go back to the main Scenario Manager…dialog box, or I can click Add and add a new scenario.…
This time I am just going to click OK and go back to the Scenario Manager.…
Author
Released
6/16/2010- Tracking income and expenses by category and contract
- Using balance sheets
- Designing worksheets to assist decision making
- Creating income statements
- Calculating loans payments and interest
- Creating cell references to other worksheets
- Summarizing data in a chart
- Building alternative budget scenarios
Skill Level Intermediate
Duration
Views
Related Courses
-
Excel 2007: Financial Analysis
with Curt Frye2h 18m Intermediate -
Excel 2007: Introduction to Formulas and Functions
with Curt Frye2h 26m Intermediate -
Excel 2007: Business Statistics
with Curt Frye4h 19m Intermediate
-
Introduction
-
Welcome1m 1s
-
-
1. Managing Cash on Hand
-
2. Calculating Loan Repayments
-
3. Budgeting Using Financial Statements
-
4. Managing Budgets
-
5. Defining Alternative Budget Scenarios
-
Summarizing scenarios2m 18s
-
Conclusion
-
Goodbye16s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Creating and applying scenarios