Dear Community,
I got an offer from a top consulting firm and will be starting soon. Until then, I am seeking to refresh my Excel skills, are there any recommended resources to do so? I would say I am on an intermediate level.
Regards
Dear Community,
I got an offer from a top consulting firm and will be starting soon. Until then, I am seeking to refresh my Excel skills, are there any recommended resources to do so? I would say I am on an intermediate level.
Regards
Hello!
Congrats of that offer!
Excel skills are part of the core skill-set of consultants, and it´s great that you want to practice them. PFB a list of the most popular commands:
There are plenty of online materials:
Hope it helps!
Cheers,
Clara
Hi!
Great to hear about your offer. Congrats!
Training the Street is great, but unfortunately they are quite expensive.
Coursera has some free courses now. You can check on their web. E.g. https://www.coursera.org/learn/excel-advanced
Have fun!
Emily
hello!
For sure! Here are some good ones I can recommend:
Finance & Quantitative Modeling for Analysts https://www.coursera.org/specializations/finance-quantitative-modeling-analysts#about 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 https://www.coursera.org/specializations/excel 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 https://www.coursera.org/learn/excel-advanced#syllabus 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.)
Best,
Daniel
Hello, I guess there are Excel courses on all major MOOC websites, on LinkedIn too... I like AbleOwl, it's maybe less well-known so I am sharing it here :-)
http://www.ableowl.com/
Kind regards,
Katharina
Hi,
You need to master the following:
Basics
Advanced skills include:
The best offline courses are Training the street.
Best!
Congrats and well done on your offer! Its great you are thinking about preparing well ahead of time.
To get really good at Excel as consultants use it, approach it in terms of:
1. Mechanics
2. Tools
3. Processes
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:
If you can do these things, you’ll outperform 95% of people in the workplace.
To learn these concepts, you could:
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é
Hi, on edx and coursera, by simply digiting "excel" in the search engine, you are going to find some good materials.
Best,
Antonello