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:

Excel training courses

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 ==>	Average difficulty
Subject ==>	Excel training

Import tables of artists, albums and concert tours into an Excel workbook using Power Query

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 workbook in Excel and save it as Importing Music.xlsx in a location of your choice.

Choose to import data from the Music Tables.xlsx workbook from the folder shown at the top of this exercise.

Choosing an Excel file to import data from.

Select this workbook to import data from.

Choose to import all three worksheets from the selected workbook.

Selecting worksheets to import from an Excel workbook

You'll need to check the Select multiple items option to do this.

Choose to load each worksheet into a table in a new worksheet.

Choosing where to load multiple queries in Power Query for Excel

Make sure you're not adding the data to the Power Pivot Data Model!

Check that you have three new worksheets in the workbook.

A collection of worksheets in a Microsoft Excel workbook

You should have four worksheets in total at this point.

Choose to import the Fastest selling albums.csv file from the folder shown at the top of this exercise.

Importing a csv file into an Excel workbook

Import the contents of this file.

Load the data into a table in a new worksheet.

An Excel table showing data imported from a csv file

Some of the new data you should see.

Choose to import data from the BPI 2026 Yearbook.pdf file. Select Table234 (Page 86) to get a list of the top 20 albums.

Choosing a table from a PDF file to import into an Excel workbook using Power Query

You can use the search box to filter the list of items.

Load the data into a table in a new worksheet.

A table in Excel loaded from a PDF file using Power Query

The column headers aren't quite right, but we can learn how to fix that later!

Wikipedia is a good source for web tables. Open a web browser and search for a list of best selling albums.

A web page containing a list of best selling albums

This is a good place to start.

Copy the URL from the web browser and, in Excel, choose to import data from a website.

Entering a URL to import data from the web in Power Query

Use the URL you've copied.

Find a table with a list of albums and choose to load it into a table in a new worksheet.

Choosing a table from a website to import into an Excel workbook.

Pick any table which has a list of albums.

Save and close the Excel file.

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!

This page has 0 threads

Add a new post

EXERCISE TOPIC

EXCEL EXERCISES

EXCEL EXERCISES

Import tables of artists, albums and concert tours into an Excel workbook using Power Query

Head office

London

Manchester