Excel 2016 Level 2

MS Excel 2016 Level 2

If you have been using Excel but still aren't getting the most out of it then the Level 2 Excel course could be for you. Assuming a good basic knowledge of Excel, this course delves into some of the more complex aspects of this powerful spreadsheet application.

Course Contents:

This course is aimed at the more experienced Excel user and includes:

  • Formulae
  • Cell Referencing
  • Sorting Records
    • Custom Sort
    • Custom Lists
  • Conditional Formatting
  •  Auto-Filter
  • Advanced Filter
  • Subtotals
  • Functions
    • If Statement
    • Count If
  • Managing Worksheets within a Workbook
  • Collating Data from Several Worksheets
  • Pivot Tables
  • Paste Special
  • Linking Excel Charts to Word or PowerPoint
  • Protecting your Work
    • Non Editable areas
    • Password protection

Duration: 1/2 day 09:30 - 13:00

To Book:

Check our timetable for next date of training and then Email tcentre@ucc.ie