Learn Excel Pivot Tables in under an hour!

Course

Online

£ 10 + VAT

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

If you've been tasked with summarising a large amount of data, or need to know how to create Pivot Tables, look no further. This course will take you from the basics of what is a Pivot Table, to creating visually impressive reports with ease. You'll be able to quickly analyse data from large worksheets into manageable reports. The course will take you through creating a Pivot Table and best practices, Grouping data to help when summarising, using powerful filtering with Slicers and illustrating your data with Pivot Charts.Pivot Tables are a great tool to master for any situation or any role where reporting is required. Who is the target audience?Any Excel user who requires an introduction to Pivot Tables. You should already be familiar with the basics used to working with large amounts of data.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

Understand what Pivot Tables are and when to use them
Create a Pivot Table report
Utilize the tools available for summarising data
Work with Slicers and Create Pivot Charts

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2021

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 4 years

Subjects

  • MS Excel
  • Excel
  • Excel Formula
  • Excel Sheet
  • Excel for Accounting
  • Database
  • Data Management
  • Information Systems
  • Microsoft
  • Microsoft Excel

Course programme

Introduction to Pivot Tables 1 lecture 00:56 Course Outline Introduction to Pivot Tables 1 lecture 00:56 Course Outline Course Outline Course Outline Course Outline Course Outline Creating Pivot Tables 5 lectures 55:11 Creating a Pivot Table Analysing Data Grouping Fields Using Slicers Adding Pivot Charts Creating Pivot Tables 5 lectures 55:11 Creating a Pivot Table Analysing Data Grouping Fields Using Slicers Adding Pivot Charts Creating a Pivot Table Creating a Pivot Table Creating a Pivot Table Creating a Pivot Table Analysing Data Analysing Data Analysing Data Analysing Data Grouping Fields Grouping Fields Grouping Fields Grouping Fields Using Slicers Using Slicers Using Slicers Using Slicers Adding Pivot Charts Adding Pivot Charts Adding Pivot Charts Adding Pivot Charts

Additional information

You'll need Excel 2010, 2013 or 2016 installed and a desire to learn about how Pivot Tables can work for your large data set

Learn Excel Pivot Tables in under an hour!

£ 10 + VAT