Microsoft Excel Advanced

This course is for individuals who have the knowledge and experience to create complex spreadsheets and want to become familiar with more advanced tools & techniques as well as automating repetitive tasks

1 day
£120+VAT

For available dates, click on the 'Book' button. If the dates shown are not suitable, contact us on 0161 359 3405 or email info@theskillsco.com

9:30am - 4:30pm

Churchgate House, 56 Oxford Street, Manchester, M1 6EU

Course Overview

On this Microsoft Excel Advanced training course you will work with advanced database management, database functions, data validation & protection. You will learn how to work with PivotTables and Pivot Charts, use the analytical features of Excel and how to record & run Macros to automate repetitive tasks.

Who is this training suitable for?
This Microsoft Excel Advanced training course is for individuals who have the knowledge and experience to create complex spreadsheets and want to become familiar with more advanced tools & techniques as well as automating repetitive tasks.

At the start of the course the trainer will provide a short refresher of basic and intermediate excel functions.


This workshop covers:

  • Advanced List Management
  • Conditional Formatting
  • Analytical Options
  • Exporting And Importing
  • Pivot Tables
  • Auditing And Notation