Salary Benchmark

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). 


Management 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 […]

Scroll to top