Master Decision making with Excel

Focused View

Amey Vidvans

1:36:04

501 View

0 - Goal seek calculate the Value needed to Achieve the Goal

1 - Goal seek calculate the Value needed to Achieve the Goal.mp4

06:14

1 - Goal-Seek.xlsx

1 - Excel WhatIf analysis data tables compare possible outcomes with variables

2 - Data-for-single-input-table.xlsx

2 - Understand Excel whatif analysis Data Table set up and Variable.mp4

04:03

3 - Excel whatif analysis data table with single Input and single output.mp4

04:19

3 - Single-input-table.xlsx

4 - Excel whatif analysis data table with single Input and multiple outputs.mp4

04:12

4 - single-input-table-Multiple-output.xlsx

5 - Analyze interest and down payment with Excel whatif analysis data table.mp4

06:13

5 - Double-input-table.xlsx

6 - Double-Input-table-example.xlsx

6 - Get desired profit with correct combination of price and sale using data table.mp4

06:31

2 - excel whatif analysis scenario manager How to choose the best scenario

7 - Scenario.xlsx

7 - Understand Excel whatif analysis scenario manager & How to create scenarios.mp4

06:14

8 - Use excel whatif analysis scenario manager to generate various alternatives.mp4

04:38

9 - Summary report using excel whatif analysis scenario manager for Comparison.mp4

06:28

3 - Understand Powerful Excel Solver in Excel whatif analysis

10 - Excel-Solver.xlsx

10 - Introduction to extremely powerful tool Excel solver in whatif Analysis.mp4

03:58

11 - How to use constraints to Achieve goals Excel WhatIf Analysis Excel Solver.mp4

07:47

12 - Data Analysis and Decision making using Excel WhatIf Analysis Excel Solver.mp4

04:46

4 - Excel Solver for Portfolio Management Profit maximization and Optimization

13 - How to find optimized solution Transport Optimization problem with Excel Solver.mp4

09:24

13 - Transportation-Optimization-1.xlsx

13 - Transportation-Optimization-2.xlsx

14 - Book1-1.xlsx

14 - Profit maximization using Excel WhatIf Analysis Excel solver.mp4

09:54

15 - Portfolio Managementfunds allocation using Excel WhatIf Analysis Excel solver.mp4

10:26

15 - Portfolio-Management-excel-solver.xlsx

5 - Bonus Section

16 - Powerful Excel Gantt charts Effortless Project Management.mp4

00:57

16 - Powerful Excel Gantt charts Effortless Project Management.txt

16 - excel-gantt-chart-2.zip

Description

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

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.

Who is this for?

Any one who wants to improve decision making

Any one who wants to improve productivity.

What You Need to Know?

Desire to learn and an open mind

Spreadsheet

More details

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.

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Amey Vidvans

Instructor's Courses

I am an education and Technology enthusiast .I particularly enjoy collaborating with people from different disciplines to develop new skills and solve a challenge.I am a Yoga Wellness Instructor , QCI Level-2 , Ayush Mantralay, Govt. Of India.I believe in Applied Learning Approach while designing a course,which integrates classroom learning with real world situation.I am a Civil Engineer with MBA in Marketing and currently working in a top real estate firm with Specialization in Project Management.My moderate portfolio includes an experience of 20 years in Project Management and operations, with a credit of successfully handling diverse Projects such as SEZ ,IT, Commercial,Residential and Hotel.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.