PivotTables is a powerful tool in Microsoft Excel, that helps you to manage data quickly and effectively. ITSC has arranged a workshop, Mastering PivotTables in Microsoft Excel with the professional trainer. This is a repeated workshop and if colleagues have attended sessions held in October/November, please leave the seats for other colleagues.
Training Outline:
- Create a PivotTable to Analyze Worksheet Data
- Use the Field List to Arrange Fields in a PivotTable
- Sort Data in a PivotTable or PivotChart
- Filter Data in a PivotTable
- Create a PivotTable Timeline to Filter Dates
- Use Slicers to Filter Data
- Group or Ungroup Data in a PivotTable
- Refresh PivotTable Data
- Create a PivotChart
- Delete a PivotTable
Please click here