Learning Excel What-If Analysis

Focused View

Curt Frye

1:22:19

142 View

01 - Introduction

01 - Improve decision-making with what-if analysis.mp4

00:52

01 - improve decision-making with what-if analysis.mp4.zip

02 - What you should know.mp4

01:08

02 - 1. Defining Scenarios and Data Tables

01 - Create a scenario.mp4

03:08

02 - Show and hide scenarios.mp4

04:07

03 - Summarize scenarios.mp4

04:06

04 - Edit and delete scenarios.mp4

03:46

05 - Define a one-variable data table.mp4

03:46

06 - Define a two-variable data table.mp4

04:16

03 - 2. Creating Goal Seek and Solver Models

01 - Find a target value using Goal Seek.mp4

02:52

02 - Activate Solver.mp4

01:48

03 - Set up a Solver worksheet.mp4

04:45

04 - Select an optimization target and operation.mp4

01:58

05 - Define constraints.mp4

06:52

06 - Require integer solutions.mp4

04:04

04 - 3. Creating a Configurable Model

01 - Organize your analysis worksheet.mp4

02:20

02 - Create a slider.mp4

05:52

03 - Create check boxes.mp4

08:47

04 - Manipulate your model.mp4

03:44

05 - 4. Performing Monte Carlo Simulation

01 - Define a scenario.mp4

03:01

02 - Create an input table.mp4

04:20

03 - Calculate demand.mp4

02:19

04 - Run and evaluate your simulation.mp4

03:14

06 - Conclusion

01 - Next steps.mp4

01:14

Description

Excel is a useful and versatile tool, but did you know you can also use it to analyze hypothetical business cases? Instructor Curt Frye walks you through the complete process. Curt begins by showing you how to create, define, edit, and delete scenarios, then goes into defining data tables. He explains how to use Goal Seek and Solver to create models, define constraints, and require integer solutions. Next, Curt covers ways to organize your analysis worksheet, use checkboxes to turn options on and off, and manipulate a worksheet model to analyze your business. Plus, he defines and demonstrates how to perform a Monte Carlo simulation.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Excel Analytics

Excel Formulas and Functions

Curt Frye

Instructor's Courses

I'm president and founder of Technology and Society, Incorporated, an Oregon "C" Corporation that encompasses my work as a course developer, writer, and speaker. I offer programs on effective teamwork, personal development, and business storytelling. BA (political science) and MBA.

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.