Course Details

MS Excel 2010 (Using Pivot Tables) (Wed March 12th 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):
Mar 12, 2014
Duration:
0 days
Time:
9:30a.m. - 12:30p.m.
Organiser:
Organisation and Staff Development office
Venue:
Nursing & Midwifery PC suite, Basement Level, Nursing & Midwifery Library Extension
The registration period has expired.

Back