Course Details

For Whom:
All Staff
Dates:
Location:
Large Library Training Room
Time:
14h00 - 17h00
Duration:
3 hours

Course Overview

Content

 

  • The Excel Interface, Navigation & Menus

  • Excel Options & Saving Formats

  • Creating, Copying & Moving Tabs

  • Cell Formatting (Number, Currency, Date etc)

  • Lists and Custom Lists

  • Cell alignment, Wrapping & Merging

  • Sorting & Filtering Lists

  • Adding & Modifying Charts & Diagrams

  • Basic Formulae (Sum/Avg/Min/Max/Count, CountA)

  • Operator Formaula (+, _, *, /)

  • Other: Round, IF, Absolute Cell References

  • Names Cell Ranges

  • Intro to Pivot Tables

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