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

Audit !!!

Check out our RefTreeAnalyser
the ultimate Excel formula auditing tool.

Trainings

Excel VBA Masterclass (English)
Excel VBA for Financials (Dutch)

Third party tools

Speed up your file

FastExcel
The best tool to optimise your Excel model!

Repair your file

Stellar Phoenix Excel Repair
Best tool to repair corrupt Excel sheets and objects
Home > English site > Newsletter

My newsletter archive

February 2017 Topics: Getting selected slicer items into your spreadsheet cells

January 2017 Topics: Bug in Styles object (VBA)

November 2016 Topics: Form controls bug revisited; What to use, Integer or Long?

October 2016 Topics: Form controls bug; report about Excel VBA Masterclass

September 2016 Topics: Excel Wheel Of Fortune, MVP Award

July/August 2016 Topics: Problems opening downloaded Excel files

June 2016 Topics: Problems with the ABAP2XLSX library

May 2016 Topics: Report of the Amsterdam Excel Summit 2016

April 2016 Topics: Update to RefTreeAnalyser

March 2016 Topics: Prevent deleting a sheet

February 2016 Topics: A Moving Checkbox

January 2016 Topics: Table Of Content, Webservice demo

December 2015 Topics: Useful VBA routines

November 2015 Topics: Articles on my website pertaining to Excel add-in development

October 2015 Topics: A faster model by getting rid of VLOOKUP

September 2015 Topics: Celebrating the 30th anniversary of Excel!

August 2015 Topics: Tools for Excel and VBA everyone should own.

July 2015 Topics: Golden rules for developing spreadsheets.

June 2015 Topics: Using the function wizard on nested functions, Summer sale, upcoming courses

May 2015 Topics: Use hyperlinks and Goto to find your VBA code, Why is my worksheet dead-slow.

April 2015 Topics: Date and time shortcut, Slow responding worksheets, Declare variables in VBA, Amsterdam Excel Summit, course "Excel VBA voor financials"

March 2015 Topics: Formula auditing shortcut, Styles, Amsterdam Excel Summit