[Lynda.com] Up and Running with Excel What-If Analysis [2014, ENG]

Содержание

Introduction
Welcome
What you should know before watching this course
Using the exercise files
1. Defining Scenarios and Data Tables
Creating a scenario
Showing and hiding scenarios
Summarizing scenarios
Editing and deleting scenarios
Defining a one-variable data table
Defining a two-variable data table
2. Creating Goal Seek and Solver Models
Finding a target value using Goal Seek
Activating Solver
Setting up a Solver worksheet
Defining constraints and running Solver
Requiring integer solutions
3. Creating a Configurable Model
Organizing your analysis worksheet
Creating a slider
Creating check boxes
Manipulating your model
4. Performing Monte Carlo Simulation
Crafting a scenario
Creating an input table
Calculating demand
Running and evaluating your simulation
Conclusion
Next steps

Скриншоты