Excel's What if Analysis

A step ahead to make you productive in any aspect of Excel
Course Created by Amey Dabholkar
Business world has now changed its style of working with each other, Collaborating with each others. This increases your potential to do lots of work in life. Applications like Office Suite, Adobe Suite have made it possible to change the scenario in current business world. To make it more flexible to work on a background which is computerized I make it a point to announce some special courses which can Enhance your productivity to suite current business scenario.

Not only the business people have been benefited but also thousands of people belonging to different backgrounds Learning, Teaching, collaborating, etc have been benefited by this learning program. I believe in teaching it through structured pattern which consist of Introduction, Explanation and plenty of Examples. So Join with me to Enhance your productivity.

  •   Lifetime access to all lessons!
  •   30 days money back guarantee!
  •   Accessible via iPhone, iPad and Android (soon!)

What if analysis is the most productive tool in Excel Explore how it has benefited lots of people:-

Accountant "I Can now Easily save the scenarios of multiples Tax rates and now can easily create provision for changes in Tax rates"
Broker "I can now create my brokerage table which helps me to calculate brokerage in an easy organised way. I don’t need help of any professional to do so. I saved a lot of $$$"
Investor "By Learning what if Analysis I became a smart investor rather than a bulk investor"
Analyst " What if Analysis made my knowledge to think out of the box and would easily use excel to analyse most of the data. I can now efficiently use solver to find out optimum solution to a problem"
Students "This make us more clear that how to analyse the data using data Analysis. We learned how to use financial functions and solve some of the complicated budget problem using goal seek

YOU CAN ALSO USE THIS SKILLS TO GET MORE PRODUCTIVE IN FUTURE.

Excel what if analysis video training is the ultimate course which will help you to get most out of your data with no special skills required. We believe in structured learning which comprises of Explaining the concept, Giving you bunch of Examples and then taking your test. This Excel course comprises of video training which you can watch at your own pace where ever you want. You also do not need to be present at a particular time for watching this course.

Excel is one of the most used spreadsheet application with ever expanding capabilities. You can get the most out of Excel by learning Excel's what if Analysis tool. e.g If you need a particular amount at an end of the period at a given a rate of interest then how much should you invest? and vice versa. This problem is normally solved by trial and Error method, permutation combination etc. which is time consuming and may not give accurate results but GOAL SEEK will help you to solve this problem within seconds.

What if you want to project future outcome i.e expected change in Tax rates. You have to create a provision beforehand and hence due to ever changing scenarios makes a difficult situation to decide SCENARIO MANAGER which can handle multiple scenarios in fraction of seconds and help you to take appropriate decision.

Creation of DATA TABLE helps to create a table of analysis of one or two variables without using a single formula.
What if you want to find an optimum solution to a problem having multiple conditions to solve. Utilty tool in Excel viz SOLVER is the best approach you solve that problem in seconds?.

Whats inclusive:

  1. Lifetime access to the course material
  2. Over 2 Hrs + of Video training
  3. Exercise Files which you can refer further
  4. High HD Quality videos.
Note: This tutorial recorded in Excel 2013 and which is applicable for Excel 2007+

Course Objectives

  • Efficiently Complete all the business analysis tools
  • Use Goal Seek to reach a desired Results
  • Use Scenario Manager to save what if analysis Scenarios
  • Use Solver to find out optimum solution to a Problem
  • Use Data Table for comparative analysis of One/Two Vairable

Who Is This For?

  • Accountants
  • Managers
  • Analysts
  • Finance, Taxation
  • Information Technology
  • Any Excel user

Course Outline

Chapter 1: What is what if Analysis

  • Lesson 1
    What is what if Analysis
    04:35
  • Lesson 2
    Where are these what if ana…
    01:06
  • Lesson 3
    Keyboard Shortcut to Access…
    02:12

Chapter 2: Goal Seek

  • Lesson 4
    What is goal seek
    06:16
  • Lesson 5
    Requirements of Goal Seek a…
    05:35
  • Lesson 6
    Solving Investment Problem
    02:23
  • Lesson 7
    Marks Goal Problem
    02:03
  • Lesson 8
    Loan Repayment problem
    02:59
  • Lesson 9
    Finding Missing Values usin…
    02:10
  • Lesson 10
    Calculating Number of guest…
    02:13
  • Lesson 11
    Calculating Monthly Payment…
    05:15

Chapter 3: Scenario Manager

  • Lesson 12
    What is a Scenario Manager
    05:05
  • Lesson 13
    Requirements of creating Sc…
    04:10
  • Lesson 14
    Creating Scenarios
    05:38
  • Lesson 15
    Editing and Deleting Scenarios
    02:23
  • Lesson 16
    Scenario Summary
    04:49
  • Lesson 17
    Merging Scenarios from same…
    03:50
  • Lesson 18
    Merge Scenarios from differ…
    03:09

Chapter 4: Data Table

  • Lesson 19
    Introduction to Data Table
    03:58
  • Lesson 20
    Requirements of Data Table
    05:21
  • Lesson 21
    One Variable data Table
    04:46
  • Lesson 22
    Two Variable Data Table
    03:57
  • Lesson 23
    Formula Cell to reference a…
    01:41
  • Lesson 24
    Hide Cells using Custom Num…
    01:59
  • Lesson 25
    Commission Data Table
    04:05

Chapter 5: Solver

  • Lesson 26
    What is Solver
    03:44
  • Lesson 27
    Enable Solver Add-In
    01:44
  • Lesson 28
    Solving a Problem using Solver
    03:42
  • Lesson 29
    Adding Constrains to Solver
    04:58

Chapter 6: Exercise File

  • Lesson 30
    Download Exercise File

  •   Lifetime access to all lessons!
  •   30 days money back guarantee!
  •   Accessible via iPhone, iPad and Android (soon!)