← Back to catalog
$297advanced
Microsoft 365 Excel: Part 3
This advanced course covers the full breadth of Microsoft 365 Excel's most powerful features. You will learn how to work in both Excel Online and the Excel desktop application, automate worksheets with macros and templates, audit and error-check your workbooks, analyze and present data with advanced tools, work across multiple workbooks, and export and source data from a variety of formats and platforms—including Microsoft Forms.
26 lessons6 modules900 minutes
What you'll learn
- Access and use Excel Online, manage workbooks in OneDrive, and switch between Excel Online and the Excel desktop application.
- Identify key feature differences between Excel Online and the Excel desktop application.
- View, add, and edit workbook properties and use the Document Inspector to remove sensitive metadata.
- Record, save, inspect, and secure macros using the VBA Editor and macro security settings.
- Create, edit, and use Excel templates to standardize and automate workbook creation.
- Apply data validation settings, input messages, and error alerts to control data entry accuracy.
- Use formula auditing tools—including Show Formulas, Trace Precedents, and Trace Dependents—to understand and verify workbook logic.
- Identify and resolve common formula errors using Error Checking and the Evaluate Formula tool.