Isaac Gottlieb – Excel For Decision Making Under Uncertainty Course

Popular Content

• 10 Common Excel Mistakes to Avoid
• Top Excel Functions for Data Analysts
• Secrets to Building Excel Dashboards in Less Than 15 Minutes
• Pro Excel Formula Writing Tips
• Hidden Excel Double-Click Shortcuts
• Top 10 Intermediate Excel Functions
• 5 Pro Excel Dashboard Design Tips
• 5 Excel SUM Function Tricks
• 239 Excel Keyboard Shortcuts

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:

• Simulations (Monte Carlo)
• Decision Trees
• Forecasting, including use of the Data Analysis toolpack.

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.

Course Prerequisites

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.

Course Syllabus

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.

Simulations

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.

Decision Trees

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.

Forecasting

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.