Question: The Data Data can come to you in many different formats. In this assignment, you are presented with a set of customer transactions contained in
The Data Data can come to you in many different formats. In this assignment, you are presented with a set of customer transactions contained in a PDF file. The challenge is to get the data into an Excel spreadsheet, formatted in a usable way, that allows you to do some analysis. As you move through the various sections of the assignment, please copy the spreadsheet tab used in that section to a new tab to work on the next section without disturbing your work from the earlier section. To receive full credit for this assignment, you must show your work for each section. Section 1: Get the Data into Excel Open the pdf document and highlight the data. Copy that data and paste it into a new workbook that you will name "Homework #2 - [Your Name]". Label the tab into which you have copied the data "Section 1". As you copy the data into the worksheet, I recommend you Paste Special-Text. You now can see that the worksheet shows all the information in one column. You want to be able to analyze the
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
