Excel Management Consultant

hey there :)

I know this format from Inverto! 

They usually focus on clean structuring, speed and accuracy rather than advanced formulas, so expect market sizing style models, basic financial calculations, sensitivity tables and very clear formatting. Practice being fast with SUMIF, VLOOKUP or XLOOKUP, basic charts and logical checks. TFocus on thinking clearly under time pressure than fancy Excel tricks.

best,
Alessa :)

Hi,

I think the best way to improve it is to actually do some practice. IB prep resources are quite popular, but i think definitely overkill for this. 

I would suggest the following:

• Read up and get familiar with shortcuts and key formulas
• Practice some basic modelling
  • Use platforms such as coursera / udemy for basic courses
  • Feel free to reach out to me and I can share some simple exercises as well

All the best!

That is a fantastic question, and I've seen these tests increasingly implemented, especially for experienced hire roles where the firm needs assurance you can generate client-ready data immediately. Here is the reality of what they are testing: it is not about knowing complex array formulas; it is almost entirely about speed, efficiency, and structured thinking.

The test is usually highly timed (30-45 minutes max) and designed to simulate a real-world, high-pressure task. They want to see that you can navigate, manipulate, and structure data without pausing. If you spend 20 seconds hunting on the ribbon for "Text to Columns" or formatting, you will run out of time. Your focus should be 90% keyboard shortcuts and muscle memory. Practice selecting entire columns/rows, creating clean tables from messy inputs, generating a simple pivot and chart, and quickly inserting and deleting cells without using the mouse.

A great way to prepare is to download a complex, messy financial dataset (like an SEC filing excerpt) and practice cleaning it up and synthesizing three key conclusions in under 20 minutes, using only the keyboard. Master shortcuts for formatting (bold, currency, borders), selection, navigation, and core data cleansing tools. When the pressure is on, that efficiency is the differentiator.

Focus on speed over complexity, and you'll be fine. All the best!