If you're interviewing with Alvarez & Marsal for a restructuring, valuation, or private equity role, there's a good chance an Alvarez and Marsal Excel test stands between you and an offer. The challenge is that A&M doesn't run one standardized test. Depending on your practice group, level, and office, you might get a dataset and a list of formulas to write, a 30-minute analysis you present to a director, a valuation modeling quiz, or an online battery that tests Excel alongside PowerPoint.
That variability is exactly why strong candidates get caught off guard. This guide breaks down the four formats candidates report, what A&M is actually grading, the skills to lock down before test day, and a 7-day plan to get you ready.
Key Insights
- The Alvarez and Marsal Excel test is not a single test: candidates report four formats, ranging from formula-driven data tasks to timed analytical cases, valuation modeling quizzes, and online test batteries.
- Restructuring, Valuation, and PEPI candidates are the most likely to face one, and it can appear anywhere from right after the recruiter screen to the final round.
- A&M rewards clean structure, accuracy under time pressure, and a clear "so what" over model complexity, and interviewers may ask you to walk through your work afterward.
What Is the Alvarez and Marsal Excel Test?
The Alvarez and Marsal Excel test is a practical skills assessment A&M uses to confirm you can do the analytical work its analysts and associates do from day one. It shows up most often in finance-heavy practices, where the job runs on spreadsheets. A&M's own restructuring analyst postings describe sorting through large data sets that can be unorganized and incomplete, and building and updating 13-week cash flow models.
That context is the key to understanding the test. A&M is an operator's firm, staffed into turnarounds, bankruptcies, diligence, and performance improvement work where clients need answers fast. The case interview tests how you think; the Excel test checks whether you can execute.
Which A&M Groups Use an Excel Test?
A&M's practice groups run their own recruiting processes (the Transaction Advisory Group even has its own campus recruiting site), so the test varies by group. Candidate reports cluster in a few places:
- Restructuring: Excel tests and take-home assignments come up repeatedly in analyst and summer analyst reports.
- Valuation: Candidates report an Excel test or modeling quiz, often followed by technical questions about their work.
- Private Equity Performance Improvement (PEPI): Reports range from standalone Excel tests to 2-hour case-and-Excel exercises for experienced hires.
- Transaction Advisory Group (TAG): Reports of a formal test are less consistent, but you should be ready to discuss your Excel experience.
- Offices outside the U.S.: Some offices, including London, use online test batteries that include an Excel module.
Treat everything below as a map of what's possible, then confirm the specifics for your process with your recruiter.
Where the Excel Test Falls in the A&M Interview Process
The test doesn't have a fixed slot. Here's where candidates report encountering it:
| Timing | What Candidates Report |
|---|---|
| Right after the recruiter screen | A London analyst candidate completed four online SHL tests (numerical, reasoning, Excel, and PowerPoint) after a 20–25 minute HR call. |
| Between screening and live interviews | One restructuring candidate described a recruiter call, then an Excel test, then a virtual one-on-one interview. |
| Between interview rounds | A Dallas restructuring candidate took an Excel test between a technical phone round and a second round with directors. |
| Final round | A Chicago restructuring summer analyst received an Excel assignment alongside two final-round interviews and had a week to complete it before those interviews. |
| Later rounds for experienced hires | A PEPI commercial due diligence associate candidate faced a 2-hour case study and Excel exercise in Round 3, after already passing an earlier Excel test. |
Questions to Ask Your Recruiter
Recruiters field these questions constantly, and asking them signals that you take the process seriously:
- Is the test live, timed online, or take-home, and how long do I have?
- Will I present my results or walk an interviewer through my file?
- Will I use my own computer, and which version of Excel should I expect?
- Are outside resources or AI tools permitted?
- Is the Excel exercise connected to a case interview?
The 4 Formats of the Alvarez and Marsal Excel Test
Candidate reports fall into four formats. You may see more than one over the course of your process.
Format 1: The Data Skills Test
This is the most commonly reported format at the analyst and summer analyst level. You receive a raw dataset and a list of tasks, and you're graded on whether your formulas return the right answers.
A Chicago restructuring summer analyst candidate described a take-home with two main sections, the first of which was a straightforward Excel test covering XLOOKUP chains, SUMIFS, COUNTIFS, TEXTSPLIT, IFS, and pivot tables. An earlier New York analyst candidate described a test that's always changing: you get a random dataset and need to analyze it using text functions, IF/AND/OR logic, INDEX/MATCH, VLOOKUP, and pivot tables.
This format tests formula fluency, speed, and accuracy. It doesn't test modeling theory, so don't spend your prep time building a three-statement model if this is the format you're facing.
Format 2: The Timed Analytical Case
This format is more common for experienced hires and later rounds. Instead of a task list, you get messy data and an open-ended question, and your job is to find the story in the numbers.
A manager-level candidate described an analytical (not modeling) test built on operational plant data, with 30 minutes for a quick analysis. A senior manager was handed a laptop loaded with financial statements and given 30 minutes to report on the health of a company a fictional client wanted to acquire, along with recommendations on what to investigate further. At the analyst level, a Chicago candidate described a 2-hour case interview with an Excel portion that tested the ability to create insights from raw numbers.
This format tests prioritization, business judgment, and your ability to communicate findings. Excel is the tool, but the deliverable is a recommendation.
Format 3: The Financial Modeling Test or Quiz
This format is most common in Valuation and in finance-heavy Restructuring and PEPI roles. A valuation summer analyst candidate reported an Excel modeling quiz paired with a case study, and one valuation associate candidate was asked follow-up technical questions based on the Excel test. A Dallas restructuring candidate fielded technical questions on the three financial statements and DCF before the Excel test, and another candidate described an Excel test focused on building a pivot table and interpreting a DCF.
One coach who works with PEPI candidates points to the same fundamentals: handle unstructured data quickly, understand how a three-statement model links together, and know the typical adjustments to net debt, net working capital, and EBITDA that come up in M&A and carve-outs. The bar is usually reading and linking financials correctly, not building a 20-tab model from scratch.
Format 4: The Online Battery or Assessment Centre
Some offices outside the U.S. fold Excel into a broader test battery. A London analyst candidate completed four online SHL tests covering numerical reasoning, reasoning, Excel, and PowerPoint. Another UK candidate described a numerical and Excel test ahead of case and market sizing interviews, and a Hong Kong candidate went through an assessment centre that combined an Excel test with a case reading exercise and group discussions.
If PowerPoint appears in your battery, prepare for it just as seriously. It's a separate skill, and most candidates neglect it until it's too late.
The 4 Formats at a Glance
| Format | Typical Length | Most Reported In | What's Graded |
|---|---|---|---|
| Data skills test | A timed session up to a one-week take-home | Analysts and summer analysts, especially Restructuring | Correct formulas, speed, accuracy |
| Timed analytical case | 30 minutes to 2 hours | Managers and above, PEPI, some analyst case rounds | Insights, prioritization, communication |
| Modeling test or quiz | Varies | Valuation, Restructuring, PEPI | Accounting and finance mechanics |
| Online battery or assessment centre | Varies | Offices outside the U.S., such as London and Hong Kong | Excel (and sometimes PowerPoint) alongside aptitude |
What A&M Is Actually Grading (Our Take)
Across every format, the scoring comes down to a handful of things, and none of them is model complexity.
- Accuracy under time pressure. A&M's work happens on deadline, often in distressed situations where a wrong number has real consequences. A fast answer that's wrong is worse than a slower one that's right.
- Clean, auditable structure. Separate inputs from calculations, label your assumptions, and keep hard-coded numbers out of your formulas. One coach advising a PEPI candidate put it plainly: the focus is clean structure and logic, not complex models.
- Linking operations to financials. Restructuring and performance improvement teams live at the point where an operational assumption (volume, price, headcount) becomes EBITDA or cash. Show that you can connect the two.
- The "so what." Numbers without a takeaway are half an answer. In analytical formats especially, interviewers want to hear what the data means and what you'd do next.
- Your ability to defend your work. Candidates report follow-up technical questions based on their test, and some describe multiple one-on-one conversations focused on the modeling test, often with an associate or director. If you can't explain every formula in your file, you haven't finished preparing.
Excel Skills to Master Before Your A&M Test
Core Skills for Every Candidate
- Navigation and shortcuts: Work keyboard-first; mouse-driven Excel is visibly slow in a timed test.
- Cell references: Know absolute, relative, and mixed references cold.
- Lookups: XLOOKUP, INDEX/MATCH, and VLOOKUP, including multi-step lookup chains.
- Conditional math: SUMIFS, COUNTIFS, and AVERAGEIFS with multiple criteria.
- Logic: IF, IFS, AND/OR, and IFERROR.
- Text and date functions: TEXTSPLIT, LEFT/RIGHT/MID, FIND, TRIM, TEXT, and EOMONTH for cleaning and reshaping raw data.
- Pivot tables: Build, filter, and refresh them, and reconcile their totals back to the source data.
- Data cleaning: Remove duplicates, fix inconsistent formats, and handle blanks before you analyze.
- Charts: Build simple charts that each make a single point.
Newer functions like XLOOKUP and TEXTSPLIT aren't available in older versions of Excel, so know the fallbacks (INDEX/MATCH; LEFT, MID, and FIND) in case the test machine isn't running the latest version.
Add-Ons by Practice Area
| Practice | What to Add |
|---|---|
| Restructuring | 13-week cash flow structure (receipts, disbursements, ending cash, liquidity), working capital timing, and the bridge from EBITDA to cash |
| Valuation | DCF mechanics, discount rate inputs, terminal value, sensitivity tables, and accounting fundamentals |
| PEPI and TAG | Three-statement links, EBITDA adjustments, net working capital, and net debt and debt-like items |
| Performance improvement | Margin bridges, cost baselines, and savings tracking |
Build these skills the way consultants actually use them. Our Excel & PowerPoint for Consulting bundle covers data cleaning, conditional math, reference functions, pivot tables, DCF modeling, and consulting-style slides and data visualization, with practice datasets and real-world project prompts. It's built for exactly the work A&M tests: fast, clean analysis that ends in a clear recommendation. Get Excel & PowerPoint for Consulting →
A 7-Day Prep Plan for the Alvarez and Marsal Excel Test
| Day | Focus | What to Do |
|---|---|---|
| 1 | Speed | Drill navigation, selection, and formatting shortcuts until you can work without the mouse. |
| 2 | Core formulas | Rebuild lookups, SUMIFS/COUNTIFS, and IF logic from scratch on a sample dataset, and time yourself. |
| 3 | Pivots and cleaning | Clean a messy dataset, answer five questions with pivot tables, and reconcile every total to the raw data. |
| 4 | Timed analytical drill | Give yourself 45 minutes with an unfamiliar dataset and produce three takeaways and one recommendation. |
| 5 | Practice-area module | Restructuring: build a simple 13-week cash flow. Valuation: build and sensitize a DCF. PEPI and TAG: build an EBITDA bridge and a net working capital analysis. |
| 6 | Full mock | Simulate the real format (length, rules, and deliverable), then present your findings out loud in five minutes. |
| 7 | Review and logistics | Fix your recurring errors, write a personal pre-submission checklist, and confirm format details with your recruiter. |
Only have 72 hours? Combine Days 1 and 2 on the first day, Days 3 and 4 on the second, and spend your final day on a full timed mock in your practice area's format.
Test-Day Tactics for Live, Timed, and Take-Home Formats
- Read every task before you touch a cell. Budget your time per task and bank the quick wins first.
- Set up your structure before you calculate. A raw data tab, a calculations tab, and a summary tab make your work easy to follow and easy to check.
- Separate inputs from formulas. Follow the standard convention of blue font for hard-coded inputs and black for formulas.
- Build in checks. Make sure totals tie, row counts match, and every surprising output gets a sanity check before you move on.
- Lead with the answer. Open your summary tab or presentation with your key finding, then show the support behind it.
- Don't overbuild a take-home. A one-week deadline isn't a request for a 20-tab model; a clean, correct, readable file wins.
- Follow the rules on outside help and AI tools. If the rules aren't stated, ask. You'll likely have to explain your work, and anything you can't defend will cost you.
After the Test: Follow-Up Questions and the Case Interview
The Excel test rarely decides your candidacy on its own. Expect interviewers to probe your file, ask why you made specific choices, and push on your assumptions. Expect broader questions about your Excel experience too; one manager-level candidate was asked to describe the most complex Excel or data model they had built.
More importantly, A&M still runs case interviews, and those cases are built around the firm's work: turnarounds and liquidity in Restructuring, value creation and EBITDA improvement in PEPI, and diligence questions in transaction-focused groups. For a full breakdown of the process, see our Alvarez & Marsal interview guide.
Pair your Excel prep with real case reps. Black Belt, Management Consulted's flagship case interview prep program, gives you 10+ hours of 1:1 coaching with a former McKinsey, Bain, or BCG consultant, a structured prep plan, and a library of 600+ real cases, so you walk into A&M's case rounds as prepared as you are for the Excel test. Explore Black Belt →
5 Mistakes That Sink A&M Candidates
- Hard-coding numbers inside formulas. It breaks your model the moment an input changes and tells the reviewer you don't build auditable work.
- Skipping reconciliation. A pivot table that doesn't tie back to the raw data is a wrong answer, even if the formula looks right.
- Delivering numbers without a takeaway. In analytical formats, the insight is the deliverable.
- Preparing for the wrong format. Candidates who spend a week on three-statement modeling and then face a formula speed test (or the reverse) lose points they could have banked.
- Not being able to walk through your own file. If an interviewer asks why a cell says what it says, you need an answer in seconds.
Frequently Asked Questions
Does every Alvarez & Marsal role have an Excel test?
No. Excel tests are most consistently reported in Restructuring, Valuation, and PEPI. Other groups and offices vary, and some substitute a broader online assessment. Ask your recruiter what your process includes.
How long is the Alvarez and Marsal Excel test?
Candidates report everything from 30-minute analytical exercises to 2-hour case-and-Excel sessions to take-home assignments with a one-week deadline. The length depends on the format, which depends on your group and level.
Is the A&M Excel test live or take-home?
Both formats are reported. Some candidates complete timed tests online or in the office, while others receive take-home assignments before their final round. Even with a take-home, expect to discuss your work afterward.
What Excel functions should I know for the A&M Excel test?
Prioritize lookups (XLOOKUP, INDEX/MATCH, VLOOKUP), conditional math (SUMIFS, COUNTIFS), IF logic, text functions, and pivot tables. For finance-heavy groups, add three-statement links, DCF mechanics, and cash flow forecasting.
Does Alvarez & Marsal use SHL tests?
Some offices do. A London analyst candidate reported four online SHL tests covering numerical reasoning, reasoning, Excel, and PowerPoint. U.S. candidate reports more often describe an Excel test or assignment administered by the team itself.
How hard is the Alvarez and Marsal Excel test?
Candidates often describe the core formula test as manageable, with some calling it straightforward. The difficulty comes from time pressure, messy data, open-ended analytical prompts, and follow-up questions that test whether you truly understand your work.
Conclusion
The Alvarez and Marsal Excel test rewards candidates who prepare for the format they'll actually face. Find out which format you're getting, master the core functions, practice turning raw data into a recommendation, and be ready to defend every cell in your file. Then put the same rigor into your case prep, because the Excel test gets you into the conversation and the case interview gets you the offer.
Ready to prepare? Build consulting-grade analysis and slide skills with Excel & PowerPoint for Consulting, and get 1:1 case coaching from former MBB consultants with Black Belt.