Excel: Analytics Tips

Deepen your Excel knowledge by picking up powerful and effective analytics techniques used by Excel pros. In this course, instructor Chris Dutton shows how to leverage intermediate to advanced Excel analytics functionality using crystal clear demos, real-world case studies, and bite-sized lessons. Each video is self-contained and focuses on a key tool or feature that you can add to your Excel tool kit. Learn how to conduct outlier detection, perform Monte Carlo simulations, and use CUBE functions. Plus, explore forecasting, using the Goal Seek feature, and leveraging Solver to tackle complex optimization models in Excel.

Note: Chris uses Microsoft Office 365 ProPlus for PC throughout the course, so some tips may not apply to all versions of Excel.

Learning objectives
Use the Analysis ToolPak to explore data.
Interpret the effect of a fence when using outlier detection.
Explain data modeling basics in Excel.
Use CUBE functions to explore data models.
Use Monte Carlo simulations to predict outcome probability.
Recognize the actions Solver does to optimize complex data models.