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
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!
