Microsoft Office 365 Excel - Level 3
Microsoft Office 365 Excel - Level 3
Module 1: Enhancing Workbooks
- Customize Workbooks
- Manage Themes
- Create and Use Templates
- Protect Files
- Preparing a Workbook for Multiple Audiences
Module 2: Auditing Worksheets
- Trace Cells
- Troubleshoot Invalid Data and Formula Errors
- Watch and Evaluate Formulas
- Create a Data List Outline
Module 3: Working with Multiple Worksheets and Workbooks
- Consolidate Data
- Link Cells in Different Workbooks
- Merge Workbooks
Module 4: Exporting Excel Data
- Export Excel Data
- Import a Delimited Text File
- Integrate Excel Data with the Web
- Create a Web Query
Module 5: Analyzing Data with PivotTables, Slicers, and PivotCharts
- Create a PivotTable
- Filter Data by Using Slicers
- Analyze Data with PivotCharts
Module 6: Automating Worksheet Functionality
- Update Workbook Properties
- Create and Edit a Macro
- Apply Conditional Formatting
- Add Data Validation Criteria