Excel's What if Analysis هذه الدورة تدرس باللغة الإنجليزية

تفاصيل الدورة

Get My Course at $25 Using Coupon code : " GRABAT25"

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

This course becomes more interesting when it comes 3 bonus sections to practice. This 3 bonus sections will teach you PMT Function, Cash Flow, Form Controls, and lots more.

Whats inclusive:

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 is recorded using Excel 2013 and can be used by Excel 2007 + Versions. This course is also suitable for Excel for Mac. This course focuses on specific target to understand What if Analysis.