case study interview excel

How to Perform Case Study Using Excel Data Analysis

In the latest Excel 365, performing any case study for business or research, it’s quite easier and smarter. It includes more exclusive features which give our required case studies a better way. I hope, you will learn the easiest way to perform a case study using Excel data analysis with some clear illustrations.

What Is Data Analysis in Excel?

The Analyze Data tool in Excel 365 is a powerful tool to manage our data by writing our queries directly in a search box. So we’ll be able to ask anything about our data without using any complex commands or formulas. Along with that, we can get very enriched and vivid visual illustrations or patterns of our data. In the earlier versions of Excel, the tool is named Data Analysis .

How Data Analysis Helps in Excel

It can search according to the queries through our natural language.
Provides high-level graphical illustrations and patterns.
Easy to get the Pivot Tables and Pivot Charts.
Faster steps save time.
The interest of Fields can be changed easily.

How to Use Excel Data Analysis for Case Study

Now let’s see how to apply the Analyze Data tool to perform a data analysis case study. But first, get introduced to our dataset that represents some categories’ yearly sales and profits of a company.

Read More: How to Install Data Analysis in Excel

With Default Analyze Data Option

First, we’ll see the default analyses that Excel makes automatically. Excel shows the most commonly used analyzes by default.

Click any data from the dataset.
Next, click as follows: Home > Analyze Data .

How to Use Excel Data Analysis for Case Study

Soon after, you will get an Analyze Data field on the right side of your Excel window. Where you will see different kinds of cases like- Pivot Tables and Pivot Charts .

Look, there is a sample Pivot Table of Sales and Profit by Category. Click on Insert Pivot Table .

Now see, the Pivot Table is inserted in a new sheet.

Click on Insert Pivot Chart from the Sales by Category section then you will get the Pivot Chart in a new sheet.

Here’s the chart.

Scroll down more and Excel will show you more possible Pivot Tables and Charts .

Feel free to use them if you prefer.

Read More: How to Analyze Data in Excel Using Pivot Tables

Analyze by Inserting Queries

Here, we’ll learn how to analyze data by inserting queries in the ‘ Ask a question about your data ’ box.

When you will click on the question box, it will show some default questions. Click one of them and it will show the answer according to the question. See, I clicked Total ‘Sales’ of ‘Accessories’ over ‘Year’ .

It’s the answer from Excel.

Or you can write your question. I asked- Profit chart according to Year .
After that, hit the ENTER button .

Now you see, it’s showing the chart of profit by year. Click on Insert PivotChart .

Soon after, a new sheet will open up with the PivotChart .

Also, there is a Setting icon in the Discover insights part, click it and a dialog box will open up to select the customized fields of interest.

Mark your desired fields from here. I marked Category and Profit.
Finally, just click Update .

Now it is showing the answers only about Category and Profit.

Things to Remember

The Analyze Data tool is only available in the latest Excel 365. But in the earlier versions, it is named Data Analysis ToolPak and available as Add-ins by default.

Download Practice Workbook

You can download the free Excel workbook from here and practice on your own.

I hope the procedures described above will be good enough to perform a case study using Excel Data Analysis. Feel free to ask any question in the comment section and please give me feedback.

How to Use Data Analysis Toolpak in Excel
How to Enter Data for Analysis in Excel
How to Make Histogram Using Analysis ToolPak
[Fixed!] Data Analysis Not Showing in Excel

<< Go Back to Data Analysis with Excel | Learn Excel

What is ExcelDemy?

Tags: Data Analysis with Excel

Md. Sourov Hossain Mithun, an Excel and VBA Content Developer at Softeko's ExcelDemy project, joined in October 2021. Holding a Naval Architecture & Marine Engineering degree from BUET, Mithun showcases expertise during his two-year tenure. With over 200 published articles on Excel topics, he earned a promotion to Team Leader, excelling in leading diverse teams. Mithun's passion extends to Advanced Excel, Excel VBA, Data Analysis, and Python programming, contributing significantly to the innovative and dynamic environment of ExcelDemy... Read Full Bio

Data Science Interview Case Studies: How to Prepare and Excel

In the realm of Data Science Interviews , case studies play a crucial role in assessing a candidate's problem-solving skills and analytical mindset . To stand out and excel in these scenarios, thorough preparation is key. Here's a comprehensive guide on how to prepare and shine in data science interview case studies.

Understanding the Basics

Before delving into case studies, it's essential to have a solid grasp of fundamental data science concepts. Review key topics such as statistical analysis, machine learning algorithms, data manipulation, and data visualization. This foundational knowledge will form the basis of your approach to solving case study problems.

Deconstructing the Case Study

When presented with a case study during the interview, take a structured approach to deconstructing the problem. Begin by defining the business problem or question at hand. Break down the problem into manageable components and identify the key variables involved. This analytical framework will guide your problem-solving process.

🚀 Read more on: "Ultimate Guide: Crafting an Impressive UI/UX Design Portfolio for Success"

Utilizing Data Science Techniques

Apply your data science skills to analyze the provided data and derive meaningful insights. Utilize statistical methods, predictive modeling, and data visualization techniques to explore patterns and trends within the dataset. Clearly communicate your methodology and reasoning to demonstrate your analytical capabilities.

Problem-Solving Strategy

Develop a systematic problem-solving strategy to tackle case study challenges effectively. Start by outlining your approach and assumptions before proceeding to data analysis and interpretation. Implement a logical and structured process to arrive at well-supported conclusions.

Practice Makes Perfect

Engage in regular practice sessions with mock case studies to hone your problem-solving skills. Participate in data science forums and communities to discuss case studies with peers and gain diverse perspectives. The more you practice, the more confident and proficient you will become in tackling complex data science challenges.

Communicating Your Findings

Effectively communicating your findings and insights is crucial in a data science interview case study. Present your analysis in a clear and concise manner, highlighting key takeaways and recommendations. Demonstrate your storytelling ability by structuring your presentation in a logical and engaging manner.

💡 Are you a job seeker in San Francisco? Check out these fresh jobs in your area!

Exceling in data science interview case studies requires a combination of technical proficiency, analytical thinking, and effective communication . By mastering the art of case study preparation and problem-solving, you can showcase your data science skills and secure coveted job opportunities in the field.

Explore, Engage, Elevate: Discover Unlimited Stories on Rise Blog

Let us know your email to read this article and many more, plus get fresh jobs delivered to your inbox every week 🎉

Featured Jobs ⭐️

Get Featured ⭐️ jobs delivered straight to your inbox 📬

Get Fresh Jobs Delivered Straight to Your Inbox

Join our newsletter for free job alerts every Monday!

Jump to explore jobs

Sign up for our weekly newsletter of fresh jobs

Get fresh jobs delivered to your inbox every week 🎉

35 Case Interviews Examples from MBB / Big Four Firms

Studying case interview examples is one of the first steps in preparing for the management consulting recruitment process. If you don’t want to spend hours searching the web, this article presents a comprehensive and convenient list for you – with 35 example cases, 16 case books, along with a case video accompanied by detailed feedback on tips and techniques.

A clear understanding of “what is a case interview” is essential for effective use of these examples. I suggest reading our Case Interview 101 guide, if you haven’t done so.

McKinsey case interview examples

Mckinsey practice cases.

Diconsa Case
Electro-Light Case
GlobaPharm Case
National Education Case

What should I know about McKinsey Case interviews?

At McKinsey, case interviews often follow the interviewer-led format , where the interviewer asks you multiple questions for you to answer with short pitches.

How do you nail these cases? Since the questions can be grouped into predictable types, an efficient approach is to master each question type. However, do that after you’ve mastered the case interview fundamentals!

For a detailed guide on interviewer-led cases, check out our article on McKinsey Case Interview .

BCG & Bain case interview examples

Bcg practice cases.

BCG – Written Case – Chateau Boomerang

Bain practice cases

Bain – Coffee Shop Co.
Bain – Fashion Co.
Bain – Mock Interview – Associate Consultant
Bain – Mock Interview – Consultant

What should I know about BCG & Bain case interviews?

Unlike McKinsey, BCG and Bain case interviews typically follow the candidate-led format – which is the opposite of interviewer-led, with the candidate driving the case progress by actively breaking down problems in their own way.

The key to acing candidate-led cases is to master the case interview fundamental concepts as well as the frameworks.

Some BCG and Bain offices also utilize written case interviews – you have to go through a pile of data slides, select the most relevant ones to answer a set of interviewer questions, then deliver those answers in a presentation.

For a detailed guide on candidate-led cases, check out our article on BCG & Bain Case Interview .

Deloitte case interview examples

Deloitte practice cases.

Undergrad Cases

Human Capital – Technology Institute
Human Capital – Agency V
Strategy – Federal Benefits Provider
Strategy – Extreme Athletes
Technology – Green Apron
Technology – Big Bucks Bank
Technology – Top Engine
Technology – Finance Agency

Advanced Cases

Human Capital – Civil Cargo Bureau
Human Capital – Capital Airlines
Strategy – Club Co
Strategy – Health Agency
Technology – Waste Management
Technology – Bank of Zurich
Technology – Galaxy Fitness

What should I know about Deloitte case interviews?

Case interviews at Deloitte also lean towards the candidate-led format like BCG and Bain.

The Deloitte consultant recruitment process also features group case interviews , which not only test analytical skills but also place a great deal on interpersonal handling.

Accenture case interview examples

Accenture divides its cases into three types with very cool-sounding names.

Sorted in descending order of popularity, they are:

These are similar to candidate-led cases at Bain and BCG. albeit shorter – the key is to develop a suitable framework and ask the right questions to extract data from the interviewer.

These are similar to the market-sizing and guesstimate questions asked in interviewer-led cases – demonstrate your calculations in structured, clear-cut, logical steps and you’ll nail the case.

These cases have you sort through a deluge of data to draw solutions; however, this type of case is rare.

Capital One case interview examples

Capital One is the odd one on this list – it is a bank-holding company. Nonetheless, this being one of the biggest banks in America, it’s interesting to see how its cases differ from the consulting ones.

Having gone through Capital One’s guide to its cases, I can’t help but notice the less-MECE structure of the sample answers. Additionally, there seems to be a greater focus on the numbers.

Nonetheless, having a solid knowledge of the basics of case interviews will not hurt you – if anything, your presentation will be much more in-depth, comprehensive, and understandable!

See Capital One Business Analyst Case Interview for an example case and answers.

Other firms case interview examples

Besides the leading ones, we have some examples from other major consulting firms as well.

Oliver Wyman – Wumbleworld
Oliver Wyman – Aqualine
LEK – Cinema
LEK – Market Sizing
Kearney – Promotional Planning
OC&C – Imported Spirits
OC&C – Leisure Clubs

Consulting clubs case books

In addition to official cases, here are a few case books you can use as learning materials.

Do keep in mind: don’t base your study on frameworks and individual case types, but master the fundamentals so you can tackle any kind of case.

Wharton Consulting Club Case Book
Tuck Consulting Club Case Book
MIT Sloan Consulting Club Case Book
LBS Consulting Club Case Book
Kellogg Consulting Club Case Book
INSEAD Consulting Club Case Book
Harvard Consulting Club Case Book
ESADE Consulting Club Case Book
Darden Consulting Club Case Book
Berkeley Consulting Club Case Book
Notre-Dame Consulting Club Case Book
Illinois Consulting Club Case Book
Columbia Consulting Club Case Book
Duke Consulting Club Case Book
Ross Consulting Club Case Book
Kearney Case Book

Case interview example – Case video

The limitation of most official case interview examples is that they are either too short and vague, or in text format, or both.

To solve that problem for you, we’ve extracted a 30-minute-long, feedback-rich case sample from our Case Interview End-to-End Secrets Program .

This is a candidate-led, profitability case on an internet music broadcasting company called Pandora.

In 30 minutes, this candidate demonstrates the exact kind of shortcoming that most candidates suffer during real case interviews – they come in with sharp business senses, then hurt their own chances with inadequate techniques.

Here are seven notable areas where the candidate (and you) can improve:

Thanking Throughout the case, as especially in the opening, he should have shown more appreciation for the time the interviewer spent with him.

Structured opening The candidate’s opening of the case feels unstructured. He could have improved it by not mixing the playback and clarification parts. You can learn to nail the case in a 3-minute start through this video on How to Open Any Case Perfectly .

Explicitness A lot of the candidate’s thought process remains in his head; in a case interview, it’s better to be as explicit as possible – draw your issue tree out and point to it as you speak; state your hypothesis when you move into a branch; when you receive data, acknowledge it out loud.

Avoiding silence The silence in his case performance is too long, including his timeout and various gaps in his speech; either ask for timeout (and keep it as short as possible) or think out loud to fill those gaps.

Proactivity The candidate relies too much on the interviewer (e.g: asking for data when it can easily be calculated); you don’t want to appear lazy before your interviewer, so avoid this.

Avoiding repeating mistakes Making one mistake twice is a big no-no in consulting interviews; one key part of the consulting skill set is the ability to learn, and repeating your mistakes (especially if the interviewer has pointed it out) makes you look like someone who doesn’t learn.

Note-taking Given the mistakes this candidate makes, he’s probably not taking his notes well. I can show you how to get it right if you watch this video on Case Interview Note-Taking .

Nonetheless, there are three good points you can learn from the candidate:

The candidate sums up what he’s covered and announces his upcoming approach at the start and at key points in the case – this is a very good habit that gives you a sense of direction and shows that you’re an organized person.

The candidate performs a “reality check” on whether his actions match the issue tree; in a case interview it’s easy to lose track of what you’re doing, so remember to do this every once in a while.

The candidate prompts the interviewer to give out more data than he asked for; if anything, this actually matches a habit of real consultants, and if you’re lucky, your interviewer may actually give out important pieces you haven’t thought of.

These are only part of the “ninja tips” taught In our Case Interview E2E Secrets Program – besides the math and business intuition for long-term development, a key feature is the instant-result tips and techniques for case interviews.

Once you’ve mastered them, you can nail any case they throw at you!

For more “quality” practice, let’s have a mock case interview with former consultants from McKinsey, BCG, Bain, Oliver Wyman, Strategy& and many other consulting firms. They will help you identify your problem areas and give you actionable feedback, making your preparation much easier and faster.

Hi! This is Kim and welcome to another performance in the Tips & Techniques part of our amazing End-to-end program. You are about to hear a really interesting performance.

There is a common Myth that Profitability cases are easier. Well, for beginners, that’s may make sense, but I would argue that Profitability cases can be really tricky and candidates without good foundation will make about the same level of mistakes regardless of type of cases given.

The profitability case we are about to watch will show that. It’s a very unconventional

Profitability. It started out like a typical one but getting more and more tricky toward the end.

The candidate is fairly good in term of business intuition, but the Tips & Techniques aspect needs a lot of fine tune! Now let’s go ahead and get started!

It’s actually a little better to playback the case information and ask clarifications. The candidate does not distinguish between the two and do both at a same time. Also, the candidate was asking these clarifications in an unorganized and unstructured fashion. This is not something terrible, but could have been better, especially when this is the very first part of the case, where the crucial first impression is being formed.

My pitch would sound like this:

“That’s a very interesting problem and I am happy to get the chance to solve it. First of all let me tell you my understanding of the case context and key objectives. Then I would like to ask a few clarifying questions regarding a few terminology and concepts. Both of these are to make sure that I will be solving the right problem.

So here is my understanding of the case: The client is ABC. Here are some DEF facts about the situation we just talked about. And the key case question is XYZ.

Does that correctly and adequately summarize the case?”

Once the interviewer confirms, I would move to the clarification part as follows: “Now I would like to ask a few clarification questions. There are three of them: No 1, … No 2, … and No 3, …”

You may see above pitch as obvious but that’s a perfect example of how you should open any cases. Every details matters. We will point out those details in just a second. But before we do that, it’s actually very helpful if you can go back, listen carefully to the above pitch, and try to point out the great components yourselves. Only after that, go back to this point and learn it all together.

Alright, let’s break down the perfect opening.

First of all, you hear me say: “That’s a very interesting problem and I am happy to get a chance to solve it”. This seems trivial but very beneficial in multiple ways:

1. I bought myself a couple of seconds to calm down and get focused. 2. By nature, we as human unconsciously like those who give us compliments. Nothing better than opening the case with a modest compliment to the interviewer.

And (c) I showed my great attitude towards the case, which the interviewer would assume is the same for real future consulting business problems.

You should do that in your interviews too. Say it and accompany it with the best smile you can give. It shows that you are not afraid of any problems. In fact, you love them and you are always ready for them.

Secondly, I did what I refer to as the “map habit”, which is to always say what you are about to do and then do it. Just like somebody in the car showing the drivers the route before cruising on the road. The driver would love it. This is where I said: “Let me tell you my understanding of the case context and key objectives. Then ABC…”.

Third, right at the beginning of the case, I try to be crystal clear and easy to follow. I don’t let the interviewer confused between playing the case vs. asking clarification questions. I distinguish between the two really carefully. This habit probably doesn’t change the outcome of how the case goes that much, but it certainly significantly changes the impression the interviewer has of me.

Fourth, in playing back the case, each person would have a different way to re-phrase. But there are three buckets to always include:

1. Who is the client 2. The facts regarding the client and the situation and (c) The key question and the objective of the case.

Fifth, after playing the case context and objectives, I pause for a second and ALIGN with the interviewer: “Does it correctly and adequately summarize the case?”. This is a habit that every consulting manager loves for young consultants to do. Nobody wants first-year folks to spend weeks of passion and hard-work building an excel model that the team can’t use. This habit is extensively taught at McKinsey, Bain and BCG, so therefore interviewers would love somebody that exhibits this habit often in case interview.

