2014
Lynda
Curt Frye
1:10
English

Make better decisions for your business by taking a deeper dive into your data with Microsoft Excel's analysis tools. In this advanced course, Curt Frye shows how to analyze hypothetical business cases using formulas and variable data. He'll show you how to build data tables, define alternative data sets with scenarios, find target values with Goal Seek, and analyze complex problems with Solver. The last two chapters show you how to create a configurable model with sliders and check boxes and how to run a Monte Carlo simulation.

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

Download File Size:196.54 MB

---