Skip to main content

Advanced Excel Training

Course Details


For Whom: All Staff
Dates: Wednesday, May 17, 2017
Location: Large Library Training Room
Time: 14h00 - 17h00
Cost: €50
Duration: 3 hours

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

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