Microsoft Excel
Intermediate Training
Microsoft Excel is an extremely handy tool, whether you’re completing admin, financial or sales tasks. But without the right training, your team won’t be using Excel effectively.
From £199
Per person
Onsite
Live online
1 Day
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. Whether you’re part of a small team or a larger group, our flexible onsite and live online sessions can accommodate anywhere from 2 to 20 participants.
What you will learn.
Find out how to further utilise nested formulas to extract data base on multiple criteria.
Get results to complex questions.
Further user’s knowledge of Pivot Tables by incorporating groupings and calculations.
Use what-if analyses to meet targets and generate forecasts.
Learn how to quickly automate repetitive or tedious tasks by using macros.
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 and HLOOKUP, 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.