PrepLounge - link to homepage PrepLounge - link to homepage
Consulting Consulting
Consulting Finance General
Login Sign up for free Sign up for free
Consulting Finance General
Community
Meeting Board
Consulting Q&A
Interview Partner
Premium Membership
Coaching
Coaches
Coaching Packages
Consulting Q&A
Resources
Case Interview Basics
Case Library
AI Casebot
Tests & Guides
Mental Math Tool
Stress Questions
Drills
Video Tutorials
Brainteaser
Career
Employers
Career Events
Consulting Jobs
Consulting Blog
Sign up for free
Login
Community
Meeting Board
Consulting Q&A
Interview Partner
Premium Membership
Coaching
Coaches
Coaching Packages
Consulting Q&A
Resources
Case Interview Basics
Case Library
AI Casebot
Tests & Guides
Mental Math Tool
Stress Questions
Drills
Video Tutorials
Brainteaser
Career
Employers
Career Events
Consulting Jobs
Consulting Blog
Schedule mock interviews on the Meeting Board, join the latest community discussions in our Consulting Q&A and find like-minded Interview Partners to connect and practice with!
Meeting Board
Consulting Q&A
Interview Partner
Premium Membership
Back to overview
Anonymous A
on Jan 26, 2022
Global
I want to receive updates regarding this question via email.

How can I improve my excel modeling skills as a consultant?

How can I improve my excel modeling skills as a consultant?

e.g. market size, profitability, M&A, etc.

I haven't built a model yet and want to build a clear model.

Any material recommendations?

7
1.7k
14
Write an answer
Be the first to answer!
Nobody has responded to this question yet.
Top answer
Ian
Coach
on Jan 27, 2022
Top US BCG / MBB Coach - 5,000 sessions |Tech, Platinion, Big 4 | 9/9 personal interviews passed | 95% candidate success

Hi there,

You have a few options here:

  1. Learn on the job
  2. Ask your colleagues
  3. Do the online/internal trainings
  4. Find online tutorials/trainings (there are a million)
  5. “Create” you own training by playing around with a big dataset or modelling our your own scenario
12
Contact coach
0 comments
Moritz
Coach
on Jan 26, 2022
ex-McKinsey EM & Interviewer | 7/8 offer rate for 4+ sessions | High impact sessions + FREE materials & exercises

Are you a current or aspiring consultant? Once you join any firm, they will generally provide you with plenty of training (most of it on the job but also good formal training for Excel or other modeling software, depending on firm).

Really not sure at all what you're after because there's no such thing as an M&A model and a profitability model is literally 3 cells if you want to keep it simple.

If what you're saying is that you have no clue how to use excel in the first place, then I can point you in the direction of some resources. However, that would seem a little odd considering your career choice.

10
Contact coach
0 comments
Pedro
Coach
on Jan 26, 2022
Bain | EY-Parthenon | Former Principal | 1.5h session | 30% discount 1st session

You will have trainings available at your consulting firm. You should do them, and when building a model, ask for the help of a more senior colleague.

If you are thinking about practicing this before hand, don't do it. You will be waisting your time because you will learn better and faster when in consulting (and whatever you learn now won't really make the difference).

9
Contact coach
0 comments
Lucie
Coach
edited on Jan 27, 2022
10+yrs recruiting & BCG Project leader

Hi there,

you will learn it as you go, but some practical tips:

1. Ensure you know excel well (functions beyond sum.if and pivot tables, formatting, etc.)

2. Your excel must be clean and clear, with instructions, proper structure, unified color coding and formatting, assumptions well defined and stated, each column having a proper description, etc. → if you leave the case now and you have to handover your model, it must be ready to use by someone else immediately

3. Practice

4. Observe

Lucie

Was this answer helpful?

8
Contact coach
0 comments
Stephan
Coach
on Jan 26, 2022
Former BCG Con and political advisor here to help you crack the case (MBB, Europe & MidEast, non-business backgrounds)

Do your company's excel trainings.

Reach out to more senior consultant in your firm/office to show you some of their favorite models, shortcuts, etc.

Search the web for model examples.

For me it's mostly about layout, design, structure (at least on the front end) than sophisticated formulars (depending on the case).

Best

Stephan

7
Contact coach
0 comments
Benjamin
Coach
on Oct 15, 2023
Ex-BCG Principal | 8+ years consulting experience in SEA | BCG top interviewer & top performer

Hi,

Speaking from experience, the most practical way is to actually get yourself staffed on cases that require you to do excel.

