FutureLearn uses cookies to enhance your experience of the website. All but strictly necessary cookies are currently disabled for this browser. Turn on JavaScript to exercise your cookie preferences for all non-essential cookies. You can read FutureLearn's Cookie policy here.

Learn more about this course.

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

Want to keep learning?

This content is taken from FutureLearn online course

Excel for Data Analysis

See other articles from this course

This article is from the free online

Excel for Data Analysis

Created by

Join Now

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