Excel Pivot Tables - Data Analysis

Microsoft Office 365 - Microsoft Excel

Book Course Now

Course Overview

A PivotTable is a powerful tool to calculate, summarise and analyse data that lets you see comparisons, patterns and trends in your data.

This course equips the user with a proficient knowledge of data analysis in Excel focusing on using Pivot Tables and Pivot Charts. Pivot tables enable you explore and analyse raw data, revealing powerful insights and trends. Pivot charts show this data in an attractive, easy to understand graphical format.

This is a one-day course running from 9:30 am - 4:00 pm.
Training is hands-on and tutor-led.
We provide a comprehensive training manual, lunch and certification.
Courses run at both Swansea and Cardiff locations.
This course can be run as a company specific option either at your site or our own.

  • Course Content

    Getting Started

    Entering the raw data for analysis, hints and tips on best practice.

    Creating Pivot Tables

    Selecting the data, defining the structure of the pivot table.


    Table layouts and styles, design and formatting options.

    Analyzing data

    Sorting, filtering and grouping tools.


    Working with calculated fields, items and values. Percentages of rows, columns, totals and other fields.

    Pivot Charts

    What is a pivot chart? Creating a pivot chart, pivot chart rules. Managing the underlying data. Formatting a pivot chart.


    Inserting a slicer, inserting multiple slicers, formatting a slicer, editing a slicer.

  • Prerequisites

    Attendees will gain the maximum benefit if they have attended our Level 1 course, or are familiar with creating basic spreadsheets and using simple functions.

  • Qualification

    Computeraid certificate of achievement.

  • Excel Level 3
    Gain an in depth knowledge of data analysis, learn how to audit your spreadsheet and use advanced features such as templates and macros.

    Excel Formulas and Functions
    Excel has an entire library of functions or predefined formulas that you can use. There are hundreds of functions in Excel that allow you to format text, reference cells, calculate financial rates, look up information and more.

Booking Options Available for Excel Pivot Tables - Data Analysis

Please select the location you want to book the course

Please select the date you want to book the course

Please select the number of people attending the course

No. People
Download Booking Form

Alternatively you can download our booking form, fill in all the relevant information and mail it back to us.

Tailored Training

Tailored Training

Take advantage of a customised training programme to suit your needs at a location of your choice.

Learn More

Funded Training

Funded Training

Funding might be available for training depending on your circumstances.

Learn More

Funded Redundancy Training

Funded Redundancy Training

Are you about to be made redundant or have you been made redundant in the last three months? 100% funded training is available.

Learn More

Email Updates

Email Updates - Join Our Mailing List

Join our mailing list to keep updated on exclusive offers and latest news on our training courses.

  • ECDL
  • ECDL Advanced
  • Approved Test Centre

  • Computeraid Ltd, 4th Floor, 11 Wind Street, Swansea, SA1 1DP

  • Telephone: 01792 610550 / 029 2066 4285
  • [email protected]
Join Computeraid Ltd on Facebook
Follow Computeraid Ltd on Twitter
Tweets by @ComputeraidLtd
View Dizzee Designs on LinkedIn

Computeraid Ltd

Computeraid Ltd – LinkedIn

Computeraid is the largest supplier independent computer training and consultancy company in South Wales, training around 20,000
people days annually.

Swansea. South Wales