Excel Challenge #5 - Footballer Dataset 1

For this task, we will be taking a data set of the top 20 footballer transfers of all time, and formatting it into an easy-to-read table. 

Download the data set here, and complete the tasks below.

Tasks

  1. Using the raw data, change the format in the Transfer_Fee column into Euro currency.

  2. Add a Conditional Format to the same column where you set any value below 70 million to fill the cell colour Green, between 70 million and 100 million to fill the cell colour Yellow and over 100 million to fill the cell colour Red.

  3. Finally, set the Table format to be White, Table Style Medium 1.

The end result should look like the table below:

Stuck on the tasks?

+ Reveal Step-By-Step Instructions


Sharpen your skills with our range of Excel courses designed to turn you from a table trainee to spreadsheet specialist here >