Learning Excel What-If Analysis
Offered By: LinkedIn Learning
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
- 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
- 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
- Organize your analysis worksheet
- Create a slider
- Create check boxes
- Manipulate your model
- Define a scenario
- Create an input table
- Calculate demand
- Run and evaluate your simulation
- Next steps
Taught by
Curt Frye
Related Courses
Introduction to Computational Finance and Financial EconometricsUniversity 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