Skip to main content

Excel Level 2

Home | Course | Excel Level 2

Course Details

For Whom: All Staff
Dates: Wednesday, January 29, 2020
Location: Large Training Room, Library
Time: 14.00 - 17.00
Presenter: Optima Training
Cost: €50
Duration: Half Day

Course Overview

This course is designed for experienced users who want to utilise the more advanced features of Microsoft Excel.  Participants should have a good working knowledge of Microsoft Excel.


  • Review of Level 1 Excel Features
  • SumIf & CountIF Functions
  • VLookUps
  • Pivot Tables
  • Advanced Charts
  • Text to Columns
  • Manipulating Worksheets
  • Templates
  • List Management (Advanced)
  • Subtotalling
  • Linking & Embedding
  • Scenarios
  • Validation
  • Auditing
  • Security
  • Macros


To book a place, please email Please send your request accompanied by your line Manager’s/Head of Department’s approval to clearly stating your department’s cost centre details

Cancellation Policy

If you are unable to attend we would ask that you give us 48  hours’ notice.

Failure to do so will result in a €75 cost code fine.