Skip to main content

Advanced Excel Training

Course Details


For Whom: All Staff
Dates: Tuesday, June 6, 2017
Location: Large Library Training Room
Time: 09h30 - 13h00
Cost: €50
Duration: 3.5 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