Skip main navigation

Advanced Capabilities of Pivot Tables and Slicers

Discover advanced capabilities of pivot tables and slicers.

Now that you have the basics covered in how to manage your data using pivot tables, it is time to kick it up a notch and explore some of the advanced capabilities of the pivot table.

In this video, we explore the different ways the pivot table can be manipulated to enhance the visualisation of data and to create sophisticated dashboards.

You already discovered that you can add and connect slicers to one or multiple pivots. Creating dashboards does not end with adding and connecting slicers.

Depending on the level of data in your pivot, you can move between and visualise high-level and granular data. For example, if you are displaying progression across a timeline as a line chart, you can view data for the entire period (year) or month to month.

Slicers are a great tool to use in your dashboards. But what about filters? Remember that you can still use your field list, in addition to your slicers, to filter your data. Slicers and filters can complement each other when used together in a dashboard. Slicers are very visual but not so useful for large amounts of data. Filters can help you manage your data sets better.

Let’s do some reflecting and recapping.
Take a moment to review the following resource which gives a broader overview of how to use slicers to filter pivot data.

Join the discussion

Imagine you’re a business owner, and you had to create a dashboard. Where would you start? Make a checklist for creating a dashboard. Did the information you learned up to this point help you while you were making your checklist?
This article is from the free online

How to Use Microsoft Excel for Data Analysis

Created by
FutureLearn - Learning For Life

Our purpose is to transform access to education.

We offer a diverse selection of courses from leading universities and cultural institutions from around the world. These are delivered one step at a time, and are accessible on mobile, tablet and desktop, so you can fit learning around your life.

We believe learning should be an enjoyable, social experience, so our courses offer the opportunity to discuss what you’re learning with others as you go, helping you make fresh discoveries and form new ideas.
You can unlock new opportunities with unlimited access to hundreds of online short courses for a year by subscribing to our Unlimited package. Build your knowledge with top universities and organisations.

Learn more about how FutureLearn is transforming access to education