Course Details

MS Excel 2010 (Using Pivot Tables) - Thurs June 5th 2014
The registration period has expired.
Category:
Information Technology
Target group:
This course is aimed at staff who are already using Excel but work with lists of data and wish to explore Excel's database capabilities.
Content:

  • Creating a Pivot Table using the Pivot Table and Pivot Chart Report Wizard

  • Determing data suitable for Pivot Charts

  • Refreshing a Pivot Table

  • Pivot Table autoformats

  • Pivot Chart Reports

  • Group Items in a Pivot Table or Pivot Chart field

  • To Ungroup a set of Items

  • Calculations in Pivot Tables - calculated fields and items: creating a calculated item, calculated field
Prerequisites:
Intermediate level Excel.
Start date (yyyy-mm-dd):
Jun 5, 2014
Duration:
0 days
Time:
9.30am - 1.00pm
Organiser:
Organisation & Staff Development, Human Resources
Venue:
PC Suite, Nursing and Midwifery Library Extension, Basement Level, JHL.
Deadline:
14 days before
The registration period has expired.

Back