Microsoft Excel
Advanced Training
Advanced Excel users need more than formulas—they need tools for complex data analysis, forecasting, and automation. This course unlocks features like nested functions, PivotTable calculations, what-if analysis, and macros to maximise efficiency and insight.
From £150 per person
Discounts for groups of 6+
Discounts for groups of 6+
Onsite
Live online
1 Day
Target Audience
This course is designed for confident Excel users who want to expand their skills with advanced features like PivotTables, macros, and what-if analysis. Suitable for anyone looking to take their spreadsheet abilities to the next level.
Prerequisites
Participants should be confident with the skills covered in an intermediate Excel course. This includes working with formulas and functions, managing data with tables and charts, using basic PivotTables, and applying conditional formatting. This course is designed for those ready to move beyond intermediate Excel into advanced techniques.
6 lessons covers:
Nesting Formulas and Conditional Formatting
Learn to nest multiple formulas, using AND and OR functions within IF statements. This module includes applying Conditional Formatting to format table rows based on criteria and dates using the TODAY function.
Advanced Pivot Tables
Explore advanced Pivot Table reporting tools, including grouping numeric and date fields, running percentage analyses, and writing field calculations. Learn how to create Pivot Tables from multiple tables.
Array Formulas and LOOKUP Functions
Discover the advantages of array formulas for formula protection, and use LOOKUP functions like INDEX and MATCH for versatile data retrieval. Participants will also learn to write SUMIFS, AVERAGEIFS, and COUNTIFS for calculations based on multiple criteria.
What-If Analysis and Macros
Utilise Goal Seek and Scenario Manager for forecasting reports. This module covers macro security, recording, running, and editing macros, as well as managing the Personal Workbook and an introduction to VBA code editing.
Customising the Quick Access Toolbar and Ribbon
Learn to add macro buttons to the Quick Access Toolbar (QAT) and customise the Ribbon by adding groups and buttons to enhance your Excel experience.
Text Functions and Data Integration
Gain proficiency in text functions such as CONCATENATE, UPPER, LOWER, and PROPER, along with MID, LEFT, RIGHT, REPT, and FIND. Learn to integrate various Excel features effectively for streamlined workflows and improved data management.
