Learning Excel What-If Analysis

Author

Released

1/8/2014

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.

Topics include:

Creating a scenario

Defining data tables

Finding a target value with Goal Seek

Defining constraints and running Solver

Creating a configurable model

Manipulating your model

Running a Monte Carlo simulation

Skill Level Intermediate

1h 10m

Duration

206,320

Views

Show MoreShow Less

- Hi, I'm Curt Frye.Welcome to Up and Running with Excel What-If Analysis.In this course, I will show you how to use Excelto answer business questions, using variable data.I'll start by demonstratinghow to define alternative data sets, using scenarios.And then move on to varying formula inputs,using one and a two variable data tables.Next I'll show you how to find a target valueusing Goal Seek,and then how to analyze complex problems using Solver.The final two chapters demonstratethe power of building models into your Excel worksheets.

Chapter three shows you how vary inputs into a model,using tools such as Sliders and Check Boxes.While Chapter four,shows you how to create a Monte Carlos simulation,using random events to model a business process.All of these methods provide the power and flexibilityyou need to make good decisions for your company.I'm sure you'll find that your timewith Up and Running with Excel What-If Analysiswill be time well spent.Dive right in.