Course Information

This instructor-led Excel Advanced training course builds on foundational and intermediate knowledge. After one day, you’ll walk away with the ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions.

Essentially, you’ll have the full power of Excel at your fingertips!

The easier you understand how to get Excel to do the hard work for you, the more you'll be able to get the answers you need from your data. This new knowledge will allow you to work much more efficiently.

Choose from our online public courses dates to book your course today.

Alternatively, contact us to arrange on-site training tailored to your needs!

Course requirements

To ensure success, we recommend that learners should have practical experience creating and analysing datasets using Excel.

Some examples of specific tasks learners should be able to perform include: creating formulas and using Excel functions; creating, sorting, and filtering datasets and tables; presenting data by using basic charts; creating and working with PivotTables, slicers, and PivotCharts; and customizing the Excel environment.

Need an Introduction or Intermediate Excel course instead?

Check below to see our related courses.

What you will learn

After 1 day, you will be able to:

• Use Pivot Tables
• Work with multiple worksheets and workbooks simultaneously
• Share and protect workbooks
• Automate workbook functionality
• Apply conditional logic
• Audit worksheets
• Present your data visually using Charts

By the end of the 1-day instructor-led Advanced Excel course, you’ll know how to validate data, use macros, create and format charts, use pivot tables and sort and filter data so you can get to the heart of the data you need.

All with our 100% Money-Back Guarantee and Unlimited Email Support.