I have an upcoming 90 minute excel test as part of the interview process with Accordion (strategic finance group). Any insight on what to expect? Interviewer mentioned it would be data focused to ensure I have requisite excel skills.
| +16 | Lateral to MBB from Investing Seat | 13 | 4h | |
| +12 | Premed to MBB Recruiting | 2 | 4d | |
| +11 | Chances at MBB - Reality Check | 2 | 6d | |
| +9 | Seeking Advice: Applying for Consulting Roles Post-MSc—Home Country vs. Study Abroad Location | 1 | 2d | |
| +3 | On campus jobs? | 3 | 6h | |
| +3 | Am i cooked for MBB | 6 | 16h | |
| +1 | Portfolio Operations Group--DFW area | 2 | 5d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Based on the most helpful WSO content, when preparing for an Excel test with a strategic finance group like Accordion, it's crucial to focus on several key areas to demonstrate your proficiency. Given the interviewer's hint that the test will be data-focused, here are some insights and areas you might want to concentrate on:
Advanced Excel Formulas: Be comfortable with using and applying advanced Excel formulas that are commonly used in finance settings. This includes, but is not limited to, INDEX MATCH, VLOOKUP, HLOOKUP, SUMIF, COUNTIF, and array formulas. These formulas are essential for data manipulation and analysis.
Financial Modeling Best Practices: Understanding the best practices in financial modeling is crucial. This includes setting up clean and clear models, using consistent formatting, and ensuring that your models are easy to follow and audit. The WSO Financial Modeling Resources section provides guidance on these best practices.
Data Analysis and Manipulation: Given the data-focused nature of the test, you should be prepared to perform various data analysis tasks. This could involve sorting, filtering, and using pivot tables to summarize and analyze large datasets efficiently.
Scenario Analysis: Be ready to conduct scenario analysis, which might involve creating different financial scenarios based on varying assumptions. This tests your ability to adjust models dynamically and analyze the impacts of different variables.
Excel Shortcuts: Proficiency in Excel shortcuts can significantly speed up your work and is often looked upon favorably by employers. Familiarize yourself with key shortcuts for navigation, formatting, and formula entry.
Attention to Detail: Strategic finance roles require a high level of accuracy. Pay close attention to detail in your calculations and analysis to minimize errors.
Remember, the goal of such tests is not only to assess your current Excel skills but also to gauge your ability to learn and adapt. Showing a structured approach to problem-solving and an ability to think critically about financial data will stand you in good stead.
Lastly, consider leveraging the WSO Excel Modeling Course to brush up on your skills before the test. This course covers a wide range of topics that are directly relevant to Excel tests in finance interviews. Good luck!
Sources: Strategic finance?, 2-hour Modeling Test for HF (Fundemental Equities) - What to expect?, What can I expect: a REPE Top 5-10 modelling test?, JLL Analyst Excel Test, Help with 3-Statement Model Test
Placeat voluptatem ut ad amet sint qui omnis. Ad veniam occaecati enim dolor ab aliquid. Ipsam nam harum voluptatibus et ex. Quam excepturi animi cupiditate. Nulla voluptates sunt amet.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...