Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Provider Logo

Learning Excel What-If Analysis

via LinkedIn Learning

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.

Syllabus

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

Taught by

Curt Frye

Related Courses

Reviews

0.0 rating, based on 0 reviews

Start your review of Learning Excel What-If Analysis

Never stop learning Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free