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!

QUERYING DATA exercises

This page lists the 18 exercises about Querying data in Excel on our website:

Software:	Excel
Topic:	Querying data
Level:	Relatively easy
Exercise:	Add custom columns in Power Query to calculate new values in a list of tallest buildings.

Show this exercise

Software:	Excel
Topic:	Querying data
Level:	Relatively easy
Exercise:	Apply basic transforms to a table of tallest buildings to tidy up the data.

Show this exercise

Software:	Excel
Topic:	Querying data
Level:	Relatively easy
Exercise:	Import a population table then tidy up the data.

Show this exercise

Software:	Excel
Topic:	Querying data
Level:	Relatively easy
Exercise:	Import data about the world's tallest buildings into an Excel workbook.

Show this exercise

Software:	Excel
Topic:	Querying data
Level:	Relatively easy
Exercise:	Use parameters in Power Query to dynamically query worksheets of top ten albums in the UK charts.

Show this exercise

Software:	Excel
Topic:	Querying data
Level:	Relatively easy
Exercise:	Use Power Query to group and aggregate a table of the world's tallest buildings.

Show this exercise

Software:	Excel
Topic:	Querying data
Level:	Average difficulty
Exercise:	Create custom columns to calculate new values from a data source of music.

Show this exercise

Software:	Excel
Topic:	Querying data
Level:	Average difficulty
Exercise:	Duplicate and append queries in Power Query to add multiple worksheets to a single list.

Show this exercise

Software:	Excel
Topic:	Querying data
Level:	Average difficulty
Exercise:	Import tables of artists, albums and concert tours into an Excel workbook using Power Query.

Show this exercise

Software:	Excel
Topic:	Querying data
Level:	Average difficulty
Exercise:	Tidy up exchange rate and investment data in Power Query, splitting columns and replacing values.

Show this exercise

Software:	Excel
Topic:	Querying data
Level:	Average difficulty
Exercise:	Use error handling features in Power Query to clean tables containing music data.

Show this exercise

Software:	Excel
Topic:	Querying data
Level:	Average difficulty
Exercise:	Use Power Query to clean data sources related to music.

Show this exercise

Software:	Excel
Topic:	Querying data
Level:	Average difficulty
Exercise:	Use Power Query to pivot a column in a table of concert tours.

Show this exercise

Software:	Excel
Topic:	Querying data
Level:	Average difficulty
Exercise:	Use Power Query to unpivot columns in a table of data about musical albums.

Show this exercise

Software:	Excel
Topic:	Querying data
Level:	Average difficulty
Exercise:	Use power Query's import from folder feature to combine multiple files into a single list.

Show this exercise

Software:	Excel
Topic:	Querying data
Level:	Average difficulty
Exercise:	Use Power Query's merge feature to lookup values across tables.

Show this exercise

Software:	Excel
Topic:	Querying data
Level:	Average difficulty
Exercise:	Use the transpose transform in Power Query to flip the rows and columns of table of entertainment data.

Show this exercise

Software:	Excel
Topic:	Querying data
Level:	Harder than average
Exercise:	Create a query to import a table of tall buildings, create new columns and then pivot the data.

Show this exercise

You can search our full list of Excel exercises here. Or why not learn to do them the right way on one of our Excel training courses? You can attend our online training classes wherever you are in the world!

None of the exercises or supporting files may be copied in any form or used commercially without the prior written permission of Wise Owl (although you're welcome to use them for testing your own knowledge).

This page has 0 threads

Add a new post

EXERCISE TOPIC

EXCEL EXERCISES

EXCEL EXERCISES

QUERYING DATA exercises

Head office

London

Manchester