Excel Pivot Tables and Data Analysis
| Date |
Location |
Duration |
Cost |
| 06 Sep 2010 (Mon) | Washington | 1 | £ 195 |
| 18 Nov 2010 (Thu) | Washington | 1 | £ 195 |
| 25 Feb 2011 (Fri) | Washington | 1 | £ 195 |
| 28 Apr 2011 (Thu) | Washington | 1 | £ 195 |
| 05 Jul 2011 (Tue) | Washington | 1 | £ 195 |
Please contact us to discuss private course dates and locations |
Course Overview
This course is designed for individuals who have a need to summarise data using Excel's powerful Pivot Table feature. After the course delegates will be able to create pivot tables based on data both within Excel and from an external source.
Prerequisites
- To ensure your success, you must have a good grounding in Excel (to at least our Level 2 course standard or equivalent) and knowledge of relational database structures would be an advantage but is not a requirement.
Objectives
Related Courses
Training Options
- Scheduled public courses at one of our training venues
- Private course at your company office throughout the UK, at one of our training venues (Durham, Newcastle or Washington) or at an independent location, convenient to you
- Bespoke course written to your specific needs, at your company office throughout the UK, at our training venue or at an independent location, convenient to you
- For further information please contact us on 0191 377 8377
What's Included
- 1 delegate per computer
- Telephone and email support
- Relaxed refreshment area at our training venues
- Lunch and refreshments when training is delivered at our training venue
Course Content
Holding Data in Excel
Sorting data
Filtering data
Creating sub totals within the datasheet
Using the Excel data Form
Getting Started with Pivot Tables
Creating a pivot table
Fields to create row headings
Fields to create column headings
Data in the summary area
Dynamically building a pivot table
Rearranging fields in a pivot table
Number formatting of the data area
Creating more than one pivot table on the same data
Moving pivot tables from one sheet to another or around the same sheet
Deleting a pivot table
Connecting to an External Source
Sorting and Filtering
Drilling down into a summary value
Carrying out a top ten only
Sorting the rows by values of the data
Filtering to exclude values in rows or columns
Using the page filter option
Formatting
Grouping and hiding of multiple row/column groupings
Removing autoFormat
Autoformat
Pivot Table Options
Turning off the summary rows and columns
Activating automatic refresh options
Refreshing a pivot table
Dealing with empty cells
Advanced Options
Setting the number format for a calculated field
Limitations on calculated fields
Adding a calculated field to a pivot table
Creating calculating fields
Pivot Charts
Using the table options seen earlier on the chart
Exploring the chart options
Changing the chart type
Using a pivot chart as opposed to a normal chart
A picture tells a thousand words
Email Us 
Print