Advanced Excel Training Level 4: PRO Users

This Excel training course will teach you to use the advanced features contained in Excel to their full extent for your business or department and is ideal for Financial managers or consultants, business owners, or line managers responsible for creating and maintaining company data.

By the end of this course, you will be able to analyse complex company data using ‘lookups’ and PivotTables. A basic introduction to creating Macros and viewing VBA, the programming language, is included.

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.

To avoid booking a course that is either too hard or too easy, too fast or too slow, we ask that all delegates complete a pre-course checklist to assess their current level of Excel knowledge. This will enable us to ensure that all delegates are on the right course and able to follow the training at a similar pace, you can retrieve this from the Training Department on request.

If we feel that you are “beyond” the elements and concepts discussed in this course – we will recommend which level we feel would most benefit you. This assessment can save both time and money!

What we will cover:

• Using lookup functions – LOOKUP, VLOOKUP, and HLOOKUP –
• *NEW* Using the XLOOKUP Function
• Auditing Workbooks and Worksheets
• Using Data validation to ensure the integrity of data
• Protecting and Un-protecting Workbooks and Sheets
• Advanced filtering of data
• Creating and Customising PivotTables

• • Adding and removing fields
  • Hiding and displaying field detail
  • Working with totals in a pivot table

• Introduction to Macros

• • Recording and Running Macros
  • Introduction to programming – viewing/basic editing of VBA
  • Assigning Macros custom buttons on a worksheet

This course is instructor-led live online and involves useful examples and exercises in a workshop environment to enable delegates to work ‘smarter’ with Excel as well as learn useful techniques, tips, and tricks.

Course Requirements:

Delegates should have access to a laptop with Excel 2016 or newer installed (unfortunately not an Apple laptop or a ‘web-based’ version of Excel). Whilst not essential, the laptop should have a mouse attached as this can be quicker for users during the course

Before enrolling in any Chamber of Commerce Excel course, all prospective delegates must complete a mandatory skills analysis.

This assessment is essential to determine your current proficiency level and ensure you are placed on the most appropriate course (Introductory, Intermediate, or Advanced) for an optimal learning experience. Based solely on the results of this self-assessment, the Chamber will recommend the suitable course level.*

*Please note that by completing the enrolment process, delegates acknowledge that the Chamber of Commerce is unable to accept responsibility or provide refunds if an individual subsequently feels they have been placed on the wrong level course, as placement relies entirely on the delegate’s own honest assessment during the skills analysis.

We strongly encourage careful and truthful completion of the analysis to secure the best possible course fit.

IMPORTANT – The trainer will need to install exercise files on your laptop should you choose to use your own. Some company laptops are not suitable as they have certain features disabled which prohibit the loading of files.

Courses are held online if you require a face to face place, please let us know so we can organise this for you.

We have an 10-delegate maximum per course so please book early to avoid disappointment.

Cost and duration

Members have exclusive savings on bookings and are able to access other great services provided by us.

This course lasts for a full day and is delivered online via Microsoft Teams by our approved expert trainers.

This session can also be arranged on a corporate basis, just for your team.  We can host them at your premises, or here at the Chamber’s brand new ‘Chamber Meeting Spaces’ facility; just off the M6 in Preston.

LOCATION

Online via Microsoft Teams

AVAILABILITY – Places available

Date doesn’t suit?

Dec 02, 2026         09.30 – 16.00

This training course is open to members and non-members. Members receive exclusive discounts on training and many other services provided by us. For more information, please contact the training team on 01772 653000.

Click HERE to view Training Terms and Conditions