Excel Challenge #6 - Footballer Dataset 2

For this challenge, create a Pivot Table from a data set of football players, which focuses on league and club names, player positions and total players.

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

Tasks

  1. Using the data table, create a Pivot Table where the Rows will focus on the League as primary level and Club as secondary level, column will focus on the Player's position and the Total will be the Total number of players bought.
  2. Add a Conditional Format to the Grand Total column to show data bars which provide an extra visual on numbers.
  3. Choose a Pivot Table design of your choice to make the visual more appealing.

    The end result should 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 >