Technical Skills / Computer Applications, Software and Infrastructure
Microsoft Excel Pivot Tables
PET002104
Interactive tables summarising data quickly and easily
Course overview
This is the ideal course for people who regularly need to extract data and put it into a format that enables quick analysis of large amounts of information.
- Creating pivot tables and adding in data
- Creating pivot charts
- Changing the pivot table layout
- Making separate pivot tables
- Refreshing data and updating pivot tables
- Using custom calculations in a pivot table
- Grouping and ungrouping pivot table items
Course benefits
Improved decision making from efficient data analysis using pattern recognition. Providing a report creation tool for moving ‘unorganised’ to ‘organised’ data.
Course dates and fees
| Date When is it? |
Location Where do I go? |
Duration How long is it? |
Availabilty Remaining space? |
Member Fees + VAT |
Non-Member Fees + VAT |
Book Add delegate(s) |
|
|---|---|---|---|---|---|---|---|
| Date: 26 Mar 2021 | Location: Portsmouth | Duration: 1 half-day | Availability: Spaces | Member Price: £141.00 (Fees + VAT) | Non-Member Price: £166.00 (Fees + VAT) | ||
| Date: 30 Jul 2021 | Location: Portsmouth | Duration: 1 half-day | Availability: Spaces | Member Price: £141.00 (Fees + VAT) | Non-Member Price: £166.00 (Fees + VAT) |