This page has 0 threads | Add post

Exercises

Finding our exercises useful? Please consider helping us to share more!

Software ==>	Excel (113 exercises)
Topic ==>	Advanced pivot tables (3 exercises)
Level ==>	Average difficulty
Subject ==>	Excel training

Using Slicers, Timelines and Report Filter pages in Pivot tables

This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Before you can do this exercise, you'll need to download and unzip this file .

Open the file contained within the folder name shown above.

Create a new pivot table on a new worksheet to show the following:

Part of pivot table	What to show
Row labels	Postcodes
Column labels	Garden size
Values	Asking price
Filters	Show only detached houses with 4 or 5 bedrooms

This is what your pivot table should initially look like:

This is what your pivot table should look like now.

Change the sheet tab name to Initial Pivot.

Use the pivot table's Report Filter Pages feature to insert new pivot tables on separate sheets that filter the location for each location type - Remote, Town, Countryside and Village.

You should now have 4 new sheets as shown below:

Each sheet has a new pivot table containing all the same filters as the original, but has a new filter on the Location field which is different for each sheet.

On the Countryside sheet, add 2 slicers and use them to filter to show only: