Course Details

Category:
Digital Literacy/IT Skills
For Whom:
All Staff
Dates:
Location:
Large Training Room, Library
Time:
09.15 - 13.00
Presenter:
Optima Training
Duration:
Half Day

Course Overview

Excel Level 1 - This course will take attendees through the most productive features of Excel, to a point where participants can create and set up professional spread sheets

 

Content – Level 1

 

  • 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