Schedule mock interviews on the Meeting Board, join the latest community discussions in our Consulting Q&A and find like-minded Case Partners to connect and practice with!

Financial modeling online course

courses Finance Financial Model online courses
New answer on Mar 23, 2020
3 Answers
1.9 k Views
Anonymous A asked on Mar 21, 2020

Hi everyone!

I recently accepted an offer to join a top-tier strategy firm and I have some time before starting. One thing I'd like to do is getting up-to-speed with financial modeling. Apart from Training the Street, which I find rather expensive, do you have any other recommended online course?


Overview of answers

  • Upvotes
  • Date ascending
  • Date descending
Best answer
Content Creator
replied on Mar 21, 2020
McKinsey / ex-Interviewer at McKinsey / I will coach you to rock those interviews


For sure! Here are some good ones I can recommend:

  • Finance & Quantitative Modeling for Analysts This is good if you are a beginner. What I like about this one is that you will be creating your own model as part of the course (financial modelling is all about learning by doing)

  • Excel Skills for Business Specialization This one is also good for beginners – it gives you an overview of how to work with big data sets (like using vlookup)

  • Excel Skills for Business: Advanced As the name says it, it's for a bit more advanced excel users. It gives a lot of best practice recommnedations on how to design your models (keeping spreadsheets clean, data organization, etc.)

I've read on the news the other day that Coursera also gives free access to their courses to everybody who is now on quarantine, so if you are in one of the quarantined countries, you are lucky – in some sense :)

Was this answer helpful?
Content Creator
replied on Mar 22, 2020
McKinsey | Awarded professor at Master in Management @ IE | MBA at MIT |+180 students coached | Integrated FIT Guide aut

Hello, congrats on the offer!

It´s great you want to spend some time on this, and even better now half of the world is locked down...

My recommendation would be:

  • Excel & financial modeling > Training The Street (e.g., Financial Modeling, Valuation, pivot tables, statistics tools, etc.) Sucess here would be to forget your mouse and do everything with your keyboard.
  • Power Point (This is also sooooooooo important) > Read "Say it with charts" and "Pyramid Principle" and try to replicate later good presentations in PPTX (e.g., you can take any of the ones published in McKinsey Global Institute that are also a fanctastic read!)

Hope it helps!



Was this answer helpful?
Content Creator
replied on Mar 23, 2020
McKinsey | NASA | top 10 FT MBA professor for consulting interviews | 6+ years of coaching

Hi, congrats for the offer!
I confirm the material suggested here by the coaches is great. However, I recommend not struggling too much with preparation, since you are not supposed to be an expert of modeling and you'll have a huge amount of time on the ground to learn it. Enjoy this period :)


Was this answer helpful?
Daniel gave the best answer


Content Creator
McKinsey / ex-Interviewer at McKinsey / I will coach you to rock those interviews
Q&A Upvotes
121 Reviews
How likely are you to recommend us to a friend or fellow student?
0 = Not likely
10 = Very likely
You are a true consultant! Thank you for consulting us on how to make PrepLounge even better!