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 > 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):

Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Fixed issue regarding range names in formulas.
Sun, 19 Feb 2017 13:20:00 GMT
Update to Flexfind
Updated: Flexfind. Added support for replacing in Powerquery M code (Excel 2016).
Sat, 18 Feb 2017 19:10:00 GMT
Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Fixed issue with short-cut keys not responding immediately after openening Excel.
Wed, 15 Feb 2017 07:50:00 GMT
Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. I have fixed a bug, Pivottables were not listed when pointing to a table name.
Thu, 9 Feb 2017 09:45:00 GMT
The Amsterdam Excel Summit 2017: Registration is open
Come and join us in Amsterdam on April 18 and 19 2017 for our famous Amsterdam Excel Summit. We have just opened registration so make sure you book your seats before Feb 20 and receive a nice early-bird discount! Visit the Amsterdam Excel Summit Website
Mon, 16 Jan 2017 16:20:00 GMT
Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. I have improved scrolling the selected cells into the viewable area of the screen
Thu, 5 Jan 2017 06:25:00 GMT
Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Fixed three bugs.
Wed, 14 Dec 2016 20:55:00 GMT
Name manager updated
Name Manager for Excel has been updated. Fix for finding dynamic range names when using the Formulas or 2D areas filter.
Tue, 13 Dec 2016 15:20:00 GMT
New article: a Simple Inventory System, built in Excel
Answering questions on forums can be very rewarding. This post is the result of a forum question. The forum member needed a simple system to manage his shop inventory. He wanted to be able to log Purchases, Reservations and Sold items and immediately be kept informed when items are (almost) out of stock..
Tue, 11 Oct 2016 13:15:00 GMT
New article: A wheel of Fortune, built in Excel
Excel is a very serious and powerful business application. That doesn't mean we can't have some fun with it. In this article I'll explain how I've built an Excel file which enables you to play with a wheel of fortune. With sound and all!.
Thu, 29 Sep 2016 17:45:00 GMT
New article: Excel add-ins fail to load
A recent Office update may cause your add-ins to be ignored by Excel. This article shows you how to fix that.
Wed, 17 Aug 2016 15:45:00 GMT
Updated: FollowCellPointer
I have just updated the small tool which follows your cell pointer by placing two arrows on top of your sheet pointing to the active cell. Fix: enabled for 64 bit Excel.
Mon, 15 Aug 2016 09:00:00 GMT
Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. I have added an option to display your formula as a mathematical equation.
Tue, 21 Jun 2016 14:55:00 GMT
Updated: An MSForms (all VBA) treeview.
Our All VBA treeview control now has a professional version which is ready for beta testing.
Thu, 16 Jun 2016 15:50:00 GMT
An MSForms (all VBA) listgrid.
Our All VBA treeview control now has a sister control: the ListGrid. This brand new control is ready for beta testing.
Thu, 16 Jun 2016 15:50:00 GMT
Register now: The Excel VBA Masterclass
We have just opened registration for The Excel VBA Masterclass. Course dates October 26 and 27, 2016.
Tue, 14 Jun 2016 14:10:00 GMT
Nieuw artikel: curves fitten met de kleinste kwadraten methode
Als je (net als ik, voordat ik Excel specialist werd) ingenieur bent, dan heb je waarschijnlijk het nodige aan experimeteerwerk gedaan. Vaak heb je dan een methode nodig om je meetresultaten te fitten met een kromme. En als je een echte ingenieur bent, dan heb je ook al een goed idee wat de soort vergelijking is de theoretisch bij je metingen zou moeten passen.
Tue, 12 Apr 2016 07:50:00 GMT
Nieuw artikel: Een klasse om VBA performance te meten
Ik ben er eindelijk aan toe gekomen een artikel te vertalen. Dit artikel beschrijft een methode om eenvoudig de performance van je VBA routines te meten.
Tue, 17 May 2016 07:50:00 GMT
Update to Flexfind
Updated: Flexfind. Improved selecting objects.
Thu, 21 Apr 2016 08:50:00 GMT
Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. I have improved the off-sheet references report to include tables and range names.
Fri, 8 Apr 2016 15:50:00 GMT