Data Manipulation in Excel

DATA MANIPULATION The job is to manipulate data within a series of spreadsheets to bring it into a consistent format. The inputs; • 12 pdf scans of confidential sales and leasing reports. Approximately 126 pages of data. An example has been uploaded. The template • An excel template, demonstrating the 20 columns of data and the data format required is provided. (Not all columns from the original documents will require manipulation or entry.) The outputs • You will save a 'clean' version of the excel template for each individual pdf. • Where the data is clean, you will copy and paste from the input excel files into the relevant columns on your 'clean' file. • Where the data requires manipulation, you will manipulate the data into a clean state and then move it into your 'clean' file. • When an individual pdf report is completely transcribed into the excel, you will perform an audit to ensure 100% fidelity to the original pdf. • You will then transfer the file back to me. • I will perform an audit of the data. • If clean; job done! Confidentiality • You will need to sign a non-disclosure agreement before seeing any data.