member event

Excel Skills Workshop

COMPANY Consulting Club
LOCATION University of St. Gallen, 01-U179
DATE 12 Nov 2018 20:00 -
12 Nov 2018 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.

Content:

  • Concatenate, Text to columns, Proper, upper, lower, Graphs and charts, Pasting tables and charts on ppt as an excel linked object and refreshing link, Pivot, Vlookup, Conditional formatting, Filter, Find and replace – formulas, Viewing formulas, Formula tracing, External links, Rank, Duplicates, Paste special, Print formatting, Working on grouped sheets, Sumif and countif, Sumifs and countifs, Sumproduct, Cleaning raw data

  • Building a financial databook (typical template in a due diligence on an M&A)

This is the advanced Excel course, so you have to have Excel knowledge. This is a member-only course with unlimited spots. We ask you to bring your own device. 

We look forward to seeing you there!