This page has 0 threads | Add post

Exercises

Many people around the world enjoy and benefit from our exercises. If you're one of them - and can afford to - please make a small donation to help keep this and future blogs, exercises, skills assessment tests, tips, tutorials and videos freely available to everyone!

You can find other training resources for the subject of this exercise here:

Classes in Power Pivot

You can also book hourly online consultancy for your time zone with one of our 7 expert trainers!

Software ==>	Power Pivot (43 exercises)
Topic ==>	Pivot tables using Power Pivot (2 exercises)
Level ==>	Relatively easy
Subject ==>	Power Pivot training

Create pivot tables based on a data model of the world's tallest buildings.

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 Tallest Buildings Pivot Tables.xlsx file in the folder shown above.

Open Power Pivot to see a data model containing data on the world's tallest buildings.

Use the Power Pivot data model to create a pivot table on a new Excel worksheet. Configure the pivot table as shown below: