Excel Challenge #1
This is the first in our series of challenges to put your Excel skills to the test.
This week, we have a series of tasks to cleanse raw data and turn it into a formatted table. If you get stuck, just scroll below to reveal step-by-step instructions with helpful tips.
Download the raw data here, and complete the tasks below.
Tasks
-
Using the initial raw data, cleanse the Rating Column wherever there is 'NaN' to 'N/A'. Then, remove the '+' at the end of each Installs value. Finally, format the data in the Last Updated column in DD-MMM-YY (for example 01-Jan-21).
-
Format the table so it is in a Blue, Table Style Medium 2 headed format and set the Table name to 'App_Data_New'.
-
Sort the data so the Top Rated Apps are shown in descending order and exclude any Ratings which are 'N/A'.
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 >

Enter Your Voucher Code Here
Note: We ask for your billing address for our tax records only. We do not ask for card details for pre-paid items.