Lastly, when asking clarification questions, you hear me number them very carefully to create the strong impression that I am very organized and structured. I said I have three clarifying questions. Then I number them as I go through each. No.1, No.2, and No.3.

Sometimes, during interviews it’s hard to know exactly how many items you are going to get. One way is to take timeout often to carefully plan your pitch. If this is not possible in certain situations, you may skip telling how many items you have; but you should definitely still number your question: No.1, No.2; and so on.

Just a moment ago, the candidate actually exhibited a good habit. After going through his clarification questions, the candidate ended by asking the “is there anything else” question. In this case, I actually give out an important piece of data.

Though this is not very common as not every interviewer is that generous in giving out data. But this is a habit management consultants have to have every day when talking to experts, clients, or key stakeholders. The key is to get the most data and insights out of every interview and this is the type of open-ended question every consultant asks several times a day.

To show of this habit in a case interview is very good!

There are three things I would like you to pay attention to:

First, it took the candidate up to 72 seconds to “gather his thoughts”. This is a little too long in a case interview. I intentionally leave the 72 seconds of silence in the recording so you get an idea of how long that is in real situations. But it’s worth-noting here is not only that. While in some very complicated and weird cases, it’s ok to take that long to really think and gather ideas. In this case, the approach as proposed by the candidate is very simple. For this very approach, I think no more than 15 to 20 seconds should be used.

No.2, with that said, I have told I really like the fact that this candidate exhibits the “map” habit. Before going straight to the approach he draws the overall approach first.

No.3. You also see here that the candidate tried to align the approach with me by asking my thoughts on it. As I just said on the previous comment, this is a great habit to have. Not only does it help reduce chance of going into the wrong direction in case interviews, but it also creates a good impression. Consulting interviewers love people doing it often!

Here we see a not-really-bad response that for sure could be much better. The candidate was going into the first branch of the analysis which is Revenue. I would fix this in 3 aspects:

First, even though we just talked about the overall approach, it’s still better to briefly set up the issue tree first then clearly note that you are going into one branch.

Second, this is not a must, but I always try to make my hypothesis as explicitly clear as possible. Here the candidate just implicitly made a hypothesis that the problem is on the revenue side. The best way to show our hypothesis-driven mindset is to explicitly say it.

Third, you hear this a ton of times in our End-to-End program but I am going to repeat it again and again. It is better to show the habit of aligning here too. Don’t just go into revenue, before doing that, give the interviewer a chance to agree or to actually guide you to Cost.

So, summarizing the above insights, my pitch would sound something like this:

“So as we just discussed, a profit problem is either caused by revenue or by cost. Unless you would like to go into cost first, let’s hypothesize that the problem is on revenue side. I would like to look deeper into Revenue. Do we have any data on the revenue?”

And while saying this, you should literally draw an issue tree and point to each as you speak.

There is an interesting case interview tip I want to point out here. Notice how the candidate responds after receiving two data points from me. He went straight into the next question without at least acknowledging the data received and also without briefly analyzing it.

I am glad that the candidate makes this mistakes… well, not glad for him but for the greater audience of this program. I would like to introduce to you the perfect habit of what you should react and do every time you have any piece of data during case interviews. So three things you need to do:

Step 1: Say … that’s an interesting piece of data. This helps the interviewer acknowledge that you have received and understand the data. This also buys you a little time. And furthermore, it’s always a good thing to give out modest compliments to the interviewer.

Step 2: Describe the data, how it looks, is there any special noteworthy trend? In this case, we should point out that revenue actually grew by more than 50%.

Also notice here that I immediately quantified the difference in specific quantitative measurement (in this case, percentage). Saying revenue went up is good, but it’s great to be able to say revenue went up by more than 50%.

Step 3: Link the trend identified back to the original case question and the hypothesis you have. Does it prove, disprove, or open up new investigation to really test the hypothesis? In this case, this data piece actually opened up new investigating areas to test the hypothesis that the bottleneck is within revenue.

My sample pitch for this step 3 would sound like this: “It’s interesting that revenue went up quite a bit. However, to be able to fully reject our hypothesis on the revenue, I would like to compare our revenue to that of the competitors as well.”

Then only at this point, after going through 3 steps above, I ask for the competitors’ revenue like the candidate did.

Notice here that I ended up asking the same question the candidate did. This shows that the candidate does have a good intuition and thought process. It’s just that he did all of these implicitly on his head.

In consulting case interview, it’s always good to do everything as explicitly as possible. Not only is it easier to follow but it helps show your great thought process.

… the rest of the transcript is available in our End To End Case Interview

Learn the Secrets to Case Interview!

Join countless other successful candidates around the world with our Case Interview End-to-End Secrets Program ! 10 example cases with 100+ real-time feedbacks on tips and techniques, 50+ exercises on business intuition and 1300+ questions for math practice!

Scoring in the McKinsey PSG/Digital Assessment

The scoring mechanism in the McKinsey Digital Assessment

Case Interview End-to-End Secrets Program

Elevate your case interview skills with a well-rounded preparation package

Preparing for case interviews is a hard task when you only have 1 week, so the first part you need to learn during this time is fundamentals of case interview

Case interview in consulting is difficult with the passing rate is around 10%. This is because big consulting firms keep an extremely high recruitment standard

A case interview is where candidates is asked to solve a business problem. They are used by consulting firms to evaluate problem-solving skill & soft skills

Hacking the Case Interview

Consulting group case interviews are given to candidates to assess teamwork in addition to communication skills, quantitative skills, and business acumen. They are used by consulting firms such as Bain, Deloitte, PwC , and EY-Parthenon .

Have an upcoming consulting group case interview? We have you covered. In this article, we'll go through in detail:

What is a consulting group case interview?
Different formats of consulting group case interviews
Why are consulting group case interviews used?
What do consulting group case interviews assess?
How to solve consulting group case interviews
How to stand out in consulting group case interviews
Consulting group case interview tips

If you’re looking for a step-by-step shortcut to learn case interviews quickly, enroll in our case interview course . These insider strategies from a former Bain interviewer helped 30,000+ land consulting offers while saving hundreds of hours of prep time.

What is a Consulting Group Case Interview?

Consulting group case interviews are a special variant of the traditional case interview. Before preparing for group case interviews, you should first become familiar with how to solve a traditional case interview .

Like a case interview, you’ll still be placed in a hypothetical business situation and asked to develop a recommendation or answer to a business problem. However, for consulting group case interviews, you’ll be put in a group of 3 to 6 people with other candidates that are also interviewing for the same consulting job.

The group will be given materials which contain the case background, objective, and other information needed to solve the case. You’ll initially have some time to read the information independently, but will spend most of the time discussing the case and working together as a group.

During these discussions, the interviewer will be observing and taking notes on each candidate.

For some group case interviews, you will also create a group presentation. As a group, you’ll present your recommendation to the interviewer who will ask follow-up questions on the work and findings.

Consulting group case interviews are much less commonly used than traditional case interviews, but they are as equally as important. They are typically given in second or final round interviews .

For firms and offices that use group case interviews, you will not receive a consulting job offer unless you can pass them.

Different Formats of Consulting Group Case Interviews

There are two different formats of consulting group case interviews:

Discussion only group case interviews

Presentation group case interviews.

A discussion only group case interview has the following structure:

Consulting Group Case Interview - Discussion Only

This format of group case interview has no presentation component. The group will be given materials with the case background information and objective.

You’ll have some time to read the information independently, but then the interviewer will bring the group together and ask the group to discuss different questions related to solving the case.

The interviewer will be heavily involved in the discussion by asking questions for the group to answer and steering the direction of the discussion.

The discussion only group case interview is focused on assessing the answers that candidates contribute to the group and how well candidates communicate with each other.

A presentation group case interview has the following structure:

Consulting Group Case Interview - Presentation

The group will be given materials that not only contain the case background and objective, but contain other information needed to solve the case. There is typically more material given in this format because you will be given more time to prepare and discuss.

The group will be given about an hour to discuss the case and create a group presentation. During this time, the interviewer will be listening in on the conversations that the group will have, but they will not interfere or answer any questions.

It is up to the group how they want to allocate their time, what topics they want to discuss, and how they want to handle creating and giving the group presentation.

Once time is up, the group will present their work and findings to the interviewer, who will ask follow-up questions.

The presentation group case interview is focused on assessing how well each candidate contributes to the group, how well candidates work with each other, and the quality of the final presentation.

Why are Consulting Group Case Interviews Used?

Consulting group case interviews are used because they are another way for consulting firms to predict which candidates would make the best consultants.

Group case interviews simulate the consulting job by placing you in a hypothetical business situation. You will need to work as a team to analyze and discuss information and then give a presentation on your recommendation. This is what consultants do every day .

These types of case interviews are used in addition to traditional case interviews because they assess a set of skills that traditional case interviews cannot assess.

Group case interviews focus on teamwork and collaboration. By putting candidates into groups, interviewers can assess how candidates work with other people and how open candidates are to other people’s ideas.

They can see how effectively candidates communicate and persuade teammates and how candidates can balance listening and leading.

What do Consulting Group Case Interviews Assess?

There are four major qualities that group case interviews assess.

Logical, structured thinking : Consultants need to be organized and methodical to work efficiently.

Can you structure complex problems in a clear, simple way?
Can you use logic and reason to make appropriate conclusions?

Interpersonal skills : Relationships are important in consulting. You’ll be working with teammates and clients every day, so fostering strong relationships is imperative.

Are you easy to work with?
Can you handle conflict or disagreement with teammates?

Teamwork skills : Consultants work closely in small teams. To be successful, consultants need to know how to work effectively in groups.

Can you make meaningful contributions while working in a group?
Do you bring out the best ideas and qualities in other people?

Presentation skills : Consultants need strong communication skills to present their work in a clear, concise, and persuasive way.

Can you communicate in a clear and concise way?
Are you articulate and persuasive in what you are saying?

How to Solve Consulting Group Case Interviews

Solving consulting group case interviews follows the same steps as solving traditional case interviews. There are four main steps:

Understand the problem
Create a framework
Answer quantitative and qualitative questions
Develop a recommendation

1. Understand the problem

The first step to solving a consulting group case interview is to fully understand the problem or objective. What is the overall business question that the group is trying to answer?

Answering or solving the wrong business problem is the quickest way to fail a group case interview.

2. Create a framework

Next, as a group, you’ll want to create some kind of framework to help you solve the case. A framework is a tool that helps you structure and break down complex problems into simpler, smaller components.

For group case interviews, your framework will help guide the group discussion. The framework collects and organizes all of the topics that the group needs to discuss and all of the questions the group needs to answer.

3. Discuss and answer quantitative and qualitative questions

Once your group has aligned on a framework to use, you can move onto the discussion. During the discussion, you will answer many of the questions that were raised in the framework that was created.

Some of these questions will be qualitative, requiring only business knowledge and judgment to answer. Other questions may be more quantitative, requiring some calculations or estimations from the case information provided.

It is up to the group what order they want to answer and discuss the questions. It is also up to the group whether they want to tackle these questions as an entire group or if they want to split up into smaller groups.

Discussion will continue until the group has reached an answer or conclusion that is accepted by everyone.

4. Develop a recommendation

Once you have finished discussing and answering all of the important questions, you will need to align on an overall recommendation.

To do this, review all of the answers and conclusions that the group has drawn. Identify which recommendation they collectively support.

If the group case interview has a presentation component, you will also need to decide how to split up the presentation across the different members of the group.

How to Stand Out in Consulting Group Case Interviews

The best way to stand out and distinguish yourself in a group case interview is to focus on adding as much value as you can to the group.

There are six different ways you can add value to the group.

Lead or facilitate the discussion

If the interviewer is not leading the discussion and just observing the group, one way to add value is to lead or facilitate the discussion.

You can propose what topics to discuss, the order they should be discussed in, and how much time should be allocated to each topic. When the group gets off track or goes on a tangent, you can bring the group’s focus back together.

Leading or facilitating the discussion establishes you as a group leader, which will leave a positive impression on the interviewer. However, because this role has so much responsibility and visibility, many people will try to take on this role.

Therefore, a group may have multiple leaders or facilitators. When trying to lead the group, make sure you remain respectful and do not interrupt other people when they are speaking.

Expand upon other people’s ideas

Another way to add value is to expand upon other people’s ideas. If a group member suggests a great idea or raises a good point, you can build upon it.

Wait until the group member has finished speaking and then jump in and compliment that person’s idea. Add more details or give more examples to make the idea more concrete.

Synthesize information

Another easy way to add value to the group is to synthesize information that other people have said. A synthesis is simply a reconciliation of different viewpoints and ideas together. This requires minimal effort, but adds tremendous value to the group.

What is the best way to synthesize information?

First, concisely summarize the major ideas that group members have made. Then, state what you like about each idea. Finally, propose an idea that consolidates the best points of each idea.

Synthesizing information does not require much thinking because you are simply repurposing the ideas of other people. This makes it an easy way to contribute to the group.

Keep track of time

Time goes by very quickly in a consulting group case interview. Therefore, a simple way to add value is to be a time keeper and make sure that the team is on track.

In the beginning of the discussion, you can propose a schedule or plan to make the most of the limited time that the group has. You can then volunteer to keep track of the time so that the group can finish discussing and deciding on everything that it needs to.

Play devil’s advocate

Another way to add value to the group is by playing devil’s advocate. You can help the team develop strong points and ideas by testing the team’s thinking and considering potential risks or downsides.

When the team has decided on an idea, bring up potential risks or downsides that the team should consider. This helps the team develop a more fully thought out answer or recommendation.

Be careful when playing devil’s advocate. You do not want to be attacking ideas or bringing them down. Instead, you want to be offering constructive feedback to test the idea and make it stronger.

The final way to add value to the group is to take notes for the team. By taking notes and keeping track of what other people are saying, you’ll be able to recall what has been discussed if any group members have questions.

This way of adding value to the group is not as recommended as the other strategies to add value.

Taking notes deprives you of opportunities to speak. Therefore, it is better to focus on understanding what other people are saying to identify opportunities to speak up rather than to focus on taking the best notes.

Consulting Group Case Interview Tips

Below are the seven biggest group case interview tips. Follow these tips to give yourself an edge over other candidates.

1. Treat your group members as teammates, not competition

While you may feel like you are competing against members of your group for a job offer, this is not the case. Multiple people or even all people in your group can receive job offers.

Rather than treating your group members like competition and trying to make yourself look better than them, treat your group members as teammates. You should think about the group case interview as your team versus the case, not you versus your teammates.

If you work well as a group and deliver an outstanding discussion or presentation, that increases the likelihood that members of the group will receive offers. If the group spends all of their time attacking each other’s comments and fighting for speaking time, the group will likely deliver a poor discussion or presentation, which makes everyone in the group look bad.

The key is to focus on delivering an outstanding result and not to focus on competing with other teammates.

2. Don’t speak too much and don’t speak too little

How much should you speak in a group case interview?

The problem with speaking too little during a group case interview is that you won’t have many opportunities to demonstrate your interpersonal, teamwork, and presentation skills. Interviewers may also think that you are shy and afraid of speaking in a group, qualities that are not ideal for a consultant.

The problem with speaking too much during a group case interview is that you may be seen as too aggressive and controlling. Speaking too much reflects poorly on you because you are taking away opportunities from other teammates to speak and contribute. You may come off as rude and disruptive if you interrupt people and talk over them.

If you were to rank order all of the members in your group by how much each person spoke, you would want to fall right in the middle. That is the perfect balance of speaking and listening.

3. Speak only if you are adding value to the group

Just because you speak a lot during a group case interview does not mean that you are doing well. The quality of what you are saying is much more important than the quantity.

If you are speaking a lot, but not adding that much value to the group, you will be seen as a poor teammate. A great teammate knows when to speak and when to listen.

Therefore, you should only speak if you are adding value to the group. Do not speak just to reach your participation quota.

4. Don’t interrupt or talk over people

The most common way to fail a group case interview is to come off as a jerk. Consultants work closely in small teams and no one wants to work with someone that is a jerk.

How do you avoid this?

First, don’t interrupt or talk over people. If someone is speaking, allow them to finish what they are saying before jumping in with your own thoughts. Second, don’t attack other people’s ideas. You may bring up your concerns and disagreements, but you should never blatantly tell someone that their idea is bad.

As long as you are a nice and respectful teammate, you will be miles ahead of anyone that is overly aggressive, pushy, or rude.

5. Involve other people

An easy way to demonstrate that you are a great teammate is to involve other people.

If you notice that someone has not spoken in a long time, ask them what their thoughts are on the discussion. If you notice that someone was cut off when speaking, ask them to finish their thoughts after the person interrupting them finishes what they are saying.

All of these actions require minimal effort, but add tremendous value to the group while making you look like a great teammate.

6. Don’t spend too much time reading independently

In the beginning of the group case interview, your group will be given materials on the case background, objective, and other information needed to solve the case. Your group members will likely spend the beginning of the group case interview reading the materials by themselves.

Do not spend too much time reading the material independently.

The purpose of the group case interview is to have discussions and work together as a group. The more time your group spends reading the material independently, the less time the group has to demonstrate interpersonal and teamwork skills.

7. You don’t need to have your idea or recommendation chosen

Remember that multiple or even all people in your group can receive job offers. Therefore, you do not need to have your own ideas or recommendations chosen in order to receive an offer.

