Salepage link: At HERE. Archive: http://archive.is/jUEaQ
with Dr Isaac Gottlieb.
In this course you’ll learn the techniques Dr Gottlieb teaches his MBA students without having to attend a costly university. Learn how to leverage Excel tools for making business decisions under uncertainty, including:
You’ll examine real business case studies, apply Excel tools to aid in decision making and learn how to use Excel to analyze data and reach decisions.
Practice exercises for each session encourage you to fine tune what you learn.
And when you’re finished we’ll send you a Certificate of Completion to add to your résumé.
This course is ideal for executives or analysts that want to improve or refresh their skills and all levels of business school students.
The course is intended for all levels and does not require any specific knowledge other than basic Excel skills. It is touching topics of statistics, probability, finance and accounting – but novice level will do.
The course contains three sessions: Simulations, Decision Trees and Forecasting. You can take them in any order. Each session includes practice exercises using real business scenarios.
You will learn how to apply Monte Carlo Simulations using Excel. This part will show how to generate probabilistic, uncertain or risky situations and simulate the potential outcome hundreds or thousands of times, constructing a risk profile of an investment, a budget or a business plan.
Risk Profile of a Business Plan Budget
You will find out how to “grow” decision trees in Excel using a free 3rd party add-in. Instead of using manual techniques, you will be able to create multi stage decision trees in Excel that can help you both analyze and demonstrate the potential consequences of your decision making process.
A Decision Tree Created in Excel
The Forecasting module will take you through a variety of tools including the Data Analysis toolpack.
You will be able to use Moving Averages, Exponential Smoothing, Trends, Regressions and Multi Regressions using Excel.
Using Excel for Forecasting