What Level of Profiency for Excel is expected of an IB Intern?

Based on the most helpful WSO content, investment banks generally do not expect interns to have an extremely advanced level of Excel proficiency right off the bat. However, having a solid grasp of key functions, shortcuts, and formatting techniques is crucial to performing well and standing out. Here's what you should focus on:

Key Excel Skills to Master:

1. Functions to Know:

   • Lookup functions: VLOOKUP, HLOOKUP, INDEX, MATCH
   • Conditional functions: IF, SUMIF, COUNTIF
   • Basic math and aggregation: SUM, AVERAGE, ROUND
   • Text functions: CONCATENATE, LEFT, RIGHT, TRIM
   • Error handling: IFERROR

2. Shortcuts to Practice:

   • Navigation: Quickly moving between sheets, rows, and columns.
   • Formatting: Adjusting column widths, applying borders, and using number formats.
   • Efficiency: Copying formulas, anchoring cells with $, and using Ctrl + D or Ctrl + R to fill data.

3. Formatting and Presentation:

   • Clean and professional formatting is critical. Ensure your spreadsheets are easy to read and visually appealing.
   • Use consistent fonts, colors, and alignment.

4. Troubleshooting:

   • Learn how to audit formulas and troubleshoot errors using tools like Trace Precedents and Trace Dependents.

What to Expect on the Job:

• On-the-Job Learning: Many firms understand that interns are still learning and will provide guidance. However, being proactive and showing a willingness to improve will set you apart.
• Low Expectations Initially: Expectations are typically low at the start of the internship. Focus on mastering the basics and double-checking your work to avoid mistakes.
• Attention to Detail: Even if your Excel skills aren't perfect, ensuring your work is error-free and well-organized will make a strong impression.

How to Prepare:

• Practice Beforehand: Use online resources, Excel tutorials, or financial modeling courses to brush up on your skills.
• Cheat Sheets: Keep a list of essential shortcuts and functions handy for quick reference.
• Templates: Familiarize yourself with financial modeling templates to understand how spreadsheets are structured in IB.

Remember, while technical skills are important, your attitude, work ethic, and ability to communicate effectively will play an equally significant role in your success as an intern.

Sources: What to expect/how to excel in a SA IB internship, Preparing for an IB internship, How should I prepare to be a good intern?, IB duties for Intern - more modeling or pitchbooks?, To All Freshman and Sophomores