Decision Modeling and Risk Analysis with Excel
What you'll learn
- Excel
- Uncertainty Modeling
- Decision Analysis
- Data Analysis
- Goal Seek
- VLOOKUP
- Pivot Table
- Data Analysis Toolpak
- Solver
- Sensitivity Analysis
- Tornado Chart
- Treeplan
- Decision Tree
- Value of Information
- Monte Carlo Simulation
- XLRisk
- Utility Theory
- Utility Function
- Exponential Utility Function
- Statistics
- Central Limit Theorem
- Probability Distribution
Requirements
- Basic commands of Excel
Description
We all have one thing in common – we don’t know what will happen tomorrow. Living together in this world full of uncertainties, some decisions are rather difficult to make:
I want to save some money for my future, but how should I allocate my investment?
I want to invest a lot in this new product, but will the market react to it well enough, to justify my investment?
I want to hire more employees, or increase my production, but what if the market demand drops?
The global pandemic has not ended, should I buy that cheap plane ticket?
This course will give you directions at these crossroads. We will use sensitivity analysis, decision tree, and Monte Carlo simulation to better understand this uncertain world, and ourselves.
Even better, we can achieve all of these in Excel, and you don’t need to be an advanced Excel user to benefit from this course. We will start from the basics, and go from zero to hero!
This course is for anyone who wants to make informed decisions, or just wants to learn more about Excel, or statistics in general. After this course, you will be well-equipped to use Excel to help you tackle real-world puzzles!
Who this course is for:
- Entrepreneurs who wants to grow their businesses
- People who want to learn more about Excel
- Anyone who wants to analyze the uncertainties before making decisions
- People who what to learn more about data analysis and modeling
- People who what to learn more about statistics
Instructor
Gancheng is a financial modeling professional based in New York. Gancheng has worked in the US, Germany, the Czech Republic, and China, across industries including market research, tourism, banking, real estate and energy. She has a deep passion for understanding different business models, and in creating financial models to tackle complicated business challenges. Over her career, she has helped big and small companies to improve their business processes.
Gancheng holds a master’s degree in Management Studies at Duke University, and a bachelor’s degree in Corporate Finance at HUST in China.