Live blog Amsterdam Excel Summit, Day 2

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!

Live blog Amsterdam Excel Summit, Day 1

We’ve started our Amsterdam Excel Summit today. Here are some pictures!

Gašper Kamenšek talking about streaming datasets

And his audience is with him all the way!

Oz du Soleil getting ready for his presentation…

Time for a break…

Talking shop with our Charting wizard…

Top view of the coffee corner

Our Wizard of Oz, bashing the %$#!$ out of crap data!

Lunch!

Obligatory food pic

Stacking up the good stuff!

Introducing our Charting Wiz Jon Peltier…

Jon, explaining how to do things properly when it comes to preparing your data for charting in Excel.

David Hoppe, preparing for his class

Taking apart a full blown Excel dashboard down to the tiniest tidbit!

The Excel VBA Masterclass: We got outstanding Attendee feedback

VBAMasterclassBanner600

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.

Event summary

The atmosphere was vibrant and enthusiastic as our group selfies show:

wp_20161027_15_59_06_prowp_20161027_15_58_31_pro 

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:

wp_20161026_11_18_02_pro

Feedback

On top of all this, we received excellent feedback from our attendees. Read all about the event feedback here.

The Excel VBA Masterclass, what to expect part 5

VBAMasterclassBanner600

Why should you register?

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

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:

  • When to use an add-in
    as opposed to a “normal” workbook
  • How to develop add-ins
    Things to consider when you’re writing code for an add-in
  • Automating installation
    As simple as it may seem to you, many users have a hard time installing add-ins. Here’s how to help them (and make sure your add-in gets used)
  • Updating Add Ins
    Having one version of the truth is very important. Given that many people use laptops you may want your add-in to be available off-line too. This means a local copy of your add-in will reside on their C-drive. How can you ensure these copies stay up to date?
  • Manual update using central location
    Sometimes all users are connected to the network shares all the time, how can you make sure you can update an add-in used by many people?
  • Programmatically updating an add-in
    Doing it all automagically!

User-defined functions

We’ll talk about UDFs extensively and (amongst other things) demonstrate how code in a UDF can be optimised for speed.

Registration

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

The Excel VBA Masterclass, what to expect part 4

The Excel VBA Masterclass, what to expect part 4

VBAMasterclassBanner600

Why should you register?

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.

Userforms

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.

Design

We’ll discuss why design of a form is important and what you might consider doing (and not doing)

Events

Anything your form needs to do has to be programmed, this is where Events come in. We’ll talk about them extensively.

Run-time vs design-time addition of controls

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.

Treating them as a class

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.

Up next: Add-ins

Tune in next time when we discuss what our course will bring regarding Add-ins.

Registration

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

The Excel VBA Masterclass, what to expect part 3

The Excel VBA Masterclass, what to expect part 3

VBAMasterclassBanner600

Why should you register?

We’ve been working hard to build course content for Our Excel VBA Masterclass and in this second 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.

Error handling

A professionally designed VBA project cannot do without proper error handling. In this part of the course we will discuss:

  • Concepts of Error handling
  • What is an error handler
  • Methods to handle errors
    • Ignore all errors
    • The better option: Prevent errors
    • Catch unexpected errors
    • Error handling in routines called from other routines
    • Using a generic error handler
    • The Err object

Up next: Userforms

Tune in next time when we discuss what our course will bring regarding Userforms.

Registration

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

The Excel VBA Masterclass, what to expect part 2

The Excel VBA Masterclass, what to expect part 2

VBAMasterclassBanner600

Why should you register?

We’ve been working hard to build course content for Our Excel VBA Masterclass and in this second 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.

Efficient coding

As a potential attendee of this course you will have acquired quite some knowledge on how to code in VBA. But are you aware of the intricacies of VBA and Excel when it comes to writing code that has good performance? In this session we’ll discuss things like:•How to measure performance

  • Efficiently exchanging information with Excel
  • How to optimise for speed
  • Structuring code for speed

One part of this subject will involve writing a User Defined function demonstrating the effects of various code structures and methods on performance.

Up next: Error handling

Tune in next time (well, I’ll send it to you 🙂 ) when we discuss what our course will bring regarding Error hendling techniques.

Registration

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

The Excel VBA Masterclass, what to expect part 1

The Excel VBA Masterclass, what to expect part 1

VBAMasterclassBanner600

Why should you register?

We’ve been working hard to build course content for Our Excel VBA Masterclass and in this post I’ll reveal the first bit of the course content (as outlined roughly here) so you can decide whether or not it is worthwile for you to attend.

Discussing OOP and Class modules

We’ll start this subject by talking a bit about what Object Oriented Programming means and how this is implemented in VBA.

Classes

OOP in VBA uses class modules so we’ll dig into that some more.

Types of classes

We’ll distinguish class types by their function, touching on these three: Event classes, Object classes, and Classes of classes.

Event Classes

An event class is a class that is mainly created to handle events. Any VBA programmer will sooner or later get acquainted with the worksheet modules and the ThisWorkbook modules and use them to have VBA code respond to events in the workbook or worksheet in question. Note that these events are “local” in such a sense that the only events you can respond to are events in the workbook your VBA code is a part of. But in some situations you need to trigger code when something happens at a higher level, for example when a workbook is opened or closed in Excel. The only way to respond to such events is by writing a class module.

Object classes

Classes are not just for handling events. In fact, handling events is just a tiny part of what classes can do for you. In this chapter I will demonstrate a class which enables you unprotect a worksheet in a workbook and which automatically protects it when your code ends.

Classes of Classes

A situation which regularly arises is one where you have the collection-item combination. For example, a workbook has a collection of worksheets. In this part of the course we demonstrate how you set up the necessary plumbing to make this work reliably.

Up next: Efficient coding

Tune in next time when we discuss what our course will bring regarding efficient coding.

Registration

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

Top Excel classes, training and events