Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Master Decision making with " Excel What-If Analysis"!

Name: Master Decision making with " Excel What-If Analysis"!
Rating: 4.6 (2564 reviews)

Unleash Advanced Excel for Business decision making. Master Sensitivity analysis, scenario comparisons and Excel solver.

Created byAmey Vidvans

Last updated 6/2025

English

What you'll learn

Goal seek - How to get required input to achieve results.
How to perform sensitivity Analysis using data tables.
Find the best alternative using Scenario manager
How to use much powerful excel solver to solve real life problems like Portfolio Management, Resource Optimization and Profit maximization.

Course content

6 sections • 16 lectures • 1h 36m total length

Goal seek - calculate the Value needed to Achieve the Goal !6:14
After completing the lecture, you will be able to do the following -
Calculate the input required to achieve desired profit
Understand the Goal seek function.
How to Access Goal seek function.
How to use Goal seek function.
What to do, If the Goal seek function doesn't give values.
Calculate Break-even point and Final grade marks using Goal seek

Understand Excel what-if analysis Data Table set up and Variable4:03
After completing the lecture, you will be able to do the following -
Understand the Anatomy of the Data Table function.
Understand Variables.
Calculate monthly instalments using the PMT function.
Excel what-if analysis data table with single Input and single output.4:19
After completing the lecture, you will be able to do the following -
How to use input or variables to get the correct result.
Find the most suitable combination of down payment and monthly instalments.
Use single input or single variable to calculate the single output.
Excel what-if analysis data table with single Input and multiple outputs4:12
After completing the lecture, you will be able to do the following -
How to use vales of inputs or variables.
How are input values arranged?
How to give references to get multiple outputs.
Understand the layout of the data table.
Analyze interest and down payment with Excel what-if analysis data table.6:13
After completing the lecture, you will be able to do the following-
Calculate Monthly instalments for various combinations of interest and down payment.
How to use Two input data table for multiple combinations of two inputs.
Understand the anatomy of Two input data table.
Get desired profit with correct combination of price and sale using data table.6:31
After completing the lecture, you will be able to do the following-
How to get the desired profit with the right combination of selling price and sales
How to use conditional formatting to highlight important values.

Understand Excel what-if analysis scenario manager & How to create scenarios.6:14
After completing the lecture, you will be able to do the following-
Understand Scenario Manager
Difference between scenario manager and Goal seek and data tables.
How to name a cell range
How to create different scenarios
Use excel what-if analysis scenario manager to generate various alternatives.4:38
After completing the lecture, you will be able to do the following-
How to use scenario manager for decision making.
How to create a base value.
How to set different input values and check the respective output.
Summary report using excel what-if analysis scenario manager for Comparison.6:28
After completing the lecture, you will be able to do the following-
How to create a summary report
How to change the base value for scenario comparisons
How to add more output values in the summary report

How to find optimized solution? Transport Optimization problem with Excel Solver9:24
Profit maximization using Excel What-If Analysis Excel solver9:54
Portfolio Management/funds allocation using Excel What-If Analysis Excel solver.10:26
After completing the lecture you will able to do the following -
Portfolio management using Excel solver.
How to allocate funds to maximize returns and minimize risks.
Understand beta or volatility.
How to calculate partial beta and expected returns.
Develop a solver model using constraints.
Solve Maths Puzzle "Magic Square" using Excel solver.
What is Olivia's Age? Math's Puzzle using Excel solver

Powerful Excel Gantt charts -Effortless Project Management !0:57
Excel Gantt charts in Minutes.Become an efficient Project Manager. Use Gantt chart Excel templates and Tracking system.
Where Dynamic Excel Gantt charts can be used -
Excel gantt charts are immensely helpful for managing simple and straight forward projects.
You can use it along with MSP or Primavera ,for creating further break up of activities.
You can easily use excel gantt charts if you don't have any costly Project Management softwares.
You can use various techniques to present critical information in a far better manner.
It uses tremendous capabilities and versatility of Excel.

Requirements

Desire to learn and an open mind
Spreadsheet

Description

Welcome to the course where you will learn one of the most underutilized features of Microsoft Excel, Excel what-If analysis.

In business, making the right decision is key to success. What-if analysis is a tool used to help make better decisions by exploring different scenarios and their possible outcomes.

It can be used to help evaluate risks and opportunities and compare the different scenarios and see which one leads to the best outcome.

Using Excel What-If Analysis you can consider different choices and their potential consequences. It will help you better understand the risks and rewards associated with each option.

Master the art of strategic decision making –

Through real life examples you will master various tools like Goal seek which is used for reverse calculation, Data table which is used for sensitivity analysis and scenario manager which is used for scenario comparisons.

Apart from this You will learn to use Excel solver to handle more Complex problems with ease.

Content and Overview: -

Together we will walk through this process, systematically decoding each element.

Irrespective of the domain and industry, apart from giving necessary knowledge, tool and techniques this is my attempt to help you improve decision making process.

I have tried to use applied learning approach while designing the course. This approach integrates class room learning with real-world situations.

What will you learn?

Goal seek - How to get required input to achieve results.
How to perform sensitivity Analysis using data tables.
Scenario comparisons for ease of decision making.
How to deal with complex problems using much powerful excel solver.
Learn to handle the data and process it.

who will benefit the most from the course on Excel what-If Analysis

Anyone who wants to use Excel to its fullest potential.
Anyone who wants to improve skills in data analysis.
Business professionals who want to make better decisions by exploring different scenarios and their possible outcomes.
Business professionals who want to evaluate risks and opportunities.
Professionals in finance or accounting who want to learn more about Excel what-if analysis
Anyone who wants to improve their ability to analyze data and make better decisions.

Post purchase support : - A complete support and assistance is available for you.I would really love to see you use this on regular basis .

Money Back Guarantee : - On top of it UDEMY gives money back guarantee for 30 days if you are not satisfied.

See you inside the course and add this amazing tool to your knowledge portfolio.

Who this course is for:

Any one who wants to improve decision making
Any one who wants to improve productivity.

Master Decision making with " Excel What-If Analysis"!

What you'll learn

Explore related topics

Course content

Introduction to Goal seek1 lecture • 6min

Excel What-If analysis data tables - compare possible outcomes with variables5 lectures • 25min

excel what-if analysis scenario manager - How to choose the best scenario.3 lectures • 17min

Understand Powerful Excel Solver in Excel what-if analysis.3 lectures • 17min

Excel Solver for Portfolio Management, Profit maximization and Optimization.3 lectures • 30min

Bonus Section1 lecture • 1min

Requirements

Description

Who this course is for: