In addition to the Essential Excel Tools and Techniques course, we plan to offer in-depth training of advanced-level topics that we believe cannot be adequately covered in a general course. At present we offer just one course under the Excel Advanced Topics heading, namely PivotTables and PivotCharts.
This course is aimed at the delegate who has a very sound knowledge of Microsoft Excel, but needs to understand the use of PivotTables and PivotCharts to analyse large amounts of raw data.
- Course Name: PivotTables and PivotCharts
- Duration: One day
- Requirements: Sound MS Excel literacy
- Cost: R2100 per person
- Introducing PivotTables
- Building a PivotTable
- Manipulating a PivotTabel
- Changing the PivotTable View
- Filtering a PivotTable
- Customising PivotTable Fields
- Setting PivotTable Properties
- Creating a PivotChart
- Calculating in a PivotTable