Skip to main content

Excel Level 2

Home | Course | Excel Level 2

Course Details

For Whom: All Staff
Dates: Monday, May 28, 2018
Location: S1-19
Time: 09.15 - 13.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.Content

  • 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