Microsoft Excel
Intermediate Training
Intermediate Excel training helps your team go beyond the basics, enabling them to work more efficiently with formulas, functions, PivotTables, and data validation. By strengthening these skills, users can significantly improve productivity in business operations.
From £150 per person
Discounts for groups of 6+
Discounts for groups of 6+
Onsite
Live online
1 Day
Target Audience
This Microsoft Excel training course is ideal for professionals across all industries who work with spreadsheets and want to improve their data analysis and reporting skills. It is suitable for office administrators, finance professionals, analysts, operations teams, and project managers looking to enhance their Excel proficiency for real world tasks.
Prerequisites
Participants should be comfortable with basic Excel tasks typically covered in our foundation level Excel course. This includes entering and formatting data, navigating spreadsheets, using simple formulas such as SUM and AVERAGE, and saving or managing workbook files. No advanced Excel knowledge is required to begin.
6 lessons covers:
Absolute Reference, Groups, and Linked Tables
Understand the difference between relative and absolute referenced formulas, and learn how to use the $ sign to lock formulas to specific cells when copying. This module covers grouping sheets together, inputting data across multiple sheets, writing formulas to sum between sheets, and linking tables using Paste Link and Link Manager.
Function Library, Logical IFS, and Conditional Formatting
Explore the Function Library to assist in writing formulas, including searching for functions with Insert Function. Participants will learn to write statistical functions such as COUNTA, COUNTBLANK, and COUNTIFS, as well as logical IFS functions for multiple test results. The module also covers conditional formatting to highlight data using rules and copying formatting with the Format Painter.
Side-by-Side Viewing, Pivot Table Reports, and Filtering
Discover how to view two tables from different files side by side, analyze data using PivotTable reports, and manage PivotTable layouts. Participants will learn to control number formats, create PivotCharts, and insert Slicers for filtering, as well as apply data validation to streamline data input.
Table Reports and Charts
Learn best practices for using Lookup and Reference functions, including VLOOKUP, HLOOKUP or XLOOKUP, to enhance data analysis. The course will cover nesting formulas within IFERROR for professional results and ensuring accurate data retrieval.
Dynamic Reporting with PivotTables
Gain insights into creating dynamic reports using PivotTables, allowing for effective data summarisation and analysis. Participants will learn to customize layouts and output statistics for clearer insights.
Data Validation for Accuracy
Explore data validation techniques to control data entry and improve accuracy, ensuring efficient and reliable data input processes.
