Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Pro Tips: Analytics Tools
Getting Started
Course Structure & Outline (1:41)
DOWNLOAD: Course Resources
Setting Expectations (1:45)
Important Note for StackSkills Students
Analytics Tips
Introduction (0:29)
Quick Analysis Tools (6:03)
Scenario Manager (7:55)
Optimizing with Goal Seek (6:33)
Basic Forecasting (11:09)
Outlier Detection (9:24)
Automated Data Tables (8:06)
Power Query Tools (10:41)
Data Modeling 101 (10:23)
CUBE Functions (16:21)
Monte Carlo Simulation (11:38)
Advanced Optimization with Solver (12:16)
Analysis ToolPak (Preview) (8:10)
QUIZ: Analytics Tips
Wrapping Up
Resources & Next Steps
More from Maven Analytics
Outlier Detection
Complete and Continue