1. Dashboard 1
  2. Consulting Q&A 2
  3. Best Excel Preparation Courses for Consulting 3
expert
Experte mit der besten Antwort

Nirmit

100% Empfehlungsrate

37 Meetings

198 Q&A Upvotes

229 USD / Coaching

Coaching vereinbaren
Profil von Nirmit anzeigen
4

Best Excel Preparation Courses for Consulting

Excel MBB preparation software

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!

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!

 Neue Antwort am 8. Jun 2020
754 Aufrufe
4 Antworten
  • Upvotes
  • Datum aufsteigend
  • Datum absteigend
Beste Antwort
Coaching mit Nirmit vereinbaren

100% Empfehlungsrate

37 Meetings

198 Q&A Upvotes

229 USD / Coaching

Wähle Deinen Wunschtermin
Profil von Nirmit anzeigen

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

Cheers,

Nirmit

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

Cheers,

Nirmit

2 Coaching mit Nirmit vereinbaren
Coaching mit Andre vereinbaren

100% Empfehlungsrate

65 Meetings

2.776 Q&A Upvotes

219 USD / Coaching

Wähle Deinen Wunschtermin
Profil von Andre anzeigen

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é

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é

0 Coaching mit Andre vereinbaren
Coaching mit Clara vereinbaren

100% Empfehlungsrate

40 Meetings

4.966 Q&A Upvotes

219 USD / Coaching

Wähle Deinen Wunschtermin
Profil von Clara anzeigen

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

Train the streets p.e.

Cheers!

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

Train the streets p.e.

Cheers!

0 Coaching mit Clara vereinbaren
Coaching mit Udayan vereinbaren

100% Empfehlungsrate

51 Meetings

917 Q&A Upvotes

179 USD / Coaching

Wähle Deinen Wunschtermin
Profil von Udayan anzeigen

Train the street hands down

Train the street hands down

0 Coaching mit Udayan vereinbaren

Verwandte Cases

Espresso, Whatelse?

3,4 Tsd. mal gelöst
Espresso, Whatelse? Espresso Whatelse is an Italian company that produces coffee and espresso machines since 1908. It is the Italian market leader and has a strong presence overall in Europe. In 2019, Espresso Whatelse has increased its revenues but it has seen declining profit margin. Your client wants to understand the root causes of this 2019 trend and how to increase its profit margin again.  
4.7 5 173
| Bewertung: (4.7 / 5.0)
Schwierigkeit: Schwierig | Stil: Interviewer-led (McKinsey-Stil) | Themen: Marktanalyse, Operations Strategy, Preisgestaltung, Profitabilitätsanalyse

Espresso Whatelse is an Italian company that produces coffee and espresso machines since 1908. It is the Italian market leader and has a strong presence overall in Europe. In 2019, Espresso Whatelse has increased its revenues but it has seen declining profit margin. Your client wants to understand ... Ganzen Case öffnen

MBB Final Round Case - Smart Education

3,3 Tsd. mal gelöst
MBB Final Round Case - Smart Education Our client is SmartBridge, a nonprofit educational institution offering face-to-face tutoring services. The client operates in the US. The mission of SmartBridge is to help as many students as possible to complete studies and prevent that they drop from the school system, in particular in disadvantaged areas. The client is considering starting operations for its services in the Chicago area. They hired us to understand if that makes sense. Due to the nonprofit regulation, SmartBridge should operate on its own in the market, without any partnership. How would you help our client?
4.6 5 125
| Bewertung: (4.6 / 5.0)
Schwierigkeit: Schwierig | Stil: Interviewer-led (McKinsey-Stil) | Themen: Wachstumsstrategie, Marktanalyse, Markteintritt, Neues Produkt

Our client is SmartBridge, a nonprofit educational institution offering face-to-face tutoring services. The client operates in the US. The mission of SmartBridge is to help as many students as possible to complete studies and prevent that they drop from the school system, in particular in disadvant ... Ganzen Case öffnen

Coronavirus Times - COVID-19 Brainteaser

1,0 Tsd. mal gelöst
Coronavirus Times - COVID-19 Brainteaser You and your family are faced with a challenging set of decisions. Due to coronavirus, your partner has taken a 20% paycut and you are worried you may lose your job. In addition, while daycare is still open, you are worried that sending your two children there will increase the risk of them bringing the virus back to your house, where your elderly grandparents are also staying. How would you go about thinking about this problem, and what would you recommend?
4.6 5 26
| Bewertung: (4.6 / 5.0)
Schwierigkeit: Anfänger | Stil: Brainteaser | Themen: Brainteaser

You and your family are faced with a challenging set of decisions. Due to coronavirus, your partner has taken a 20% paycut and you are worried you may lose your job. In addition, while daycare is still open, you are worried that sending your two children there will increase the risk of them bringing ... Ganzen Case öffnen

Chinese Chess - Airline Business During COVID-19

800+ mal gelöst
Chinese Chess - Airline Business During COVID-19 Sky China, a government-backed Chinese airline, has recently seen profits plummet due to COVID-19. Profits are down 80% in the months of February and March, but are showing early signs of a rebound in April.  They've brought you in to first investigate what can be done immediatedly to prevent hemorrhaging cash and surive in the short-term. They are also looking to see how the current situation can be viewed as an opportunity, and what can be done to prepare for the future. 
4.4 5 21
| Bewertung: (4.4 / 5.0)
Schwierigkeit: Fortgeschritten | Stil: Candidate-led (üblicher Stil) | Themen: Kapazitätsänderung, Wettbewerbsreaktion, Wachstumsstrategie, Operations Strategy, Organisationsverhalten, Profitabilitätsanalyse

Sky China, a government-backed Chinese airline, has recently seen profits plummet due to COVID-19. Profits are down 80% in the months of February and March, but are showing early signs of a rebound in April. They've brought you in to first investigate what can be done immediatedly to prevent hemor ... Ganzen Case öffnen

Hot Wheels

500+ mal gelöst
Hot Wheels Problem definition: Our client is Korean Car Parts (KCP), a multi-national original equipment manufacturer (OEM) of car parts based in Korea. They've recently seen a decline in profits and have brought us in to understand how to address this falling profitability.
4.3 5 15
| Bewertung: (4.3 / 5.0)
Schwierigkeit: Fortgeschritten | Stil: Candidate-led (üblicher Stil) | Themen: Wettbewerbsreaktion, Wachstumsstrategie, Marktanalyse, Operations Strategy, Profitabilitätsanalyse

Problem definition: Our client is Korean Car Parts (KCP), a multi-national original equipment manufacturer (OEM) of car parts based in Korea. They've recently seen a decline in profits and have brought us in to understand how to address this falling profitability. Ganzen Case öffnen

Ähnliche Fragen

McKinsey's Reply to my application
Average Price Decrease ?
MBB Recruitment System Ban
Adminstrative Question - How do consulting firms apply to visas for their consultants while they are abroad
Can I reapply to McKinsey after I failed the resume round?
Accounting Studies
Similarity b/w Mck PST and BCG Potential Test
Moving from BCG to McKinsey
Does the McKinsey Imbellus test apply to the Associate role as well?
MBB Hiring in Middle East, India and SouthEast Asia
Stelle eine Frage

Verwandte Unternehmen

Karriere & Bewerbung bei Bain & Company