
June 7 and 8, 2018
7 en 8 juni 2018
Program for The Amsterdam Excel Summit, June 7, 2018
|
Registration
|
Please note this program may be subject to change!
Start |
End |
Track 1 |
Track 2 |
|
08:15 | 08:45 |
Registration |
||
08:45 | 09:00 |
Start and introduction of speakersTony De Jonker & Jan Karel Pieterse |
||
09:00 | 10:10 | Side sessions 1 |
Adding Pizazz & Power to your ChartsUsing charts right out of the box seldom produce the desired high-quality result for your Excel dashboard or report. For instance, charts often need extra formatting, especially when dealing with legacy workbooks. Do you know there’s a world of further improvements that you can easily apply right away? This session will uncover many top-notch tricks that will certainly wow your boss. You will learn how to:
|
Unleash the Power of Excel with Power Query“People keep telling me that Power Query is the thing to learn instead of VBA, is that true?” Someone asked me that recently, and I’d never suggest that someone deliberately not learn VBA. However, he was really expressing skepticism about the buzz around Power Query. Let’s dig into that! How do Power Query and VBA compare? Why have a lot of VBA coders spend more time in Power Query and much less time in the Visual Basic Editor? This session will explore some real-life projects that were all VBA but could have been accomplished purely within the Power Query interface.
Oz du Soleil |
10:10 | 10:30 | Break and networking opportunities | ||
10:30 | 11:40 | Side sessions 2 |
What if I Care?You have sweated blood and tears getting the best estimates for your model that you possibly can. You know it’s certain your forecast will be wrong though – because things change. This session looks at simple ways to undertake “what if?” analysis in your Excel spreadsheets, without the need for “black box” calculations, Excel features (e.g. Solver) and VBA.
Liam Bastick |
Mastering Your Data in Power PivotWhile Excel is a calculation app, Power Pivot is a filtering app. That means that you need to focus on filtering context for instance by using DAX. One of the problems of using DAX functions for filtering is that you can use the same DAX function on row level and on column level. The results can be different! Mastering context means that you are in control of your Data model.
Henk Vlootman |
11:45 | 12:30 |
Key note: What’s new in ExcelTamar Tzruya Bar Zakai – Microsoft |
||
12:30 | 13:30 | Lunch | ||
13:30 | 13:50 |
Tips & TricksBy “Excel out of the box” Bob Umlas |
||
14:00 | 15:10 | Side sessions 3 |
The best Excel secrets revealedWould you like to save time when working with Excel and learn about the hidden features? Join us on this amazing session jam packed with tips and tricks
Tony de Jonker |
The Time of Your Life99,9% of Excel Data Models rely on a good Calendar. This session will cover a few techniques on how to create a dynamic calendar in your Power Pivot Data Model and explain why a good Time Dimension (Calendar) is probably the most important thing in any Excel or Power BI Data Model. This session will also feature some time intelligence calculations in Power Pivot that are only available if you have a good Calendar.
Gašper Kamenšek |
15:10 | 15:30 | Break and networking opportunities | ||
15:30 | 16:40 | Side sessions 4 |
Advanced Data Visualization in Excel – Power BI and AppsShowing your results in charts and/or dashboards is an effective way to analyze and communicate the results of your spreadsheet model. Because charting has evolved a great deal in Excel, this session lays out the different options available and considers the pros and the cons of each. At the end of the session, you can make more informed decisions in your next data visualization project. This session covers the following topics:
David Hoppe
|
Building a Budget Comparison Model in Power PivotIn this session we will look at solving the un-vlookupable issue of comparing actuals and budgets by using Power Pivot. During the session you’ll be exposed to proper modelling techniques, and how to solve common many-many problems that occur when building Power Pivot. Things you’ll learn:
Ken Puls |
16:40 | 17:30 |
Meet the ExpertsAnd we’ll wrap up during this session too |