Best Excel Preparation Courses for Consulting

Question

Hey everyone,

in about a month, I will start working for MBB. Since I have some spare time now and do not have a traditional business background, I am looking for good excel courses that are not too expensive and add the most value with regard to typical entry level tasks. Otherwise, I'd also appreciate an overview of topics that you consider most important, so I can take a look at those on my own as well (I am thinking of Pivot tables, VBA, macros etc.) or even other softwares that are used frequently. I just want to avoid having to spend too much time in the first few weeks acquainting myself with rather basic concepts.

Thanks in advance!

Answer 1

See if you can get your hands on matrial for Train the Street. Pretty impactful

Cheers,

Nirmit

Answer 2

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é

Answer 3

Train the street hands down

Answer 4

Super recommendable, it´s gonna make the difference between a good and a bad lifestyle.

Train the streets p.e.

Cheers!