Beyond knowing the standard functions, the nuances of each case cannot be predicted and you will always be faced with new situations/problems in excel. 

If you are already on the job, there is no way that you will have time to take a training on excel that will allow you to spend as much time and effort on it versus an actual project. 

Last but not least, I would get hold of your firm's internal guidelines for excel formatting and keep that handy.

All the best!

4
Contact coach
0 comments
Clara
Coach
on Jan 28, 2022
McKinsey | Awarded professor at Master in Management @ IE | MBA at MIT |+180 students coached | Integrated FIT Guide aut

Hello!

Once you have started, there are a million of great and expensive internal resources you can leverage if you have time, I would 100% recommend that

Hope it helps!

Cheers, 

Clara

3
Contact coach
0 comments
Sign up for free to read all answers.
Sign up for free to read all answers.
Yes, I would like to be informed about new content, exciting jobs, relevant events, and selected employers.
By creating an account, I confirm that I agree to PrepLounge's Terms of Use. Please read our Privacy Policy.
Sign up with
You already have an account? Log in here.
Similar Questions
Consulting
Hi, I got an offer from McKinsey Paris!
on Sep 05, 2024
Global
6
1.5k
Top answer by
Ariadna
Coach
BCG | Project Leader and Experienced Interviewer | MBA at London Business School
66
6 Answers
1.5k Views
+3
Consulting
Onboarding prep: 1 week left, how to use time wisely?
on Sep 23, 2024
Global
7
1.3k
Top answer by
Alessa
Coach
xMcKinsey & Company | xBCG | +200 individual & group coachings | feel free to schedule a 15 min intro call for free
81
7 Answers
1.3k Views
+4
Consulting
Short Term MBB Internship
on Oct 24, 2024
Global
8
900+
Top answer by
luca
Coach
Former-BCG | >95% approval rate | Expert in BCG case and Risk
66
8 Answers
900+ Views
+5
Top Answer by
Ian
Coach
Top US BCG / MBB Coach - 5,000 sessions |Tech, Platinion, Big 4 | 9/9 personal interviews passed | 95% candidate success
To coach profile
Related Article
Excel for Consultants – Key Skills for Your Life as a Consultant
In this article you will learn which Excel skills are really important for consultants.
View article
Related Product
Prepped and Primed 3
5.0
31 reviews
USD 1,478
USD 1,185
More information
Related Case
Expert case by
Francesco
BCG Final Round Case - Sugar to Indonesia
3.7
3.7k times solved
Advanced
Candidate-led
Open case
Similar Questions
Consulting
Hi, I got an offer from McKinsey Paris!
on Sep 05, 2024
66
6
1.5k
Consulting
Onboarding prep: 1 week left, how to use time wisely?
on Sep 23, 2024
81
7
1.3k
Consulting
Short Term MBB Internship
on Oct 24, 2024
66
8
900+
Everything for Your Career
  • Interview Coaching
  • Q&A
  • Interview Partner
  • Mental Math Tool
  • Interview Drills
  • Stress Questions
  • Blog
Everything for Your Career
  • Interview Coaching
  • Q&A
  • Interview Partner
  • Mental Math Tool
  • Interview Drills
  • Stress Questions
  • Blog
Popular in Consulting
  • Case Library
  • Meeting Board
  • Interview Partner
  • Case Interview Basics
  • Case Interview
  • Consulting Q&A
Popular in Finance
  • Finance Q&A
  • Interview in Investment Banking
  • Investment Banking Salaries
Popular in Consulting
  • Case Library
  • Meeting Board
  • Interview Partner
  • Case Interview Basics
  • Case Interview
  • Consulting Q&A
Popular in Finance
  • Finance Q&A
  • Interview in Investment Banking
  • Investment Banking Salaries
Consulting and Finance Employers
  • RWE Consulting
  • Whiteshield Advisory
  • All Employers »
About PrepLounge
  • For Companies
  • For Universities
  • For Coaches
  • About Us
  • Career
  • FAQ
© 2012 PrepLounge
Our servers are powered by electricity from renewable sources.
  • Cookies & Privacy
  • Terms & Conditions
  • Imprint
  • Sitemap
  • Contact
Facebook Linkedin Instagram TikTok Youtube
Questions or Feedback?
Select category
  • Select category
  • General Feedback
  • Case Interview Preparation
  • Coaching
  • Technical Problems
  • Other
Your name
Your email address
Cancel