Fighting or pushing too hard for your own ideas and recommendations may actually harm you. It may suggest that you are not open to other people’s ideas and not willing to support your teammates.

Learn Case Interviews 10x Faster

Here are the resources we recommend to learn the most robust, effective case interview strategies in the least time-consuming way:

Comprehensive Case Interview Course (our #1 recommendation): The only resource you need. Whether you have no business background, rusty math skills, or are short on time, this step-by-step course will transform you into a top 1% caser that lands multiple consulting offers.
Hacking the Case Interview Book (available on Amazon): Perfect for beginners that are short on time. Transform yourself from a stressed-out case interview newbie to a confident intermediate in under a week. Some readers finish this book in a day and can already tackle tough cases.
The Ultimate Case Interview Workbook (available on Amazon): Perfect for intermediates struggling with frameworks, case math, or generating business insights. No need to find a case partner – these drills, practice problems, and full-length cases can all be done by yourself.
Case Interview Coaching : Personalized, one-on-one coaching with former consulting interviewers
Behavioral & Fit Interview Course : Be prepared for 98% of behavioral and fit questions in just a few hours. We'll teach you exactly how to draft answers that will impress your interviewer
Resume Review & Editing : Transform your resume into one that will get you multiple interviews

Land Multiple Consulting Offers

Complete, step-by-step case interview course. 30,000+ happy customers.

47 case interview examples (from McKinsey, BCG, Bain, etc.)

Case interview examples - McKinsey, BCG, Bain, etc.

One of the best ways to prepare for case interviews at firms like McKinsey, BCG, or Bain, is by studying case interview examples.

There are a lot of free sample cases out there, but it's really hard to know where to start. So in this article, we have listed all the best free case examples available, in one place.

The below list of resources includes interactive case interview samples provided by consulting firms, video case interview demonstrations, case books, and materials developed by the team here at IGotAnOffer. Let's continue to the list.

McKinsey examples
BCG examples
Bain examples
Deloitte examples
Other firms' examples
Case books from consulting clubs
Case interview preparation

Click here to practise 1-on-1 with MBB ex-interviewers

1. mckinsey case interview examples.

Beautify case interview (McKinsey website)
Diconsa case interview (McKinsey website)
Electro-light case interview (McKinsey website)
GlobaPharm case interview (McKinsey website)
National Education case interview (McKinsey website)
Talbot Trucks case interview (McKinsey website)
Shops Corporation case interview (McKinsey website)
Conservation Forever case interview (McKinsey website)
McKinsey case interview guide (by IGotAnOffer)
McKinsey live case interview extract (by IGotAnOffer) - See below

2. BCG case interview examples

Foods Inc and GenCo case samples (BCG website)
Chateau Boomerang written case interview (BCG website)
BCG case interview guide (by IGotAnOffer)
Written cases guide (by IGotAnOffer)
BCG live case interview with notes (by IGotAnOffer)
BCG mock case interview with ex-BCG associate director - Public sector case (by IGotAnOffer)
BCG mock case interview: Revenue problem case (by IGotAnOffer) - See below

3. Bain case interview examples

CoffeeCo practice case (Bain website)
FashionCo practice case (Bain website)
Associate Consultant mock interview video (Bain website)
Consultant mock interview video (Bain website)
Written case interview tips (Bain website)
Bain case interview guide (by IGotAnOffer)
Bain case mock interview with ex-Bain manager (below)

4. Deloitte case interview examples

Engagement Strategy practice case (Deloitte website)
Recreation Unlimited practice case (Deloitte website)
Strategic Vision practice case (Deloitte website)
Retail Strategy practice case (Deloitte website)
Finance Strategy practice case (Deloitte website)
Talent Management practice case (Deloitte website)
Enterprise Resource Management practice case (Deloitte website)
Footloose written case (by Deloitte)
Deloitte case interview guide (by IGotAnOffer)

5. Accenture case interview examples

Case interview workbook (by Accenture)
Accenture case interview guide (by IGotAnOffer)

6. OC&C case interview examples

Leisure Club case example (by OC&C)
Imported Spirits case example (by OC&C)

7. Oliver Wyman case interview examples

Wumbleworld case sample (Oliver Wyman website)
Aqualine case sample (Oliver Wyman website)
Oliver Wyman case interview guide (by IGotAnOffer)

8. A.T. Kearney case interview examples

Promotion planning case question (A.T. Kearney website)
Consulting case book and examples (by A.T. Kearney)
AT Kearney case interview guide (by IGotAnOffer)

9. Strategy& / PWC case interview examples

Presentation overview with sample questions (by Strategy& / PWC)
Strategy& / PWC case interview guide (by IGotAnOffer)

10. L.E.K. Consulting case interview examples

Case interview example video walkthrough (L.E.K. website)
Market sizing case example video walkthrough (L.E.K. website)

11. Roland Berger case interview examples

Transit oriented development case webinar part 1 (Roland Berger website)
Transit oriented development case webinar part 2 (Roland Berger website)
3D printed hip implants case webinar part 1 (Roland Berger website)
3D printed hip implants case webinar part 2 (Roland Berger website)
Roland Berger case interview guide (by IGotAnOffer)

12. Capital One case interview examples

Case interview example video walkthrough (Capital One website)
Capital One case interview guide (by IGotAnOffer)

13. Consulting clubs case interview examples

Berkeley case book (2006)
Columbia case book (2006)
Darden case book (2012)
Darden case book (2018)
Duke case book (2010)
Duke case book (2014)
ESADE case book (2011)
Goizueta case book (2006)
Illinois case book (2015)
LBS case book (2006)
MIT case book (2001)
Notre Dame case book (2017)
Ross case book (2010)
Wharton case book (2010)

Practice with experts

Using case interview examples is a key part of your interview preparation, but it isn’t enough.

At some point you’ll want to practise with friends or family who can give some useful feedback. However, if you really want the best possible preparation for your case interview, you'll also want to work with ex-consultants who have experience running interviews at McKinsey, Bain, BCG, etc.

If you know anyone who fits that description, fantastic! But for most of us, it's tough to find the right connections to make this happen. And it might also be difficult to practice multiple hours with that person unless you know them really well.

Here's the good news. We've already made the connections for you. We’ve created a coaching service where you can do mock case interviews 1-on-1 with ex-interviewers from MBB firms . Start scheduling sessions today!

The IGotAnOffer team

Interview coach and candidate conduct a video call

11 Feb 2022

07 Feb 2022

Resolved: Practical case study for excel interview

Instructions: 1. Use the data on the GFD and CHARITY tabs to provide the details on the SUMMARY. Please note that the format on the SUMMARY tab is only meant as a guide to the desired output, You may present the requested data in the format you think best displays the information and showcases your capabilities

08 Feb 2022

Hey Temitope, You need to use SUMIFS, COUNTIFS, and AVERAGEIFS. To learn how to use these functions you can see the respective lectures in the Intro to Excel course. Once you have done that, I'll be happy to help with specific questions. Best, Ned

Hi Ned, I have gone through the lectures and understand how to use the functions. below is the instruction i was given for the case study practice.

Kind Regards. Temitope.

09 Feb 2022

Hello, Still waiting for a response.

Hey Temitope, I would be ok to help with some parts of the question if you ask me specific questions. But I can't solve the entire task. I don't think that's fair. Best, Ned

Submit an answer

World-Class

Data Science

Learn with instructors from:

20 Most-Asked Excel Job Interview Questions for Business Analyst

Updated on October 17, 2023

It can be difficult sometimes to pinpoint the exact tasks of a business analyst . That is because every business analyst has multiple tasks that they need to accomplish at the same time. Therefore, even the title of ‘business analyst’ can be considered a very broad term which can include titles such as data, process, project analyst and manager. This article will explore Excel for business analysts .

What are the different parts of Business Plan Template?

The key responsibility of a business analyst can consist of establishing plans and models for the finance departments of companies. It is not only an important task for the department but also this position decides on crucial financial decisions for the company itself. That is why a successful business analyst should focus on learning and improving their financial reporting, forecasting and strategizing.

Some of the duties of business analysts are analyzing the financial opportunities and threats of the company; and giving and sharing business information with and from the shareholders of the company. Establishing comprehensive analyses, identifying and solving financial problems or challenges, and budgeting the internal and external business also comes with the job position of business analyst.

One of the essential skills for a business analyst is the ability to be technically literate. That means that a business analyst should be aware of the various functions of various applications and useful software. One of these programs (and perhaps the most useful and popular of them all) is Microsoft Excel.

Below in the later chapters of this blog post, you can find 20 job interview questions related to Excel for business analysts.

Question 1: What are the common data formats in Microsoft Excel?

If you are applying for a business analyst job position, you are expected to know certain details about Microsoft Excel. The data formats which Excel allows to run in are one of these details. Due to the fact that Microsoft Excel is a business analyst’s one of the most essential tools at the workplace, knowledge about the common data formats would be crucial. This knowledge is not only required at the work but also is needed in your job interview.

A sample answer for this question can be: “The most common data formats used in Microsoft Excel are numbers, percentages, dates and sometimes texts (as in words and strings of texts).”

Question 2: How are these data formats used in Microsoft Excel?

Similar to every job position and every job interview, only knowing the information is just the half of the work. You need to justify your knowledge with your applications, actions and also, practical knowledge. Therefore, only memorizing the data formats would not be helpful, if you have not used them yourself. You need to know what they are and on top of that, you need to know how they are used in the job.

A sample answer for the uses of data formats in Excel can be: “Numbers can be formatted in data cells as decimals or round values. Percentages show a part of a whole and the whole being 100%. The dates can automatically change depending on the region and location Microsoft Excel is connected from. And the text format is used when analyses, reports or other documents are entered into the Excel spreadsheet as data.”

Question 3: What are the cell references?

Cell references (or in fact, references are general) should be one of the most useful tools an analyst can utilize. The different cell references and their uses can sometimes be seen as trivial details; however, they are absolutely not. They are actually incredible time savers, especially for an always busy business analyst.

A sample answer on the definition of cell references: “Cell references are used to refer to data located in the same Excel spreadsheet but to data in a different cell. There are three different cell reference types: Absolute, relative and mixed cell references.”

Question 4: What are the functions of different cell references?

A business analyst should be able to know specifically the difference between the various cell references. This knowledge will not only come in handy at your job interview but also in communicating and collaborating with your coworkers and employees.

A sample answer can be: “The absolute cell reference forces the data to stay in the cell which it was put in. No matter how many formulas are used on the data itself, an absolute cell reference stays with the data. The relative cell reference moves with the cell when the formula on the cell is moved to another one. And the mixed cell reference indicates that the row or the column related to the data cell is changed or moved.”

Question 5: Which key or combination of keys allow you to toggle between the absolute, relative and mixed cell references?

Supervisors, bosses, company owners, employees, your coworkers and even you have something in common: Everybody wants to save time. No one wants to spend unnecessary time on something they can otherwise do it in a much lesser time. Therefore, everyone loves shortcuts. In addition to that if you are applying for a business analyst position, they are going to expect that you know certain Microsoft Excel shortcuts.

A sample answer on the key to press to shift between the cell references can be: “In Windows devices the F4 key lets you to change the cell references. In Mac devices the combination of keys Command + T will allow you this shift.”

It would be useful to note here that if you are an expert on using Microsoft Excel on only one of the devices, do not worry. You do not need to know every shortcut in each of the operating systems. If you efficiently can use one and show that to the employers, they would be satisfied.

Question 6: What is the function of the dollar sign ($) in Microsoft Excel?

In fact, the dollar sign ($) serves many purposes in Excel and none of them is related to the dollar currency at all. The dollar sign has multiple functions including some of the formulas you can type in. It also can denote any of the currencies written in a spreadsheet. However, in terms of cell references the dollar sign has only one purpose.

A sample answer can be: “The dollar sign when written tells Excel whether to change the location of the reference or not, if the formula for it is copied to other cells.”

Question 7: What is the LOOKUP function in Microsoft Excel?

As you are going to see in the later chapters of this blog post, the LOOKUP function is one of the most popular tools in Excel. If you are applying for a business analyst job, it is also one of the functions that you must be familiar with.

A sample answer on the LOOKUP function can be: “The LOOKUP function allows the user to find exact or partial matches in the spreadsheet. The VLOOKUP option lets the user search for data located in the vertical position. The HLOOKUP option functions the same way but in the horizontal plane.”

Question 8: What is the disadvantage of using the VLOOKUP function?

These kinds of questions test you in a way that you are familiar with the advantages and the good functions of Excel as well as the disadvantages. It also offers you a chance to exercise your critical thinking muscle and combine it with your analytical knowledge.

A sample answer can be: “The major disadvantage of the VLOOKUP function is that it can become ineffective very easily. If you shift data from a column to another, it will also change the column numbers that data was located. This forces you to manually enter the same formulas into (now) different data cells.”

Question 9: How do you insert a comment into an Excel spreadsheet?

A sample answer about the way you can insert comments can be: “You can insert comments into your spreadsheet simply by selecting the cell, right clicking and choosing the ‘Insert Comment’ option.”

Question 10: What is the difference between a comment and a note?

A sample answer on the difference between the two terms can be: “While replying to comments is available; replying to notes attached to cells is not. The notes can be looked at as single annotations.”

Question 11: How important is VBA for a business analyst?

It can be important to actually sit down, do some research on the areas that you think you are lacking and practice your knowledge of Visual Basic for Applications (VBA). These actions should be done before the job interview. Otherwise, a topic such as VBA which every business analyst should be familiar with can be your weakness. And it also can become the reason that you are rejected for the job position that you have applied for.

A sample answer can be: “If a business analyst wants to be successful and work in respected companies, she or he needs to learn and get familiar with the required tools. They should always follow the trends and practice with the most modern devices and tools. VBA is perhaps the most important function of Microsoft Excel and it is crucial for a business analyst to easily use this tool.”

Question 12: What is conditional formatting?

No matter which job position you hold at the moment or which position you are looking to apply for, conditional formatting is an essential function of Excel. It is so simple and so useful at the same time that you might have been using even without knowing what it is called!

A sample answer can be: “Conditional formatting allows you to change the visual aspect of cells. For example, you want all the cells which include a value of 3 to be highlighted with a yellow highlighter and made italic. Conditional formatting lets you achieve this action in only seconds.”

Question 13: What are the most important functions of Excel to you as a business analyst?

The functions you will list as an answer to this question will show the interviewer what you do in Microsoft Excel. You might me more ready for the interview, if you have at least 5 functions ready for this question. You do not have to memorize every formula and list the most complicated ones. Ask yourself this question about the function you want to list: What are my most used functions?

A sample answer for the functions that a business analyst most use can be: “I most often use the LOOKUP function; followed by COUNT and COUNTA functions. The IF and MAX and MIN functions are also one of the ones I usually use.”

Recommended Reading: Most Used Excel Functions

Question 14: What does the COUNTA function execute in an Excel spreadsheet?

Now, you have listed your favorite and most used functions. Regardless of the functions you list, the interviewer can ask any function’s purpose or use. That is why it is important for you to generally know the most important functions. You can find the functions and formulas every business analyst needs to know later in the chapters below in this blog post.

A sample answer on the COUNTA function can be: “The COUNTA can scan all the rows and columns that contain data, identify them and ignore the empty cells.”

Question 15: What is the difference between the functions of COUNT and COUNTA?

Once again, if the interviewer is certain that using Microsoft Excel is one of the essential skills you need to have in order to be accepted, you will be asked a lot of ‘function questions.’

A sample answer on the difference can be: “While COUNT function counts the cells that contain numbers as their data source; the COUNTA function returns the number of cells that contain any kind of data in it. These can include numbers, texts, letters, dates, etc.”

Question 16: Can you import data from other software into an Excel spreadsheet?

You, as a business analyst, might be using other programs and software to enter your data. However, if the company wants you to fully transfer into Microsoft Excel, you should be able to do that without any worry and more importantly, without any delay.

A sample answer on data can be: “Importing data from various external data sources into an Excel spreadsheet is available. Just go into the ‘Data tab above in the toolbar. And by clicking the ‘Get External Data’ button, you will be able to import data from other software into Excel.”

Recommended Reading: Google Sheets vs. Microsoft Excel: Which is better?

Question 17: Why do you think the knowledge of Microsoft Excel is important for a business analyst?

A sample answer for the importance of Microsoft Excel for a business analyst can be: “Using Excel and dealing with the company’s data is crucial because it’s the only data the organization has. And it is in the hands of the business analyst to analyze and come up with results and solutions for problems. The business analyst is also the financial consultant as well as an analyst. You can become the person that the CEO listens to in order to ‘make’ or ‘break’ certain deals.”

Question 18: As a business analyst, do you choose to store your sensitive data in a Microsoft Excel spreadsheet?

In order to answer these kinds of direct questions, the only thing you need to do is to be honest. That is it. No interviewer wants to see a ‘yes man’ when conducting a job interview. If there are some things you think that are lacking in Microsoft Excel, you should speak and voice your opinion.

A sample answer can be: “Yes, I do store my client’s data in Microsoft Excel. However, if the data I am dealing with is confidential, then I would not be storing that sensitive data in an Excel file.”

Question 19: As a business analyst, how would you operate with sensitive data in Microsoft Excel?

A sample answer for the security of information in an Excel file can be: “Due to the fact that I would be responsible for the transfer, the possible disappearance or the leak of the data, I would store confidential data in a software other than Microsoft Excel.”

Question 20: How can you protect your data in Microsoft Excel?

A sample answer for the security of an Excel spreadsheet can be: “From the Review tab, you can choose to protect your sheet with a password. That way the spreadsheet will be password protected and cannot be opened or copied without the password.”

What Skills Do You Need to Be A Business Analyst?

The required skills for a business analyst consist of both soft and hard skills. That means only graduating from a business school or with a business degree will not automatically turn you into the ‘ideal candidate’ for the job.

A business analyst’s skill set should be analytical and technical as much as it should be social and communicative. You can find required skills for a business analyst in regards to both hard skills and soft skill below:

Social Skills

A business analyst should be able to present their findings to a group setting. The presentations can demonstrate the social skills a business analyst has. You should be effectively communicating with your coworkers, supervisors and clients in order to discuss certain issues. This applies to presentations with your employees to the meetings with the CEO itself.

Critical Thinking Skills

One of the most significant actions that business analysts are responsible for is evaluation. And evaluation and assessment are actions that require critical thinking. As it was mentioned above in the previous chapter, being a ‘yes man’ is not something that will boost your confidence and allow you to do a better job.

That is why critical thinking will help you focus on what you can ask and question. This skill will not only help you improve your work but also develop new skills and improve other abilities.

Problem Solving Skills

No matter what position you work in, no matter which company you work for, if you are unable to solve the problems you face, you will not be successful. Period, it is that simple. Because every imaginable job itself is some way related to solving problems.

That means you have to be good at identifying the problems themselves. Then you have to consider which ones can be or should be solved. And after that you would be able to create a plan in order to solve the problems the organization develops and the challenges you as a business analyst face.

To improve your Excel or PowerBI skills for more understandable dashboards and reporting, the most important three tips from experts are to start small, to learn how to create visuals and also to learn by doing. It’s very important to practice what you learn.

Data-Analysis-Excel-Templates-Someka-Banner

What Do Business Analysts Use Excel For?

Simple and complicated spreadsheets.

When a business analyst is working for a client and is processing results or when she or he is doing personal side work, they will be using Microsoft Excel. And they are going to create spreadsheets no matter how basic or complicated they are. In order to analyze and report your results, you are going to always need to create spreadsheets and operate in them.

Filtering, Sorting and Processing Large Amounts of Data

Using Microsoft Excel for filtering and sorting data is something every Excel user does. However, not every user might have the amount of data a business analyst handles and deals with. That is why in order to quickly and efficiently sort and filter vast quantities of data business analysts use Microsoft Excel for the job.

Creating Charts and Graphs

Excel’s endlessly customizable charts and graphs can come in handy for a business analyst when she or he is doing a presentation. These visual illustrations of data can make the audience understand and look at the data in a much clearer way.

Which Microsoft Excel Functions and Formulas Do Business Analysts Need to Know?

Basic Math Operations: There are four basic mathematical operations. They include addition, subtraction, multiplication and division.
LOOKUP Functions ( VLOOKUP and HLOOKUP )
SUM Function
COUNT Function
COUNTA Function
AVERAGE Function
MAX and MIN Functions
IF Function

Here, you can find some of the most essential functions a business analyst should be familiar with. However, there are a lot more to this list. If you are feeling like you should practice more on the functions you know and learn different ones, you should try the Someka Excel Formulas Training Kit .

Excel-Formulas-Practice-Someka-Template-Banner

This Excel template provides you various real life Excel problems and teaches you how to solve them with the necessary functions. There are three levels of function complexity: Beginner, Medium and Advanced Level. The Full Package Training Kit has the total 30 functions and 100 real world questions with it. If you are looking to train and practice on your own, this is the only necessary tool for you!

Other Excel Functions for Business Analysts

Pivot tables.

Pivot table is perhaps the tool that will save you the most time in Excel. It is capable of summarizing and analyzing data in a matter of seconds. And regardless of the size of the data itself, it will provide you the summary of it. With these features, it can be one of the best ‘friends’ of a business analyst who is using Microsoft Excel.

Charts are the essential way for you to present your data. Everyone can turn in pages upon pages of numbers. And sometimes that kind of presentations are required as well. However, as detailed and customizable as the Charts section in Excel is going to help you create incredible looking many types of charts:

Column Chart
Pie Chart (2-D and 3-D)
Doughnut Chart
XY (Scatter) Chart
Bubble Chart
Stock Chart
Surface Chart
Radar Chart
Combo Chart

Calculated Items

Calculated items work as custom formulas that use the sum of different items. It calculates the sum of different items and put into a pivot field. It is almost a supportive feature of Pivot Tables. You can use it in calculating delivery and shipment details and also, for the product orders as well.

Conditional Formatting

This feature also goes well when you are presenting your results and the processed data to a group. It helps you differentiate different data cells from each other. You can highlight, emphasize and change the format of the cells to your choosing. As a business analyst, you are going to always deal with numbers. Therefore, presenting them in a much fashionable way will help everyone to easily realize and understand what they are looking at.

Excel Templates for Business Analysts!

Flowcharts can be a handy way to demonstrate your analyses. Someka Automatic Flowchart Maker has incredible customization features. You can change the shapes, colors, categories and decision labels with only the click of a few buttons! You can also use the drag-and-drop tool if you want to stay with the basics.

Automatic-Flowchart-Maker-Excel-Template-Someka-SS2

– This workflow is created by Someka’s Flowchart Maker –

Also, conducting SWOT analysis for the company you are working for can lead to more profit and less problems. A business analyst’s job is to analyze, and so analyzing the company’s strengths, weaknesses, opportunities and the threats is crucial. And you can conduct this analysis with Someka’s free SWOT Analysis Template !

Another important tool is FMEA Excel Template. This tool is for risk analysis to detect possible failure modes and plan preventive actions.

FMEA-Excel-Template-Someka-Excel-Template-SS1

– This Dashboard is from Someka’s FMEA Excel Template –

Someka’s BCG Matrix Template creates a framework in which you can assess the value of your investments. With the four different sections titled Stars, Question Marks, Cash Cow and Poor Dog; you can analyze the market growth rate and relative market share in the Excel template. As a business analyst, this free template will be one of the tools to achieve that goal.

– This is the Dashboard section of Someka’s BCG Matrix Template –

With the Competitive Analysis Template , you can evaluate your company’s competitors. Following that, you can even develop new strategies and financial models and manage the competition in the market. The template provides charts for each of your competitors and visual illustrations of market shares. Download this free and professional template for presentations right now and do not ever lose your place in the market!

FINAL WORDS ON EXCEL FOR BUSINESS ANALYSTS

The technical skill of using Microsoft Excel is not the only factor for becoming a successful business analyst. You need to integrate good social and communicative skills, combine them with analytical and managerial skills as well. It is a job with important and life-changing consequences for the company which you are working for. And perhaps using Microsoft Excel is not the only skill for the job, but it is without a doubt one of the most important ones.

1. The key to landing your consulting job.

Case interviews - where you are asked to solve a business case study under scrutiny - are the core of the selection process right across McKinsey, Bain and BCG (the “MBB” firms). This interview format is also used pretty much universally across other high-end consultancies; including LEK, Kearney, Oliver Wyman and the consulting wings of the “Big Four”.

If you want to land a job at any of these firms, you will have to ace multiple case interviews.

It is increasingly likely that you will also have to solve online cases given by chatbots etc. You might need to pass these before making it to interview or be asked to sit them alongside first round interviews.

Importantly, case studies aren’t something you can just wing . Firms explicitly expect you to have thoroughly prepared and many of your competitors on interview day will have been prepping for months.

Don’t worry though - MCC is here to help!

This article will take you through a full overview of everything you’ll need to know to do well, linking to more detailed articles and resources at each stage to let you really drill down into the details.

As well as traditional case interviews, we’ll also attend to the new formats in which cases are being delivered and otherwise make sure you’re up to speed with recent trends in this overall part of consulting recruitment.

Before we can figure out how to prepare for a case interview, though, we will first have to properly understand in detail what exactly you are up against. What format does a standard consulting case interview take? What is expected of you? How will you be assessed?

Let's dive right in and find out!

Professional help

Before going further, if this sounds like a lot to get your head around on your own, don't worry - help is available!

Our Case Academy course gives you everything you need to know to crack cases like a pro:

Case Academy Course

To put what you learn into practice (and secure some savings in the process) you can add mock interview coaching sessions with expereinced MBB consultants:

Coaching options

And, if you just want an experienced consultant to take charge of the whole selection process for you, you can check out our comprehensive mentoring programmes:

Explore mentoring

Now, back to the article!

2. What is a case interview?

Before we can hope to tackle a case interview, we have to understand what one is.

In short, a case interview simulates real consulting work by having you solve a business case study in conversation with your interviewer.

This case study will be a business problem where you have to advise a client - that is, an imaginary business or similar organisation in need of guidance.

You must help this client solve a problem and/or make a decision. This requires you to analyse the information you are given about that client organisation and figure out a final recommendation for what they should do next.

Business problems in general obviously vary in difficulty. Some are quite straightforward and can be addressed with fairly standard solutions. However, consulting firms exist precisely to solve the tough issues that businesses have failed to deal with internally - and so consultants will typically work on complex, idiosyncratic problems requiring novel solutions.

Some examples of case study questions might be:

How much would you pay for a banking licence in Ghana?
Estimate the potential value of the electric vehicle market in Germany
How much gas storage capacity should a UK domestic energy supplier build?

Consulting firms need the brightest minds they can find to put to work on these important, difficult projects. You can expect the case studies you have to solve in interview, then, to echo the unique, complicated problems consultancies deal with every day. As we’ll explain here, this means that you need to be ready to think outside the box to figure out genuinely novel solutions.

2.1. What skills do case interviews assess?

Reliably impressing your interviewers means knowing what they are looking for. This means understanding the skills you are being assessed against in some detail.

Overall, it’s important always to remember that, with case studies, there are no strict right or wrong answers. What really matters is how you think problems through, how confident you are with your conclusions and how quick you are with the back of the envelope arithmetic.

The objective of this kind of interview isn’t to get to one particular solution, but to assess your skillset. This is even true of modern online cases, where sophisticated AI algorithms score how you work as well as the solutions you generate.

If you visit McKinsey , Bain and BCG web pages on case interviews, you will find that the three firms look for very similar traits, and the same will be true of other top consultancies.

Broadly speaking, your interviewer will be evaluating you across five key areas:

2.1.1.One: Probing mind

Showing intellectual curiosity by asking relevant and insightful questions that demonstrate critical thinking and a proactive nature. For instance, if we are told that revenues for a leading supermarket chain have been declining over the last ten years, a successful candidate would ask:

“ We know revenues have declined. This could be due to price or volume. Do we know how they changed over the same period? ”

This is as opposed to a laundry list of questions like:

Did customers change their preferences?
Which segment has shown the decline in volume?
Is there a price war in the industry?

2.1.2. Two: Structure

Structure in this context means structuring a problem. This, in turn, means creating a framework - that is, a series of clear, sequential steps in order to get to a solution.

As with the case interview in general, the focus with case study structures isn’t on reaching a solution, but on how you get there.

This is the trickiest part of the case interview and the single most common reason candidates fail.

We discuss how to properly structure a case in more detail in section three. In terms of what your interviewer is looking for at high level, though, key pieces of your structure should be:

Proper understanding of the objective of the case - Ask yourself: "What is the single crucial piece of advice that the client absolutely needs?"
Identification of the drivers - Ask yourself: "What are the key forces that play a role in defining the outcome?"

Our Problem Driven Structure method, discussed in section three, bakes this approach in at a fundamental level. This is as opposed to the framework-based approach you will find in older case-solving

Focus on going through memorised sequences of steps too-often means failing to develop a full understanding of the case and the real key drivers.

At this link, we run through a case to illustrate the difference between a standard framework-based approach and our Problem Driven Structure method.

2.1.3. Three: Problem Solving

You’ll be tested on your ability to identify problems and drivers, isolate causes and effects, demonstrate creativity and prioritise issues. In particular, the interviewer will look for the following skills:

Prioritisation - Can you distinguish relevant and irrelevant facts?
Connecting the dots - Can you connect new facts and evidence to the big picture?
Establishing conclusions - Can you establish correct conclusions without rushing to inferences not supported by evidence?

2.1.4. Four: Numerical Agility

In case interviews, you are expected to be quick and confident with both precise and approximated numbers. This translates to:

Performing simple calculations quickly - Essential to solve cases quickly and impress clients with quick estimates and preliminary conclusions.
Analysing data - Extract data from graphs and charts, elaborate and draw insightful conclusions.
Solving business problems - Translate a real world case to a mathematical problem and solve it.

Our article on consulting math is a great resource here, though the extensive math content in our MCC Academy is the best and most comprehensive material available.

2.1.5. Five: Communication

Real consulting work isn’t just about the raw analysis to come up with a recommendation - this then needs to be sold to the client as the right course of action.

Similarly, in a case interview, you must be able to turn your answer into a compelling recommendation. This is just as essential to impressing your interviewer as your structure and analysis.

Consultants already comment on how difficult it is to find candidates with the right communication skills. Add to this the current direction of travel, where AI will be able to automate more and more of the routine analytic side of consulting, and communication becomes a bigger and bigger part of what consultants are being paid for.

So, how do you make sure that your recommendations are relevant, smart, and engaging? The answer is to master what is known as CEO-level communication .

This art of speaking like a CEO can be quite challenging, as it often involves presenting information in effectively the opposite way to how you might normally.

To get it right, there are three key areas to focus on in your communications:

Top down : A CEO wants to hear the key message first. They will only ask for more details if they think that will actually be useful. Always consider what is absolutely critical for the CEO to know, and start with that. You can read more in our article on the Pyramid Principle .
Concise : This is not the time for "boiling the ocean" or listing an endless number possible solutions. CEOs, and thus consultants, want a structured, quick and concise recommendation for their business problem, that they can implement immediately.
Fact-based : Consultants share CEOs' hatred of opinions based on gut feel rather than facts. They want recommendations based on facts to make sure they are actually in control. Always go on to back up your conclusions with the relevant facts.

For more detail on all this, check out our full article on delivering recommendations .

Prep the right way

2.2. where are case interviews in the consulting selection process.

Not everyone who applies to a consulting firm will have a case interview - far from it!

In fact, case interviews are pretty expensive and inconvenient for firms to host, requiring them to take consultants off active projects and even fly them back to the office from location for in-person interviews. Ideally, firms want to cut costs and save time by narrowing down the candidate pool as much as possible before any live interviews.

As such, there are some hoops to jump through before you make it to interview rounds.

Firms will typically eliminate as much as 80% of the applicant pool before interviews start. For most firms, 50%+ of applicants might be cut based on resumes, before a similar cut is made on those remaining based on aptitude tests. McKinsey currently gives their Solve assessment to most applicants, but will use their resulting test scores alongside resumes to cut 70%+ of the candidate pool before interviews.

You'll need to be on top of your game to get as far as an interview with a top firm. Getting through the resume screen and any aptitude tests is an achievement in itself!

For readers not yet embroiled in the selection process themselves, let’s put case interviews in context and take a quick look at each stage in turn. Importantly, note that you might also be asked to solve case studies outside interviews as well…

2.2.1. Application screen

It’s sometimes easy to forget that such a large cut is made at the application stage. At larger firms, this will mean your resume and cover letter is looked at by some combination of AI tools, recruitment staff and junior consulting staff (often someone from your own university).

Only the best applications will be passed to later stages, so make sure to check out our free resume and cover letter guides, and potentially get help with editing , to give yourself the best chance possible.

2.2.2. Aptitude tests and online cases

This part of the selection process has been changing quickly in recent years and is increasingly beginning to blur into the traditionally separate case interview rounds.

In the past, GMAT or PST style tests were the norm. Firms then used increasingly sophisticated and often gamified aptitude tests, like the Pymetrics test currently used by several firms, including BCG and Bain, and the original version of McKinsey’s Solve assessment (then branded as the Problem Solving Game).

Now, though, there is a move towards delivering relatively sophisticated case studies online. For example, McKinsey has replaced half the old Solve assessment with an online case. BCG’s Casey chatbot case now directly replaces a live first round case interview, and in the new era of AI chatbots, we expect these online cases to quickly become more realistic and increasingly start to relieve firms of some of the costs of live interviews.

Our consultants collectively reckon that, over time, 50% of case interviews are likely to be replaced with these kinds of cases. We give some specific advice for online cases in section four. However, the important thing to note is that these are still just simulations of traditional case interviews - you still need to learn how to solve cases in precisely the same way, and your prep will largely remain the same.

2.2.3. Rounds of Interviews

Now, let’s not go overboard with talk of AI. Even in the long term, the client facing nature of consulting means that firms will have live case interviews for as long as they are hiring anyone. And in the immediate term, case interviews are still absolutely the core of consulting selection.

Before landing an offer at McKinsey, Bain, BCG or any similar firm, you won’t just have one case interview, but will have to complete four to six case interviews, usually divided into two rounds, with each interview lasting approximately 50-60 minutes .

Being invited to first round usually means two or three case interviews. As noted above, you might also be asked to complete an online case or similar alongside your first round interviews.

If you ace first round, you will be invited to second round to face the same again, but more gruelling. Only then - after up to six case interviews in total, can you hope to receive an offer.

2.3. Typical case interview format

Before we dive in to the nuts and bolts of case cracking, we should give you a bit more detail on what exactly you’ll be up against on interview day.

Case interviews come in very similar formats across the various consultancies where they are used.

The standard case interview can be thought of as splitting into two standalone sub-interviews. Thus “case interviews” can be divided into the case study itself and a “fit interview” section, where culture fit questions are asked.

This can lead to a bit of confusion, as the actual case interview component might take up as little as half of your scheduled “case interview”. You need to make sure you are ready for both aspects.

To illustrate, here is the typical case interview timeline:

First 15-30 minutes: Fit Interview - with questions assessing your motivation to be a consultant in that specific firm and your traits around leadership and teamwork. Learn more about the fit interview in our in-depth article here .
Next 30-40 minutes: Case Interview - solving a case study
Last 5 minutes: Fit Interview again - this time focussing on your questions for your interviewer.

Both the Case and Fit interviews play crucial roles in the finial hiring decision. There is no “average” taken between case and fit interviews: if your performance is not up to scratch in either of the two, you will not be able to move on to the next interview round or get an offer.

NB: No case without fit

Note that, even if you have only been told you are having a case interview or otherwise are just doing a case study, always be prepared to answer fit questions. At most firms, it is standard practice to include some fit questions in all case interviews, even if there are also separate explicit fit interviews, and interviewers will almost invariably include some of these questions around your case. This is perfectly natural - imagine how odd and artificial it would be to show up to an interview, simply do a case and leave again, without talking about anything else with the interviewer before or after.

2.4. Differences between first and second round interviews

Despite interviews in the first and second round following the same format, second/final round interviews will be significantly more intense. The seniority of the interviewer, time pressure (with up to three interviews back-to-back), and the sheer value of the job at stake will likely make a second round consulting case interview one of the most challenging moments of your professional life.

There are three key differences between the two rounds:

Time Pressure : Final round case interviews test your ability to perform under pressure, with as many as three interviews in a row and often only very small breaks between them.
Focus : Since second round interviewers tend to be more senior (usually partners with 12+ years experience) and will be more interested in your personality and ability to handle challenges independently. Some partners will drill down into your experiences and achievements to the extreme. They want to understand how you react to challenges and your ability to identify and learn from past mistakes.
Psychological Pressure: While case interviews in the first round are usually more focused on you simply cracking the case, second round interviewers often employ a "bad cop" strategy to test the way you react to challenges and uncertainty.

2.5. Differences between firms

For the most part, a case interview is a case interview. However, firms will have some differences in the particular ways they like to do things in terms of both the case study and the fit component.

As we’ll see, these differences aren’t hugely impactful in terms of how you prepare. That said, it's always good to know as much as possible about what you will be going up against.

2.5.1. Candidate led vs interviewer led case formats

Most consulting case interview questions test your ability to crack a broad problem, with a case prompt often going something like:

" How much would you pay to secure the rights to run a restaurant in the British Museum? "

You, as a candidate, are then expected to identify your path to solve the case (that is, provide a structure), leveraging your interviewer to collect the data and test your assumptions.

This is known as a “candidate-led” case interview and is used by Bain, BCG and other firms.

However, a McKinsey case interview - especially in the first round - is slightly different, with the interviewer controlling the pace and direction of the conversation much more than with other case interviews.

At McKinsey, your interviewer will ask you a set of pre-determined questions, regardless of your initial structure. For each question, you will have to understand the problem, come up with a mini structure, ask for additional data (if necessary) and come to the conclusion that answers the question.

McKinsey’s cases are thus referred to as “interviewer-led”. This more structured format of case also shows up in online cases by other firms - notably including BCG’s Casey chatbot (with the amusing result that practising McKinsey-style cases can be a great addition when prepping for BCG).

Essentially, these interviewer-led case studies are large cases made up of lots of mini-cases. You still use basically the same method as you would for standard (or candidate-led) cases - the main difference is simply that, instead of using that method to solve one big case, you are solving several mini-cases sequentially.

2.5.2. The McKinsey PEI

McKinsey brands its fit aspect of interviews as the Personal Experience Interview or PEI. Despite the different name, this is really much the same interview you will be going up against in Bain, BCG and any similar firms.

McKinsey does have a reputation for pushing candidates a little harder with fit or PEI questions, focusing on one story per interview and drilling down further into the specific details each time. We discuss this tendency more in our fit interview article. However, no top end firm is going to go easy on you and you should absolutely be ready for the same level of grilling at Bain, BCG and others. Thus any difference isn’t hugely salient in terms of prep.

2.6. How are things changing in 2023?

For the foreseeable future, you are going to have to go through multiple live case interviews to secure any decent consulting job. These might increasingly happen via Zoom rather than in person, but they should remain largely the same otherwise.

However, things are changing and the rise of AI in recent months seems pretty much guaranteed to accelerate existing trends.

Even before the explosive development of AI chatbots like ChatGPT we have seen in recent months, automation was already starting to change the recruitment process.

As we mentioned, case interviews are expensive and inconvenient for firms to run. Ideally, then, firms will try to reduce the number of interviews required for recruitment as far as possible. For many years, tests of various kinds served to cut down the applicant pool and thus the number of interviews. However, these tests had a limited capacity to assess candidates against the full consulting skillset in the way that case interviews do so well.

More recently, though, the development of online testing has allowed for more and more advanced assessments. Top consulting firms have been leveraging screening tests that better and better capture the same skillset as case interviews. Eventually this is converging on automated case studies. We see this very clearly with the addition of the Redrock case to McKinsey’s Solve assessment.

As these digital cases become closer to the real thing, the line between test and interview blurs. Online cases don’t just reduce the number of candidates to interview, but start directly replacing interviews.

Case in point here is BCG’s Casey chatbot . Previously, BCG had deployed less advanced online cases and similar tests to weed out some candidates before live case interviews began. Now, though, Casey actually replaces one first round case interview.

Casey, at time of writing, is still a relatively “dumb” chatbot, basically running through a pre-set script. The Whatsapp-like interface does a lot of work to make it feel like one is chatting to a “real person” - the chatbot itself, though, cannot provide feedback or nudges to candidates as would a human interviewer.

We fully expect that, as soon as BCG and other firms can train a truer AI, these online cases will become more widespread and start replacing more live interviews.

We discuss the likely impacts of advanced AI on consulting recruitment and the industry more broadly in our blog.

Here, though, the real message is that you should expect to run into digital cases as well as traditional case interviews.

Luckily, despite any changes in specific format, you will still need to master the same fundamental skills and prepare in much the same way.

We’ll cover a few ways to help prepare for chatbot cases in section four. Ultimately, though, firms are looking for the same problem solving ability and mindset as a real interviewer. Especially as chatbots get better at mimicking a real interviewer, candidates who are well prepared for case cracking in general should have no problem with AI administered cases.

2.6.1. Automated fit interviews

Analogous to online cases, in recent years there has been a trend towards automated, “one way” fit interviews, with these typically being administered for consultancies by specialist contractors like HireVue or SparkHire.

These are kind of like Zoom interviews, but if the interviewer didn’t show up. Instead you will be given fit questions to answer and must record your answer in your computer webcam. Your response will then go on to be assessed by an algorithm, scoring both what you say and how you say it.

Again, with advances in AI, it is easy to imagine these automated interviews going from fully scripted interactions, where all candidates are asked the same list of questions, to a more interactive experience. Thus, we might soon arrive at a point where you are being grilled on the details of your stories - McKinsey PEI style - but by a bot rather than a human.

We include some tips on this kind of “one way” fit interview in section six here.

3. What do I need to learn to solve cases?

If you’re new to case cracking. You might feel a bit hopeless when you see a difficult case question, not having any idea where to start.

In fact though, cracking cases is much like playing chess. The rules you need to know to get started are actually pretty simple. What will make you really proficient is time and practice.

In this section, we’ll run through a high level overview of everything you need to know, linking to more detailed resources at every step.

3.1. Business fundamentals

Obviously, you are going to need to be familiar with basic business concepts in order to understand the case studies you are given in the first instance.

If you are coming from a business undergrad, an MBA or are an experienced hire, you might well have this covered already.

However, many consultants will be entering from engineering or similar backgrounds and the major consulting firms are hiring more and more PhDs and non-MBA master's graduates from all subjects. These individuals will need to get up to speed on business fundamentals.

Luckily, you don’t need a degree-level understanding of business to crack interview cases, and a lot of the information you will pick up by osmosis as you read through articles like this and go through cases.

However, some things you will just need to sit down and learn. We cover everything you need to know in some detail in our Case Academy course. However, some examples here of things you need to learn are:

Basic accounting (particularly how to understand all the elements of a balance sheet)
Basic economics
Basic marketing
Basic strategy

Note, though, that learning the very basics of business is the beginning rather than the end of your journey.

Once you are able to “speak business” at a rudimentary level, you should try to “become fluent” and immerse yourself in reading/viewing/listening to as wide a variety of business material as possible, getting a feel for all kinds of companies and industries - and especially the kinds of problems that can come up in each context and how they are solved.

The material put out by the consulting firms themselves is a great place to start, but you should also follow the business news and find out about different companies and sectors as much as possible between now and interviews. Remember, if you’re going to be a consultant, this should be fun rather than a chore!

3.2. How to solve cases like a real consultant

This is the really important bit.

If you look around online for material on how to solve case studies, a lot of what you find will set out framework-based approaches. However, as we have mentioned, these frameworks tend to break down with more complex, unique cases - with these being exactly the kind of tough case studies you can expect to be given in your interviews.

To address this problem, the MyConsultingCoach team has developed a new, proprietary approach to case cracking that replicates how top management consultants approach actual engagements.

MyConsultingCoach’s Problem Driven Structure approach is a universal problem solving method that can be applied to any business problem , irrespective of its nature.

As opposed to just selecting a generic framework for each case, the Problem Driven Structure approach works by generating a bespoke structure for each individual question and is a simplified version of the roadmap McKinsey consultants use when working on engagements.

The canonical seven steps from McKinsey on real projects are simplified to four for case interview questions, as the analysis required for a six-month engagement is somewhat less than that needed for a 45-minute case study. However, the underlying flow is the same.

This video has more information on how frameworks can be unreliable and how we address this problem:

Otherwise, let's zoom in to see how our method actually works in more detail:

3.2.1. Identify the problem

Identifying the problem means properly understanding the prompt/question you are given, so you get to the actual point of the case.

This might sound simple, but cases are often very tricky, and many candidates irretrievably mess things up within the first few minutes of starting. Often, they won’t notice this has happened until they are getting to the end of their analysis. Then, they suddenly realise that they have misunderstood the case prompt - and have effectively been answering the wrong question all along!

With no time to go back and start again, there is nothing to do. Even if there were time, making such a silly mistake early on will make a terrible impression on their interviewer, who might well have written them off already. The interview is scuppered and all the candidate’s preparation has been for nothing.

This error is so galling as it is so readily avoidable.

Our method prevents this problem by placing huge emphasis on a full understanding of the case prompt. This lays the foundations for success as, once we have identified the fundamental, underlying problem our client is facing, we focus our whole analysis around finding solutions to this specific issue.

Now, some case interview prompts are easy to digest. For example, “Our client, a supermarket, has seen a decline in profits. How can we bring them up?”. However, many of the prompts given in interviews for top firms are much more difficult and might refer to unfamiliar business areas or industries. For example, “How much would you pay for a banking license in Ghana?” or “What would be your key areas of concern be when setting up an NGO?”

Don’t worry if you have no idea how you might go about tackling some of these prompts!

In our article on identifying the problem and in our full lesson on the subject in our MCC Academy course, we teach a systematic, four step approach to identifying the problem , as well as running through common errors to ensure you start off on the right foot every time!

This is summarised here:

Following this method lets you excel where your competitors mess up and get off to a great start in impressing your interviewer!

3.2.2. Build your problem driven structure

After you have properly understood the problem, the next step is to successfully crack a case is to draw up a bespoke structure that captures all the unique features of the case.

This is what will guide your analysis through the rest of the case study and is precisely the same method used by real consultants working on real engagements.

Of course, it might be easier here to simply roll out one an old-fashioned framework, and a lot of candidates will do so. This is likely to be faster at this stage and requires a lot less thought than our problem-driven structure approach.

However, whilst our problem driven structure approach requires more work from you, our method has the advantage of actually working in the kind of complex case studies where generic frameworks fail - that is exactly the kind of cases you can expect at an MBB interview .

Since we effectively start from first principles every time, we can tackle any case with the same overarching method. Simple or complex, every case is the same to you and you don’t have to gamble a job on whether a framework will actually work

In practice, structuring a problem with our method means drawing up either an issue tree or an hypothesis tree , depending on how you are trying to address the problem.

These trees break down the overall problem into a set of smaller problems that you can then solve individually. Representing this on a diagram also makes it easy for both you and your interviewer to keep track of your analysis.

To see how this is done, let’s look at the issue tree below breaking down the revenues of an airline:

These revenues can be segmented as the number of customers multiplied by the average ticket price. The number of customers can be further broken down into a number of flights multiplied by the number of seats, times average occupancy rate. The node corresponding to the average ticket price can then be segmented further.

It is worth noting that the same problem can be structured in multiple valid ways by choosing different means to segment the key issues.

That said, not all valid structures are equally useful in solving the underlying problem. A good structure fulfils several requirements - including MECE-ness , level consistency, materiality, simplicity, and actionability. It’s important to put in the time to master segmentation, so you can choose a scheme isn’t only valid, but actually useful in addressing the problem.

After taking the effort to identify the problem properly, an advantage of our method is that it will help ensure you stay focused on that same fundamental problem throughout. This might not sound like much, but many candidates end up getting lost in their own analysis, veering off on huge tangents and returning with an answer to a question they weren’t asked.

Another frequent issue - particularly with certain frameworks - is that candidates finish their analysis and, even if they have successfully stuck to the initial question, they have not actually reached a definite solution. Instead, they might simply have generated a laundry list of pros and cons, with no clear single recommendation for action.

Clients employ consultants for actionable answers, and this is what is expected in the case interview. The problem driven structure excels in ensuring that everything you do is clearly related back to the key question in a way that will generate a definitive answer. Thus, the problem driven structure builds in the hypothesis driven approach so characteristic of real consulting practice.

You can learn how to set out your own problem driven structures in our article here and in our full lesson in the MCC Academy course.

Join thousands of other candidates cracking cases like pros

3.2.3. lead the analysis.

A problem driven structure might ensure we reach a proper solution eventually, but how do we actually get there?

We call this step " leading the analysis ", and it is the process whereby you systematically navigate through your structure, identifying the key factors driving the issue you are addressing.

Generally, this will mean continuing to grow your tree diagram, further segmenting what you identify as the most salient end nodes and thus drilling down into the most crucial factors causing the client’s central problem.

Once you have gotten right down into the detail of what is actually causing the company’s issues, solutions can then be generated quite straightforwardly.

To see this process in action, we can return to our airline revenue example:

Lead the analysis for the Airline Case Study

Let’s say we discover the average ticket price to be a key issue in the airline’s problems. Looking closer at the drivers of average ticket price, we find that the problem lies with economy class ticket prices. We can then further segment that price into the base fare and additional items such as food.

Having broken down the issue to such a fine-grained level, solutions occur quite naturally. In this case, we can suggest incentivising the crew to increase onboard sales, improving assortment in the plane, or offering discounts for online purchases.

Our article on leading the analysis is a great primer on the subject, with our video lesson in the MCC Academy providing the most comprehensive guide available.

3.2.4. Provide recommendations

So you have a solution - but you aren’t finished yet!

Now, you need to deliver your solution as a final recommendation.

This should be done as if you are briefing a busy CEO and thus should be a one minute, top-down, concise, structured, clear, and fact-based account of your findings.

The brevity of the final recommendation belies its importance. In real life consulting, the recommendation is what the client has potentially paid millions for - from their point of view, it is the only thing that matters.

In an interview, your performance in this final summing up of your case is going to significantly colour your interviewer’s parting impression of you - and thus your chances of getting hired!

So, how do we do it right?

Barbara Minto's Pyramid Principle elegantly sums up almost everything required for a perfect recommendation. The answer comes first , as this is what is most important. This is then supported by a few key arguments , which are in turn buttressed by supporting facts .

Across the whole recommendation, the goal isn’t to just summarise what you have done. Instead, you are aiming to synthesize your findings to extract the key "so what?" insight that is useful to the client going forward.

All this might seem like common sense, but it is actually the opposite of how we relay results in academia and other fields. There, we typically move from data, through arguments and eventually to conclusions. As such, making good recommendations is a skill that takes practice to master.

We can see the Pyramid Principle illustrated in the diagram below:

The Pyramid principle often used in consulting

To supplement the basic Pyramid Principle scheme, we suggest candidates add a few brief remarks on potential risks and suggested next steps . This helps demonstrate the ability for critical self-reflection and lets your interviewer see you going the extra mile.

The combination of logical rigour and communication skills that is so definitive of consulting is particularly on display in the final recommendation.

Despite it only lasting 60 seconds, you will need to leverage a full set of key consulting skills to deliver a really excellent recommendation and leave your interviewer with a good final impression of your case solving abilities.

Our specific article on final recommendations and the specific video lesson on the same topic within our MCC Academy are great, comprehensive resources. Beyond those, our lesson on consulting thinking and our articles on MECE and the Pyramid Principle are also very useful.

3.3. Common case types and the building blocks to solve them

You should tackle each new case on its own merits. However, that’s not to say there aren’t recurring themes that come up fairly reliably in cases - there absolutely are. Business is business and case studies will often feature issues like profitability, competition etc.

Old fashioned framework approaches would have you simply select a defined framework for each kind of case and, in effect, just run the algorithm and wait for a solution to fall out.

We’ve already explained how frameworks can let you down. In this context, too many candidates will fall into the trap of selecting a framework for that case type that simply won’t work for their specific case.

The counterpoint in favour of frameworks, though, is that they are at least fast and prevent you having to start from the ground up with a common kind of case.

Ideally, you should have the best of both worlds - and this is why, in our articles on this site and in our MCC Academy course, we have developed a set of “building bocks” for common case themes.

As they name suggests, building blocks give you modular components for different kinds of case to help build out your own custom structures faster. These then allow you to leverage the symmetries between cases without inheriting the inflexibility of frameworks.

Let’s take a look at five different case types and get a brief idea of how our building block approach helps you with each. You can find more detail on each in the full length articles linked, as well as in the full-length video lessons in our MCC Academy course.

3.3.1. Estimation

Consultants need to push forward to provide definitive recommendations to clients in a timely manner despite typically not having access to full information on a problem. Estimation of important quantities is therefore at the heart of real life consulting work.

Estimation is thus just as fundamental to case cracking.

A case interview might centre on an estimation question, and this might be quite common for a first round interview. However, estimation is also very likely to be a crucial part of pretty well any other kind of case question you receive is likely to include estimation as a crucial component of your analysis.

The kinds of estimation you might be asked to make in a case interview can be very daunting:

How many bank branches are there in Italy?
How many cars are sold in Berlin in one year?
How many people will buy the latest high-tech smartphone on the market?

You might have no idea where to begin with these examples. However, tempting as it might be, your answer cannot ever be a simple guess .

A decent estimation does have a guessed element - though this should really be an educated guess based on some pre-existing knowledge. However, this guessed element is always then combined with a rigorous quantitative method to arrive at a reasonable estimation.

In context of a case interview, it’s important to realise that your interviewer doesn’t really care about the right answer (they don’t need to ask you to find out, after all). What’s important is showing the rational process by which you get to your answer.

A guess that was somehow exactly correct is no good compared to a “wrong” answer that was reached by a very sensible, intelligent process of estimation. In cases, this method will often be a matter of segmentation.

So, where would we start in working out how many cars are sold in Berlin, for example?

The key to estimation case questions is the ability to logically break down the problem into more manageable pieces. In consulting case studies, this will generally mean segmenting a wider population to find a particular target group. For example, starting from the total population of Berlin and narrowing down to the cohort of individuals who will buy a car that year.

There are usually many ways to segment the same starting population, and several different segmentation schemes might be equally valid. However, it is crucial to choose the specific method best suited to the goal in answering the question and allowing you to best leverage the data you have available.

Segmentation must be allied with assumptions in order to arrive at an estimation. These assumptions are the “guessed” element of estimations we mentioned above. Assumptions cannot just be plucked from thin air, but must always be reasonable .

The example below showcases both the segmentation and assumptions made in an estimation of the size of the wedding planning market in London:

Our articles on estimation and the MECE concept are great starting points in getting to grips with consulting estimation. However, the best place to learn how to make estimations is with the dedicated building block video lesson in our MCC Academy course.

Those of you from physics or engineering backgrounds will probably see a lot in common with Fermi questions . We have plenty of estimation cases for you to work through in our free case library. However, Fermi questions are a great way of getting a little extra practice and you can find a lifetime’s supply online.

3.3.2. Profitability

The fundamental goal of any normal business is to maximise profits - nobody is getting up and going to work to lose money. Even Silicon Valley tech start-ups are supposed to be profitable some day!

Profitability problems are thus bread and butter issues for management consultants.

Clients often tell consultants broadly the same story. The business was doing in well in recent years, with strong profits. However, some recent turn of events has upset the status quo and led to concerns around profit levels. Consultants are brought in as businesses are often sufficiently complex that it can be difficult to figure out precisely where and why the company is losing money - let alone how to then reverse the situation and restore healthy profits.

Despite steady growth in customer flow, the Walfort supermarket chain has seen falling profits in the past year. What is the reason for this decline?

Understanding profitability ultimately means understanding the various components that determine a company’s profit. You will need to learn to decompose profit first into revenues and costs (profit being the synthesis of these two factors). Crucially, you then need to segment further, distinguishing different specific revenue streams and separating various fixed and variable costs.

To take an example, just examining the revenue side of profit, the incoming revenues for an insurance firm might be broken down as follows:

Improving profitability will inherently mean increasing revenues and/or decreasing costs. To solve profitability problems, we thus have to understand the ways we can minimise different costs, as well as ways to drive sales and/or optimise pricing to increase revenue. Importantly, you must be able to judge which of these options is best suited to address specific scenarios.

The key to tackling the complex kind of profitability questions given by MBB-level consultancies lies in this proper segmentation.

By contrast, old-fashioned case interview frameworks will simply have you look at aggregate cost and revenue data before recommending generic cost-cutting or revenue-driving measures. However, this will often lead to negative outcomes in more involved cases, making matters worse for the client.

For example, it might well be that a company actually makes a loss when it serves a certain cohort of customers. An airline, for instance, might lose money on economy class customers but make a healthy profit on each business class customer. Attempts to boost revenue by increasing sales across the board might actually reduce profit further by increasing the number of economy class customers. What is required is targeted measures to increase focus on business class and/or mitigate economy class losses.

You can start learning to segment these kinds of cases properly in our article on profitability , whilst the best way to really master profitability questions is our full lesson on the subject in the Building Blocks section of our MCC Academy course.

3.3.3. Pricing

For a company to be profitable at all, it is a pre-requisite that it charges the right price for whatever it sells. However, establishing what price to charge for any one product - or indeed a whole suite of related products - can be a highly complex business.

Consultants are often engaged to negotiate the many variables, with all their complex interdependencies, at play in pricing. Correspondingly, then, pricing is a common theme in case interviews.

A company launches a new smartphone with a significantly improved camera. How much should they charge?
A doughnut chain wants to start selling coffee in their shops. How much should they charge per cup?

Clearly, lot of different factors can influence the answers to these questions, and it can be difficult to know where to start. To get a handle on all this complexity, you will need to take a methodical, structured approach.

To really understand pricing, you must begin from fundamentals like the customer’s willingness to pay, the value captured by the company, and the value created for the customer. These basics are shown in the diagram below:

This might seem simple enough, but the exact level at which prices are ultimately set is determined by a whole host of factors, including product availability, market trends, and the need to maintain a competitive position within the market. In particular, if we are changing the price of an existing product, we must consider how the price elasticity of demand might cause sales to fluctuate.

Our four-step method for pricing starts from establishing the customer’s next best alternative, calculating the value added by our own product, and working from there. A summary of this method is given, along with an overview of pricing in general, in our article on the subject . However, the most complete resource is our pricing lesson in the MCC Academy .

3.3.4. Valuation

Valuation is fundamental to any kind of investment. Before allocating capital towards a particular opportunity, an investor must understand precisely what value it holds and how this compares to the other available options.

In short, valuation tells us how much we should be willing to pay to acquire a company or an asset.

There are many ways to value an asset - indeed the finer points are still subject to research in both the academic and private sectors.

Standard ways to assign value include asset-based valuations (notably the Net Asset Value or NAV) and the various multiples so widely used by market traders.

However, in consulting case interviews, you will only usually need to be familiar with Net Present Value (NPV) . This means you need to learn and master the NPV equation:

CF = Cash Flow r = Discount Rate

Whilst this is a pretty simple equation on the face of it, in order to make proper use of it, you will also need to develop a feel for interest/discount rates appropriate to different cases. This will be essential, as you will often have to estimate rational values for these rates for different investments before plugging those values into the NPV equation. Our Case Academy course has more detail here.

Note, though, that NPV is only really half the story.

NPV provides a kind of “absolute” value for an asset. However, the fact is that the worth of any asset will be different for different buyers , depending largely upon what the buyer already owns. In just the same way a spare clutch for a 1975 Ford will be a lot less valuable to a cyclist than to someone restoring the relevant classic car, so a courier business will be more valuable to an online retailer than to an airline.

As such, what we call the Total Enterprise Value (TEV) of an asset is calculated as a function of that asset’s NPV and of the potential cost and revenue synergies resulting from an acquisition. This is shown in the useful structure below:

You can learn more about all aspects of valuation in our article here , as well as in our dedicated video lesson in MCC Academy . These include guides to the kind of interest rates typically required to finance different kinds of investment.

3.3.5. Competitive Interactions

Most of what we’ve discussed so far in terms of case themes and our building block approach to them will all depend upon the prevailing competitive landscape our client exists within. Product prices, profit levels and ultimately valuations can all change over time in response to competition.

What is more, the zero sum dynamics of competitive interactions mean that these things can change quickly .

Companies enjoying near monopolies for years or even decades can quickly see their values go to zero, or near enough, in the face of some innovation by a competitor coming onto the market.

Nokia and Kodak thoroughly dominated the mobile phone and photography markets respectively - until new companies with new products pulled the rug out from under them and led to precipitous collapses.

New market entrants or old competitors with new ideas can throw a company’s whole business model up in the air overnight . Complex decisions about profound changes need to be made yesterday. Firms trying to save themselves will often slash prices in attempts to maintain sales - though this can actually make things worse and result in a corporate death-spiral. Consultants are then frequently called in to help companies survive - with this type of engagement carrying over to inform case interview questions.

You are running an airline and a low-cost competitor, like Ryanair, decides to start operating on your routes. You are rapidly losing customers to their lower fares. How do you respond?

Your eventual solutions to competitive interaction problems will likely need to be novel and unique to the situation. However, the process by which we understand competitive interactions and move towards those solutions is usually very methodical, moving through the limited dimensions in which a company can take action.

The following structure neatly encodes the general options open to responding to new sources of competition:

Of course, we would never suggest that you blanket-apply any strict, inflexible methodology to a whole swathe of case questions – this is precisely the approach that causes so much trouble for candidates using old-fashioned frameworks.

This structure is only a starting point - a shortcut to a bespoke framework specific to the case question in hand. You might well have to alter the details of the structure shown and you will almost certainly have to expand it as you lead the analysis . How you build out your structure and the solutions you provide are necessarily going to depend upon the specific details of the case question.

Thus, in order to deal with competitive interactions, you will need to put in the time to understand how the different strategies available function - as well as how competitors might then react to implementing such strategies. With enough practice, though, soon you won’t be fazed by even the most complex cases of competition between firms.

You can learn more in our article here and in our dedicated video lesson on competitive interaction in the MCC Academy case interview course.

3.4. Mental mathematics

Almost every interview case study will feature some mental mathematics and this is an area where many many candidates let themselves down.

As such, it makes sense to out in the time and make sure you are fully proficient.

Nothing beyond high school level is required, but you probably don’t do much mental arithmetic day to day and will likely need to practice quite a lot to get good enough to reliably perform at pace, under pressure.

We give a high-level overview of what you need to know in our consulting math article , but devote a whole section of our MCC Academy course to a deep dive on consulting math, with plenty of practice material to get you up to scratch.

4. How do I practice for case interviews?

As we said above - case interviews are much like chess. The rules are relatively quick to learn, but you need to practice a lot to get good.

If you’re working through our MCC Academy course, we recommend getting through the core Problem Driven Structure section. After that, you should be practising alongside working through the remainder of the course and beyond. However you do things, you need to get up to speed with the fundamentals before practice is going to do much more than confuse you.

Of course, if you’re enrolled in one of our mentoring programmes , your mentor will let you know precisely when and how you should be scheduling practice, as well as tracking your progress throughout.

4.1. Solo Practice

For solitary preparation, one of the best uses of your time is to work on your mental mathematics . This skill is neglected by many applicants - much to their immediate regret in the case interview. Find our mental math tool here or in our course, and practice at least ten minutes per day, from day one until the day before the interview.

Once you've covered our Building Blocks section, you should then start working through the cases in My Consulting Coach's case bank alongside your work on the course. This is a large library of case interview questions and answers in different formats and difficulties.

To build your confidence, start out on easier case questions, work through with the solutions, and don't worry about time. As you get better, you can move on to more difficult cases and try to get through them more quickly. You should practice around eight case studies on your own to build your confidence.

4.2. Peer practice

One you have worked through eight cases solo, you should be ready to simulate the interview more closely and start working with another person.

Here, many candidates turn to peer practice - that is, doing mock case interviews with friends, classmates or others also applying to consulting.

If you’re in university, and especially in business school, there will very likely be a consulting club for you to join and do lots of case practice with. If you don’t have anyone to practice, though, or if you just want to get a bit more volume in with others, our free meeting board lets you find fellow applicants from around the world with whom to practice.

4.3. Professional practice

You can do a lot practising by yourself and with peers. However, nothing will bring up your skills so quickly and profoundly as working with a real consultant.

Perhaps think about it like boxing. You can practice drills and work on punch bags all you want, but at some point you need to get into the ring and do some actual sparring if you ever want to be ready to fight.

Of course, it isn’t possible to secure the time of experienced top-tier consultants for free. However, when considering whether you should invest to boost your chances of success, it is worth considering the difference in your salary over even a just few years between getting into a top-tier firm versus a second-tier one. In the light of thousands in increased annual earnings (easily accumulating into millions over multiple years), it becomes clear that getting expert interview help really is one of the best investments you can make in your own future.

Should you decide to make this step, MyConsultingCoach can help, offering the highest quality case interview coaching service available . Each MCC case coach is selected as an MBB consultant with two or more years of experience and strong coaching expertise.

Case interview coaching is hugely beneficial in itself. However, for those who want to genuinely maximise their chances of securing a job offer - and especially for time-poor, busy professionals or hard-pressed students who want to take the guesswork and wasted time out of their case interview prep - we also offer a much more comprehensive service .

With one of our bespoke mentoring programmes , you are paired with a 5+ year experienced, ex-MBB mentor of your choosing, who will then oversee your whole case interview preparation from start to finish - giving you your best possible chance of landing a job!

4.4. Practice for online cases

Standard preparation for interview case studies will carry directly over to online cases.

However, if you want to do some more specific prep, you can work through cases solo to a timer and using a calculator and/or Excel (online cases generally allow calculators and second computers to help you, whilst these are banned in live case interviews).

Older PST-style questions also make great prep, but a particularly good simulation is the self-assessment tests included in our Case Academy course . These multiple choice business questions conducted with a strict time limit are great preparation for the current crop of online cases.

5. Fit interviews

As we’ve noted, even something billed as a case interview is very likely to contain a fit interview as a subset.

We have an article on fit interviews and also include a full set of lessons on how to answer fit questions properly as a subset of our comprehensive Case Academy course .

Here though, the important thing to convey is that you take preparing for fit questions every bit as seriously as you do case prep.

Since they sound the same as you might encounter when interviewing for other industries, the temptation is to regard these as “just normal interview questions”.

However, consulting firms take your answers to these questions a good deal more seriously than elsewhere.

This isn’t just for fluffy “corporate culture” reasons. The long hours and close teamwork, as well as the client-facing nature of management consulting, mean that your personality and ability to get on with others is going to be a big part of making you a tolerable and effective co-worker.

If you know you’ll have to spend 14+ hour working days with someone you hire and that your annual bonus depends on them not alienating clients, you better believe you’ll pay attention to their character in interview.

There are also hard-nosed financial reasons for the likes of McKinsey, Bain and BCG to drill down so hard on your answers.

In particular, top consultancies have huge issues with staff retention. The average management consultant only stays with these firms for around two years before they have moved on to a new industry.

In some cases, consultants bail out because they can’t keep up with the arduous consulting lifestyle of long hours and endless travel. In many instances, though, departing consultants are lured away by exit opportunities - such as the well trodden paths towards internal strategy roles, private equity or becoming a start-up founder.

Indeed, many individuals will intentionally use a two year stint in consulting as something like an MBA they are getting paid for - giving them accelerated exposure to the business world and letting them pivot into something new.

Consulting firms want to get a decent return on investment for training new recruits. Thus, they want hires who not only intend to stick with consulting longer-term, but also have a temperament that makes this feasible and an overall career trajectory where it just makes sense for them to stay put.

This should hammer home the point that, if you want to get an offer, you need to be fully prepared to answer fit questions - and to do so excellently - any time you have a case interview.

6. Interview day - what to expect, with tips

Of course, all this theory is well and good, but a lot of readers might be concerned about what exactly to expect in real life . It’s perfectly reasonable to want to get as clear a picture as possible here - we all want to know what we are going up against when we face a new challenge!

Indeed, it is important to think about your interview in more holistic terms, rather than just focusing on small aspects of analysis. Getting everything exactly correct is less important than the overall approach you take to reasoning and how you communicate - and candidates often lose sight of this fact.

In this section, then, we’ll run through the case interview experience from start to finish, directing you to resources with more details where appropriate. As a supplement to this, the following video from Bain is excellent. It portrays an abridged version of a case interview, but is very useful as a guide to what to expect - not just from Bain, but from McKinsey, BCG and any other high-level consulting firm.

6.1. Getting started

Though you might be shown through to the office by a staff member, usually your interviewer will come and collect you from a waiting area. Either way, when you first encounter them, you should greet your interviewer with a warm smile and a handshake (unless they do not offer their hand). Be confident without verging into arrogance. You will be asked to take a seat in the interviewer’s office, where the interview can then begin.

6.1.1. First impressions

In reality, your assessment begins before you even sit down at your interviewer’s desk. Whether at a conscious level or not, the impression you make within the first few seconds of meeting your interviewer is likely to significantly inform the final hiring decision (again, whether consciously or not).

Your presentation and how you hold yourself and behave are all important. If this seems strange, consider that, if hired, you will be personally responsible for many clients’ impressions of the firm. These things are part of the job! Much of material on the fit interview is useful here, whilst we also cover first impressions and presentation generally in our article on what to wear to interview .

As we have noted above, your interview might start with a fit segment - that is, with the interviewer asking questions about your experiences, your soft skills, and motivation to want to join consulting generally and that firm in particular. In short, the kinds of things a case study can’t tell them about you. We have a fit interview article and course to get you up to speed here.

6.1.2. Down to business

Following an initial conversation, your interviewer will introduce your case study , providing a prompt for the question you have to answer. You will have a pen and paper in front of you and should (neatly) note down the salient pieces of information (keep this up throughout the interview).

It is crucial here that you don’t delve into analysis or calculations straight away . Case prompts can be tricky and easy to misunderstand, especially when you are under pressure. Rather, ask any questions you need to fully understand the case question and then validate that understanding with the interviewer before you kick off any analysis. Better to eliminate mistakes now than experience that sinking feeling of realising you have gotten the whole thing wrong halfway through your case!

This process is covered in our article on identifying the problem and in greater detail in our Case Academy lesson on that subject.

6.1.3. Analysis

Once you understand the problem, you should take a few seconds to set your thoughts in order and draw up an initial structure for how you want to proceed. You might benefit from utilising one or more of our building blocks here to make a strong start. Present this to your interviewer and get their approval before you get into the nuts and bolts of analysis.

We cover the mechanics of how to structure your problem and lead the analysis in our articles here and here and more thoroughly in the MCC Case Academy . What it is important to convey here, though, is that your case interview is supposed to be a conversation rather than a written exam . Your interviewer takes a role closer to a co-worker than an invigilator and you should be conversing with them throughout.

Indeed, how you communicate with your interviewer and explain your rationale is a crucial element of how you will be assessed. Case questions in general, are not posed to see if you can produce the correct answer, but rather to see how you think . Your interviewer wants to see you approach the case in a structured, rational fashion. The only way they are going to know your thought processes, though, is if you tell them!

To demonstrate this point, here is another excellent video from Bain, where candidates are compared.

Note that multiple different answers to each question are considered acceptable and that Bain is primarily concerned with the thought processes of the candidate’s exhibit .

Another reason why communication is absolutely essential to case interview success is the simple reason that you will not have all the facts you need to complete your analysis at the outset. Rather, you will usually have to ask the interviewer for additional data throughout the case to allow you to proceed .

NB: Don't be let down by your math!

Your ability to quickly and accurately interpret these charts and other figures under pressure is one of the skills that is being assessed. You will also need to make any calculations with the same speed and accuracy (without a calculator!). As such, be sure that you are up to speed on your consulting math .

6.1.4. Recommendation

Finally, you will be asked to present a recommendation. This should be delivered in a brief, top-down "elevator pitch" format , as if you are speaking to a time-pressured CEO. Again here, how you communicate will be just as important as the details of what you say, and you should aim to speak clearly and with confidence.

For more detail on how to give the perfect recommendation, take a look at our articles on the Pyramid Principle and providing recommendations , as well the relevant lesson within MCC Academy .

6.1.5. Wrapping up

After your case is complete, there might be a few more fit questions - including a chance for you to ask some questions of the interviewer . This is your opportunity to make a good parting impression.

We deal with the details in our fit interview resources. However, it is always worth bearing in mind just how many candidates your interviewers are going to see giving similar answers to the same questions in the same office. A pretty obvious pre-requisite to being considered for a job is that your interviewer remembers you in the first place. Whilst you shouldn't do something stupid just to be noticed, asking interesting parting questions is a good way to be remembered.

Now, with the interview wrapped up, it’s time to shake hands, thank the interviewer for their time and leave the room .

You might have other interviews or tests that day or you might be heading home. Either way, if know that you did all you could to prepare, you can leave content in the knowledge that you have the best possible chance of receiving an email with a job offer. This is our mission at MCC - to provide all the resources you need to realise your full potential and land your dream consulting job!

6.2. Remote and one-way interview tips

Zoom case interviews and “one-way” automated fit interviews are becoming more common as selection processes are increasingly remote, with these new formats being accompanied by their own unique challenges.

Obviously you won’t have to worry about lobbies and shaking hands for a video interview. However, a lot remains the same. You still need to do the same prep in terms of getting good at case cracking and expressing your fit answers. The specific considerations around remote interviews are, in effect, around making sure you come across as effectively as you would in person.

6.2.1. Connection

It sounds trivial, but a successful video interview of any kind presupposes a functioning computer with a stable and sufficient internet connection.

Absolutely don’t forget to have your laptop plugged in, as your battery will definitely let you down mid-interview. Similarly, make sure any housemates or family know not to use the microwave, vacuum cleaner or anything else that makes wifi cut out (or makes a lot of noise, obviously)

If you have to connect on a platform you don’t use much (for example, if it’s on Teams and you’re used to Zoom), make sure you have the up to date version of the app in advance, rather than having to wait for an obligatory download and end up late to join. Whilst you’re at it, make sure you’re familiar with the controls etc. At the risk of being made fun of, don’t be afraid to have a practice call with a friend.

6.2.2. Dress

You might get guidance on a slightly more relaxed dress code for a Zoom interview. However, if in doubt, dress as you would for the real thing (see our article here ).

Either way, always remember that presentation is part of what you are being assessed on - the firm needs to know you can be presentable for clients. Taking this stuff seriously also shows respect for your interviewer and their time in interviewing you.

6.2.3. Lighting

An aspect of presentation that you have to devote some thought to for a Zoom interview is your lighting.

Hopefully, you long ago nailed a lighting set-up during the Covid lockdowns. However, make sure to check your lighting in advance with your webcam - bearing in mind what time if day your interview actually is. If your interview is late afternoon, don’t just check in the morning. Make sure you aren’t going to be blinded from light coming in a window behind your screen, or that you end up with the weird shadow stripes from blinds all over your face.

Natural light is always best, but if there won’t be much of that during your interview, you’ll likely want to experiment with moving some lamps around.

6.2.4. Clarity

The actual stories you tell in an automated “one-way” fit interview will be the same as for a live equivalent. If anything, things should be easier, as you can rattle off a practised monologue without an interviewer interrupting you to ask for clarifications.

You can probably also assume that the algorithm assessing your performance is sufficiently capable that it will be observing you at much the same level as a human interviewer. However, it is probably still worth speaking as clearly as possible with these kinds of interviews and paying extra attention to your lighting to ensure that your face is clearly visible.

No doubt the AIs scoring these interviews are improving all the time, but you still want to make their job as easy as possible. Just think about the same things as you would with a live Zoom interview, but more so.

7. How we can help

There are lots of great free resources on this site to get you started with preparation, from all our articles on case solving and consulting skills to our free case library and peer practice meeting board .

To step your preparation up a notch, though, our Case Academy course will give you everything you need to know to solve the most complex of cases - whether those are in live interviews, with chatbots, written tests or any other format.

Whatever kind of case you end up facing, nothing will bring up your skillset faster than the kind of acute, actionable feedback you can get from a mock case interview a real, MBB consultant. Whilst it's possible to get by without this kind of coaching, it does tend to be the biggest single difference maker for successful candidates.

You can find out more on our coaching page:

Explore Coaching

Of course, for those looking for a truly comprehensive programme, with a 5+ year experienced MBB consultant overseeing their entire prep personally, from networking and applications right through to your offer, we have our mentoring programmes.

You can read more here:

Comprehensive Mentoring

Account not confirmed

The Tesla Financial Analyst Interview Guide

Walk through the Tesla financial analyst interview process and learn how I landed a job with Tesla’s FP&A Business Operations team.

Introduction

In this article, Michael (former FP&A and Business Operations Analyst at Tesla), will walk you through the steps he took to land a full-time analyst role at Tesla. This guide will cover the various stages of the interview process alongside general notes, tips, and sample interview questions and answers.

#1 Passing the Resume Screen

Tesla received 3 million job applications in all of 2021. This may sound a bit daunting, but there are several different things that you can do to squeeze past this first obstacle.

Clean Up Your Resume

First, you need to clean up your resume and tailor all of your experiences to best fit the financial analyst role or whichever role you are applying for.

Tesla is an innovative, technology-driven company that likes seeing people use data to make logical business decisions. Keep this in mind when tuning up the bullets in your resume.

When writing the experience section of your resume, you should make sure to start each bullet with an action verb. This will help cut down the excess “fluff” in your resume and make it easier for recruiters to understand your previous tasks and experiences.

Sample Action Verbs:

More Action Verbs

In addition to using action verbs, you should quantify your resume as much as possible so that you clearly state how you added value to your previous companies. For example, you can change “Reduced product line wait time” to “Reduced product line wait time by 3 seconds resulting in a 15% increase in production efficiency.”

For more details and tips, check out our other article on how to write the perfect resume .

Try to Obtain an Employee Referral

With thousands of applications flowing into Tesla each day, an employee referral would certainly help bring your resume to the top of the stack.

Now if you don’t have any existing friends or connections that work at Tesla, you can try to use LinkedIn and cold emails to contact an existing employee to ask for a quick phone call.

When scrolling through your LinkedIn network, try to look for your school alumni and ideally people who work on the finance team or the team that you are applying to. The goal is to hop on a phone call with your connection so that you can learn more about the working roles at Tesla and demonstrate a genuine interest in the company.

For those looking to better their chances of a referral, we recommend you check out our article on Networking Cold Email Templates.

#2 Phone Screen

If you make it past the resume screen, then congratulations, you’ve made it past the largest cutting stage of the application process.

Following the resume screen, you’ll likely have to hop on a call with one recruiter and one or two finance managers. These calls are quite straightforward and very behavioral-focused. Although they seem quite simple, it will be important to give off a good impression and to make your interviewers believe that you will be a good fit on one of their teams.

Preparation Tip: Read Up on Tesla News

Spend an hour reading online articles on Tesla. Finance-oriented publications like CNBC , The Financial Times , and Bloomberg are great places to start.
Watch YouTube videos on recent company stories. Tesla has its own channel and Rob Maurer also runs a very informative YouTube channel called the Tesla Daily .
Read Tesla’s 10-K annual report. Every public company is required to post a publicly available 10-K company report . I’d recommend taking a look at the section on “Risk Factors” and “Management Opportunities, Challenges, and Risks.” (These sections are perfect for coming up with interesting follow-up questions that you can ask your interviewer).

Sample Questions & Answers

The following should give you an idea of the types of questions that you may be asked in these phone screen interviews.

Q: Why do you want to work for Tesla?

Sample Answer:

“Tesla seems to be a very dynamic and innovative company. With this in mind, I figured that this type of work exposure, particularly at the junior level, would be extremely rewarding as I would be forced to learn many things in a rapid environment. Although this may seem daunting for some, I’ve always been the type to throw myself into challenging situations to force myself to figure things out. Tesla has made tremendous progress since its first factory opening in Fremont, California and I’d simply love to take part in its massive global mission.”

Q: Where do you see yourself in 5 years?

“It’s hard to answer that question specifically as 5 years is quite a long time. What I can say is that I would like to spend the first few years of my analyst career learning the little details and all the ins and outs of the business. Then, after building up my fundamentals and overall experience, I would like to transition into a role that would allow me to make thoughtful and impactful business decisions.”

Q: What do you like to do outside of work and school?

“I really enjoy going fishing when I have some free time over the weekend. Although it seems like fishing is a relatively relaxed activity, I actually really enjoy the strategic side of a fishing operation. Whether it's looking a weather and wave height reports or researching specific species and testing different baits and fishing equipment, I actually really enjoy the process of testing out different theories to find what works best for me.”

#3 Excel Case Study Interview

If you make it past the phone screen stage, you’ll likely move on to an Excel case study interview. To prepare for this Excel case study test, I recommend you make sure you are comfortable with basic Excel skills and finance fundamentals.

Excel: In my case study, I ended up using simple formulas like SUMIFS and VLOOKUPS and I didn’t have to use pivot tables or macros. That said it certainly wouldn’t hurt to learn pivot tables and other Excel functions as they’ll likely switch up the case studies every now and then.

Finance: The Excel case study (at least when interviewing for the financial analyst role) is very much finance oriented. At a minimum, make sure you understand the ins and outs of an income statement so that you can comfortably solve for gross and net profit margins, EBITDA, etc.

General Tip: They will likely ask you for your insights or recommendations given the figures and data available. If certain figures or assumptions seem a bit high, perhaps you could recommend the analyst to speak with the manufacturing team or distribution team for more details on mandatory vs optional expenses (this makes it seem like you are familiar with real work scenarios).

If you’re interested in learning more about how you can best prepare for your interviews, consider checking out our Excel for Business & Finance Course and our Complete Finance & Valuation Course . These two courses should help you comfortably tackle finance interviews at the most competitive corporations and investment banks!

#4 Final Round: 4-5 Back-to-Back 30-Minute Interviews

If you make it past the Excel case study test, you’ll likely have an opportunity to take part in a final round interview consisting of 4-5 back-to-back 30-minute interviews with members from various finance teams.

These interviews will consist of mostly technical and brain teaser questions. With this in mind, you should expect to open up Excel during the interview to share your screen and walk through mini case studies and teaser problems.

General Tip: Once you find a reasonable solution, don’t just stop at the numerical answer. The interviewer wants to see how you can connect the data to actionable business ideas. You’ll usually want to make some surface-level assumptions to arrive at a figure, then tell your interviewer the types of follow-up questions you would ask if you had more time to work on this in a real business setting.

You should also expect a couple of behavioral questions at the end of the interview alongside an opportunity to ask the interviewer general questions.

The following should give you an idea of the types of problem-solving questions that you might be asked in the final round of interviews.

Q: Tell me 3 different methods that you could use to price a Tesla car entering a new market?

You can use a competitive pricing model. Simply put, you can look up the prices of competing cars in the new market and price the Tesla car within a certain range of its competitors (maybe plus or minus 5%). It will also be interesting to factor in any potential tax benefits that some countries give to electric vehicle consumers as that could give Teslas a big pricing edge over traditional combustion engine vehicles.
You can use a cost-based pricing model. In this method, you can add up all the costs required to manufacture and distribute a vehicle. Then you can apply a percentage premium to that cost basis to arrive at the consumer-facing price. Perhaps you could use some industry-standard or comparable markup figure to determine the percentage premium to use.
You could create a model based on customer income. In this method, you could start by looking at all of the existing markets, and create a ratio using the Tesla prices in those markets relative to the median family income in that area. Once you have that ratio, you can apply it to your new market by finding the median family income in the new area.

Q: Identify the bottleneck of the car manufacturing line given XYZ data

This question will likely require you to use simple math to figure out which stage in the production line is taking up the most time. Once you figure out the bottleneck, the interviewer might ask you a follow-up question modifying the figures of the original scenario.

For example, your interviewer might say: “If you were presented with the opportunity to invest $X amount of dollars to cut down the bottleneck time by 25%, would you proceed with the project?”

To approach this problem, you would likely have to calculate how much more product you would be able to produce and the dollar value of that additional product. From there, you could calculate the payback period or essentially how long it would take for the additional profits to cover the cost of the initial investment.

#5 Job Offer!

If you make it past the final round of interviews, congratulations, you’ll likely receive an email and a call from the HR team.

If you don’t get the job offer, don’t worry and keep your chin up. It’s already quite an accomplishment to make it to the final round of interviewers. Even if you don’t end up at Tesla, you can still apply to many other great companies like Apple, Amazon, Visa, and more.

If you're fishing around for a new job, consider signing up for our weekly newsletter for more career news and interesting job opportunities that we find at fortune 500 companies across the globe.

Additional Resources

If you’re looking to better prepare your technical skills for any competitive business or finance interviews, consider checking out our courses using the get started button below!

Dolor enim eu tortor urna sed duis nulla. Aliquam vestibulum, nulla odio nisl vitae. In aliquet pellentesque aenean hac vestibulum turpis mi bibendum diam. Tempor integer aliquam in vitae malesuada fringilla.

Elit nisi in eleifend sed nisi. Pulvinar at orci, proin imperdiet commodo consectetur convallis risus. Sed condimentum enim dignissim adipiscing faucibus consequat, urna. Viverra purus et erat auctor aliquam. Risus, volutpat vulputate posuere purus sit congue convallis aliquet. Arcu id augue ut feugiat donec porttitor neque. Mauris, neque ultricies eu vestibulum, bibendum quam lorem id. Dolor lacus, eget nunc lectus in tellus, pharetra, porttitor.

Test Bullet List 1
Test Bullet List 2
Test Bullet List 3

"Ipsum sit mattis nulla quam nulla. Gravida id gravida ac enim mauris id. Non pellentesque congue eget consectetur turpis. Sapien, dictum molestie sem tempor. Diam elit, orci, tincidunt aenean tempus."

Tristique odio senectus nam posuere ornare leo metus, ultricies. Blandit duis ultricies vulputate morbi feugiat cras placerat elit. Aliquam tellus lorem sed ac. Montes, sed mattis pellentesque suscipit accumsan. Cursus viverra aenean magna risus elementum faucibus molestie pellentesque. Arcu ultricies sed mauris vestibulum.

Morbi sed imperdiet in ipsum, adipiscing elit dui lectus. Tellus id scelerisque est ultricies ultricies. Duis est sit sed leo nisl, blandit elit sagittis. Quisque tristique consequat quam sed. Nisl at scelerisque amet nulla purus habitasse.

Nunc sed faucibus bibendum feugiat sed interdum. Ipsum egestas condimentum mi massa. In tincidunt pharetra consectetur sed duis facilisis metus. Etiam egestas in nec sed et. Quis lobortis at sit dictum eget nibh tortor commodo cursus.

Odio felis sagittis, morbi feugiat tortor vitae feugiat fusce aliquet. Nam elementum urna nisi aliquet erat dolor enim. Ornare id morbi eget ipsum. Aliquam senectus neque ut id eget consectetur dictum. Donec posuere pharetra odio consequat scelerisque et, nunc tortor. Nulla adipiscing erat a erat. Condimentum lorem posuere gravida enim posuere cursus diam.

Ready to Level Up Your Career?

Learn the practical skills used at Fortune 500 companies across the globe.

Human Resources | What is

Free Excel Test for Interviewing Candidates

Updated March 15, 2024

Updated Mar 15, 2024

Published March 15, 2024

Published Mar 15, 2024

REVIEWED BY: Heather Landau

WRITTEN BY: Robie Ann Ferrer

Get Your Free Hiring Ebook With Downloadable Templates

Your Privacy is important to us.

This article is part of a larger series on Hiring .

Need Help Hiring?

Get Your Free Hiring Ebook

1 Free Excel Test Directions
2 How to Facilitate an Excel Test
3 Excel Skills to Test
4 Alternative Options to Our Free Excel Test
6 Bottom Line

When hiring for certain positions, you must ensure job applicants are well-versed in the qualifications for the role. For bookkeepers, accountants, and any finance position, among others, Excel skills are vital.

If you need a quick way to test applicants, use our free Excel test for interview candidates that mimics data that might be included in a sports club’s client database. Having your applicants use and manipulate that data allows you to evaluate their ability to use formulas, VLookup, IF statements, and more in 30 minutes or less.

FILE TO DOWNLOAD OR INTEGRATE

Thank you for downloading!

We also have an Excel test results file you can download for free. Armed with the results, you can weed out unqualified job applicants, so you only hire candidates who meet your required qualifications.

Excel Test Results

Free Excel Test Directions

Note that our Excel exam for interview candidates contains data for a fictional facility—the Patagonia Exploration Club International (PECI). When your test subject downloads the provided Excel test, they will see club information in multiple tabs—”Context & Tasks,” “Clubdata,” and “Fitness Table.”

Tab 1: Context & Tasks

The “Context & Tasks” tab includes the various Excel functions that will be tested and the instructions for performing those tasks using data provided across all three tabs. The information in the left columns (specifically columns C to M) shows the skills and familiarity required to complete the tasks in each stage.

Showing context tasks tab include the various accelerated excel functions.

The test consists of the following stages:

Stage 1: Standardizing the Dataset – This stage tests the individual’s ability to process data between different types of variables.
Stage 2: Conversions – This stage tests the individual’s ability to convert formulas (i.e., centimeters to inches) and use the VLOOKUP (vertical lookup) function to populate them.
Stage 3: Pivot Table 1 – This stage tests the individual’s ability to create a pivot table.
Stage 4: Pivot Table 2 – This stage tests the individual’s ability to take an existing pivot table and change its values, creating new value tabs.
Stage 5: Sorting and Pivotchart – This stage tests the individual’s ability to sort data within a pivot table or pivotchart.
Stage 6: Print Setup and Output – This stage tests the individual’s ability to create a header using Page Setup, as well as print the document to a PDF file.

Tab 2: Clubdata

The “Clubdata” tab lists the demographic information of all club members of our fictional club, such as name, birth date, sex, height, and weight, among other data. This data is used in the “Context & Tasks” tab to complete the Excel skills test for interview applicants.

Showing clubdata tab lists the demographic information.

Tab 3: Fitness Table

The “Fitness Table” shows the PECI-SCORE, PECI-LEVEL and PECI-CODE. In “Stage 2: Conversions” of this free Excel test, applicants will use data collected to calculate the PECI-SCORE, and use VLOOKUP to populate the PECI-CODE from the tab FITNESS TABLE tab into their answers.

Excel Test Results: Grading

Aside from the test file itself, we have an Excel Test Results file. This contains the test answers, so do not send this file to your job applicants. It is for grading purposes only and should be used as a guide to examine how well the individual performed on their assessment. Pay attention to individual questions and not just the final score, as some applicants may score lower overall but have more proficiency in the area you need.

It also has the same tabs as the Excel Test file, but with additional sheets that show what the completed data should look like. For a peek at those tabs, check out the below images and what each results sheet illustrates about your candidate’s Excel capabilities.

The completed CLUBDATA tab shows how effectively your candidate can input, format, filter, and sort data, as well as use formulas, to standardize client names, email addresses, and other data.

The completed PIVOT tab shows the candidate’s ability to create and manage a pivot table using provided data and manipulate the data within the pivot table to deliver the desired results.

The completed RECORDCOUNT tab demonstrates the candidate’s ability to use the created pivot table to count values and grand totals using tabs.

The completed ALLFEMALE tab shows the candidate’s ability to sort, extract, and format data in the spreadsheet such as name, year, and birthdate.

The completed ALLFEMALESPORTS tab shows the candidates ability to use LEGENDS, VALUES, and AXIS tools to extract data and create an aesthetically pleasing chart.

How to Facilitate an Excel Test

The right time to give your Excel test for job interview can vary based on the position you’re hiring for and how many applicants you get. The most logical time to have job applicants complete an Excel test is during the applicant screening part of the interview process. You have the candidate’s commitment at this point, as they have learned they are in the running for the job and have been selected for an interview.

The test can be administered by email or in person, depending on your preference.

If you choose to email the test to your candidates, make sure you only email the test sheet and not the answer sheet . The biggest benefit to emailing the Excel test to the applicant is that you can gauge their interest level in the position without too much investment. If they don’t respond to your email request, they probably aren’t that interested or qualified for the role.

The downside to emailing the test to the applicant is that they could use outside sources to complete the test. When you’re giving a candidate an Excel test, you really want to know what they know—not what they can look up.

You may choose to give job applicants an Excel test in person. This allows you to see the applicant work through the test, giving you a better idea of how long it takes them to complete. This method immediately lets you learn what the applicant knows about the program. The biggest downside here is that this takes time to schedule and requires a proctor to sit in with the candidate. When done later in the hiring process, however, it can help you separate the outstanding applicants from the average.

Excel Skills to Test

Depending on the position you need to fill, the job applicant’s qualifications and Excel skillset required might vary. Hiring for a front-office position or receptionist role that needs to know how to create simple spreadsheets and use a SUM formula is an entirely different Excel skill set than looking for a bookkeeper or finance administrator to recruit.

Certain Excel skills will be necessary for your specific open role. For example, a bookkeeper must know how to input accounts receivable and payable data to create an accurate budgetary picture. A finance manager may need to know how to create charts to show a visual representation of where this month’s revenue is coming from.

Here are some common Excel skills to test interview candidates for:

Data and cell formatting
Data sorting or manipulation
Database set up
Using formula
Pivot tables
Creating charts
Conditional formatting

It is recommended that you test for the basics, regardless of the level of position for which you’re hiring. Applicants must prove they have the foundational elements of Excel. Without that, they may not be able to complete the more challenging tasks required for the position.

Alternative Options to Our Free Excel Test

While our free basic Excel test for interview candidates can help you evaluate applicant knowledge and proficiency in using this program, there are other options you can try. Indeed offers a free Excel skills test that can be added as part of your applicant screening. Additionally, you can purchase Excel tests from outside sources, where they will be administered and graded for you, or even create your own test unique to your business.

Indeed Excel Test

Indeed provides free applicant screening tools for many skills, including Excel. In addition to the option to ask applicants about their Excel skills, you can have Indeed test each candidate on their level of proficiency.

Further, if you set up the Excel test during the application process, Indeed will automatically reject any applicant who fails the Excel test. However, the downside to using Indeed’s Excel test is that you will not have the ability to customize the test in any way or evaluate an applicant’s test performance in person.

Indeed's skills tests cover different topics, from written communication to customer service and leadership skills.

You can add up two skills tests to your Indeed job posts. (Source: Indeed)

Purchase an Excel Test

There are companies that will allow you to purchase an Excel test, along with an answer page. You can either purchase a specific test you download and send to applicants, or you can purchase access to a link that you can email to applicants. Of these options, sending a link is the most efficient for you since you simply get the results back and do not have to grade the test yourself.

Some are integrated into more comprehensive HR software and others are standalone tests. However, depending on your business needs and how frequently you plan to hire, purchasing Excel tests can get expensive. Several options include:

TestGorilla : Free for five tests; Starts at $499 monthly for more than 400 tests
TestDome : Starts at $150 for one pack good for four months & 10 candidates
EmployTest : Starts at $199 for five tests

Create Your Own Excel Test

If you are creating your own Excel test, be sure to ask practical questions that are related to the job duties of the position. Your questions should require applicants to create spreadsheets and test their ability to organize, track, and manipulate numerical data.

Review our guide to pre-employment assessment solutions for other tools to help you evaluate your candidates’ qualifications and work experience.

Frequently Asked Questions (FAQs) About Excel Tests

Can you assess excel skills in an interview.

Yes, you can do this by asking questions about the candidate’s knowledge of Excel formulas, features, and functions. However, we recommend adding a hands-on Excel test for interview candidates to your pre-employment assessment processes. This will help you gauge whether the applicants’ knowledge is only theoretical or if they can also solve actual Excel problems.

What topics are included in Excel tests for interviews?

An Excel skills test can cover basic to intermediate topics, depending on the position. Let’s say, you’re looking for an administrative assistant, you can include test activities about sorting data, adjusting cell formats, and using basic formulas like SUM. However, if you’re hiring a financial analyst, you need to add advanced Excel topics, such as pivot tables and data validation commands.

Bottom Line

When Excel skills are important to the position, you should verify a job applicant’s aptitude. The best way to do that is through a practical exam. Download our free Excel Test template to test the Excel skills of your applicants. Grading the test can take time, but it ensures that you know exactly what Excel skills each applicant has so you can make the right hiring decision.

About the Author

Find Robie Ann On LinkedIn

Robie Ann Ferrer

Robie Ann Ferrer is an HR expert writer at Fit Small Business, focusing on small business HR and payroll software content. She has over eight years of content writing experience, handling different topics. Robie also worked as an HR specialist for 10 years where she managed various facets of HR—from payroll and benefits to employee services and HR systems.

Join Fit Small Business

Sign up to receive more well-researched small business articles and topics in your inbox, personalized for you. Select the newsletters you’re interested in below.

IMAGES

Excel Spreadsheet Test For Interview
49 ejemplos y plantillas de estudios de casos gratuitos
EXCEL of Free Interview Form.xls
Case Interview Frameworks: The Ultimate Guide (2024)
49 Free Case Study Templates ( + Case Study Format Examples + )
excel interview questions

VIDEO

Case Study Interview
Case Study Interview
case study (interview)
Case Study Interview Session
CASE STUDY 2 LIVE: Meta Insider Strategy That SLASHED Grant Cardone's Ad Costs by Jaw-Dropping 70%+!
MS Excel Interview Questions And Answers

COMMENTS

Excel Case Study/Scenarios Index
2 Comments. This article is a temporary solution for the Index of Excel Case Studies/Scenarios. Index Case Study/Scenario 1 Case Study/Scenario 2 Case Study/Scenario 3 Case Study/Scenario 4 CASE ...
12 Excel Interview Questions for 2024 (Plus Sample Answers)
Excel interview questions and answers. Excel interview questions will be technical in nature and offer an opportunity for you to speak about your experience and skill level with the business resource. The following are some typical Excel questions you might receive in an interview: 1.
How to Perform Case Study Using Excel Data Analysis
Excel shows the most commonly used analyzes by default. Steps: Click any data from the dataset. Next, click as follows: Home > Analyze Data. Soon after, you will get an Analyze Data field on the right side of your Excel window. Where you will see different kinds of cases like- Pivot Tables and Pivot Charts. Look, there is a sample Pivot Table ...
Data Science Interview Case Studies: How to Prepare and Excel
When presented with a case study during the interview, take a structured approach to deconstructing the problem. Begin by defining the business problem or question at hand. Break down the problem into manageable components and identify the key variables involved. This analytical framework will guide your problem-solving process.
REAL Excel Interview Tests for Business & Finance Roles
Learn excel interview test questions for business & finance professionals.Among the most common excel test involve SumIFs, Index Match, Vlookups and data cle...
35 Case Interviews Examples from MBB / Big Four Firms
Other firms case interview examples. Besides the leading ones, we have some examples from other major consulting firms as well. Oliver Wyman - Wumbleworld. Oliver Wyman - Aqualine. LEK - Cinema. LEK - Market Sizing. Kearney - Promotional Planning. OC&C - Imported Spirits. OC&C - Leisure Clubs.
Excel Tests in Interviews: INDIRECT, MATCH, SUMIFS, and More
In this tutorial, you'll learn how to write a flexible Excel formula that lets you summarize quarterly or monthly data in an annual format using the INDIRECT...
Consulting Group Case Interviews: How to Prepare and Excel
Consulting group case interviews are much less commonly used than traditional case interviews, but they are as equally as important. They are typically given in second or final round interviews . For firms and offices that use group case interviews, you will not receive a consulting job offer unless you can pass them.
47 case interview examples (from McKinsey, BCG, Bain, etc.)
BCG mock case interview with ex-BCG associate director - Public sector case (by IGotAnOffer) BCG mock case interview: Revenue problem case (by IGotAnOffer) - See below. 3. Bain case interview examples. CoffeeCo practice case (Bain website) FashionCo practice case (Bain website)
Practical case study for excel interview
I was sent an excel sheet to provide solution as the first stage in my interview process. Below is the instructions and screenshot of the excel sheet. I need guidance on how to provide solution to the case study. Thank you so much. Instructions: 1. Use the data on the GFD and CHARITY tabs to provide the details on the SUMMARY.
20 Most-Asked Excel Job Interview Questions for Business Analyst
A sample answer for the functions that a business analyst most use can be: "I most often use the LOOKUP function; followed by COUNT and COUNTA functions. The IF and MAX and MIN functions are also one of the ones I usually use.". Recommended Reading: Most Used Excel Functions.
Case Interview: all you need to know (and how to prepare)
Down to business. Following an initial conversation, your interviewer will introduce your case study, providing a prompt for the question you have to answer. You will have a pen and paper in front of you and should (neatly) note down the salient pieces of information (keep this up throughout the interview).
Job Interview
Job Interview - Excel Case Study. Discussion. I have been scheduled for a three hour time block in which I am to analyze data, identify trends and create a presentation that I will then present during my interview. The goal is to demonstrate critical thinking and the ability to manipulate and summarize data. Tips?
Data Analysis Using Excel Case Study
By using Excel for data analysis, individuals can explore and analyze the data related to the case study in a comprehensive and structured manner. Excel offers various tools and functionalities, such as PivotTables, slicers, and data visualization features, which allow users to assess patterns, trends, and relationships within the data.
I have an interview on Friday that said they will be testing Excel
Some interviews want a case study, some want SQL, some want Python, etc. It's not been easy I'm constantly pulled from one thing to the other so I'm not really a master of anything. To do so I need to be in a work environment where I do these things daily and there's some focus. ... We had an excel interview test for my interview 4 months ago ...
Efficio
A first round of interviews, typically involving two interviews and a case study. An Excel-based case study. A second round of interviews with senior management. I actually do have a few excel-based real-life case studies (from past candidates). They are across the topics of food delivery, investment decisions, and mining/operations optimization.
Tesla Financial Analyst Interview Guide
These interviews will consist of mostly technical and brain teaser questions. With this in mind, you should expect to open up Excel during the interview to share your screen and walk through mini case studies and teaser problems. General Tip: Once you find a reasonable solution, don't just stop at the numerical answer.
Free Excel Test for Interviewing Candidates
Note that our Excel exam for interview candidates contains data for a fictional facility—the Patagonia Exploration Club International (PECI). When your test subject downloads the provided Excel test, they will see club information in multiple tabs—"Context & Tasks," "Clubdata," and "Fitness Table." Tab 1: Context & Tasks
Case Study Interview Examples (With Tips to Answer Them)
Here are some case study interview examples. You can utilise these samples to gain a better sense of how interviewers may pose case interview questions and what subjects they may address: 1. A hotel in Kuala Lumpur, Malaysia, is a customer of a corporation. Their core consumer base consists primarily of international visitors.
Excel case study Questions & Answers
Find all questions and answers on Excel case study. Management Consulting Career Application Process Case Interview Tips. ... Deloitte Excel case study Value Creation Most recent answer on Oct 09, 2023 The best answer (on Jul 24, 2018) is from: ...
Amazon interview
Hey, they asked me all kinds of questions after the excel task. I honestly just googled "Amazon Interview questions" and found a bunch of basic ones they ask (non-subject specific) e.g. please describe a time where a project didn't go as planned.
How to Prepare for a Real Estate Technical Interview
The case study (or skills test) component of the interview tests your ability to value real estate using Excel (and possibly ARGUS). The company will provide you a computer with the necessary software, give you a time limit (typically 2 - 4 hours), and ask you to create a deliverable and/or answer certain questions within the allotted time.
Leading the pack: an exclusive interview with Uber's Chief Barketing
Meet Teddy, Uber's Chief Barketing Officer. With a nose 👃 that can sniff out trends faster than you can say "squirrel!" 🐿️ and loyalty that puts human's best friend to shame, Teddy is more than just an employee; he's the leader of the pack 🐺. From negotiating treats 🦴 to chasing the company's KPIs (Kibble Performance ...