member event

Excel Skills Workshop - Intermediate Skills

COMPANY Consulting Club
LOCATION Online - meeting link will be sent out
DATE 23 Mar 2020 18:15 -
23 Mar 2020 19:30

Polish your skills! Stuck with an Excel problem, and quite sure there has to be a simpler solution? A common scenario during university and when starting a consulting career.

With certain tricks from one of our Excel experts, you will be able to use Excel more efficiently and save time. Take this opportunity to improve your Excel skills for an internship in consulting and get useful tips and tricks on shortcuts among many other things.

The "Intermediate" Workshop covers:

  • Shortcuts
  • Best practices in consulting/IB internships (error testing, formual building, color formatting for inputs, grid lines, page break, lock edit cells, special search)
  • Formula tracking
  • Pivot tables
  • Useful functions in Consulting and Investment Banking
    • Index(match, match) vs Vlookup Sumifs 
    • Averagesifs 
    • Countifs
    • Indirect
    • Offset
  • Named ranges
  • Other helpful text and datefunctions

This is a member-only course with limited spots. Please bring your own device.

We look forward to seeing you there!