Call us today: 0800 028 3045
Microsoft Excel – Pivot Table Specialist Course
Is it right for me?
Our Excel Pivot Table Specialist course is a comprehensive guide to working with Pivot Tables for those who are keen to learn more about the use of Pivot Tables to analyse and present data.
You should be a confident Excel user and be able to create and edit worksheets and write basic formulas.
What will I get out of it?
By the end of the course you will be able to:
- Build and customise Pivot Tables
- Group and sort information within Pivot Tables
- Add different types of summary calculations to Pivot Tables
- Create Pivot Charts
- Add calculated fields and items
Versions available
2003, 2007, 2010
Related courses in our range
What does it cover?
The anatomy of a Pivot Table
- Using a Pivot Cache
- Building a Pivot Table
- The Pivot Table interface
- Refreshing the Pivot Table
- Adding column, row, page and data fields
- Changing data orientation
- Showing data fields in columns or rows
- Using the Slicer tool (2010)
Setting Pivot Table options
- Format options
- Totals and filters options (2007 and 2010)
- Display and printing options (2007 and 2010)
- Data options
Customising pivot tables
- Modifying field names
- Data formatting
- Changing field layout options
- Changing summary calculations
- Working with subtotals
Filtering and sorting
- Filtering items
- Sorting data
- Value and label filters (2007 and 2010)
- Creating top 10 reports
- Using Search within a PivotTable (2010)
Grouping
- Grouping date fields
- Grouping numeric fields
- Adding your own groups
Summary calculations
- Running totals
- Differences year on year, month on month
- % Differences year on year, month on month
- % of Row, Column, Total and other fields
Pivot Charts
- Pivot Chart rules
- Creating a Pivot Chart
- Working with your Pivot Chart
Creating calculations
- Adding calculated fields
- Adding calculated items
“Superb class, love the small group numbers. Excellent service and helpful staff from the initial enquiry right up to the end of the course.”
Carol Chuter Stevenson, L&D Officer, Sanctuary Housing Association
Course Summary
Send to a colleague
Please enter details below and click 'submit'
Tailor this course
If you are interested in this course but would like it tailored to your specific needs, contact Karen Osborn on 0800 028 3045.
Alternatively, enter your details below and one of our team will contact you.
Thales Training & Consultancy is a highly successful training services company based in Crawley. We help companies to develop advantage through learning and development. Highly trusted by leading enterprises, we deliver a full range of dedicated training solutions that enable organisations to achieve key business goals. The 4 core services we offer are Training Courses, Supply Management, Bespoke Services and Managed Services. Our successful partnerships with clients prove that the delivery and management of the right training and development can significantly enhance the pursuit of business excellence.
