About Me

Jan Karel Pieterse, Excel expert

Hi, I am Jan Karel Pieterse from The Netherlands. 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!

I founded JKP Application Development Services in November 2003.

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

Office Script and Power Automate Demo (YouTube video), Excel Virtually Global conference, October 17, 2022

Office Scripts (YouTube video), Excel Virtually Global conference, October 13, 2021

Smart VBA Macro Recording, Excel Virtually Global conference, July 23rd, 2020

Working with tables in Excel, Techcommunity webinar, January 22, 2020

Formulas – Pitfalls to avoid when creating Spreadsheet models, Excel Experts Class 2019, December 17, 2019, Utrecht

Business Modeling – Building powerful models using Power Pivot Light, Excel Experts Class 2019, December 17, 2019, Utrecht

Lookup functions, Excel Experience day 2019, December 12, 2019, Utrecht Leidsche Rijn

Pitfalls of some often-used functions in Excel, Excel Experience day 2019, December 12, 2019, Utrecht Leidsche Rijn

End User Developed Applications, Microsoft MVP Summit 2019, March 20, 2019, Redmond WA, USA

Creating a dynamic dashboard using Slicers, Excel Experts Class 2018, 7 December 2018, Arnhem

Useful VBA Tools, Excel Experts Class 2018, 7 December 2018, Arnhem

VBA: writing efficient code, Excel Experience day 2018, 6 December 2018, Arnhem

Reviewing Spreadsheets, Excel Experience day 2018, 6 December 2018, Arnhem

(older presentations omitted for brevity)

Publications

Books

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

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.