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.

Speed up your file

FastExcel
The best tool to optimise your Excel model!
Home > English site
Deze pagina in het Nederlands

Company Profile

Jan Karel Pieterse, Excel expert

JKP Application Development Services was founded in November 2003 by me, Jan Karel Pieterse (owner).

JKP Application Development Services develops custom-made applications, using Microsoft Office Excel® and VBA and Access and VBA to their full extent. Other Office applications are integrated into the solutions where needed.

Custom-made training programs are also possible; Together we determine the content of the training based on your needs.

My Services page shows you what services I can provide. This page also includes a list of recent projects so you can assess my level of experience in the business.

My Products page shows some samples of products I have developed.


About Jan Karel

I have been supporting Microsoft Excel users from over the world for many years, helping them with their day-to-day tasks using Microsoft Excel.

These efforts have been rewarded by Microsoft by granting me the MVP Award many times (each year starting from 2002). Worldwide, there are only about 100 Excel MVP's, so with JKP Application Development Services you are sure to get top level expertise. Get a real Excel expert to help you!

As a process engineer with about 20 years of corporate experience, I have experience in business processes as well as knowledge of the systems used for those processes.


Speaking engagements

From Model to Application, Excel Experts Class 2013, december 13, 2013, Bunnik

The Range Object, Excel Experts Class 2013, december 13, 2013, Bunnik

VBA Demonstration, Excel Experience Day 2013, december 12, 2013, Bunnik

Speed up your spreadsheet, Excel Experience Day 2013, december 12, 2013, Bunnik

An introduction to VBA, The European Investment Bank, September 5, 2013, Luxemburg

Pivot tables from start to finish, Excel Experts Class 2012, December 14, 2012, Amsterdam

VBA: introduction to userforms, Excel Experts Class 2012, December 14, 2012, Amsterdam

Excel 2013; the next generation, Excel Experience day 2012, December 13, 2012, Ede

Hidden problems in Excel files; How to keep your spreadsheets healthy. Excel Experience day 2012, December 13, 2012, Ede

Pivot tables en Slicers, ISA Group Excel training, 10 February 2012, Utrecht

Getting (external) data into Excel , Excel Experts Class 2011, December 9, 2011, Utrecht

Advanced userforms, Excel Experts Class 2011, December 9, 2011, Utrecht

VBA: working with variables, Excel Experience day 2011, December 8, 2011, Ede

Using Userforms in VBA-macro's, Excel Experience Day 2011, December 8, 2011, Ede

Distributing VBA Macro’s to other users, Excel Experts Class 2010, December 10, 2010, Amsterdam

Introduction to Excel VBA, Excel Experience Day 2010, December 9, 2010, Ede

Presentation at the Microsoft Global MVP Summit at Redmond. Presenting to the Microsoft Office Excel product group. Content and title under NDA. February 16, 2010. Redmond WA, USA.

Practical applications with VBA. Excel Experience Day 2009, December 10, 2009. Ede, The Netherlands.

Using Pivot Tables. Excel Experience Day 2008, December 11, 2008. Ede, The Netherlands.

Introduction to Excel VBA. Excel Experience Day 2008. December 11, 2008. Ede, The Netherlands.

Avoid mistakes, pitfalls in using Excel. Excel Experience Day 2007. December 11, 2007. Ede, The Netherlands.

Introduction to Excel VBA. Excel Experience Day 2007. December 11, 2007. Ede, The Netherlands.

Excel Masterclass. "Nationale Office dag". November 30, 2006 Ede  Netherlands.

Excel and XML, an Introduction, "Excel experience day 2006". December 7, 2006. Ede, The Netherlands.

Excel 12, "Nationale Office dag". November 29, 2005. Ede, The Netherlands.

Publications

Books

Revision author of Excel 2007 VBA Programming for Dummies. Author: John Walkenbach, publisher: Wiley. ISBN: 978-0-470-04674-6.

Magazines

Dutch article: Opstartproblemen verhelpen in Excel; Microsoft Technet magazine No. 2, May 2010, Microsoft.

Author and editorial staff member for www.wekafinancieel.nl, managed by Weka publishers.

Dutch Article: Excel 12 is in aantocht!, Microsoft Office magazine (number 29, Spring 2006)

Dutch Article: XML breekt door, Microsoft Office magazine (number 27, October 2005)
You can read this article (in Dutch) here too.

Dutch article: Excel-macro's geschikt maken voor anderen., Microsoft Office magazine (number 25, April 2005 and number 26, July 2005). See this page for an English version of this article.

Dutch article: Bereiknamen in Excel, Microsoft Office magazine issue number 21, 2004.

Websites

Importing Text Files in an Excel Sheet, Microsoft blog, June 10, 2010

Where to Find the Form Controls Microsoft blog, February 13, 2010

Preventing auto_open and Workbook_Open events from running Microsoft blog, December 15, 2009

Using parameters with web queries, Microsoft MSDN article, August 2009

Editing Data in an Excel 2007 Open XML File with VBA, Microsoft, June 2009

Using Styles to Dress Up Your Worksheets in Excel 2007, Microsoft MSDN, March 2009

Fixing Links To UDFs in Add-ins, Microsoft Office Online, December 2008

Working with Tables in Excel 2007 (VBA), Microsoft Office Online, September 2008

Werken met tabellen in Excel 2007 (Dutch), Microsoft voor ondernemers website, September 2007

Microsoft Knowledge base

How to troubleshoot startup problems in Excel, June 2009

Macro in Excel Stops After A Workbook.Open Command, February 26, 2005

Property let procedure not defined error when accessing PivotTable SourceData Property, July 18, 2004

Method to Delete Corrupt Defined Names in Excel, June 2, 2004


General

If you have a remark or a question, or would like a quotation, please use the form on my contact page or send me an e-mail.

I invite you to browse through this site. Come back often, as I add information to it regularly.

Memberships and affiliates

I am member of the Dutch Excel Experts Nederland group, a team of independent Excel experts which have joined their forces to enable better service levels for their customers.