PrepLounge - Link zur Homepage PrepLounge - Link zur Homepage
General General
Consulting Finance General
Login Kostenlos anmelden Kostenlos anmelden
Consulting Finance General
Community
Meeting-Board
Q&A
Interview-Partner
Premium-Mitgliedschaft
Coaching
Coaches
Coaching-Pakete
Q&A
Übungsmaterial
Case-Interview-Basics
Case-Sammlung
Tests & Guides
Kopfrechen-Tool
Stressfragen-Modus
Drills
Brainteaser
Karriere
Arbeitgeber
Karriere-Events
Speed Recruiting
Stellenangebote
Blog
Kostenlos anmelden
Login
Community
Meeting-Board
Q&A
Interview-Partner
Premium-Mitgliedschaft
Coaching
Coaches
Coaching-Pakete
Q&A
Übungsmaterial
Case-Interview-Basics
Case-Sammlung
Tests & Guides
Kopfrechen-Tool
Stressfragen-Modus
Drills
Brainteaser
Karriere
Arbeitgeber
Karriere-Events
Speed Recruiting
Stellenangebote
Blog
Verabrede dich zum Casen über das Meeting-Board, nimm an Diskussionen in unserem Consulting Q&A teil und finde gleichgesinnte Interview-Partner:innen, um dich auszutauschen und gemeinsam zu üben!
Meeting-Board
Q&A
Interview-Partner
Premium-Mitgliedschaft
Zurück zur Übersicht
Anonym A
am 1. Mai 2019
Global
Ich möchte Updates zu der Frage per E-Mail erhalten.

How do I master excel within a few weeks?

I will be starting a consulting gig within 1 month and I need to master excel before going in. Are there any online courses that provide complete training with interactive worksheets and lots of data to actually practice?

4
2,4k
8
Schreibe eine Antwort
Schreibe die erste Antwort!
Bisher hat niemand auf diese Frage reagiert.
Beste Antwort
Vlad
Coach
am 1. Mai 2019
McKinsey / Accenture Alum / Got all BIG3 offers / Harvard Business School

Hi,

You need to learn the following:

Basics

  • Fast excel - throw away your mouse and put some tape on your touchpad. Do everything with your keyboard!
  • The main formulas (especially vlookup, column, etc)
  • Pivot tables
  • Nice formating
  • Modeling - you need at least to know how to structure your sheets (Inputs, outputs, sources, versions, etc)

Advanced skills include:

  • Financial modeling (making proforma statement)
  • Valuation of projects / companies

The best offline courses are Training the street.

Best!

3
Coach kontaktieren
0 Kommentare
Guennael
Coach
am 1. Mai 2019
Ex-MBB, Experienced Hire; I will teach you not only the how, but also the why of case interviews

Wallstreet prep is probably the best. To "excel" however, you will need to work on a project and actually creat models: just going through a course will never replace hands on experience.

Is one month enough time? Absolutely! Good luck, happy learning

1
Coach kontaktieren
0 Kommentare
Clara
Coach
am 26. Dez. 2019
McKinsey | Awarded professor at Master in Management @ IE | MBA at MIT |+180 students coached | Integrated FIT Guide aut

Hi!

Super recommended that you do a refreshment on the basics, any in the internet will do. 

Cheers!

0
Coach kontaktieren
0 Kommentare
Gelöschter Nutzer
am 8. Juni 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é

0
0 Kommentare
Ähnliche Fragen
Consulting
Hi, I got an offer from McKinsey Paris!
am 5. Sept. 2024
Global
6
1,6k
Beste Antwort von
Ariadna
Coach
BCG | Project Leader and Experienced Interviewer | MBA at London Business School
66
6 Antworten
1,6k Aufrufe
+3
Consulting
Onboarding prep: 1 week left, how to use time wisely?
am 23. Sept. 2024
Global
7
1,3k
Beste Antwort von
Alessa
Coach
xMcKinsey & Company | xBCG | +200 individual & group coachings | feel free to schedule a 15 min intro call for free
81
7 Antworten
1,3k Aufrufe
+4
Consulting
Short Term MBB Internship
am 24. Okt. 2024
Global
8
900+
Beste Antwort von
luca
Coach
Former-BCG | >95% approval rate | Expert in BCG case and Risk
66
8 Antworten
900+ Aufrufe
+5
Beste Antwort von
Vlad
Coach
McKinsey / Accenture Alum / Got all BIG3 offers / Harvard Business School
Zum Coach-Profil
Verwandter Artikel
Excel für Consultants – Skills für deinen Alltag als Consultant
In diesem Artikel erfährst du, welche Excel Skills als Consultant wirklich wichtig sind.
Zum Artikel
Verwandter Case
Expertencase von
Francesco
BCG Final Round Case - Sugar to Indonesia
3,7
3,7k mal gelöst
Schwierig
Candidate-led
Case öffnen
Ähnliche Fragen
Consulting
Hi, I got an offer from McKinsey Paris!
am 5. Sept. 2024
66
6
1,6k
Consulting
Onboarding prep: 1 week left, how to use time wisely?
am 23. Sept. 2024
81
7
1,3k
Consulting
Short Term MBB Internship
am 24. Okt. 2024
66
8
900+
Alles für deine Karriere
  • Interview-Coaching
  • Q&A
  • Interview-Partner
  • Kopfrechen-Tool
  • Interview-Drills
  • Stressfragen-Modus
  • Blog
Alles für deine Karriere
  • Interview-Coaching
  • Q&A
  • Interview-Partner
  • Kopfrechen-Tool
  • Interview-Drills
  • Stressfragen-Modus
  • Blog
Beliebt im Consulting
  • Case-Sammlung
  • Meeting-Board
  • Interview-Partner
  • Case-Interview-Basics
  • Case-Interview
  • Consulting Q&A
Beliebt in Finance
  • Finance Q&A
  • Interview im Investment-Banking
  • Gehälter im Investment Banking
Beliebt im Consulting
  • Case-Sammlung
  • Meeting-Board
  • Interview-Partner
  • Case-Interview-Basics
  • Case-Interview
  • Consulting Q&A
Beliebt in Finance
  • Finance Q&A
  • Interview im Investment-Banking
  • Gehälter im Investment Banking
Arbeitgeber im Consulting und Finance
  • Bain & Company
  • BCG Platinion
  • BearingPoint Deutschland
  • Deloitte
  • DHL Consulting
  • EY
  • EY-Parthenon
  • Forvis Mazars
  • FTI-Andersch AG
  • Inverto, a BCG company
  • Kearney
  • Mercedes-Benz Management Consulting
  • Oliver Wyman
  • Roland Berger
  • RSM Ebner Stolz Management Consultants
  • RWE Consulting
  • Simon-Kucher
  • Stern Stewart & Co.
  • Struktur Management Partner
  • Telekom Strategy Consulting
  • thyssenkrupp Management Consulting
  • zeb Consulting
  • Alle Arbeitgeber »
Über PrepLounge
  • Für Unternehmen
  • Für Hochschulen
  • Für Coaches
  • Über uns
  • Karriere
  • FAQ
© 2012 PrepLounge
Unsere Server werden mit Strom aus erneuerbaren Quellen betrieben.
  • Cookies & Datenschutz
  • AGB
  • Impressum
  • Sitemap
  • Kontakt
Facebook Linkedin Instagram TikTok Youtube
Fragen oder Feedback?
Wähle eine Kategorie
  • Wähle eine Kategorie
  • Allgemeines Feedback
  • Case-Interview-Vorbereitung
  • Coaching
  • Technische Probleme
  • Andere
Dein Name
Deine E-Mail-Adresse
Abbrechen