September 27, 2022

Course Description

If utilised correctly, the benefits of Microsoft Excel cannot be overstated. Due to the program’s capability of formatting data, performing calculations, analysing data and integrating information, a working knowledge of Excel is vital for most office-based professionals today.

This advanced course guides participants through some of Excel’s Database features. Attendees will learn how to create both VLOOKUP and HLOOKUP to extract information from a list, as well as how to create a ‘Left Lookup’ using a combination of INDEX and MATCH functions. Delegates will also learn how to create PivotTables to facilitate the professional organisation, display and charting of data; and to generate ‘point and click’ Macros to automate multi-step processes.

All attendees will receive highly useful course notes to refer back to at any time and have a chance to engage in an informative Q & A on the day.

It is ESSENTIAL to have your own laptop /desktop with the minimum required software installed (Microsoft Excel 2013).

Course Content

Use Advanced Functions


• Nesting VLOOKUP and TRIM

• The SUMPRODUCT function

• Use the IFERROR function


• Use Data Validation

• Use Named Ranges

Working with Macros

• About Macros

• Recording Macros

• Running Macros

• Editing Macros in the VBE

• Assigning Macros to Buttons

Organizing Worksheet and Table Data

• Create and modify Tables

• Format Tables

• Sort and Filter Table data

• Calculate data in a Table

Working with PivotTables

• Create PivotTables

• Edit PivotTables

• Add Fields to a PivotTable

• Change the Layout of a PivotTable

• Add Currency Style

• Group PivotTable Data

• Drill into Pivot Data

• Create Pivot Charts

• Refresh the Data

• Create Slicers

Who Should Attend?

This course would be ideal for those who have a solid understanding of Microsoft Excel, this course will provide you with the knowledge and skills to use Excel at a more advanced level.

Ideally delegates should have completed the ‘Excel Intermediate' – Level 2 course.


On completion of this one-day training course, you will receive your Certificate of Attendance. Please note certificates are issued at the close of the training course to participants on completion of the course. Please check directly with your association or awarding body to see how many points they will award.


An ‘Early Bird’ discounted rate of €465 is currently available. This training course normal rate is €565. Places are limited and are allocated on a first come first served basis.

The course cost includes all course documentation and Certificate of Attendance.


Kelly Meegan
KM Consultancy Services

Recommended for you

People who booked this course also attended: