Microsoft Excel: Processing Data

Start Date Start - End Time Venue Places Taken
21/03/2018 9:30 AM - 11:30 AM 02-D108A Duhig Tower 13 of 17 Register
8/05/2018 9:30 AM - 11:30 AM 02-D108A Duhig Tower 2 of 17 Register
23/05/2018 12:30 PM - 2:30 PM Gatton, Bldg 8102, Rm 123 3 of 10 Register
26/06/2018 9:30 AM - 11:30 AM 02-D108A Duhig Tower 4 of 17 Register
16/08/2018 9:30 AM - 11:30 AM 02-D108A Duhig Tower 0 of 17 Register
26/09/2018 9:30 AM - 11:30 AM 02-D108A Duhig Tower 0 of 17 Register
1/11/2018 9:30 AM - 11:30 AM 02-D108A Duhig Tower 0 of 17 Register
12/12/2018 9:30 AM - 11:30 AM 02-D108A Duhig Tower 0 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.

Previously called Microsoft Excel: Manipulating Data