Working with Lists of Data - SS06

General Description

The ability to sift through and analyse large amounts of data is an essential part of most types of planning. Excel has some powerful tools which enable the user to filter lists of data and create automatic subtotals.

Target Audience

This session is intended for participants wishing to improve on their existing basic working knowledge of Microsoft Excel.

Pre-requisites

Participants should be able to use standard features of Microsoft Excel including how to enter, select and format data, move around a worksheet and create basic formulas.

Duration

3 hours

Learning Outcomes

• Create lists of data
• Sort data in a list by rows and columns
• Apply and remove AutoFilters
• Create custom AutoFilters
• Create criteria for Advanced filters
• Apply an advanced filter
• Remove filters
• Use a data entry form
• Generate Automatic SubTotals
• Create and work with nested Subtotals
• Apply, use and remove Outlining
• Set validation criteria for data entry
• Use database functions