Course Description

This half-day Excel 365 Level 3 Essentials course delivers a focused introduction to advanced Excel features in a time-efficient format. You'll gain practical skills in the most valuable advanced Excel tools without the time commitment of a full-day course. Perfect for busy professionals who need to enhance their Excel capabilities quickly, this condensed course covers key advanced functions, auditing techniques, and PivotTable essentials.

Target Student

Ideal for users who already have intermediate Excel skills and need to quickly master specific advanced features. You should be comfortable with basic formulas, data organisation, and chart creation. This course is designed for professionals who need to analyse complex data, create dynamic reports, or streamline their existing Excel workflows, but have limited time for training. The focused curriculum prioritises the most immediately applicable advanced Excel tools.

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

• Use Advanced Formulas
• Use Auditing Tools
• Create and manipulate PivotTables and PivotCharts

Course Content

Lesson 1: Advanced Formulas

• Statistical Functions to include MAXIFS, MINIFS
• Working with Text Functions
• Calculating with Financial Functions
• Date and Time Functions
• Database Functions

Lesson 2: Auditing a Worksheet

• Display formulas in worksheet cells
• Show precedent and dependent cells
• Finding and Resolving Errors
• Using the Watch Window
• Evaluating a Formula

Lesson 3: Creating PivotTables, PivotCharts and Slicers

• Creating a PivotTable
• Amending the fields in a PivotTable
• Updating the PivotTable
• Adding Calculations to a PivotTable
• Add Grouping to a PivotChart
• Creating a PivotChart
• Slicers
• PivotTable Timelines
• Creating from Tables and Related Tables.