Skip to main content

Introduction to Excel

Course Details


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