Create a pivot table in the “Job Data Exercise” file to report the remaining information requested in the survey. Using the data summarized in the pivot table, complete the “Benchmark survey” worksheets.
Prepare the files for the assignment. These files include: One excel file called “Job Data Exercise” that you’ve created for Assignment #1, which includes several worksheets of data reflecting compensation data from your company. You can use your file from the previous assignment as a starting point, but additional vlookups are necessary for this Assignment. […]