…Excel is a wonderfully flexible and powerful tool.…For example, you can create models that let you…modify your formula's inputs to estimate sales revenue and costs.…You can also model systems that use random events such…as product demand to estimate resource utilization and other costs.…In this movie, I'll give you an overview of one way…to set up a worksheet to run a Monte Carlo simulation.…I will use the Monte Carlo setup workbook,…which you can find in the chapter 4 folder of your exercise files archive.…The items in the workbook's worksheet are divided into several different sections.…
The items in the top left corner of the worksheet, in the…section that I've named Commemorative Items,…have different elements that affect production.…So you have the number of items to be produced, a random number which…we'll use in a later movie, demand, which is the number of items that…the public wants to buy, cost per unit, next is…the cost to make each unit, then the price for which…you're selling the item and the amount it costs you…
- Explain how to create a scenario in Excel.
- Identify the two input values that should be used to create a two variable data table.
- Recall what the Excel feature Goal Seek is used for.
- Recognize the three things that must be separated from one another to make reading a worksheet with multiple units easier.
- Describe the tools that Excel provides to manipulate data.
- Break down the steps required to recalculate a worksheet's formulas.
Skill Level Intermediate
1. Defining Scenarios and Data Tables
2. Creating Goal Seek and Solver Models
3. Creating a Configurable Model
4. Performing Monte Carlo Simulation
- 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.Cancel
Take 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.