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 Feb 07, 2018
Global
I want to receive updates regarding this question via email.

How to get quicker at Excel and PowerPoint for Consulting

Hello all,

I am going to start working within the next months as business Analyst at one of the top three consulting firms and would like to get tricks/ideas about how to get quicker with Excel and Powerpoint. Do you have any idea about trainings/websites that could be helpful?

Many thanks!

9
15.0k
42
Write an answer
Be the first to answer!
Nobody has responded to this question yet.
Top answer
Vlad
Coach
on Feb 07, 2018
McKinsey / Accenture Alum / Got all BIG3 offers / Harvard Business School

Hi,

1) Excel and Financial modeling - the best course I know is Training The Street. Take Financial Modeling, Valuation, Maybe LBO. They have the amazing templates that you have to repsoduce to be able to do that fast.

The key thing - throw away your mouse and put some tape on your touchpad. Do everything with your keyboard!

2) Power Point

  • First, read "Say it with charts" and "Pyramid Principle".
  • As a next step Google for MBB presentations on SlideShare and try to replicate them in PPT.
  • Finally, take MBA some cases (HBS or any other) and try to derive the conclusions and put them on slides using MBB styles.

And finally - take a long vacation before starting your job;)

Good Luck!

8
Contact coach
0 comments
Deleted user
on Jun 08, 2020

Dear A,

Congratulations to your offer!

It would be helpful for you to learn the business-focused Excel features.

In business, about 80% of your work will come from 20% of the functionality of the Microsoft Excel.

The core skills of a competent business Excel user are something like:

  • Formatting & basic formulas
  • Mouse-free Excel navigation
  • Vlookups & conditional statements
  • Data analysis - filtering, sorting, and analyzing data
  • Data visualization - tables, charts, and dual axis charts
  • What-if-analysis
  • Pivot tables

If you can do these things, you’ll outperform 95% of people in the workplace.

To learn these concepts, you could:

  • Learn the concepts online for free
  • Take an online course

If you’re looking for something free, I’d recommend Googling & Youtube-ing those topics on my list. Tons of free material online. On Udemy you can also find some courses. 

If you’re short on time, take a short business-focused online course.

I’d recommend the following business-focused course focused on mastering the 20% of functions that make up 80% of Excel work.

Best,

André

6
0 comments
Deleted user
edited on Jan 14, 2018
Originally answered question: Resource to learn Excel quickly

Training the street has online offering that is really solid (used for the people who report to me): https://www.ttsuniversity.com/Default.aspx

Another good one is ozgrid.com: http://www.ozgrid.com/

Hope it helps,

Andrea

5
0 comments
Deleted
Coach
on Feb 07, 2018
NOT AVAILABLE

Hey,

My 2 cents on the topic (especially on the powerpoint piece): if by any chance that consulting firm is McKinsey, I would strongly reccommend you to read "Say it with Charts" and "Say it with Presentation" (Gene Zelazny, a VA who has been with McKinsey for the last decades); these books are given in the initial training and contain everything you need to know about ppt... all the rest comes with practice and experience.

Anyway, my personal view (and it worths what it worths, as it is no fact, but just something built on my own personal experience as well as hundreds of McK colleagues that knew zero about excel/ppt in the day 0, and most of the people excels after 1 year) is that if I was in your position, I wouldn't spend much time worrying about these topics and would rather enjoy free time in general before getting into the buble called consulting :)

Best

Bruno

3
Contact coach
0 comments
Deleted user
on Feb 07, 2018

Agreed with other response: enjoy your free time, you will be given all the training needed and all the practice/exercise needed - sometimes more than you'd like :).

On PowerPoint the golden rule is that less words is best.

On Excel the only strong advice I can give, if you want to become a ninja, is not to buy or use a mouse. Ever. The moment you have it, it will be your crutch.

hope it helps,

andrea

3
0 comments
Francesco
Coach
on Feb 08, 2018
#1 Coach for Sessions (4.500+) | 1.500+ 5-Star Reviews | Proven Success: ➡ interviewoffers.com | Ex BCG | 10Y+ Coaching

