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

File crashes Excel!!

Save my workbook!
The best tool for salvaging problematic workbooks.


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)

Update: Name Manager
Name Manager has just been updated to build 669. When a name is renamed, PowerQuery M code will be checked for existence of the name and updated accordingly
Fri, 21 Feb 2020 13:40:00 GMT

Webinar recording: Working with tables in Microsoft Excel
Ever used Format as Table in Microsoft Excel? Did you know Format as Table can be a whole lot more than just fancy formating? Join Jan Karel Pieterse as he discusses working with tables and how they can help you in your everyday work with Excel.
Fri, 31 Jan 2020 10:50:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. You can now choose whether or not to display references in your formula more than once
Wed, 15 Jan 2020 09:20:00 GMT

Updated : Table Tools
I have updated the TableTools add-in, with a couple of bug fixes.
Mon, 13 Jan 2020 13:30:00 GMT

The Excel VBA Masterclass
I have scheduled a new run of my Excel VBA Masterclass. Make sure you register now
Tue, 26 Nov 2019 12:45:00 GMT

New download: Excel Spreadsheet Model Template
To help in the battle towards better spreadsheets I have uploaded an Excel Spreadsheet Model Template.
Wed, 20 Nov 2019 09:05:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Fixed the wrong calculation setting (use 1 core only) of the add-in
Tue, 12 Nov 2019 09:45:00 GMT

Update: Excel File Remediation Utility
The Excel File Remediation Utility has been updated to build 128. Added "Copy sheet special" item to right-click menu of worksheet tabs.
Thu, 31 Oct 2019 09:15:00 GMT