About Me
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
Excel add-ins that make your life easier (Youtube video), Excel virtually global conference, October 11, 2023
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.