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 !!!

Probeer onze RefTreeAnalyser
de beste Excel formule auditing tool.

Cursussen

Excel VBA Masterclass (Engels)
Excel VBA voor Financials

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 > Nederlandse site > Nieuws
This page in English

Wijzigingen aan deze site

De 20 meest recente wijzigingen

(In omgekeerd chronologische volgorde, zowel Engelse en Nederlandse pagina's):

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
Updated article: Working with Circular references in Excel
I have updated the page on VBA driven circular reference calculations
Tue, 22 Oct 2019 11:45:00 GMT
Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Fixed issue where references are not found when formula contains new line character (alt+enter).
Thu, 26 Sep 2019 12:15:00 GMT
And the winner is...
Today I've posted the solutions I received for my Excel challenge of August 2019 named Combinations, Combinations.
Thu, 19 Sep 2019 14:00:00 GMT