Most Valuable Professional

View Jan Karel Pieterse's profile on LinkedIn subscribe to rss feed
Subscribe in a reader

Subscribe to our mailing list

* indicates required

Audit !!!

Check out our RefTreeAnalyser
the ultimate Excel formula auditing tool.


Excel VBA Masterclass (English)
Excel VBA for Financials (Dutch)

Third party tools

Speed up your file

The best tool to optimise your Excel model!

Repair your file

Stellar Phoenix Excel Repair
Best tool to repair corrupt Excel sheets and objects

Your Excel Expert; uw Excel specialist

Welcome to the website of

JKP Application Development Services.

If you are looking for an Excel specialist and an Excel and VBA expert you've come to the right place.

My core business is developing solutions using Microsoft Excel/VBA and Access/VBA. Integration with other (Office) programs is possible.

Need expert Excel help? Get in touch.

My Services page lists some example projects.

Need Excel or VBA training? Information about our Excel and VBA trainings can be found on our trainings page.

If you need more information about me, look at my English homepage.

To find out whether you've actually found an Excel expert, I invite you to browse through my Excel articles.

I also recommend to try my free utilities.

Click here for remote assistanceClick for remote assistance

Welkom op de website van

JKP Application Development Services.

Als u op zoek bent naar een echte Excel specialist en een Excel en VBA expert dan bent u aan het juiste adres.

De nadruk ligt op het ontwikkelen van toepassingen in Microsoft Excel/VBA en Microsoft Access/VBA. Ook integratie met andere (Office) programma's is mogelijk.

Kunt u de hulp van een Excel expert gebruiken? Neem dan contact op.

Op de Diensten pagina vind u voorbeelden van projecten.

Zoekt u Excel of VBA cursussen? Informatie over onze Excel en VBA trainingen kunt u op onze training pagina vinden.

Wilt u meer over mij weten ga dan naar mijn Nederlandse homepage.

Wilt u zelf beoordelen of u een echte Excel expert heeft gevonden, bekijk dan mijn Excel artikelen.

Probeer ook eens mijn gratis hulpprogramma's.

Klik hier voor hulp op afstandKlik voor hulp of afstand


What's new on this site:

(English and/or Dutch content)

Nieuw op deze site

(Engelse en/of Nederlandse artikelen)

The Amsterdam Excel Summit 2017: Registration is open
Come and join us in Amsterdam on April 18 and 19 2017 for our famous Amsterdam Excel Summit. We have just opened registration so make sure you book your seats before Feb 20 and receive a nice early-bird discount! Visit the Amsterdam Excel Summit Website
Mon, 16 Jan 2017 16:20:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. I have improved scrolling the selected cells into the viewable area of the screen
Thu, 5 Jan 2017 06:25:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Fixed three bugs.
Wed, 14 Dec 2016 20:55:00 GMT

Name manager updated
Name Manager for Excel has been updated. Fix for finding dynamic range names when using the Formulas or 2D areas filter.
Tue, 13 Dec 2016 15:20:00 GMT

New article: a Simple Inventory System, built in Excel
Answering questions on forums can be very rewarding. This post is the result of a forum question. The forum member needed a simple system to manage his shop inventory. He wanted to be able to log Purchases, Reservations and Sold items and immediately be kept informed when items are (almost) out of stock..
Tue, 11 Oct 2016 13:15:00 GMT

New article: A wheel of Fortune, built in Excel
Excel is a very serious and powerful business application. That doesn't mean we can't have some fun with it. In this article I'll explain how I've built an Excel file which enables you to play with a wheel of fortune. With sound and all!.
Thu, 29 Sep 2016 17:45:00 GMT

New article: Excel add-ins fail to load
A recent Office update may cause your add-ins to be ignored by Excel. This article shows you how to fix that.
Wed, 17 Aug 2016 15:45:00 GMT

Updated: FollowCellPointer
I have just updated the small tool which follows your cell pointer by placing two arrows on top of your sheet pointing to the active cell. Fix: enabled for 64 bit Excel.
Mon, 15 Aug 2016 09:00:00 GMT