finance, IT & administration
build skills to work with software, systems and procedures
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.