YoVDO

Learning Excel What-If Analysis

Offered By: LinkedIn Learning

Tags

What-if Analysis Courses Data Tables Courses Monte Carlo Simulation Courses Financial Modeling Courses Goal Seek Courses

Course Description

Overview

Find out how to analyze hypothetical business cases in Excel.

Syllabus

Introduction
  • Improve decision-making with what-if analysis
  • What you should know
1. Defining Scenarios and Data Tables
  • Create a scenario
  • Show and hide scenarios
  • Summarize scenarios
  • Edit and delete scenarios
  • Define a one-variable data table
  • Define a two-variable data table
2. Creating Goal Seek and Solver Models
  • Find a target value using Goal Seek
  • Activate Solver
  • Set up a Solver worksheet
  • Select an optimization target and operation
  • Define constraints
  • Require integer solutions
3. Creating a Configurable Model
  • Organize your analysis worksheet
  • Create a slider
  • Create check boxes
  • Manipulate your model
4. Performing Monte Carlo Simulation
  • Define a scenario
  • Create an input table
  • Calculate demand
  • Run and evaluate your simulation
Conclusion
  • Next steps

Taught by

Curt Frye

Related Courses

Introduction to Computational Finance and Financial Econometrics
University of Washington via Coursera
Math behind Moneyball
University of Houston System via Coursera
La gestión de los riesgos y la administración de los cambios en el proyecto
University of California, Irvine via Coursera
Introduction to Spreadsheets and Models
University of Pennsylvania via Coursera
Managing Uncertainty in Marketing Analytics
Emory University via Coursera