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.

Filters and slicers

In this video, Deborah Ashby from Simon Sez IT explores filtering and slicers in pivot tables.

In this video, you’ll explore filtering and slicers.

You will learn more about:

how to refresh and change the data source for a pivot table
the options available in the right-click menu for a pivot table
using filters and clearing filters
adding and using slices.

Want to keep learning?

This content is taken from Packt online course

Advanced Data Visualisation and Analysis in Excel

See other articles from this course

This article is from the free online

Advanced Data Visualisation and Analysis in Excel

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