559 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
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.
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
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:
Detached and semi-detached properties; with
3, 4, or 5 bedrooms.
This should give this:
You can move and resize the slicers just like any other object in Excel.
On the initial pivot table, insert a date on the market timeline and filter it to show:
Properties with 1 or 2 bedrooms; which were
Placed on the market between Nov 2022 and March 2023.
Your pivot table on the initial pivot sheet should now look like this:
A timeline is like a slicer but for dates only.
Re-name the sheet tab to Timeline Pivot and use Save As... to save the file in your own new Excel work folder.
You can find other training resources for the subject of this exercise here:
25 Aytoun Street