
April 13th and 14th 2015, 13 en 14 april 2015
Program
Programma
We prepared an excellent and exciting program, spanning two days:
We hebben een een uitstekend programma samengesteld, dat twee hele dagen omvatte:
Program for day 1 (April 13th, 2015)
Het programma van dag 1 (13 april 2015)
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 | Keynote Plenaire sessie The world [of Office] is changing…Yigal Edery, Microsoft, Principal Group Program Manager, Office BI The world of productivity is changing rapidly. New technologies are born daily. Data is everywhere. People are everywhere, and on different devices. And they all want access to their data wherever and whenever they are. In this session, we will show how Office has been evolving to fit the modern era. We will take a look at Excel and how it’s been evolving to support these needs, as well as at the Power BI offering coming from Microsoft to further enhance the life of you, the data analyst. |
|
11:00 | Break and networking opportunities Pauze (netwerkmogelijkheid) |
|
11:15 | Side sessions 1 | |
One app to rule your data: An introduction to Power Query.Ken Puls Power Query is one of the most exciting new components for Excel 2010 and Excel 2013. If you’ve ever needed to import data from a file, database or web page, this course is for you. Power Query adds a huge amount of functionality to Excel, making it easy to source, clean up and convert the data into a format that is easily useable by Excel. By the end of this one hour class, you’ll learn how we can use Power Query to:
Text file, CSV file, Excel file, database, email or web page… you need one |
GetPivotDataRoger Govier Many people use formula based solutions for aggregating data for their Monthly or Quarterly reports. These reports often summarize thousands of rows of raw data and people make use of formulae such as SUMPRODUCT, SUMIF, COUNTIF, AVERAGEIF and their newer counterparts of COUNTIFS, SUMIFS and AVERAGEIFS to generate all of the summarised data. This information is then displayed in a Dashboard or a formatted report for their managers to read. All of the “heavy lifting” for producing these summaries of data can be achieved more easily with Pivot Tables – where not a single formula needs to be written. However, many people are put off Pivot Tables because they don’t understand them, or they don’t like the format of the information is produced. GetPivotData is a little used, and not well understood method of pulling data that has been calculated via a Pivot table into a report of the exact layout and format required. This session is all about de-mystifying GetPivotData and showing how a single universal formula can be used to create the reports required. The session will include
|
|
12:30 | Lunch | |
13:30 | Side sessions 2 | |
M is for Data Monkey: Simple tweaks for major effectsKen Puls Power Query’s user interface is incredibly effective and allows us to do some amazing things to our data. But did you know that under the covers, the Power Query interface is a macro recorder? In this class Ken will teach you how to make light edits to Power Query’s macro language: M. We’ll look at creating basic M functions, implementing dynamic file paths to your source data, consolidating multiple Excel workbooks and other practical techniques that require light manipulation in the M language. You’ll leave armed not only with some M patterns, but the knowledge of how to easily implement them into your own solutions. |
Practices that make working with Excel charts less painfulJon Peltier Using charts in Excel can be frustrating, especially with complicated data sets or complex chart styles. There are a few things you can do with your data or with the chart’s own elements to make your life easier and make your charts more informative. I’ll discuss:
|
|
14:45 | Break and networking opportunities Pauze (netwerkmogelijkheid) |
|
15:00 | Side sessions 3 | |
How to make your Excel Power pivot model professional.Henk Vlootman Excel Power pivot is an awesome tool, acting as bridge between your databases and Excel. But there are some downsides to this combination. Your dashboard e.g. is bound to your Excel (Power pivot) model. It means that only one person at a time can view the dashboards. If you make your Power pivot a server-based application, you create different dashboards in as much Excel models as you want. If you have a SharePoint farm the dashboards can also be published on that farm. You can easily port your Excel Power pivot model to a SQL Server tabular model. But what are the bottlenecks? In this session:
|
Working With Multiple CriteriaLiam Bastick So how many left-handed Israeli women with three sons bought your product on Tuesdays in March? Management loves to get to the bottom of multiple criteria analysis but how can you do it simply in Excel? Are PivotTables always the answer? This session looks at what techniques to use when in your financial analysis using Excel. Topics will include:
|
|
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:00 | Demo by SpreadsheetSoftware.com | |
17:15 | Wrap up by Tony De Jonker & Jan Karel Pieterse Afsluiting door Tony De Jonker & Jan Karel Pieterse |
Program for day 2 (April 14th, 2015
Het programma van dag 2 (14 april 2015)
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 | Keynote Plenaire sessie Business Intelligence in Excel vNextYigal Edery, Microsoft, Principal Group Program Manager, Office BI Business Intelligence and data analysis are becoming more and more critical in today’s world, with massive amounts of data available to support organizations striving to make data-driven decisions. Excel is the data analysis tool of choice for one billion users around the world. In this keynote, we will discuss how Microsoft is improving Excel vNext to enable much more powerful and streamlined data analysis experiences for the excel users and enabling you to cope with the data challenges of the modern era. |
|
11:00 | Break and networking opportunities Pauze (netwerkmogelijkheid) |
|
11:15 | Side sessions 1 | |
Optimizing your Power Pivot models using Power Query (and other performance tips)Ken Puls You know the scene; you’ve built a beautiful Power Pivot model that has solved all of your organization’s problems. You open it up, click Refresh and wait patiently for all the data to stream in. That’s okay, there’s a lot of data and you expect that. Then you click a slicer and… wait… Time during the initial data load is one thing, but consumer’s patience during use is another. Their tolerance for latency is much less. In this session we’ll explore the things you can do to increase your Power Pivot model performance. We’ll look at the key factors that affect performance, as well as the things you can do to deal with them. In addition, we’ll look at how sourcing your data with Power Query can give you ultimate control over your data’s size and shape, and tricks to optimize it for Power Pivot consumption. |
Making chart types that Excel didn’t know aboutJon Peltier Excel offers a wide variety of built-in charts, some very useful. But some of the most useful chart types you may want to use are not built into Excel. With a little magic, you can use regular Excel charts to achieve the appearance you want.
|
|
12:30 | Lunch | |
13:30 | Side sessions 2 | |
Make your VBA UDFs efficientCharles Williams VBA UDFs have a reputation for being slow. I will show you a few simple steps that can make your VBA UDFs run 100’s of times faster:
|
Avoiding Common Mistakes in Valuations ModellingLiam Bastick This session looks at an area of financial modelling that is often developed incorrectly: creating a valuation from your financial model. Aimed at Excel professionals working or with an interest in valuations, this session provides an introduction to:
|
|
14:45 | Break and networking opportunities Pauze (netwerkmogelijkheid) |
|
15:00 | Side sessions 3 | |
Slicers and Timelines and their use with Pivot Tables and TablesRoger Govier This session will show how Slicers (introduced with Excel 2010) for use with Pivot Tables, and Timelines (introduced with Excel 2013), which along with Slicers can be used with Pivot Tables and Tables to make reporting neater and easier to filter. Straight “out of the box”, Slicers are big and bold and ugly and take up far too much of the screen “real estate”. Many people who have only looked at them cursorily are put off and believe they cannot be effectively used in Dashboard reporting. This session will show how easily they can be formatted for better use, including some of the formatting methods which are “hidden” from the user. The session will include
|
Checking Your Excel SpreadsheetsLiam Bastick For those that audit models, have their models audited or those who don’t want to be embarrassed by reporting staff turnover as #DIV/0! (and being one of those staff turned over), this session provides brief tricks and tips for checking your models. Discussion will include:
|
|
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:00 | Demo by Infotron | |
17:15 | Wrap up by Tony De Jonker & Jan Karel Pieterse Afsluiting door Tony De Jonker & Jan Karel Pieterse |