Overview
-
Leverage some of the most powerful analytics techniques for Excel. Learn how to conduct outlier detection, perform Monte Carlo simulations, use CUBE functions, and more.
Syllabus
-
Introduction
- About the Pro Tip series
- Analytics tips
- Quick Analysis toolset
- Scenario Manager
- Optimization with Goal Seek
- Basic forecasting
- Outlier detection
- Automated data tables
- Power Query tools
- Data modeling 101
- CUBE functions
- Monte Carlo simulation
- Advanced optimization with Solver
- Analysis ToolPak (preview)
- Conclusion: Analytics tips