Hi Anonymous,

congratulations for your offer! As mentioned, you will get a lot of training on both at the beginning; Vlad mentioned some additional good resources. In terms of Excel, I would just add one tip – try to master VLookUp and Pivot Tables – they will be some of the main tools you would use.

If you want to properly prepare, I would not consider technical skills only though. Consulting is a people business and can be highly stressful time to time, thus, would be equivalent important to prepare on:

  • Communication and people skills: a classic on the topic is the book “How to win friends and influence people” by Dale Carnegie. If you can have any kind of sales experience before that would also help a lot (a lot more than reading-only)
  • Stress management. I recommend “The Secret” by Rhonda Byrne.

For the long term these skills are actually more important then the technical ones.

A couple of things that could help you during your first weeks are instead the following:

  1. Take notes when your manager tells you something – this will help you to remember details and will show you care about them to the team.
  2. Align frequently with your manager on priorities and deadlines. Chances are you will always have too many things to do. Either you learn which things go first or you will risk to sleep very few hours in your first weeks ;)
  3. Ask for feedback every two-three weeks – this will show you are proactive and willing to learn.
  4. Always double check. First impression is very important in consulting: if you show you are reliable from the beginning, you will create a reputation of a reliable person.
  5. Ask for help when you don't know what to do – better to let know you are in trouble with meeting a deadline then missing the deadline.
  6. Be social and respectful with the support staff – these people are great and influential as well in the company.
  7. Start to build a weekly calendar the Sunday before. Allocate main tasks, both for private life and work. Will be though to do at the beginning but once you master this skill your productivity will skyrocket, as will force to think about your priorities a lot in advance.

Hope this helps,

Francesco

3
Contact coach
0 comments
Vlad
Coach
on Jan 14, 2018
McKinsey / Accenture Alum / Got all BIG3 offers / Harvard Business School
Originally answered question: Resource to learn Excel quickly

Hi,

Can't help with online, but the best offline courses are Training the street.

Best,

2
Contact coach
0 comments
Deleted
Coach
on Jan 14, 2018
Google Product Manager | Ex- BCG Consultant | References Available
Originally answered question: Resource to learn Excel quickly

Hi there

I would recommend actually an investment banking / PE recruitment guide like WallStreetOasis or Breaking Into Wall Street.

What you'd want to look for is any online modules or exercises that guides you through building a model for a business - I am fairly sure Breaking Into Wall Street has one about building an income forecast model. 

Jack

0
Contact coach
0 comments
Deleted user
on Feb 07, 2018

Agreed with other response: enjoy your free time, you will be given all the training needed and all the practice/exercise needed - sometimes more than you'd like :).

On PowerPoint the golden rule is that less words is best.

On Excel the only strong advice I can give, if you want to become a ninja, is not to buy or use a mouse. Ever. The moment you have it, it will be your crutch.

hope it helps,

andrea

