Skip to main content

Excel Level 1

Home | Course | Excel Level 1

Course Details


For Whom: All Staff
Dates: Wednesday, January 29, 2020
Location: Large Training Room, Library
Time: 09.30 - 13.00
Presenter: Optima Training
Cost: €50
Duration: Half Day
Maximum Number of Participants: 10

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

Cancellation Policy

If you are unable to attend we would ask that you give us 48  hours’ notice.

Failure to do so will result in a €75 cost code fine.