Skip to main content

Excel 365: PivotTables And PivotCharts

In this E-Learning course, learners will be shown how to use PivotTables as an easy way to hide data or change the display scheme without having to change the Excel spreadsheet itself or the data in it. This allows one to clearly display and evaluate complex Excel spreadsheets with a large number of data records.

Instruction on PivotCharts will also be given to enable data visualisation using charts.

Course Features
Office Version
Application Group
Level
Advanced
Learning Time
1 Stunde und 25 Minuten
Number of Learning Videos
27
Languages Available
English
German
French
Spanish
Portuguese
Japanese
Chinese
Russian
Course Design
  • Videos with Audio Narration and Closed-Captions
  • Practice Interactive Exercises
  • Tips and Printable PDF's
  • Chapter Tests
  • Personalized Learning Recommendations
  • Comprehensive Final Test with Certificate
  • Compatible with Desktop and Mobile Devices
  • SCORM and xAPI Support for LMS Deployement
Course Topics

Creating and setting up a PivotTable

  • Understanding PivotTables
  • Preparing data for PivotTable creation
  • Creating a PivotTable
  • Defining rows and values in a PivotTable
  • Rearranging the fields of a PivotTable
  • PivotTable: Adding items from a field as columns
  • Moving and deleting PivotTables

Filtering and grouping data

  • PivotTable: Grouping data
  • Adding a global filter to a PivotTable
  • Filtering a PivotTable with a slicer
  • PivotTable: Inserting a timeline

Changing the look

  • Formatting a PivotTable
  • PivotTable: Inserting a blank row after each group item
  • Splitting page field items onto separate sheets
  • Applying report layouts to a PivotTable

Performing calculations

  • PivotTable: Defining the calculation function
  • PivotTable: Defining a function for subtotals
  • PivotTable: Adding a calculated field

Refreshing PivotTable data

  • Updating a PivotTable
  • Changing the data source of a PivotTable

Creating and setting up a PivotChart

  • Understanding PivotCharts
  • Creating a PivotChart
  • Selecting and arranging PivotChart fields

Customising a PivotChart

  • Changing the calculation function of a PivotChart
  • Changing the chart style for a PivotChart
  • Changing the chart type of a PivotChart
  • Changing the data source of a PivotChart
This Course is Included in our Content Bundles

New Generation Workplace | E-Learning Content Bundle

Our full course library for Microsoft 365 and Microsoft Office.

Includes E-Learning training courses for the following applications: Excel, Word, PowerPoint, Outlook, OneNote, OneDrive, Teams, SharePoint, Planner, Power BI, Power Automate, Power Apps, Delve, Forms, Lists, To-Do, Whiteboard, Windows, Edge, Viva Engage, Visio and more...

Our New Generation Workplace content package is our full E-Learning course library for Microsoft 365.

This course package addresses core end-user training for Office and Windows at the Beginner, Intermediate and Advanced levels and also provides training on how to use Microsoft 365 collaboration tools to easily communicate and work in project teams.

During your subscription to this course package, you will receive our content updates to the package, including new courses we release into the package.

Desktop | E-learning Content Bundle

Learn and improve basic skills on using the classic Office desktop apps and more.

Includes E-Learning training courses for the following applications: Excel, Word, PowerPoint, Outlook, OneNote, OneDrive, Windows, Edge, To-Do and more...

Our Desktop E-Learning content package for Microsoft 365 addresses core end-user training for Office and Windows at the Beginner, Intermediate and Advanced levels.

During your subscription to this course package, you will receive our content updates to the package, including new courses we release into the package.

Contact info

We are the leaders in the building industries and factories. We're word wide. We never give up on the challenges.