expert
Expert with best answer

Vlad

98% Recommendation Rate

359 Meetings

5,132 Q&A Upvotes

USD 229 / Coaching

How do I master excel within a few weeks?

Anonymous A asked on May 01, 2019 - 2 answers

I will be starting a consulting gig within 1 month and I need to master excel before going in. Are there any online courses that provide complete training with interactive worksheets and lots of data to actually practice?

2 answers

  • Upvotes
  • Date ascending
  • Date descending
Best Answer
Vlad
Expert
replied on May 01, 2019
McKinsey / Accenture / Got all BIG3 offers / More than 300 real MBB cases / Harvard Business School
Book a coaching with Vlad

98% Recommendation Rate

359 Meetings

5,132 Q&A Upvotes

USD 229 / Coaching

Hi,

You need to learn the following:

Basics

  • Fast excel - throw away your mouse and put some tape on your touchpad. Do everything with your keyboard!
  • The main formulas (especially vlookup, column, etc)
  • Pivot tables
  • Nice formating
  • Modeling - you need at least to know how to structure your sheets (Inputs, outputs, sources, versions, etc)

Advanced skills include:

  • Financial modeling (making proforma statement)
  • Valuation of projects / companies

The best offline courses are Training the street.

Best!

Guennael
Expert
replied on May 01, 2019
Ex-MBB, Experienced Hire; I will teach you not only the how, but also the why of case interviews
Book a coaching with Guennael

99% Recommendation Rate

263 Meetings

1,238 Q&A Upvotes

USD 269 / Coaching

Wallstreet prep is probably the best. To "excel" however, you will need to work on a project and actually creat models: just going through a course will never replace hands on experience.

Is one month enough time? Absolutely! Good luck, happy learning