Advanced Microsoft Excel 2016

The Advanced Microsoft Excel 2016 is a high level one-day course covering advanced functionality for Excel users including data validation, error handling and other high-level functionality.

Advanced Microsoft Excel 2016

Advanced Microsoft Excel 2016

Are you looking to learn advanced Excel skills including complex formulas or do you have data or other systems that could be enhanced with dashboards and charts? PSP’s Advanced Excel course is a fantastic one-day course aimed at confident Excel users to take you to the next level of competence. There will be a high level of one-on-one training and practical exercises to solidify your learning.

Enquire Now

If you have completed the Intermediate Excel course or have a good working knowledge of the elements of our Intermediate Excel course, the Advanced Excel course is ideal to solidify your knowledge and give you advanced Excel skills needed to perform complex data analysis and use complex formulae and logic.

 Included on the day's course will be the following content;

  • Data validation (setting up, using data validation to test existing data, creating a drop down list)
  • Adding logic
  • Error handling
  • Using track changes functionality
  • Presenting data with dashboards and charts
  • Merging data from external data sources

In order to make best use of the day you will be allocated an individual fully equipped workstation where you can practise your skills. The trainer will also use an overhead screen to demonstrate. The trainer will floor walk during the practical exercises to check your understanding and provide supportive coaching and tips.

At the end of the day you will be given a course manual to solidify your learning and a certificate of completion.


Good written and spoken English.

A good level of knowledge and the ability to confidently perform all the tasks included in our Intermediate Excel course.

If you are unsure which level course would best suit your needs, please get in touch with us to discuss further.

At the end of the day's training you will be an Advanced Excel Practitioner performing complex data analysis and using complex formulae and logic. You will receive a certificate of completion from PSP and a takeaway course manual.

Uniquely to PSP, and due to the high level of this course, you will also receive a valuable personal reference from our trainer detailing your participation on the course, your level of competency and the progress you have made.

All of our face-to-face training courses take place at our learning centre in Spalding, Lincolnshire. The environment is extremely comfortable, studious and professional and course numbers for management courses are capped at only 12 candidates per course allowing candidates to benefit from a high level of personal coaching from your trainer.

Our purpose built Learning Centre benefits from;

  • 65" touch screen with built-in camera for video conferencing
  • 9ft telescopic projector screen
  • Individual desktop power points for laptops and chargers (no additional charge)
  • Printer for any additional course notes
  • Temperature controlled air conditioning and heating
  • Comfy break out areas for group work
  • Separate board room is available to hire for wraparound staff meetings etc.
  • Free on-site parking

We have an onsite technical team and concierge to ensure that your day goes without a hitch and create an optimum learning environment.

All courses are delivered with a free lunch provided onsite and free tea, coffee and soft drinks available throughout the day.


£499 + VAT