Call us today: 0800 028 3045
NEW! Microsoft Excel – Excel Pivot Tables Online Course
Find out more about our Online Training Courses
Is it right for me?
Do you work with large amounts of data that needs to be analysed quickly? Are you constantly being asked to change the way your data is presented? Are you currently using autofilter and copy and paste to extract data from lists? In this 1 hour session you will see how Pivot tables are able to solve all those problems for you.
What will I get out of it?
By the end of the course you will know:
- How Pivot tables work
- How to create and modify your Pivot table structures
- How to change the summary calculation used to analyse your data
- How to use report filter
- How to group data
- How to sort data
- How to create a Pivot chart
Related courses in our range
What does it cover?
Pivot Tables
- How Pivot tables work
- Working with the Pivot cache
- Building the structure to your Pivot table
- Modifying the structure
- Creating report filters
- Refreshing data
- Single vs. multiple Pivot caches
Changing Summary Calculations
- Changing the summary calculation method
- Adding subtotals
Sorting Pivot Data
- Simple sorting
- Advanced sorting
Grouping Data in a Pivot
- Grouping dates
- Grouping numbers
Pivot Charts
- Creating a Pivot chartModifying a Pivot chart
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.
