
May 26th and 27th 2016, 26 en 27 mei 2016
Program for day 1 (May 26th, 2016)
|
Registration
|
9:00 | Registration Registratie |
|
9:30 | Start and introduction of speakers by Tony De Jonker & Jan Karel Pieterse Begin van de dag en presentatie van de sprekers door Tony De Jonker & Jan Karel Pieterse |
|
9:45 | Tips and tricks by our presenters Tips en trucs door onze experts |
|
10:15 | Key note by Microsoft Excel Program managers Yigal Edery and Guy Hunkin (Get inside information from the people developing Excel on what’s up next in Excel) | |
11:00 | Break and networking opportunities Pauze (netwerkmogelijkheid) |
|
11:15 | Side sessions 1 | |
Customize Charts with VBABy Jon Peltier We will work through examples that should introduce you to:
|
Evil and Hero FunctionsBy Charles Williams A discussion of some of Excel’s most Evil and Greatest functions.
|
|
12:30 | Lunch | |
13:15 | Demonstration by Maarten Bessems of SpreadsheetSoftware | |
13:30 | Side sessions 2 | |
The role of slicers and Dimension tables in a Power pivot dashboard.By Henk Vlootman Within Power pivot dashboards Dimension tables plays an important role as intermediary between the different fact tables, that can come from different sources. It functions as the oil between the tables, but they also play an important role as being the steering wheel for your `Power pivot dashboard. In this session we’ll exploring Dimension tables and how you can use them in your dashboards.
Tuning your slicers |
Helper cells, Array Formulas, Tips & TricksBy Bob Umlas
|
|
14:45 | Break and networking opportunities Pauze (netwerkmogelijkheid) |
|
15:00 | Side sessions 3 | |
Customize the Excel Ribbon for your Workbooks and Add-InsBy Jon Peltier You can readily modify the Excel ribbon to make your workbooks and add-ins easy for people to use.
|
Advanced Power Query and M LanguageBy Guy Hunkin (Microsoft) Excel 2016 includes a powerful new set of features called Get & Transform, which provides fast, easy data gathering and shaping capabilities. During this session we will learn how to leverage the powerful Get & Transform capabilities to connect, combine, and refine data to meet your analysis needs. We will also take a quick glance at the Power Query Formula Language, known as M, which helps you to provide solutions to even more complex business problems. |
|
16:15 | Break and networking opportunities Pauze (netwerkmogelijkheid) |
|
16:30 | Ask the Experts Vraag het aan de experts In this session, you may ask ANY question to our Excel MVPs and to the Microsoft Excel team members! |
|
17:15 | Wrap up by Tony De Jonker & Jan Karel Pieterse Afsluiting door Tony De Jonker & Jan Karel Pieterse |
|