
May 26th and 27th 2016, 26 en 27 mei 2016
Program for The Excel Charting And Dashboard Masterclass (May 27th, 2016)
|
Registration
|
9:00 | Registration Registratie |
9:15 | 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 |
09:30 | Clean Data and Clean Formatting for Excel Charts
Jon Peltier We will discuss what makes good source data for Excel charts (nice arrangement of data, header rows and columns, no blank rows, \ columns, or cells), how to quickly validate data with a chart, and how to manipulate a chart’s source data. We will also talk about using appropriate chart types and just enough formatting (but not too much!) to clearly convey your data. |
11:00 | Break and networking opportunities Pauze (netwerkmogelijkheid) |
11:15 | Dynamic data visualizations
David Hoppe Be ready to blow your mind. In this workshop, communication & visualization expert David Hoppe (excelusive.com) will craft dynamic data visualizations that you thought were impossible. You will learn how to build pivot charts without using pivotcharts – a technique that allows you to utilize the advanced formatting options that pivot charts lack, and additionally has some surprising applications for creating advanced data visualizations too. Besides, you’ll be introduced to the fascinating world of mini charts, a.k.a. sparklines, going way beyond the built-in sparklines features of Excel. As a bonus, David will share his mini charts addin that will greatly facilitate building custom sparklines on your own! In this session you will learn how to:
|
12:45 | Lunch |
13:45 | Techniques for Building Charts and Dashboards
Jon Peltier
|
15:15 | Break and networking opportunities Pauze (netwerkmogelijkheid) |
15:30 | Create Insightful Charts in Excel
Tony de Jonker You can give more meaning to your charts by adding shapes such as text boxes, lines, stars and callouts combined with controls. These shapes will dynamically highlight important events in your chart without using any VBA. Learn the secrets of mashing up existing charts with XY charts and how to display important notes depending on the period chosen. We’ll show you practical examples such as break even charts and actual versus forecast charts. |
17:00 | Wrap up by Tony De Jonker & Jan Karel Pieterse Afsluiting door Tony De Jonker & Jan Karel Pieterse |
|