We’re only days away from the ModelOff Global Training Camp 2015 in London, presented by Microsoft at their Cardinal Place offices. The agenda is almost fully set and there are 32 world-class training sessions open to the 250-plus registrants.
Three streams will run throughout the GTC: Financial Analysis and Modelling, Corporate Finance and Advanced Excel. With more than 40 world-class trainers and presenters from the UK, Europe and around the world also descending on London for the event, participants have the opportunity to meet, learn from and share with some of the industry’s foremost financial and analytical minds. It makes for some tough choices ahead for GTC participants! In Part 1 of the GTC Preview, we looked at some of the highlights across the Financial Analysis and Corporate Finance Streams.
Here is Part 2, which focuses on the sessions hosted by the Microsoft Excel Product and Engineering Teams in the Advanced Excel Stream. It is in no way intended to be exhaustive and we encourage you to keep an open mind for all GTC sessions to see which suit your skills, interests and needs the most.
1. What’s new in Excel 2016?
Presenter: Eli Schwartz
Time: Thursday morning
Brief: Are you using Excel every day to analyse data and derive insights from it? Are you interested in learning what’s coming in Excel 2016 and how we’ve improved it as the hero tool for business analytics? If so, then this session is for you! Come see the innovations coming in 2016, learn how Excel can better empower you to gather the data around you, get to the insights that matter, and share them to make an impact.
2. Advanced Analysis & Power Pivot
Presenters: Ashvini Sharma and MVP Henk Vlootman
Time: Thursday late morning
Brief: In this session, we’ll cover Power Pivot, a set of features that make it incredibly easy to perform analysis with large volumes of data in Excel, and DAX, a calculation language designed with you in mind. We’ll also briefly look at how to perform analysis over uncertain data!
3. Excel Everywhere
Presenter: Sangeeta Mudnal
Time: Friday morning
Brief: In this session you will learn about our vision for Excel on iOS, Android, Windows mobile, Mac and Excel Online including our approach to shared code. We will also share some of the amazing strides we have made across the mobile platforms with great demos, so be sure to come with Excel installed on your mobile device and follow along.
4. Data acquisition in Excel using Power Query and Data cleansing & manipulation
Presenters: Dany Hoter & Joe McDaid
Time: Friday late morning
Brief: not available at time of publication
5. Keynote: Spreadsheet archaeology: what can we learn for examining spreadsheets?
Presenter: Felienne Hermans
Time: Friday late afternoon
Brief: When the Enron energy corporation went bankrupt, university researchers acquired a subset of their emails. Felienne Hermans of Delft University of has examined those emails, specifically looking for attached spreadsheets.
Felienne found that emailing spreadsheets was very common within Enron, because the set of emails spanning 15 months of emails contained over 50.000 attached spreadsheets! In this session Felienne will explain:
• The most interesting results from the Enron set
• What conclusions we can draw from it
• Methods and techniques to battle spreadsheet problems”