Tag Archives: Benchmarking Survey

Create a pivot table in the “Job Data Exercise” file to report the remaining information requested in the survey ( of incumbents, avg salary, bonus count and average bonus amount).

Question Instructions: 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 […]