Learning Excel What-If Analysis

Go to class

Write Review

Free Online Course: Learning Excel What-If Analysis provided by LinkedIn Learning is a comprehensive online course, which lasts for 1-2 hours worth of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from LinkedIn Learning. Learning Excel What-If Analysis is taught by Curt Frye.

via LinkedIn Learning

1-2 hours worth of material

Self Paced

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

0, based on 0 Course votes at GetYourEducation

Start your review of Learning Excel What-If Analysis

Add review ->

Language

English
Certificate
Certificate Available
Date of Start
08th January, 2014
Price
Free Trial Available
Provider
LinkedIn Learning
Taught By

Curt Frye
Share this course

Learning Excel What-If Analysis

ANIMATIONs

Adobe Lightroom Classic Fundamentals

Build, Train, and Deploy ML Pipelines using BERT

English for Research Publication Purposes

English for Research Publication Purposes

Introduction to Bohemian Watercolor Techniques