Master Scenario Analysis In Excel For Business & Planning
Last updated 6/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 798.86 MB | Duration: 1h 54m
Last updated 6/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 798.86 MB | Duration: 1h 54m
Complete Guide To Scenario Analyses and Monte Carlo Simulation Concepts and Tools in Microsoft Excel -Business Analytics
What you'll learn
Understand What Is Scenario Analysis in Business Context
Explain When Scenario Analyses Can be Used
Learn Implementing Scenario Analyses Using Microsoft Excel
Learn How to Calculate Profit and Costs Including Fixed and Variable Costs
Learn How to Use Data Table, Goal Seek, and Solver Commands in Excel
Learn the Steps of Scenario Analyses
Requirements
Basic Familiarity with Microsoft Excel
Description
In this course three goals are pursued: 1- Learning Scenario Analysis and it's technics including but limited to Monte Carlo Simulation 2- Learning Microsoft Excel's scenario Analysis tools 3- and learning business analytics formula and parameters that are applicable in all business contexts and are essential for anyone involved in business, economics, and finance. Scenario Analysis is a powerful planning and management technic to deal with various possible futures and make sure to achieve an acceptable outcome under different scenarios. This technic is used in business, finance, economics, politics, negotiations, and even military operations. The main argument of this technic is that when outlining a plan, our assumptions can change due to unpredicted events and therefore the outcomes can change. For this reasons, we need to count in different scenarios (through changes in assumptions) and study their impact on the outcomes. Essentially, scenario analysis is a method of dealing with randomness in life. An advance technic of dealing with randomness is called Monte Carlo Simulation, which uses random sampling to predict and forecast future outcomes under numerous random scenarios. In this course, students will learn this powerful technic and learn how to implement a sample Monte Carlo Simulation using Microsoft Excel creatively. Also, Microsoft Excel Provides various powerful tools for scenario analysis including Goal Seek, Data Tables, Scenario Manager, and Solver. In this course after learning the Scenario Analysis concept and applications, students first learn how to analyze and calculate profit and cost (including fixed and variable cost), how to calculate the Break Even volume, and how to form an Income Statement using Microsoft Excel. While calculating these important business metrics, students learn how to set up excel sheets to be ready for further scenario analyses. Then using excel tools such as Goal Seek, Data Table, and Solver, students implement some scenario analyses to achieve certain desired outcomes. Monte Carlo Simulation is offered at the end of the course as an advanced bonus for curious minds. About the Instructor:My name is Mohammad Habibi. I have a Ph.D. in business and have taught in various programs including undergrad and graduate (MBA) courses in different parts of the world such as US, Canada, Malaysia, and Iran. My teaching style is quick and to the point and I believe learning will occur while doing. If you have any questions please send me an email or connect with through LinkedIn.
Overview
Section 1: Introduction
Lecture 1 Introduction
Section 2: Scenario Analyses and Its Applications
Lecture 2 What Is Scenario Analyses?
Lecture 3 Scenario Analyses Applications
Section 3: Basic Business Quantitative Analytics
Lecture 4 Basic Business Quantitative Analytics - Intro
Lecture 5 Profit and Cost Analytics Formulas
Lecture 6 Break Even Analyses Intro and Formula
Lecture 7 Markup Analyses
Section 4: Doing Business Analytics Using Excel
Lecture 8 Multi Channel Markup Analyses - Using Excel
Lecture 9 Break Even Analyses Using Excel
Lecture 10 Scenario Analysis Using Goal Seek in Excel
Lecture 11 Earning Statement Projection Using Excel
Lecture 12 Scenario Analysis; Sales Growth
Lecture 13 Scenario Manager in Excel
Lecture 14 Scenario Analysis: One Variable Data Table in Excel
Lecture 15 Scenario Analysis: Two Variables Data Table in Excel
Lecture 16 Scenario Analysis Using Solver in Excel
Section 5: Monte Carlo Simulation; Bonus Section - Advanced
Lecture 17 Introduction to Monre Carlo Simulation
Lecture 18 Implementing Monte Carlo Simulation Using Excel
Business Students,Entrepreneurs,Engineers,Programmers,Whoever needs planning for the future!