Excel Secrets: High Productivity learning what-if-analysis

This Lecture will Explain you what is the benefit of what if analysis tools, Explain the meaning of the same and will walk you through how we are going to go throughout this series.

Topics Covered:

1) Access What if analysis tools by going to data tab > Data Tools > What if Analysis

2) Creating Shortcuts in Quick Access Toolbat

Using Keyboard shortcuts to Access the what if Analysis tools features. Learn about 6 keyboard shortcuts

Goal seek is used to reach the desired result by changing formula dependent cells. Learn how the goal seek is used through a bunch of examples.

Steps are the rules and when you follow the rules you can easily become master in it. Solving procedure will explain how to analyse the affected unaffected cells and then use the parameters from the goal seek

Investment problem is the most commonly problem in current investing world. How to solve a typical investment problem learn from this video.

Scenario: How much more marks should i obtain in a particular subject so as my average is 90%.

Scenario: in how much period should i repay the loan so as my monthly payments would be $3000.

Budget problem is the most common problem and you can use the goal seek to solve the problem.

Here is a practical problem where you have to calculate monthly payments for home loan

This video explains the use of scenario manager

Understand the steps of creating the scenarios

This video explains you how to create a scenario for data analysis

This video explains you how to edit or delete scenarios

This video explains you how to create a scenario summary to analyse the given scenarios

This video explains you how to merge scenarios in the same workbook

When you have to create repeated scenario at that time this feature helps you. This video explains how to merge scenarios belonging to diferent workbooks

Data Table helps one to find out the values by comparing one/Two Variables

Explains you the solving procedure of data table and its requirements

Data Tables are of two types. One variable and two variable. One variable data table consist of one variable which can either be rate of interest or a period in months.

Data tables are of two types one variable data table and 2 variable data table. This two variable data tables consists of a row input cells and column input cells.

Reference another formula cell to create a data Table

Using a custom number formatting to hide a cell contain

One can also create a data table by referencing blank cells

In practical scenario one has to create a complicated data table. The commission data table is one of the example which will make you pro in Data Table. Its very simple scenario but a little complicated steps. "Commission depends upon type of product sold and number of item sold. Create a data Table to summarize 2 variables."

This Lecture explains you the importance of solver and also some core points. Understand core points to become master in Solver

Solver is an add-in which is readily available in Excel but it's not enable. In this video i will walk you through how to enable the solver add-in to get the most of it

This Lecture explains you the basic concept and solves the problem by filling parameters. Conditions are added in the next lecture

Constrains are the condition applied to the cells to get an optimum solution. More constrains you add more it will reach to the solution and more time it will take to solve and overall which will complicate the process. To know more watch the lecture

This bonus file will explain you the PMT() function which was used for the most of the time in this video. I will also explain you the cash flow which is necessary for PMT function to give the correct result

This procedure will explain you how to enable developer tab which can be used for form controls. Also you will find basic explanation and introduction to form controls in this video

Using scroll bar to change the rate of interest cell

Using spin button to move up and down the values

Using checkbox to enable or disable taxes

Using Quick Access toolbar and macro to switch between scenarios

I have enjoyed a lot with you thanks for joining this course and spending the precious time watching all the videos

I am sure that this course will enable managers to take appropriate decisions in various fields. This will also reduce there time in analysing data in most effective manner. If you donot understand the course at first instance then repeat the same video till you are confident using all the tricks mentioned in this video.

Details regarding all my social media links.