Skip main navigation

The three main filters to explore

What filtering methods are available for a pivot table, and how do they function? Learn more in this video.

After watching this video, you should understand the filtering methods available for a pivot table, as well as how they function so you can start thinking about how to select the correct one for your context.

Share your thoughts

Can you think of a real-life scenario where applying filters to a pivot table would be particularly useful for decision-making or data exploration? Describe how the filters would be applied in that context and share in the comments below.
This article is from the free online

Mastering Excel Pivot Tables

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