Apr 22, 2016 · Verbal assessments for Excel & Finance/BI systems seem limited compared to a actual scored assessment, paper-based or computer application (If you can't afford online app, used screenshots and formulate questions that require selection of correct sequence or missing/next step info.

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 Excel and data management skills in an interview? Do you have ...

Aug 19, 2015 · A basic understanding of Excel's data model (values vs presentation, dates are represented by numbers) Here are some skills that tend to put a user in the "advanced" range: Chaining together various functions to create a complex formula Usage of more complicated functions (SUMPRODUCT, INDEX/MATCH, array formulas) Pivot tables