Excel Secrets: High Productivity learning what-if-analysis
4.4 (8 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
711 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Secrets: High Productivity learning what-if-analysis to your Wishlist.

Add to Wishlist

Excel Secrets: High Productivity learning what-if-analysis

A to Z Guide to make use of Excel What if Analysis in many possible ways PLUS lots of secrets finally revealed.
4.4 (8 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
711 students enrolled
Created by Amey Dabholkar
Last updated 9/2014
English
Learn Fest Sale
Current price: $10 Original price: $30 Discount: 67% off
2 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 6 Articles
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
Requirements
  • Laptop/Computer/Tablet/Mobile for Viewing this Course
  • Excel 2007 or Later. (Excel 2003 will also work)
Description

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Over 300+ Happy Students having great Content Engagement

LATEST: Course updated on 8th of September 2014

What's New: Cheat Sheet which helps you to revise the content later

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++


EXCEL EXPLORE'S WHAT IF ANALYSIS - THE MOST PRODUCTIVE TOOL

Benefits to Everyone

Accountant "I Can now Easily save the scenarios of multiples Tax rates and create provision for changes in Tax rates"

Broker "It 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 " It made me 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 Clarifies 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,
  • Examples
  • Test

This Excel course comprises of video training which you can watch at your own pace where ever you want.

Excel is one of the most used spreadsheet applications 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. SCENARIO MANAGER handles multiple scenarios in a fraction of seconds and helps you to take an 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?.

This course becomes more interesting when it comes 3 bonus sections to practice.

  • PMT FUNCTION
  • CASH FLOW
  • FORM CONTROLS, and lots more.

Includes:

  1. High Quality videos (Recorded at 720P HD Mode)
  2. Exercise Files/ Handouts to download
  3. Lifetime Access to the videos / Updates (if Any)

Note:

This course which focuses on the specific target of understanding WHAT IF ANALYSIS is recorded using Excel 2013 and can be used by Excel 2007 + Versions. This course is also suitable for Excel for Mac.

Click the "take this course" button, top right, now ... every hour you delay is costing you money ..

Who is the target audience?
  • Accountants
  • Managers
  • Analyst
  • Any Excel User
  • Corporate Person
  • Business Man
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 47 Lectures Collapse All 47 Lectures 02:40:37
+
Lets get Started...
4 Lectures 04:50

This video is an introduction to the course. This video Explains how te course is structured and methodology during this full course.

Preview 02:06

Exercise Files consists of

1) Start Files

2) Finished Files: Files after working with this video

3) Power point Presentation: Presentation used during this course

I recommend you to download the sample file associated with this video. This video consist of a zip file of all the workbooks used during this course with power point presentation.

Using Exercise Files
01:02

This E-Brochure is describes all the details regarding this course.

Preview 01:42

What if Analysis Presentation
13 pages
+
What is what if Analysis?
3 Lectures 07:50

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.

Preview 04:34

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

Where are these What if Analysis Tools
01:05

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

Keyboard Shortcuts to Access what if Analysis Tools
02:11
+
Goal Seek
8 Lectures 28:46

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.

What is Goal Seek?
06:15

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

Requirements of Goal Seek and solving Procedure
05:34

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

Solving Investment Problem
02:22

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

Marks Goal Problem
02:02

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

Loan Repayment Problem
02:58

Finding Missing Value
02:09

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

Calculating Number of Guest within Allocated Budget
02:12

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

Calculating Monthly payments for Home Loan
05:14
+
Scenario Manager
7 Lectures 28:57

This video explains the use of scenario manager

What is a Scenario Manager?
05:04

Understand the steps of creating the scenarios

Requirements of Creating scenarios and solving Procedure
04:09

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

Creating a Scenario
05:37

This video explains you how to edit or delete scenarios

Editing and Deleting a Scenario
02:22

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

Scenario Summary (Table+Pivot Table)
04:48

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

Merging Scenarios in same workbook
03:49

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

Merging Scenarios from different workbooks
03:08
+
Data Table
8 Lectures 28:51

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

Data Table: An Introduction
03:57

Explains you the solving procedure of data table and its requirements

Requirements of Creating a data Table and solving Procedure
05:20

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.

One Variable Data Table
04:45

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.

Two Variable Data Table
03:56

Reference another formula cell to create a data Table

Reference Formula to create a Data Table
01:40

Using a custom number formatting to hide a cell contain

Hide Formula Cells
01:58

One can also create a data table by referencing blank cells

Referencing Blank Cells and create a Data Table
03:11

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."

Commission Data Table
04:04
+
Solver
4 Lectures 14:05

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

What is Solver?
03:43

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

Enable Solver Add-in
01:44

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

Solving Problem
03:41

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

Adding Constrains
04:57
+
Bonus Files
6 Lectures 31:41

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

(1) PMT and Cash Flow
06:47

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

(2) Form Controls : Prerequisits
04:00

Using scroll bar to change the rate of interest cell

(2) Form Controls : Scroll Bar
04:44

Using spin button to move up and down the values

(2) Form Controls : Spin Button
04:13

Using checkbox to enable or disable taxes

(2) Form Controls : Check Boxes
05:49

Using Quick Access toolbar and macro to switch between scenarios

(3) Switch Scenarios using (QAT, Macro)
06:08
+
Cheat Sheet (Revise Anytime using cheat sheets)
4 Lectures 00:04

Cheat Sheet: Goal Seek
00:01

Cheat Sheet: Scenario Manager (1)
00:01

Cheat Sheet: Scenario Manager (2)
00:01
+
Conclusion
2 Lectures 01:29

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

Preview 00:59

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.

Preview 00:30
+
Next Step
1 Lecture 00:20

Details regarding all my social media links.

Preview 00:20

Summary Quiz
9 questions
About the Instructor
Amey Dabholkar
4.2 Average rating
87 Reviews
1,911 Students
3 Courses
Excel Educator and Professional

Amey Dabholkar, is recognized in his teaching Microsoft Excel. He owns and runs his website which delivers high quality Excel content and articles. The website features tutorials which are in form of video and comprehensive article. He is also renowned Udemy Premium Instructor delivering high quality content. His Dashboard Course (Part One) which was one of the best launch in year 2014 received over 1000+ Students and high quality interaction.

Comments, Feedback includes that the person/student could apply the technique very next day. He teaches by giving real life Example with current industry standards hence users are satisfied with it. Ask questions till convinced because he provides lifetime updates and support for his course.

Business world/ corporate world now requires the deep knowledge of dashboarding, data mining, analysis etc. Excel is a very good application which can perform these thing