Excel Training - Advanced
27 Nov 2017 20: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.
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 or attend our Excel Training - Basic. This is a member-only course with unlimited spots. We ask you to bring your own device.