SOLD OUT - Click here for next available date

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.

On completion, course participants are provided with 3 months free access to supporting Excel Level 3 video training content.

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
• The SUMPRODUCT function
• 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
• Calculate outside of 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
  

Prerequisites

Ideally delegates should have completed the ‘Excel Intermediate –Level 2’ course or be comfortable in applying the majority of the features andfunctions associated with the Level 2 course content.

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. Please check directly with your association or awarding body to see how many points they will award.

Cost

This course costs €485 (normal rate is €585).PLEASE NOTE THE EARLY BIRD RATE CLOSES 3 WEEKS PRIOR TO COURSE DATE. The course cost includes all course documentation and Certificate of Attendance.