Two excellent days. That about sums it up for me for our 2018 Amsterdam Excel Summit. The positive feedback we recieved from our attendees and our speakers (just look at the smiles on their faces in the above picture) was overwhelming.
I’d like to thank everyone who made it possible for our event to become such a success!
We hope to welcome you next year.
Thanks again,
Jan Karel Pieterse
Tony de Jonker
Our fifth Amsterdam Excel Summit has opened for registration!
June 7, 2018: The Amsterdam Excel Summit 2018
June 8, 2018: The Amsterdam Excel Summit post-conference Masterclasses
This year our outstanding event will feature two post-conference masterclasses (on June 8):
The Excel Business Modeling Masterclass
and
Master your data with PowerQuery
Thanks
Jan Karel Pieterse
Tony de Jonker
Our fifth Amsterdam Excel Summit is scheduled!
June 7, 2018: The Amsterdam Excel Summit 2018
June 8, 2018: The Amsterdam Excel Summit post-conference Masterclass
I promised to keep you posted, so….
We’re in the middle of creating a great program. I have updated our list of speakers.
Mind you, the list is not complete yet as we’re waiting for the information from the Microsoft Product Managers who are going to speak at our conference.
Also, I can reveil that we will offer two separate masterclasses on June 8!
More to follow soon.
Thanks
Jan Karel Pieterse
Tony de Jonker
We set the dates for our fifth Amsterdam Excel Summit:
June 7 and 8, 2018.
We are now piecing together a great program for you, stay tuned!
Subcribe to our newsletter if you want to be informed about the program.
Our second day of our Amsterdam Excel Summit has started!
Pictures!
Our pretty banner 🙂
Coffee first!
Guy Hunkin from Microsoft showing off all things new in Excel 365
Our enthusiastic audience
Jon Peltier getting ready for his presentation
Frederic le Guen showing all sorts of nice details about Power Query (Get And Transform)
Proof of being present…
Charles Williams bringing us up to speed with all the different technologies to automate Excel
Oz explaining when (and when not!) to use PowerQuery
Lunch time!
Gašper Kamenšek with a great demo of bing maps and PowerQuery
Henk Vlootman scratching his head to figure out how to answer a hard question…
But providing the answer of course!
I was there too! 
Sometimes work prevails…
Our French speaking attendees (and speaker) 
Tips and tricks by mister tip himself; Tony!
Ken telling us what Power BI was like in 1990
Which raised a few questions!
Who wants to play “assistent”?
It’s not hard, it’s easy!
O, really?
Sudhi from Microsoft preparing for his talk
Together with his colleague Jakob
The full goup!
And a very warm thank-you to our presenters!
Important notice to our attendees of
The Excel Data Analysis And Reporting Masterclass, April 18, 2017
Our masterclass had to relocate and will now be held at:
Room Mate Aitana Hotel
IJdok 6
1013 MM Amsterdam
We’ve just become famous, a nice post about our event has been published on the Microsoft MSDN blog
Register now, our early bird discount ends on Feb 20, 2017!
Alas, all good things come to an end and our Excel VBA Masterclass is no exception to that rule. We had two days crammed full with VBA information.
The atmosphere was vibrant and enthusiastic as our group selfies show:
and at the end of day one, most attendees even stayed longer in order to be able to spend extra time trying to solve one of our challenging assignments:
On top of all this, we received excellent feedback from our attendees. Read all about the event feedback here.
We’ve been working hard to build course content for Our Excel VBA Masterclass and in this mailing I’ll reveal the last bit of the course content (as outlined roughly here) so you can decide whether or not it is worthwile for you to attend.
Add-ins are a powerful addition to Excel. Creating add-ins isn’t hard to do, but there are many things to consider when you decide to deliver your code in an add-in. In this section of the course we will touch on these subjects:
We’ll talk about UDFs extensively and (amongst other things) demonstrate how code in a UDF can be optimised for speed.
Our Excel VBA Masterclass training covering advanced VBA subjects such as Error handling, Userform design, Class modules and etcetera is open for registration.
Training dates: October 26 and 27, 2016
Location: Zilveren Toren, Amsterdam
We’ve been working hard to build course content for Our Excel VBA Masterclass and in this post I’ll reveal a bit more about the course content (as outlined roughly here) so you can decide whether or not it is worthwile for you to attend.
Many VBA developers will have started their career with Excel’s macro recorder. Soon after they start to edit recorded macro’s and then discover at some point they need to get information from the user. If this information is more than a simple yes/No or a single choice, or if a specific UI design is needed the most efficient way in VBA is to build a Userform.
We’ll discuss why design of a form is important and what you might consider doing (and not doing)
Anything your form needs to do has to be programmed, this is where Events come in. We’ll talk about them extensively.
If you know up front what fields are needed for your form, you can manually draw them on the designer canvas. But what if there are many controls or if you don’t know up front how many there are? We’ll show you how to handle both processes efficiently.
Out of the box, Excel VBA allows you to address a userfrom by its classname directly. We’ll discuss why there are better ways of doing this.
Tune in next time when we discuss what our course will bring regarding Add-ins.
Our Excel VBA Masterclass training covering advanced VBA subjects such as Error handling, Userform design, Class modules and etcetera is open for registration.
Training dates: October 26 and 27, 2016
Location: Zilveren Toren, Amsterdam
