Learn how to use Excel Pivot Tables
Our virtual and face-to-face Microsoft Office and Excel training courses will empower your team to boost productivity.
About this Excel Course
A pivot table is a tool in Microsoft Excel that will help efficiently create a summary including only the data that you need it to. If you have an overwhelming spreadsheet that you need to make sense of, pivot tables are a great option.
This course assumes the learner has previously attended an Excel Level 1 or Level 2 course or has equivalent working knowledge as well as confidence with the use of personal computers and the Windows operating system environment.
Please view our Pricing page or complete the form below to obtain a quote. The cost will depend on the number of participants and whether training is to be conducted on your site or at one of our recommended training room locations.
- Create PivotTables
- Use Compound Fields
- Sort and Filter in a PivotTable
- PivotTable Options
- Create and use Slicers
- Insert a Timeline Filter
- Count in a PivotTable
- Format PivotTable Values
- Group in PivotTable Reports
- Work With PivotTable Grand Totals
- Work With PivotTable Subtotals
- Find the Percentage of a Grand Total, Column or Row Total
- Find the Difference From
- Create Running Totals
- Create Calculated Fields
- Create and edit a PivotChart
More Excel Training Courses
Microsoft Excel is a helpful and powerful program for data analysis and documentation. It is a spreadsheet program, which contains a number of columns and rows, where each intersection of a column and a row is a “cell.” Each cell contains one point of data or one piece of information.
Excel Beginners Course: This is a beginner’s course and aims to give the new spreadsheet user a thorough preparation in the basics of creating and working with spreadsheets using Microsoft Excel 365. Emphasis is placed on developing accurate and well-designed spreadsheets employing sound design and documentation principles.
Excel Intermediate Course: The skills and knowledge acquired in Microsoft Excel Intermediate enable users to expand their knowledge and learn how to create more productive workbooks. It covers formulas and function techniques as well as charting.
Excel Advanced Course: The skills and knowledge acquired in Microsoft Excel Advanced enables users to expand their knowledge and skills beyond building simple workbooks by using analytical and productivity tools.
More Computer Training Courses
At CJ Computer Training, we offer a full cache of computer courses and our friendly computer software trainers can teach you how to confidently and efficiently use a wide range of computer apps from Microsoft apps and Office 365, Adobe Design software, Atlassian and more.