Excel Secrets: High Productivity learning what-if-analysis
- 2.5 hours on-demand video
- 6 articles
- 3 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- 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
- Laptop/Computer/Tablet/Mobile for Viewing this Course
- Excel 2007 or Later. (Excel 2003 will also work)
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,
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.
- High Quality videos (Recorded at 720P HD Mode)
- Exercise Files/ Handouts to download
- Lifetime Access to the videos / Updates (if Any)
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 ..
- Any Excel User
- Corporate Person
- Business Man
This video is an introduction to the course. This video Explains how te course is structured and methodology during this full course.
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.
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.
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."
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.