Hi there. Hope you and yours are well in these difficult times!
This is just a very short announcement that I’ll be doing an on-line version of my Excel VBA Masterclass.
The training is scheduled for May 18, 20, 26, 28, June 2, 4 and I’ll be using Microsoft Teams to deliver it to your homes!
Regards,
Jan Karel Pieterse
Great news for anyone who would like to combine visiting the beautiful city of Ljubljana and learn about Excel VBA coding techniques!
On Novermber 5th, 2018 I’ll be teaching the Excel VBA Masterclass in Ljubljana.
In short I’ll be addressing:
There are still some seats available, so hurry up and register soon!
Jan Karel Pieterse
PS: There are two other very interesting masterclasses on that same day, so if you are not into VBA (I can’t imagine you aren’t) there are alternatives!
Hi Excel lovers,
Wanted to draw your attention to our fifth
June 7 and 8 , 2018
We’ve worked hard to get an exciting line-up of speakers presenting on a wide variety of Excel subjects during our two-day conference.
So if you’re an Excel power-user, this is one of those one-of-a-kind conferences you cannot afford to miss!
Hope to see you in Amsterdam on June 7 and 8 2018!
Jan Karel Pieterse, Tony de Jonker
Hi Excel lovers,
Wanted to draw your attention to our fourth
April 18 and 19, 2017
We’ve worked hard to get an exciting line-up of speakers presenting on a wide variety of Excel subjects during our two-day conference.
So if you’re an Excel power-user, this is one of those one-of-a-kind conferences you cannot afford to miss!
Hope to see you in Amsterdam on April 18 and 19 2017!
Jan Karel Pieterse, Tony de Jonker
Hi Everyone!
We’ve opened registration for our third annual
May 26, 2016
Join us in Amsterdam to learn how to Excel from our Experts (all MVPs):
Jon Peltier, Bob Umlas, Roger Govier, Henk Vlootman, Oz du Soleil, Tony de Jonker, Jan Karel Pieterse.
Attend this comprehensive training event and you will:
May 27th 2016
The Amsterdam Excel summit also features a post-conference training. Attend this one-day masterclass and:
Excel MVP and charting Guru Jon Peltier teaches you how to visualize your numerical information in the most effective way.
Excel MVP and financial expert at najlepsze strony bukmacherskie Tony de Jonker and communication & visualization expert David Hoppe unveil the secrets of creating powerful and flexible dashboards.
So head over to our website to register or to signup to our mailing list so we can keep you posted!
Regards,
Jan Karel Pieterse
Hi there!
Only recently I read this quote somewhere: “If you want something done, ask a busy person”. I found two entirely different people as the originator of this quote: Benjamin Franklin and Lucille Ball. I wonder which it is…
Well, turns out I’ve been quite busy as of late. So I decided it was time to dust off some old stuff I prepared to add to my site but never came round to finishing (I must have become less busy when I was almost done :-) ).
If you’re about to embark on the journey to create an add-in out of a set of macro’s you have been using for some time now, this article is a nice read as it takes you through most of the steps needed when building an add-in for Excel.
Enjoy!
Jan Karel Pieterse
Hi everyone!
If you write a lot of VBA code you probably sometimes run into performance issues. A customer rings you and complains that the Excel file you built for them does not perform well. I’ve written a small article on my site, inspired by a post here: Error Handling via an Error Class. I needed a quick way to log and report performance of subroutines and I also wanted to see how many times a routine was called.
Enjoy!
Jan Karel Pieterse
www.jkp-ads.com
Hi Everyone,
I’ve just added a new page to my site on how to synchronise slicers which point to different pivotcaches:
Synchronising Slicers
Enjoy the read!
Jan Karel Pieterse
www.jkp-ads.com
