Best training datasets for learning Excel

Excel
Neue Antwort am 28. Okt. 2022
4 Antworten
739 Views
Anonym A fragte am 27. Okt. 2022

I am starting my MBB internship early next year. Before I start, I want to practice Excel. I know the most used commands, but I would like to practice on “real” data, not just passively read/watch videos.

Are there any Excel tutorials where you get tasks in actual Excel files? Eg. you have a lot of data in one sheet, and you are to create one specific graph or extract some information from the graph.

Übersicht der Antworten

Upvotes
  • Upvotes
  • Datum aufsteigend
  • Datum absteigend
Beste Antwort
Cristian
Experte
Content Creator
antwortete am 27. Okt. 2022
#1 rated MBB & McKinsey Coach

Hi there, 

Congrats on the offer and starting soon!

You might find the lessons here useful: https://www.guru99.com/excel-tutorials.html They're structured along the main sort of operations you'd need to use in consulting and they have sample databases that you can practice on. There is plenty of material there to keep you busy for a couple of weeks. 

However, while it's important to practice and it will surely make your life easier once you get started, you will be provided will all the training you need. So it might be worth also to enjoy the time you have until then. 

Best,

Cristian

War diese Antwort hilfreich?
Ian
Experte
Content Creator
antwortete am 27. Okt. 2022
#1 BCG coach | MBB | Tier 2 | Digital, Tech, Platinion | 100% personal success rate (8/8) | 95% candidate success rate

Hi there,

NYC Open Data is an awesome resource with real data sets (used by all kinds of data analytics training programs): https://opendata.cityofnewyork.us/

Also, a quick google search will pop up hundreds of practice datasets for you!

War diese Antwort hilfreich?
Anonym B bearbeitete die Antwort am 27. Okt. 2022

Kubicle is used by several consulting companies to train new joiners with “actual” excel files. It is a paid subscription service however for personal use. Hope it helps!

(editiert)

War diese Antwort hilfreich?
6
Maikol
Experte
Content Creator
antwortete am 28. Okt. 2022
BCG Project Leader | Former Bain, AlixPartner, and PE | INSEAD MBA | GMAT 780

You can find many open data sources (World Bank, American cities, etc) and you can implement there what you see in videos on YouTube.

Beyond learning functions, it is equally important to learn to structure your “model” and have a clear mind on what to do. 

Learning functions and implementing them is really basic, a great consultant should focus on modeling. Connected to that, my suggestion is to learn to create three financial statements from scratch. It may be even more than what is required in 90% of the projects, but it is an invaluable source of learning.



 

War diese Antwort hilfreich?
Cristian gab die beste Antwort

Cristian

Content Creator
#1 rated MBB & McKinsey Coach
670
Meetings
26.247
Q&A Upvotes
120
Awards
5,0
213 Bewertungen
Wie wahrscheinlich ist es, dass du uns einem Freund oder Kommilitonen empfiehlst?
0
1
2
3
4
5
6
7
8
9
10
0 = Nicht wahrscheinlich
10 = Sehr wahrscheinlich