Skip main navigation

New lower prices! Get up to 50% off 1000s of courses. 

Explore courses

How to Create Pivot Tables in Excel

This video explains that pivot tables are powerful tools to calculate, summarise and analyse data that lets you see comparisons, patterns and trends.

This video on the basics of creating pivot tables will include:

  • Creating and selecting the correct cells
  • Using pivot tables in an existing or new worksheet
  • How to add fields
  • How to edit filters, columns and rows
  • How you can group data in a pivot table in order to analyse it
  • How to create and edit slicers to focus analysis
This article is from the free online

Excel for Data Analysis

Created by
FutureLearn - Learning For Life

Reach your personal and professional goals

Unlock access to hundreds of expert online courses and degrees from top universities and educators to gain accredited qualifications and professional CV-building certificates.

Join over 18 million learners to launch, switch or build upon your career, all at your own pace, across a wide range of topic areas.

Start Learning now