Microsoft 365 Excel Desktop Level 3
- Course focuses on advanced Excel features, formulas, PivotTables, Illustrations, and Templates.
- Aims to enhance Excel skills for better data manipulation and application use.
- Targeted at individuals seeking in-depth Excel knowledge.
- Prerequisites include attending Excel Level 1 and/or Level 2 courses.
- Objectives include data validation, advanced formulas, auditing, PivotTables, templates, and illustrations.
Overview
The Online Microsoft 365 Excel Training Course is designed to help participants explore advanced Excel features, including formulas, data validation, auditing tools, PivotTables, illustrations, and templates. The course aims to enhance Excel proficiency for better data manipulation. Targeted at individuals seeking in-depth Excel knowledge, prerequisites include attending Excel Level 1 and/or Level 2 courses. By the end of the 1-day course, participants will be able to validate data, work with advanced formulas, create PivotTables, use illustrations, and more.
Who should attend
Excel Users
Course Content
In this virtual Microsoft 365 Excel Desktop Level 3, Instructor-Led course you use the more advanced features of Excel with advanced formulas, use Data Validation and Auditing tools along with working with PivotTables, Illustrations and Templates.
You can view all of our Microsoft Training Courses here.
Who Should Attend
Location
Course Syllabus
Day 1
Data Validation
• Number Validation
• Data List Validation
• Message Prompts and Alerts
• Conditional Data Validation
• Data Validation Errors
Advanced Formulas
• Statistical Functions to include MAXIFS, MINIFS
• Working with Text Functions
• Mixed cell references BODMAS
• Date and Time Functions
Auditing a Worksheet
• Display formulas in worksheet cells
• Show precedent and dependent cells
• Finding and Resolving Errors
• Using the Watch Window
• Evaluating a Formula
Creating PivotTables, PivotCharts, Slicers and Timelines
• Creating a PivotTable
• Amending the fields in a PivotTable
• Updating the PivotTable
• Adding Calculations to a PivotTable
• Add Grouping to a PivotChart
• Pivot Tool Gear Settings
• Create a PivotChart
• Create and use Slicers
• Create from Tables and Related Tables
• PivotTable Timelines
• Create from Tables and Related Tables.
• Work with PowerPivot Add-In
Working with Templates
• Create a Template
• Create a Hyperlink
• Adding Cell Comments/Notes
Inserting Illustrations
• SmartArt
• Insert Images into a Spreadsheet
• Insert Shapes into a Spreadsheet
• Group and Layer Graphics
• Quick Shape Formatting
Additional Information
Delegates should have attended the Excel Level 1 and/or Excel Level 2 course or have the equivalent knowledge.
