The objective of this workshop is to cover the What-if Analysis set of decision-making tools. It enables the user to investigate what is the impact of input changes on outputs. This allows the decision-maker to make wiser choices for an optimal outcome.
Course Outline:
The workshop is about the What-if Analysis - a set of Excel’s decision-making tools. These tools enable the user to investigate what is the impact of input changes on correlated outputs. It allows the decision-maker to make wiser choices. The two topics covered are the Goal Seek and the Data Table - Sensitivity Analysis. You will learn how to use these features for any of your models (budgets, forecasts or other disciplines) – to be able to understand what is the impact of changes of these models. These tools empower the users to evaluate and examine their decision models – potentially reaching better decisions. The chapter covers the Goal Seek and the Sensitivity Analysis tools.
The two topics used frequently for this matter are:
• Goal Seek
• Data Table -Sensitivity Analysis
Goal-Seek, the first tool, allows the analyst to check the impact of one variable input’s change on a target output. The user determines a goal - and the tool shows the user what has to be changed to achieve that goal.
Data-Table is a Sensitivity Analysis tool. The analyst can change one or two inputs (One-Way and Two-Way Data Tables) and find out the impact of making small incremental input changes in one or two variables on the outputs.
Topics to be Covered:
• Goal-Seek.
• Data-Table.
o One-Way Data Table.
o Two-Ways Data Table.
o Using Scroll Bars.
• Case Study.
What You Get:
• Training Materials
• Live Q&A Session with our Expert
• Participation Certificate
• Access to Signup Community (Optional)
• Reward Points
Who Will Benefit:
Excel users that need advanced tools for and decision making. These topics were taught by the presenter in the executive MBA programs, where the attendees did not have a quantitative background.
Lookup Function Essentials in Microsoft Excel
Get Instant Access 60 Minutes View Program |
Filtering Techniques for Microsoft Excel Data
Get Instant Access 90 Minutes View Program |
Mastering Microsoft Excel® Macros and VBA
Get Instant Access 60 Minutes View Program |
2 Hours Virtual Seminar on Microsoft Excel Functions
Get Instant Access 120 Minutes View Program |
Analyzing Data using Microsoft Excel Pivot Tables
Get Instant Access 90 Minutes View Program |
Get Instant Access On-Demand Access
Preparing for the ICE Storm: What to Do During I 9 Audits and ICE Raids
Janette S. Levey
Human Resources
Get Instant Access On-Demand Access
OSHA Inspections and Investigations-How to Manage Them
Irwin Dobrushin
Environment Health and Safety | OSHA
Get Instant Access On-Demand Access
29 CFR 1904: OSHA's New Injury Recordkeeping E-Submission Rule
Occupational Safety and Health Administration
Get Instant Access On-Demand Access
Working with Excel Databases: Sort, Filter, Subtotal and More
Cathy Horwitz
Cross Industry | Skill Enhancement
Get Instant Access On-Demand Access
Writing Audit Reports
Jonnie T. Keith CIA, CFE, CGAP, CICA
Governance, Risk and Compliance
Get Instant Access On-Demand Access
BSA Reporting Requirements
Banking and Financial Services Industry
Get Instant Access On-Demand Access
Human Factors-Usability Based on ISO 62366
Medical Device | Diagnostic | Pharmaceutical | Biologics fields
Get Instant Access On-Demand Access
Chat GPT for Project Managers
Charles H. Paul
All FDA Regulated Industry