Learning Excel What-If Analysis
Overview
Analyze hypothetical business cases using Excel formulas and variable data.
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.
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.
Syllabus
Introduction
- Welcome
- What you should know before watching this course
- Using the exercise files
- 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
- Finding a target value using Goal Seek
- Activating Solver
- Setting up a Solver worksheet
- Defining constraints and running Solver
- Requiring integer solutions
- Organizing your analysis worksheet
- Creating a slider
- Creating check boxes
- Manipulating your model
- Crafting a scenario
- Creating an input table
- Calculating demand
- Running and evaluating your simulation
- Next steps
Taught by
Curt Frye
Related Courses
Reviews
0.0 rating, based on 0 reviews
Never Stop Learning!
