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:

Courses in Excel

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

Software ==>	Excel (128 exercises)
Topic ==>	Querying data (18 exercises)
Level ==>	Relatively easy
Subject ==>	Excel training

Import data about the world's tallest buildings into an Excel workbook.

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 .

Create a blank Excel workbook and save it with the name Importing Buildings.xlsx in a location of your choice.

Choose to import data from the Tallest Buildings.xlsx file from the folder shown at the top of this exercise.

Select the Buildings worksheet.

Choosing to import a worksheet using Power Query in Excel

Buildings is the only worksheet in the file.

Choose to load the data into a table in a new worksheet.

Choosing where to load query results in an Excel workbook

These are the default settings so you shouldn't need to change anything.

You should now have a new worksheet containing a table of tallest buildings.

A table of tallest buildings in an Excel worksheet

Some of the data you should see.

Save the Importing Buildings.xlsx file and close down Excel.

Now we'll make some changes to the original file. Find and open the Tallest Buildings.xlsx file from the folder shown at the top of this exercise.