(Controller at Silicon Valley start-up)| Aug 19, 2013
Excel and data management (including working with large volumes of data and databases) skills are often assumed upon finance and accounting professionals. However, some positions are better served by those who are exceptionally strong in this area. How does a hiring manager assess (or maybe offer an Excel skills test) Excel and data management skills in an interview?
Editor's Discussion Summary:
It's hard to assess Excel skills in interviews
Ask what functions they've used, such as "sumif," "vlookups," and "if"
Ask what their favorite advanced funciton is
Ask about classes, certifications, and online training they've taken
Before the interview, ask them to bring an Excel analysis they've done to discuss
Present an Excel file and ask them to complete it, fix it, interpret it, etc
Ask about what the conadidate believes are his/her potential Excel weaknesses
Ask them to create a pivot table or other advnaced function
Attempt to understand their willingness and ability to learn new things