Excel Challenge #3 - Employee Dataset 1

 This week's task is to organise a list of Employees within an organisation.

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

Tasks

  1. Using the initial raw data, split the name in the Last Name column using the comma as the split between last name and First Name.

  2. After splitting the name, place the Full Name in the Full Name column using the First Name and Last Name only.

  3. Finally format the table so you box all the cells and give the headers a Bold font.

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 >