Analyse and Visualise Data with Pivot Tables
in Microsoft Excel

Overview:

This module is designed to provide participants with the skills needed to effectively analyse and visualise data using Pivot Tables in Microsoft Excel. Pivot Tables are powerful tools that allow users to summarise, explore, and present large datasets in a dynamic and interactive manner.

Target Audience:

This module is ideal for:

  • Beginners with little to no Excel experience
  • Professionals looking to refresh their basic Excel skills
  • Anyone wanting to improve their productivity with spreadsheets

By the end of this course, you'll be able to:

  • Understand the purpose and functionality of Pivot Tables and PivotCharts.
  • Create and customize Pivot Tables to analyse large datasets.
  • Use PivotCharts to visualise data and identify trends and patterns.
  • Apply advanced Pivot Table features such as grouping, calculated fields, and slicers.

Topics include:

  • Understanding the Pivot Table interface and component
  • Steps to create a Pivot Table from a data range or table
  • Customising fields and layout for optimal data analysis
  • Sorting, filtering, and grouping data within Pivot Tables
  • Creating PivotCharts to complement Pivot Tables
  • Customising chart types, styles, and layouts
  • Refreshing and updating Pivot Tables with new data
  • Use calculated fields to create new data fields by applying formulas to existing fields within the Pivot Table. 
  • Use slicers to provide an interactive interface to the data view and understand the current filtering state 

All Microsoft Excel Modules

Automate Decisions with Logical Functions

Search and Retrieve Data from tables with Lookup Functions

Analyse and Visualise Data with Pivot Tables

Add Automation to Your Workbooks with Macros

Transform Your Data with Power Query

Use AI in Excel to Turbo Charge Your Excel Experience

First Steps in Microsoft Excel

Creating Basic Formulas

Manipulate Data Using Tables

Data Visualisation with Charts

Using Statistical Functions to Analyse Data


Back to Training Courses
Submit
Thank you! Your message has been sent.
Unable to send your message. Please fix errors then try again.
Smiling professional man giviing okay gesture and holding a laptop

Contact Us

To find out more about our products and services or to discuss how we can help  improve communications and collaboration using Microsoft 365 apps within your organisation, give us a call on the telephone number below or complete the contact form.

  01274 024 353

Last Updated : 04/08/2024