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.
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.
After splitting the name, place the Full Name in the Full Name column using the First Name and Last Name only.
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
Highlight the data in the Last Name column which you want to split (as below) and then click "Text to Columns", found in the ribbon at the top of the screen, under Date -> Data Tools-> Text to Columns.
When the Convert Text wizard appears, select the File Type "Delimited" and then Next. On the next page of the Wizard, check the "Comma" Delimiter box, which will show the data split by comma. Finally, click finish, to split the data into 2 columns.
NOTE: If a dialogue box appears, which reads 'There is already Data in here. Do you want to replace it?', go ahead and click OK.
In the 'Full Name' column, use the Concatenate formula to create the Full Name of the individual.
Concatenate puts together information in different cells, so in cell D5 type the formula =CONCATENATE((C5)," "(B5)) and then click the bottom right corner of the cell and drag the formula down the column to build every individual's name.
Highlight the headings in the table and select the Bold font (found in Excel -> Home -> Font-> Bold), finally select all the data in the table and then select the All Borders option in the Borders section of Font (found in Excel -> Home -> Font-> Borders)
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.