This one-day course takes a look at the advanced features of Microsoft Excel and will focus on what is good and bad design. We will also look at the type of structure that works with a PivotTable as opposed to the type of structure that works with a VLOOKUP.
Attendees will learn how to create V & H Lookups, utilising Drop-down lists and Named Ranges; how to structure Left Lookups using a combination of the Index and Match functions to extract information from a list; How to create PivotTables to facilitate the professional organisation, display and charting of data.
Ideally delegates should have completed the ‘Excel Intermediate – Level 2’ course or be comfortable in applying the majority of the features and functions associated with the Level 2 course content.
Use Advanced Functions
Tables
Work with Pivot Tables
This course will be of huge benefit to anyone in public or private sector who has experience with excel and needs amore advanced level of training focusing on Pivot Tables and VLOOKUPs
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.
This course may qualify for CPD points. Please check directly with your association or awarding body to see how many points they will award.
An ‘Early Bird’ discounted rate of €495 is currently available. This training course normal rate is €595. Places are limited and are allocated on a first come first served basis. PLEASE NOTE THE EARLY BIRD RATE CLOSES 3 WEEKS PRIOR TO COURSE DATE. The course cost includes all course documentation and Certificate of Attendance.