Excel is the terrific program for analyzing and storing large datasets, and you can also use it for forecasting future values. For example, you might want to forecast growth per quarter for an upcoming fiscal year. In this movie, I will show you how to extend your analytical abilities by creating scenarios.
- [Voiceover] Most of the time,…you will use Excel to summarize existing data.…However, if you're a manager or a project leader…who needs to account for possible future scenarios,…performing what the Excel team refers to…as what if analysis,…you'll have one of two options.…First, you can create a worksheet…for every combination of variables.…Or, the second, easier way to perform…this type of what if analysis is to create…scenarios within a single worksheet.…In this movie, I will show you how to create scenarios.…This workbook contains a single worksheet,…and in it I have current revenue data…for 4 different quarters, Q one through 4,…and the projected increase, and also…the projected new revenue, based on…the projections in cells B4 through E4.…
If I wanted to present different scenarios,…for example, a pessimistic or a lower estimate,…and also an optimistic or higher estimate,…I could do so by either creating…new worksheets, or changing the values as I go.…However, I can also create scenarios within this workbook,…
Author
Curt Frye
Released
5/18/2016- Entering a data series using the fill handle
- Creating hyperlinks
- Controlling the Ribbon
- Moving between worksheets quickly
- Setting a print area
- Selecting noncontiguous cells
- Applying a table style
- Creating substitute data sets using scenarios
- Wrapping and shrinking cell text
- Entering data quickly
- Removing duplicate values
- Inserting the current date or time
- Generating a list of unique random numbers
- Calculating running totals
- Summarizing data
- Dealing with formula errors
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome56s
-
-
1. Top 10 Shortcuts
-
Hiding worksheets1m 33s
-
2. Controlling the Excel Program and Interface
-
Controlling the Ribbon1m 33s
-
-
3. Managing Workbooks and Worksheets
-
Setting a print area1m 56s
-
4. Organizing Data
-
Creating a custom view2m 36s
-
Finding a target value3m 8s
-
5. Entering and Formatting Data
-
Picking data from a list1m 19s
-
6. Managing a Data Series
-
Extending a date series3m 10s
-
Removing duplicate values3m 51s
-
-
7. Working with Dates and Times
-
8. Creating Useful Formulas
-
Rounding values5m 23s
-
9. Managing Formulas
-
Calculating running totals2m 26s
-
Commenting within a formula3m 13s
-
Dealing with errors4m 5s
-
-
Conclusion
-
Next steps1m
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press 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 substitute data sets using scenarios