Who should attend? Existing users of Microsoft Excel, who want to create Pivot Tables, Lookups and Data Validation.

Assumed Knowledge: A working knowledge of Excel, gained from the workplace or by prior attendance on an IT course.

Objectives: Delegates will be able to produce well-structured pivot tables, and use Lookups and Data Validation.

Creating and working with PivotTables

Understanding PivotTables
Creating a PivotTable using Worksheet data
Creating a PivotTable using External data

Laying out a PivotTable on a Worksheet
Modifying PivotTable Fields
Using a Report Filter
Refreshing a PivotTable
Formatting a PivotTable

Enhancing PivotTables

Working with Summary Functions
Applying Filters
Creating a Slicer
Using a Timeline
Grouping DataCreating a Calculated Field
Creating a PivotChart

Automating Pivot Tables with Macros

Introducing Macros
Recording Pivot Table macros
Refining recorded macros

The VLOOKUP, HLOOKUP and XLOOKUP Function in Excel is a tool for looking up a piece of information in a table or data set and extracting some corresponding data/information.

Data validation in Excel refers to setting specific criteria for accepting data in a cell or range of cells. This feature prevents users from entering invalid data that could lead to errors.

Claire Commins – Information Technology Trainer  – Teaching Experience Summary  

Teaching Microsoft Office classes to staff and students in NUI Galway, Trinity College, GMIT Galway, University of Limerick and University College Cork since 1999.

Teaching Microsoft Project, Access, Excel, PowerPoint and Word to advanced level for private and public sector for 22 years.

Teaching study skills and exam techniques in Secondary schools to Teachers, Students and Parents.

Relevant Education / Training 

•  Honours degree in Training and Education from NUI Galway.
• Qualified as a Systems Analysis and Computer Programmer.
• Completed MOUS exams in Microsoft Access, Excel, PowerPoint and Word.
• Completed ECDL exams in Microsoft Access, Excel, PowerPoint and Word.

In order for us to continue to bring you subsidized content we will require you to fill out a profile sheet which will be emailed to you after your booking – completion of this sheet guarantees you a place on the training.

Please note our training courses are only available for people residing in the Republic of Ireland

Please note training sessions are live interactive training.