I am a former BCG decision round interviewer with 300+ real interviews conducted and 8 years interviewing experience
Book a coaching

what excel skills do i need to start my consulting internship

Val
  • Upvotes
  • Date ascending
  • Date descending
Andrea
Expert
replied on 02/13/2018
I am a former BCG decision round interviewer with 300+ real interviews conducted and 8 years interviewing experience

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 replied on 02/13/2018
McKinsey / Accenture / Got all BIG3 offers / More than 300 real MBB cases / Harvard Business School

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!