Hi there,

You have a few options here:

1. Learn on the job
2. Ask your colleagues
3. Do the online/internal trainings
4. Find online tutorials/trainings (there are a million)
5. “Create” you own training by playing around with a big dataset or modelling our your own scenario

In terms of skills, you will need to be quite proficient at Excel, depending on the client/project. This does not mean knowing VBA! Just as an example, you'll need to know functions like indexmatch, pivot tables, data cleaning/manipulation, modeling, etc.

Helpful Prior Q&A

https://www.preplounge.com/en/consulting-forum/free-online-resources-to-learn-excel-basics-6946

https://www.preplounge.com/en/consulting-forum/what-excel-prep-course-do-you-recommend-9795

Hi there,

Good on you for trying to get ahead of the game! However, my big advice is to relax! 

This is a challenge that many people face and is therefore expected by your future employer. Once you join, they will generally provide you with plenty of training. Most of it on the job but also good formal training for Excel or other modeling software (depending on firm).

There's no standard models and people build models very differently, even for the same purpose/problem. Hence, wait until you can look over the shoulder of your future colleagues who have a bit more seniority and learn from them.

If what you're saying is that you have no clue how to use excel in the first place, then I can point you in the direction of some resources. However, that would seem a little odd considering your career choice.

Hope this helps a bit. Best of luck!