Microsoft Excel: Processing Data

Start Date Start - End Time Venue Places Taken

Duration: 2 hours

Coordinator: Mr David Miles

Presenter: Ms Fiona Stroud

This course builds on skills acquired in the MS Excel Introduction to Spreadsheets course and focuses on using tools which assist users to manipulate lists of data and techniques to simplify formula creation and data analysis.

This course will enable participants to:

1. Use conditional formatting effectively
2. Use IF and VLOOKUP functions for data analysis
3. Sort and filter to extract data
4. Use PivotTables for flexible data presentation.

Previously called Microsoft Excel: Manipulating Data