Skip to main content

Microsoft Excel Level 2

Course Details

For Whom: All Staff
Dates: Tuesday, February 13, 2018
Location: Large Training Room, Library
Time: 14.00 - 17.00
Presenter: Optima Training
Cost: €50
Duration: Half Day

Course Overview

Excel Level 2 - 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 Level 1(preferably have attended Level 1 training). 

Content – Level 2 
  • 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