Course Details

For Whom:
All Staff
Dates:
Location:
Large Library Training Room
Time:
09h30 - 13h00
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

HR Research Logos