Question: Load the data into Excel. Below, are a few suggestions to keep in mind. You should import the data into three different worksheets within one


Load the data into Excel. Below, are a few suggestions to keep in mind. You should import the data into three different worksheets within one workbook. One worksheet should hold the 2015 data, another worksheet should contain the 2016 data and the third worksheet should include the job codes. Label these three worksheets as 2015Data, 2016Data and JobCodes, respectively. Follow Excel leading practices, including: Depending on how you loaded data into Excel, you may utilize "Text to Columns" on the Data Ribbon of the Excel toolbar or the Text Import Wizard to split the delimited single column of text in the 2015Data, 2016Data, and JobCodes tabs into multiple columns. Transform the data: Once the data is loaded into Excel and split from a delimited single column of text, make the 2015, 2016 and job codes data "talk together." That is, be aware that the different years of data are aggregated at different levels and you have to extract job code information to be able to compare the data between years. Follow Excel leading practices, including
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
