Advanced Excel Training Level 4: PRO Users

April 21, 2022 from 9:30 am to 4:00 pm

Please Note: This Advanced Excel training course requires a basic knowledge of Windows and a PC laptop/ mouse with Excel 2016 installed 

This advanced Excel training course will teach you to use the advanced features of Excel to their full extent for your business or department.

By the end of this advanced Excel training course, you will be able to configure and reproduce company data in a list using PivotTables, edit and analyse complex data by creating and utilising Scenarios, Goal Seek, incorporate built-in functions into a worksheet, work with controls and record macros.

This is the fourth and final Excel course in our 4-course Excel Pro-User program. It is the highest level of training for Excel available from the NWL Chamber for those that utilise Excel in a professional environment.

This advanced Excel training is ideal for Financial managers or consultants, business owners or line managers responsible for creating and maintaining company data via spreadsheets.

Delegates will learn the following high level features:

  • LOOKUP functions
  • Auditing Workbooks and Worksheets
  • Using tracer arrows
  • Finding worksheet errors
  • Workbook, Worksheet, and Cell Protection
  • Protecting and Un-protecting Workbooks and Sheets
  • Linking Workbooks
  • Creating and Customising PivotTables
  • Adding and removing fields
  • Hiding and displaying field detail
  • Working with totals in a pivot table
  • Database, Logical and Information functions
  • Command and Function macros
  • Recording and running Macros
  • Assigning Macros to the Keyboard and Toolbar
  • Interpreting and Analysing data using Excel tools Goal seeker, outlines, and scenarios
  • Consolidating data
  • …And so much more!

This advanced Excel training course has been designed for experienced users of Microsoft Excel who have either completed the Excel Level 3: Power Users course (or equivalent or have taken the Excel Online Assessment to determine a readiness for the Excel Level 4: Pro Users course. The link for the 3-5 minute assessment is below:

Excel Assessment: Are you a beginner or pro? Find out here

This course is instructor led, and involves useful examples and exercises in a workshop environment to enable delegates to come away with an amazing repertoire of practical advanced Excel experience as well as useful techniques, tips, and tricks.

This course requires a laptop and mouse with Excel 2016 or newer installed – if needed, a limited number are available for hire on the course but this must be reserved/booked several days in advance. The trainer will need to install exercise files on your laptop should you choose to use your own.

Book Your Place Now

Training location

Chamber Training Centre - Blackpool Fylde Coast
Chamber Training Centre, Blackpool, United Kingdom
Price :
Members: £139 + vat, Affiliate members: £169 + vat, Non-members: £189 + vat, Laptop rental: £20 + vat
Contact :
Chamber Training Team 01253 347063 or Email:

Share this