member event

Excel Skills Workshop - Intermediate Skills

COMPANY Consulting Club
LOCATION 01-U179
DRESS CODE
DATE 16 Apr 2019 19:00 -
16 Apr 2019 21:00

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/IB
    • Index(match, match) vs Vlookup Sumifs 
    • Averagesifs 
    • Countifs
    • Indirect
    • Offset
  • Named ranges
  • Other helpful text and datefunctions

This is a member-only course with unlimited spots. Windows computers will be availbale.

We look forward to seeing you there!