Excel Advanced in 1 day

Instructor-Led Excel Advanced Course

Take your Excel skills to the next level with advanced, practical training tailored to your specific needs. Delivered one-to-one, this course recognises that every learner has different skill levels, goals, and real-world applications. Build confidence with advanced Excel techniques and learn to work smarter, faster, and more effectively.

Who should attend the Excel Advanced Course?

Excel Advanced is for Excel Experts:
you work daily with Excel and your work revolves around spreadsheets and Excel databases. Delivered one-to-one.

Excel Advanced Course Outline

General
Editing Standard Formatting Rules
Input Validate rules
Using Formulas in Conditional Formatting
Group and Outline
Filter and Sorting

Excel Tables and Advanced Filter
Working with Excel tables
Copy specific datasets from sheets, workbooks or external data

Consilidate

Goal seek, consolidate and scenarios

Using Form Templates
Creating Templates

Advanced Excel Lookup Functions
VLookup Function
Hlookup Function
Using the Index Function, Using the Match Function, Index and Match Together
Using the Indirect Function

Excel Advanced Functions
Using Error Functions,
Logical Functions,
Array Functions,
Rounding Functions

Advanced Excel Pivot Table Tools
Importing Pivot Table Data,
Calculated Fields in Pivot Tables,
Showing Pivot Data as a Percentage,
Creating Custom Pivot Tables Styles
Pivot Charts

Excel Macros
Creating, amending and deleting macros
Running macros

Book the Excel Advanced 1-day course

Contact us / Customise your Excel course

Powered byEMF HTML Contact Form

What makes the Excel course special?

Contact PCWorkshops