Excel 2016 Intermediate- Database & Pivot Tables
- 1st November 2017
- 01:00 PM - 04:00 PM
- 354.1.015 (Computer Lab Library SW1.015)
- Add to Calendar
Objectives of this course are to enable experienced users of Microsoft Excel to increase their knowledge of the features of this powerful spreadsheet application.
Database Concepts - Importing and exporting data - Using Sort & AutoFilter - Using Database Tables Working With Data - Data validation - Conditional formatting - Summarising data by creating subtotals Pivot Tables - Create Pivot Tables from the raw data - Create Pivot Charts
Please ensure you log into TCMS to enrol if you are interested in attending the session.