As a compensation professional, you are likely aware of all the great functions that the Microsoft Excel program can perform for you in your work. While there are great programs that help compensation professionals organize and analyze large amounts of data, sometimes the old reliable spreadsheet can be just as beneficial for project work. At some point during your interview, your interviewer may want dig into your experiences with Excel. with this question, they are specifically talking about the PivotTables within the program that are used to house large data sets. If you have direct experience, discuss that in detail with your interviewer and talk about how using the program assisted you in your work. If you don't have experience with this function in Excel, be sure to research it and talk about its importance in aggregating numerical data and using the program to analyze large amounts of data.
