what excel skills do i need to start my consulting internship

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)

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!