Mastering Excel 365 – Advanced (2023)
In this course, we will show you how to make use of advanced features to summarize information, identify errors, apply conditional formatting, and find and assess information. We will also demonstrate how to best utilize available filtering and sorting techniques, including the new dynamic array functions.
You’ll learn how to add trendlines to charts to add a visual element to your forecasting and how to create custom templates that can be used repeatedly. You’ll also be able to create and modify important objects such as PivotTables, macros, and graphics.
- Editing
- Functions
- Data Manipulation
- Data Consolidation and Subtotals
- PivotTables and Macros
- Charts
- Graphics
- Sharing