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!

What has changed?

PerfectXL Compare, for Spreadsheet Comparison
This Excel compare tool is fast, reliable, and easy to use. Compare two Excel files now and see for yourself!
Home > English site > News
Deze pagina in het Nederlands

Web Changes

Last 20 changes to this site (in reverse chronological order, both Dutch and English updates are shown):

Video: Smart Macro Recording
I presented during the Excel Virutally Global conference in July 2020, Here's the recorded video: Smart VBA Macro Recording
Mon, 24 Aug 2020 16:15:00 GMT
Updated article: Prevent Open Event
I have updated my existing article on how to prevent Open events from running as Microsoft has changed the way Excel responds to the Shift key being held down (it now ignores it).
Thu, 13 Aug 2020 16:15:00 GMT
New article: Enabling Drag and Drop between two Listboxes on a VBA Userform
I have added a new article today which shows how to enable drag and drop between two listboxes on an Excel userform
Wed, 10 Jun 2020 10:30:00 GMT
Nieuw artikel: Gegevenstypen gebruiken in Excel
Ik heb een artikel toegevoegd over het gebruik van Gegevenstypen in Excel.
Thu, 21 May 2020 16:00:00 GMT
New article: Using Data Types in Excel
I have added a new article today about data types in Excel.
Fri, 08 May 2020 15:20:00 GMT
New article: A Generic Spreadsheet Template
I have added a new article today about what every spreadsheet models should contain. With a free download too!
Fri, 01 May 2020 17:40:00 GMT
Nieuw artikel: Een Generiek Spreadsheet Sjabloon
Ik heb een nieuw artikel toegevoegd vandaag over wat er in ieder goed Excel bestand zou moeten zitten. Met gratis download.
Fri, 01 May 2020 17:40:00 GMT
The Excel VBA Masterclass
I have scheduled a new run of my Excel VBA Masterclass for these dates: May 18, 20, 26 and 28, 2020 June 2 and 4, 2020. The masterclass will be completely on-line, using Microsoft Teams. Make sure you register now
Thu, 23 Apr 2020 09:25:00 GMT
Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Added PowerQuery M code to Object search. Fixed a bug regarding finding cell references in Objects
Wed, 15 Apr 2020 10:55:00 GMT
Updated: Compare Two Tables
I've fixed two bugs in the tool.
Fri, 10 Apr 2020 15:00:00 GMT
Update: Name Manager
Name Manager has just been updated to build 672. Range names generated by the new LET function are now correctly identified as system names
Wed, 1 Apr 2020 10:40:00 GMT
Update: Name Manager
Name Manager has just been updated to build 671. When a name is renamed, PowerQuery M code will be checked for existence of the name and updated accordingly
Fri, 21 Feb 2020 13:40:00 GMT
Webinar recording: Working with tables in Microsoft Excel
Ever used Format as Table in Microsoft Excel? Did you know Format as Table can be a whole lot more than just fancy formating? Join Jan Karel Pieterse as he discusses working with tables and how they can help you in your everyday work with Excel.
Fri, 31 Jan 2020 10:50:00 GMT
Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. You can now choose whether or not to display references in your formula more than once
Wed, 15 Jan 2020 09:20:00 GMT
Updated : Table Tools
I have updated the TableTools add-in, with a couple of bug fixes.
Mon, 13 Jan 2020 13:30:00 GMT
The Excel VBA Masterclass
I have scheduled a new run of my Excel VBA Masterclass. Make sure you register now
Tue, 26 Nov 2019 12:45:00 GMT
New download: Excel Spreadsheet Model Template
To help in the battle towards better spreadsheets I have uploaded an Excel Spreadsheet Model Template.
Wed, 20 Nov 2019 09:05:00 GMT
Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Fixed the wrong calculation setting (use 1 core only) of the add-in
Tue, 12 Nov 2019 09:45:00 GMT
Update: Excel File Remediation Utility
The Excel File Remediation Utility has been updated to build 128. Added "Copy sheet special" item to right-click menu of worksheet tabs.
Thu, 31 Oct 2019 09:15:00 GMT
Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Improved the layout of the Object references dialog
Wed, 30 Oct 2019 16:15:00 GMT