This page has 0 threads | Add post

Exercises

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

Software ==>	PowerPivot (72 exercises)
Topic ==>	Using Excel tables (3 exercises)
Level ==>	Average difficulty
Subject ==>	Power BI training

Link to Excel, Access and the clipboard (via Word) to import and link 4 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 .

This should be a simple exercise: just create a pivot table showing the number of stores in each region!

What could possibly be difficult about that? Well, unfortunately the gods of misfortune have blown on our tables, and scattered them into four different types of data source: a linked Excel table, an imported Excel workbook, an Access database and a Word document.

Open the workbook called Stores in the above folder. Use the PowerPivot tab to add this table to your data model:

Now rename your table in the PowerPivot data model.

Next, go into Word and open up the document called Regions in the above folder. Copy the table of regions, and paste it into PowerPivot to get a second table: