We offer a wide range of Microsoft Excel training courses to suit all skill levels, from introductory to advanced and specialist topics. Our courses are available online and on-demand, with options for group training. Our flexible onsite and live online sessions can accommodate anywhere from 2 to 20 participants.
What you will learn.
Unlock the Power of Absolute References: Master formula locking with the $ sign, link tables across multiple sheets, and streamline your workflow with grouped data.
Supercharge Your Formulas & Formatting: Learn how to use powerful functions like COUNTA, IFS, and COUNTIFS, plus highlight key data with smart conditional formatting.
Effortless Data Analysis with PivotTables: Create dynamic PivotTable reports, filter data with Slicers, and view multiple tables side by side for easy analysis.
Boost Your Data Retrieval Skills: Master VLOOKUP, HLOOKUP, XLOOKUP and IFERROR to ensure accurate, professional results in your data analysis.
Create Dynamic Reports & Ensure Accuracy: Build customisable reports and use data validation to ensure flawless data entry and more reliable outcomes.
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.
