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

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
Related Courses
Microsoft Excel Intermediate
This course is suitable for individuals who are self taught and wish to formalise and expand their knowledge of Excel or for those who have completed the Excel Introduction course and wish to improve their skills
Excel Dashboards
Dashboard reports can be used to display a range of complex information including financial reports, management information and statistics.
Microsoft Excel Introduction
For individuals who are comfortable using a personal computer and Microsoft Windows but with little or no experience using Microsoft Excel or any other spreadsheet program.