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.

Prerequisites

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.

Course Content

Use Advanced Functions

• Use VLOOKUP
• Nesting VLOOKUP and TRIM
• Use Data Validation
• Use Named Ranges
• Use INDEX and MATCH
• Deal with Errors

Tables

• Create a Table
• Quick tips for using a Table
• Insert & Delete Table Rows & Columns
• Calculate in a Table
• Understand Structured References
• Remove the Table feature

Work with Pivot Tables

• Create PivotTables
• Edit PivotTables
• Add Fields to a PivotTable
• Add Currency Style
• Group PivotTable Data
• Drill into Pivot Data
• Create Pivot Charts
• Refresh the Data
• Change the Layout of a PivotTable
• Create Slicers
  

Who should attend?

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.

Certification

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.

Cost

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.