expert
Expert with best answer

Andrea

100% Recommendation Rate

107 Meetings

754 Q&A Upvotes

USD 269 / Coaching

what excel skills do i need to start my consulting internship

Val asked on Feb 13, 2018 - 2 answers
2 answers

  • Upvotes
  • Date ascending
  • Date descending
Best Answer
Andrea
Expert
replied on Feb 13, 2018
Former BCG decision round interviewer with 300+ real interviews in 8 years
Book a coaching with Andrea

100% Recommendation Rate

107 Meetings

754 Q&A Upvotes

USD 269 / Coaching

To add to the above:

-Sensitivity tables (1 input, 2 input)

-Text manipulation functions (len,left,right, etc)

-Conditional functions (if, sumif, etc)

-Search functions (please use index/match instead of vlookup as it is more robust)

Vlad
Expert
replied on Feb 13, 2018
McKinsey / Accenture / Got all BIG3 offers / More than 300 real MBB cases / Harvard Business School
Book a coaching with Vlad

98% Recommendation Rate

358 Meetings

5,124 Q&A Upvotes

USD 229 / Coaching

Hi,

Depending on whether it is an MBA / Grad internship. For an MBA internship you are expected to know both basics and advanced:

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

Best!