…Worksheet models let you combine a series of inputs into a coherent picture.…Some inputs are numbers, such as computer prices.…While others are costs that might or might not apply.…For example, you could choose whether to include a product category in an order.…In this movie, I'll show you how to turn…individual items on and off by using check boxes.…I'm going to work in the check boxes sample…file, which you can find in the chapter three folder…of your exercise files archive. This worksheet has a series…of elements to it. The first are the costs for given product…categories at given quantities, so, for example, 250 servers at $1500 each…with an 18.1% discount would cost just over $307,000.…
And the same for desktops, notebooks and tablets.…The other financial terms are the number…of years and the interest rate, and then I've…calculated my monthly payment, base price and total cost.…The discount scroll bar value is linked to the slider here.…That's currently positioned on row ten.…So if I click the left and right arrows, I can increase or decrease the discount.…
- 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.