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 Jun 01, 2020
Global
I want to receive updates regarding this question via email.

Free online resources to learn Excel basics

Hello, 

I am looking for ONLINE FREE materials to learn Excel. 

From zero to "acceptable" level:

  • Simple formulas & tools: formating, sorting, sum, average, vlookup, etc.
  • Conditional formulas: sumif, averageif, etc.
  • Pivot tables

It can be videos, free courses or tutorials, whatever works!

Thanks for any hint!

5
4.6k
32
Write an answer
Be the first to answer!
Nobody has responded to this question yet.
Top answer
Deleted user
edited 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.

Also, for candidates like you, who have already secured the offer with a leading consulting firm, I have designed my program "Get ready for the first 100 days " as well as long-term career planning. This program touches all the important aspects: the mindset, the skills, knowledge, networking and ,managing yourself as well, your bosses and clients - everything that is important in your successful career. 

In fact, I'm sharing my knowledge of 6 years career experience in consulting, where I was able to land on the fast track promotion and to be promoted from consultant to a project manager just within 3 years, which is extremely fast. 

Happy to share these insights with you, feel free to reach out directly to me.

Good luck,

André

4
0 comments
Deleted user
on Jun 01, 2020

Hi, 

You can have a look at this youtube chain 

https://www.youtube.com/playlist?list=PL_iwD7O7FG7jzLQIYm6-9Gx3hvXVUG7C5

There are a lot of tutorials on typical Excel functions (e.g. vlookup, pivot tables , ...). You can select the videos the most relevant for you.

Hope it helps

David

3
0 comments
Deleted
Coach
on Jun 01, 2020
Dubai|5+ years | Activity on hold

Hi there,

For me, I find the youtube channel of Leila Gharani very helpful (https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA)

She speaks a bit too slow for me, so I recommend to listen to her at 1.75 speed :) and she gives really good tutorials from basic stuff (e.g, conditional formatting) to advanced technique (e.g, data tables, pivot tables, dashboards)

Hope this helps

Khaled

3
Contact coach
0 comments
Ian
Coach
on Jun 02, 2020
Top US BCG / MBB Coach - 5,000 sessions |Tech, Platinion, Big 4 | 9/9 personal interviews passed | 95% candidate success

Hi there,

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 :)

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

Hello! See on top the below

https://www.preplounge.com/en/consulting-forum?query=excel&status[]=own-answers-only&tab=your&company-session-id=0&sort=most-relevant-desc&page=1&perPage=20

1
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 Feb 28, 2025
Global
6
1.2k
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.2k Views
+3
Consulting
Onboarding prep: 1 week left, how to use time wisely?
on Oct 02, 2024
Global
7
900+
Top answer by
Hagen
Coach
#1 recommended coach | >95% success rate | 8+ years consulting, 8+ years coaching and 7+ years interviewing experience
81
7 Answers
900+ Views
+4
Consulting
Finance Intern - Hiring Process
on Apr 30, 2025
Global
4
100+
Top answer by
Daniel
Coach
Ex-McKinsey, Bain & Kearney | 5+ yrs consulting, coaching & interviewing | 95%+ candidate success
7
4 Answers
100+ Views
+1
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.6k times solved
Advanced
Candidate-led
Open case
Similar Questions
Consulting
Hi, I got an offer from McKinsey Paris!
on Feb 28, 2025
66
6
1.2k
Consulting
Onboarding prep: 1 week left, how to use time wisely?
on Oct 02, 2024
81
7
900+
Consulting
Finance Intern - Hiring Process
on Apr 30, 2025
7
4
100+
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
How likely are you to recommend us to a friend or fellow student?
0
1
2
3
4
5
6
7
8
9
10
0 = Not likely
10 = Very likely
Submit feedback
Thanks for your feedback! Your opinion helps us make PrepLounge even better.
Close Close and keep on prepping
Want to leave already?
After your registration you have free access to:
12 mock interviews with peers
360.000+ peers in our community
36 exercises (incl. structuring drills, mental math, brainteasers and more)
Video tutorials
Video case solutions
Sign up for free
Questions or Feedback?
Select category
  • Select category
  • General Feedback
  • Case Interview Preparation
  • Coaching
  • Technical Problems
  • Other
Your name
Your email address
Cancel