STEM / Analytics

Learning Excel: Data Analysis

Spreadsheets are only as valuable as the insights you can pull from them. Excel gives professionals with a foundational knowledge of statistics a full tool kit for turning raw data into business intelligence—and Copilot speeds up the pattern-finding.

In this course, Microsoft Excel MVP Mynda Treacy steps through practical statistical techniques using built-in features and functions in Excel. Learn how to summarize large datasets with PivotTables, measure variability with variance and standard deviation, and calculate probabilities with common distribution functions. Mynda also shows you how to apply trendlines and regression analysis to forecast outcomes, evaluate relationships between variables (while avoiding common interpretation mistakes), and use Copilot to accelerate exploration. Along the way, you can reinforce your skills with hands-on challenges based on realistic business scenarios.

This course was created by Mynda Treacy. We are pleased to host this training in our library.

Learn More