Microsoft Excel: Manipulating Data

Start Date Start - End Time Venue Places Taken
15/11/2017 9:30 AM - 11:30 AM 02-D108 Duhig Tower 10 of 17 Register

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.