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 Mar 31, 2021
Global
I want to receive updates regarding this question via email.

What Excel Prep course do you recommend?

I am beginning an internship in consulting and wanted to take a course in excel beforehand to prepare. I have heard that Train the Streets is great, but I was looking for something more economical. I spotted some courses on Udemy, but don't know which to pick. Do you have any specific courses you could recommend?

5
2.7k
28
Write an answer
Be the first to answer!
Nobody has responded to this question yet.
Top answer
Deleted user
on Mar 31, 2021

Have a look at this thread: https://www.preplounge.com/en/consulting-forum/excel-skills-9465

17
0 comments
Denis
Coach
on Apr 01, 2021
Goldman Sachs Investment Banker NYC | Ex-Bain 5 yrs| MBA Chicago Booth | Passed > 13 MBB > 20 IB interviews

I liked Wall Street Prep, Break Into Wall Street, Udemy, Coursera. There are a lot of good ones - make sure not to overdo Excel since it would be more beneficial for you to be proficient in

MS Outlook including EFFICIENT use of calendar - look on Youtube for Outlook pro usersMS One Note - forget paper based Todo lists - that is the way to go

You would not believe how many people have messy calendars, cannot send proper meeting invites, dont know how to properly sort inbox and have no proper folder structure. This is the tool that will be open 24/7 on your laptop and the piece of software you use the most.


MS PPT - make sure you are proficient with how to use PPT in its basic form although all firms have special customized software within PPT so save you time

12
Contact coach
0 comments
Antonello
Coach
on Mar 31, 2021
McKinsey | NASA | top 10 FT MBA professor for consulting interviews | 6+ years of coaching

Hi, I appreciate Udemy and Coursera's proposals.

Best,
Antonello

7
Contact coach
0 comments
Ian
Coach
on Apr 01, 2021
Top US BCG / MBB Coach - 5,000 sessions |Tech, Platinion, Big 4 | 9/9 personal interviews passed | 95% candidate success

Hi there,

This is great that you're preparing for this role ahead of time! Just remember, you do not need to be an absolutel whiz before you start. Most courses will do the trick, so just pick whichever one seems to suit your learning style best.

Here are a few to start you off:

A few good resources:

https://blog.hubspot.com/marketing/learn-excel-resources

https://www.udemy.com/share/101Wde/ (Udemy is excellent. $15...basically free)

Important Tip: Don't just learn formulas etc. Test yourself! Download a free data set, ask yourself a question, and try to solve for it. Play with actual data solving real questions and building a real dashboard etc. Don't just passively take lessons :)

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

Hello!

Congrats of that offer!

If there is one thing I wish I had done before joining McKinsey, that would have been Excel. So great that you are thinking about this now, since it can really be a game changer, so I would really focus on that (more than pptx, industry knowledge, etc., that are nice-to-have, but not deal breakers).

Train the Street is great, but get any that makes you familiar with:

Basic operations: SUM, SUMPRODUCT

Text transformations: CONCATENATE, LEFT, RIGHT, & operator,

Connecting different datasets: VLOOKUP, HLOOKUP, INDEX(MATCH(),MATCH())

Conditional-based operations: SUMIF, COUNTIF, SUMIFS, COUNTIFS, COUNTA

Learn how to analyze data using Pivot Tables

There are plenty of online materials:

Microsoft Support: https://support.office.com/en-us/excel

Kubicle: https://kubicle.com/personal (go for the 7 days free trial - Excel for Business Analytics)

Hope it helps!

Cheers,

Clara

0
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
Florian
Coach
1400 5-star reviews across platforms | 600+ offers | Highest-rated case book on Amazon | Uni lecturer in US, Asia, EU
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
Hagen
Coach
#1 recommended coach | >95% success rate | 9+ years consulting, 9+ years coaching and 8+ years interviewing experience
81
7 Answers
1.3k Views
+4
Consulting
Short Term MBB Internship
on Oct 24, 2024
Global
8
800+
Top answer by
Hagen
Coach
#1 recommended coach | >95% success rate | 9+ years consulting, 9+ years coaching and 8+ years interviewing experience
66
8 Answers
800+ Views
+5
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 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
800+
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
  • Case 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
  • Case 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
Questions or Feedback?
Select category
  • Select category
  • General Feedback
  • Case Interview Preparation
  • Coaching
  • Technical Problems
  • Other
Your name
Your email address
Cancel