Excel Pivot Tables Training Course

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.

Assumed Knowledge

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.

Duration

2.5 hours

Cost

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.

Main Topics

  • 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 365Adobe Design softwareAtlassian and more.

Microsoft training courses excel

Microsoft training courses powerpoint” width=

microsoft training courses word

microsoft training courses onenote

microsoft training courses sharepoint

microsoft training courses teams

illustrator training course

photoshop training course

indesign training course

confluence training course

jira training course

atlassian training course