Most Valuable Professional

View Jan Karel Pieterse's profile on LinkedIn subscribe to rss feed

Subscribe in a reader

Audit !!!

Check out our RefTreeAnalyser
the ultimate Excel formula auditing tool.


Visit our Amsterdam Excel Summit

Speed up your file

The best tool to optimise your Excel model! "

Subscribe to our mailing list

* indicates required

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.

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.

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 2015: Great content!
Extended early bird discount on our Amsterdam Excel Summit! Last week our mail server experienced some problems, which meant that the registration form did not work. To compensate for anny inconvenience caused by this problem we have decided to extend the early ...
Mon, 23 Feb 2015 14:40:00 GMT

Updated article: Working with Circular references in Excel
In my Circular Reference article I promised to include an example of a VBA driven circular reference calculation. I have done that today so head over to my site to check it out!
Wed, 11 Feb 2015 09:30:00 GMT

The Amsterdam Excel Summit 2015: Great content!
Join us in Amsterdam on April 13th and 14th 2015, for the second Amsterdam Excel Summit! We have a lot of interesting subjects, including: Business Intelligence in Excel vNext, An introduction to Power Query, working with Excel charts less painful, Professionalising your Power Pivot Model, More efficient VBA UDFs, ...
Tue, 10 Feb 2015 17:20:00 GMT

Name manager updated
Name Manager for Excel has been updated. Improved renaming rangenames in VBA code.
Tue, 10 Feb 2015 17:20:00 GMT

The Amsterdam Excel Summit 2015: Registration is now open!
Join us in Amsterdam on April 13th and 14th 2015, for the second Amsterdam Excel Summit! An absolute unique group of Excel MVPs will gather in Amsterdam to share their expert knowledge with you. The Excel MVPs happen to be in Amsterdam for a meeting and we've succeeded in getting some of them to present at our event. Make sure you register!
Thu, 22 Jan 2015 10:15:00 GMT

Registratie geopend: Excel VBA voor Financials V2
Excel VBA voor Financials versie 2; Een twee-daagse Excel VBA cursus (20 en 26 mei 2015). Bespaar tijd door het automatiseren van uw rapportages! Ontsluier de geheimen van VBA en breng uw Excel kennis en vaardigheden op ongekende hoogte !
Tue, 30 Dec 2014 13:05:00 GMT

Update: GoBack.
Finally got some time to include an Excel 2007-2013 version of this little tool that traces where you went in your Excel files and gets you back easily!
Wed, 19 Nov 2014 06:45:00 GMT

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. I have added an option to report all unique formulas in your workbook. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! ...
Thu, 23 Oct 2014 16:45:00 GMT