Scenario Analyses: Concepts and Tools for Business Analytics

Beginners Guide To Scenario Analyses and its Implementation in Business Context Using Microsoft Excel

What you’ll learn:
Understand What Is Scenario Analyses 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
Scenario Analyses 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 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.

In this course after learning the Scenario Analyses concept and applications, we first learn how to analyze and calculate profit and cost (including fixed and variable cost), how to calculate the Break Even Point, and how to form an Income Statement using Microsoft Excel. While calculating these important business metrics, we learn how to set up our excel sheets to be ready for further scenario analyses. Then using excel tools such as Goal Seek, Data Table, and Solver, we implement some scenario analyses to achieve certain outcomes that are desired.

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.

Who this course is for
Business Students
Entrepreneurs
Engineers
Programmers
Whoever needs planning for the future!