Excel 2016 Filtering and Sorting

Microsoft Office Excel Sorting & Filtering

Microsoft Excel is a spreadsheet program that lets you organise your data into lists.  Excel is capable of performing calculations, generating charts and has many tools to enable you to analysis and summarise your data. This course will detail a number of useful features regarding the sorting and filtering of larege Excel lists that can help make managing and using your data more straight forward.

Course Contents:

The course will cover the following items:

  • Sorting
    • Custom Sort
    • Custom Lists
    • Sorting on several levels
  • Filtering
    • Conditional filtering
      • Above/Below average values only
      • Text Containing
      • Cells of a particular colour
    • Advanced Filter

Duration: 2 hours approximately

To book: Check our timetable for next available date and  Email tcentre@ucc.ie 

Related Courses