0
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
What are the most effective techniques for gathering and prioritizing user requirements during the initial phases of a project?
on Jul 16, 2024
Global
2
800+
18
2 Answers
800+ Views
Consulting
Mediocre? feedback after McKinsey Interview (2nd round)
on Aug 01, 2024
Global
3
1.4k
30
3 Answers
1.4k Views
Consulting
Workshop Invitation
on Aug 09, 2024
Global
4
700+
18
4 Answers
700+ Views
Consulting
TOOLS/SOFTWARES that are required to become a consultant or business analyst
on Aug 16, 2024
Global
2
900+
34
2 Answers
900+ Views
Consulting
Recruiting process at MBB
on Aug 16, 2024
Global
2
1.0k
48
2 Answers
1.0k Views
Consulting
Ask a Consultant
MBB Target CGPA in Germany
on Aug 22, 2024
Global
2
1.1k
34
2 Answers
1.1k Views
Consulting
Hi, I got an offer from McKinsey Paris!
on Sep 05, 2024
Global
6
1.6k
66
6 Answers
1.6k Views
Consulting
Onboarding prep: 1 week left, how to use time wisely?
on Sep 23, 2024
Global
7
1.4k
81
7 Answers
1.4k Views
Consulting
Circular reference switch: when to turn on/ off?
on Oct 04, 2024
Global
2
1.2k
29
2 Answers
1.2k Views
Consulting
Urgent: Preparation for an MBB Internship
on Oct 22, 2024
Global
4
1.0k
44
4 Answers
1.0k Views
Consulting
Short Term MBB Internship
on Oct 24, 2024
Global
8
900+
66
8 Answers
900+ Views
Consulting
Why is consulting such long hours?
on Oct 29, 2024
Global
3
1.1k
39
3 Answers
1.1k Views
Consulting
Postponing McKinsey interview
on Nov 02, 2024
Global
6
600+
61
6 Answers
600+ Views
Consulting
Mckinsey Salaries
on Nov 19, 2024
Middle East
6
3.9k
50
6 Answers
3.9k Views
Consulting
Promotions
on Dec 29, 2024
Global
4
1.7k
19
4 Answers
1.7k Views
Consulting
McKinsey Dubai Hiring
on Dec 31, 2024
Global
2
900+
12
2 Answers
900+ Views
Consulting
Kearney Excel Test - Tips
on Jan 08, 2025
Global
3
1.3k
19
3 Answers
1.3k Views
Consulting
Business Analyst / McKinsey
on Mar 24, 2025
Global
8
600+
21
8 Answers
600+ Views
Consulting
Finance Intern - Hiring Process
on Apr 29, 2025
Global
4
200+
8
4 Answers
200+ Views
Consulting
alix partners
on May 01, 2025
Global
3
400+
9
3 Answers
400+ Views
Show more
Top Answer by
Vlad
Coach
McKinsey / Accenture Alum / Got all BIG3 offers / Harvard Business School
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
Bain 1st Round Case – AirService [NEW]
4.7
9.4k times solved
Intermediate
Candidate-led
Open case
Similar Questions
Consulting
What are the most effective techniques for gathering and prioritizing user requirements during the initial phases of a project?
on Jul 16, 2024
18
2
800+
Consulting
Mediocre? feedback after McKinsey Interview (2nd round)
on Aug 01, 2024
30
3
1.4k
Consulting
Workshop Invitation
on Aug 09, 2024
18
4
700+
Consulting
TOOLS/SOFTWARES that are required to become a consultant or business analyst
on Aug 16, 2024
34
2
900+
Consulting
Recruiting process at MBB
on Aug 16, 2024
48
2
1.0k
Consulting
Ask a Consultant
MBB Target CGPA in Germany
on Aug 22, 2024
34
2
1.1k
Consulting
Hi, I got an offer from McKinsey Paris!
on Sep 05, 2024
66
6
1.6k
Consulting
Onboarding prep: 1 week left, how to use time wisely?
on Sep 23, 2024
81
7
1.4k
Consulting
Circular reference switch: when to turn on/ off?
on Oct 04, 2024
29
2
1.2k
Consulting
Urgent: Preparation for an MBB Internship
on Oct 22, 2024
44
4
1.0k
Consulting
Short Term MBB Internship
on Oct 24, 2024
66
8
900+
Consulting
Why is consulting such long hours?
on Oct 29, 2024
39
3
1.1k
Consulting
Postponing McKinsey interview
on Nov 02, 2024
61
6
600+
Consulting
Mckinsey Salaries
on Nov 19, 2024
50
6
3.9k
Consulting
Promotions
on Dec 29, 2024
19
4
1.7k
Consulting
McKinsey Dubai Hiring
on Dec 31, 2024
12
2
900+
Consulting
Kearney Excel Test - Tips
on Jan 08, 2025
19
3
1.3k
Consulting
Business Analyst / McKinsey
on Mar 24, 2025
21
8
600+
Consulting
Finance Intern - Hiring Process
on Apr 29, 2025
8
4
200+
Consulting
alix partners
on May 01, 2025
9
3
400+
Show more
Questions by Categories
Questions about MBB
CV Questions
Personal Fit Questions
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