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:
- 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.
Who is teaching the course
Dr. Isaac Gottlieb earned his PhD in Management Engineering from Columbia University. He was a clinical professor at the Fox Business School of Temple University and has over 15 years of industrial experience.
He was awarded a Microsoft Excel Most valuable Professional (MVP) for 2014 - 2016.
Dr. Gottlieb has taught Excel over the last 15 years to over 30,000 MBA, executive MBA, MS, PhD and undergraduate students at Columbia, NYU, Temple, and other universities. He has conducted numerous corporate seminars in the United States and abroad.
He is also the author of Next Generation Excel: Modeling in Excel for Analysts and MBA’s.
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.
Risk Profile of a Business Plan Budget
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.
A Decision Tree Created in Excel
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.
Using Excel for Forecasting
Watch a Sample Video from the Course
Choose Your Membership Level
Excel for Decision Making Online
USD $49Add to cart
USD $49Add to cart
12 Months Online
Online Only Access To Course
Course Videos 2hrs 14mins
One Payment for 12 Months Access
Unlimited 24/7 access
Pause, rewind, replay
Download Workbooks and Practice Data
30 Day Money Back Guarantee
Excel for Decision Making Download
USD $99Add to cart
USD $99Add to cart
12 Months Online + Download
Online Access + Download & Keep Course Videos*
Course Videos 2hrs 14mins
One Payment for 12 Months Access
Unlimited 24/7 access
Pause, rewind, replay
Download Workbooks and Practice Data
30 Day Money Back Guarantee
Notes
- Videos will be available for download after the 30 day Money Back Guarantee period ends. You can watch the videos online in the meantime.
- Membership and access to the training materials is for one person only. Logons are not to be used by multiple people.
- Downloaded videos are to be used only by the registered member, they are not to be transferred/shared amongst other people.
- *You can request a refund provided that no more than 30% of the course videos have been watched.