Course Details

Category:
Digital Literacy/IT Skills
For Whom:
All Staff
Dates:
Location:
Large Training Room, Library
Time:
14.00 - 17.00
Presenter:
Optima Training
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

Register

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

HR Research Logos