Excel What-If-Analysis Decision-Making Tools
Duration: 60 Minutes
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
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.
- Goal-Seek
- Data-Table
- One-Way Data Table
- Two-Ways Data Table
- Using Scroll Bars
- Case Study
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 solid quantitative background.
- Decision Makers
For more than 25 years Dr. Isaac Gottlieb has been teaching Excel workshops for MBA students in a number of universities, including, Columbia, NYU and others in the US and other countries. In addition, he taught courses of Management Science and Statistics for Managers (always) using Excel. Over 100,000 students have attended his workshops and courses over the past 25 years.
He received the Microsoft MVP – Most Valuable Professional – award for the years 2014-6. “A Microsoft Most Valuable Professional (MVP) is an award for individuals who have exhibited exceptional technical expertise and a talent for sharing knowledge within their technical community.” (From Microsoft’s site.)
Isaac Gottlieb has taught how to use Excel—and how to apply it effectively to various business disciplines—to thousands corporate professionals from leading multinational companies as well as small private business corporations.
He mails Excel-Tip-Of-The-Month to over 35,000 recipients.
Dr. Gottlieb has earned his PhD and two Masters Degrees from Columbia University Department of Industrial Engineering and Operations Research.
His two recent books are:
Excel 2022 Pro 100 + PivotTables, Charts & Reports: Explore Excel 2022 with Graphs, Animations, Sparklines, Goal Seek, Histograms, Correlations, Dashboards. Nov 2022.
Management Science using Excel: Harnessing Excel's advanced features for business optimization. Aug 2023.
Upcoming Webinars
By Diane L. Dee
Date: Oct. 6, 2025
By Dr. Susan Strauss
Date: Oct. 7, 2025
By Abdelrahman Abdou
Date: Oct. 9, 2025
By Melveen Stevenson
Date: Oct. 9, 2025
By Rebecca Staton-Reinstein
Date: Oct. 9, 2025
By David Nettleton
Date: Oct. 14, 2025
By Carl Young
Date: Oct. 15, 2025
By Beverly Beuermann-King
Date: Oct. 15, 2025
By Deb Schaffer
Date: Oct. 16, 2025
By Bruce Lee
Date: Oct. 17, 2025
By John Fetzer
Date: Oct. 17, 2025
By Erica Chisolm & Vanessa Hardiman
Date: Oct. 20, 2025
By Diane L. Dee
Date: Oct. 20, 2025
By Marcia Zidle
Retention Starts Here: Stop Losing Your Critical Talent and Start Keeping Them With Stay Interviews!
Date: Oct. 22, 2025
By Charles H. Paul
Date: Oct. 22, 2025
By Dr. Susan Strauss
Date: Oct. 23, 2025
By Michael Healey
Date: Oct. 24, 2025
By Mark Gorkin
Date: Oct. 29, 2025
By Pete Tosh
Recorded Session
By William J. Rothwell
Recorded Session
By Mike Thomas
Recorded Session
By Dr. Susan Strauss
Recorded Session
By Audrey Halpern
Recorded Session
By Cathy Horwitz
Recorded Session
By Dr. Susan Strauss
Recorded Session
By Beverly Beuermann-King
Recorded Session
By David Nettleton
Recorded Session
By Bruce Lee
Recorded Session
By Paul J. Cline
Recorded Session
By Beverly Beuermann-King
Recorded Session
By Charles H. Paul
Recorded Session
By Richard E Cascarino
Recorded Session
By Bruce Lee
Recorded Session
By Dr. Susan Strauss
Recorded Session
By Cathy Horwitz
Recorded Session
By Dr. Susan Strauss
Recorded Session
By Mark Gorkin
Recorded Session
By Marcia Zidle
Recorded Session
By Cathy Horwitz
Recorded Session
By Melveen Stevenson
Recorded Session
By Mike Thomas
Recorded Session
By Marcia Zidle
Unlock Employee Loyalty: Stay Interviews Will Keep Them Engaged Before They Start Looking Elsewhere!
Recorded Session
