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
Newsletter Archive

Audit !!!

Check out our RefTreeAnalyser
the ultimate Excel formula auditing tool.


Excel VBA for Financials (Dutch)

Third party tools

Speed up your file

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

Excel Headlines

My very own list of news on Excel, gathered from various sources!

This site

Summer sale at
Yes we're having a summer sale at From July 1 to July 10 we offer a 25 % discount on both our products: RefTreeAnalyser and The Excel File Remediation Utility
Thu, 25 Jun 2015 06:15:00 GMT
New product: The Excel File Remediation Utility
I have launched a new product you can try and buy directly from my site: The Excel File Remediation Utility. This tool helps you to try and salvage Excel models with problematic content accumulated during a long editing history.
Thu, 25 Jun 2015 06:15:00 GMT

Excel Experts Nederland

Excel Expert Nederland Blog
The Amsterdam Excel Summit 2015
Hallo! Na het enorme succes van vorig jaar, hebben we besloten opnieuw dit unieke evenement te organiseren: The Amsterdam Excel Summit Excel Experts Van Wereldklasse Een absoluut unieke groep Excel MVP’s zal in april 2015 in Amsterdam zijn om hun geweldige Excel kennis met u te delen. Deze MVP’s zijn in Amsterdam voor een bijeenkomst en wij zijn erin geslaagd om deze mensen voor ons evenement te boeken! Hoor het direct van de makers van Excel Iemand van het BI team van Microsoft zal tijdens dit evenement presentaties verzorgen, dus als je wilt weten welke kant het op gaat bij Microsoft Excel, zorg dan dat je erbij bent! Programma We hebben … Continue reading
Mon, 26 Jan 2015 16:28:42 +0000

Daily Dose Of Excel

By Dick Kusleika (et al)

An error has occured while trying to process
Please contact web-master.

The Ken Puls Blog

By Ken Puls
Power Query’s Extract Text Feature

This will be a short post, as today we are leading our second sold out Power Query workshop at  I wanted to make sure I still got something out for my readers today though.  This time I’m looking at … Continue reading

The post Power Query’s Extract Text Feature appeared first on The Ken Puls (Excelguru) Blog.

Wed, 26 Aug 2015 18:10:51 +0000

.NET & Excel

By Dennis Wallentin

An error has occured while trying to process
Please contact web-master.

PTS Blog

By Jon Peltier
Plot Values Along the Axis of an Excel Chart

A blog reader emailed me with a question: I want to visualize a series of prices on single axis: I want to portray these in correct proportion, horizontally along a single line – much like points on a thermometer. These prices are going to be the X values. You need some kind of dummy Y values, […]

The post Plot Values Along the Axis of an Excel Chart appeared first on Peltier Tech Blog.

Thu, 13 Aug 2015 14:24:41 +0000

Contextures Blog

By Debrah Dalgleish
Excel Worksheet Navigation Tips

It can be a real pain to find a specific sheet, if an Excel file has lots of worksheets. If I'm making a big file for a client, I'll often colour groups of sheet tabs, to they're easier to find. Then, if you want the admin lists sheets, look for the red group.

Cobbler's Syndrome

For my own workbooks, I usually don't bother, and then end up wasting time, scrolling back and forth, looking for the sheet that I need. It's like the old saying – "The shoemaker's children go barefoot." Apparently I'm not the only one who

Continue reading Excel Worksheet Navigation Tips

Thu, 27 Aug 2015 04:01:00 +0000

Microsoft Excel on MSDN

By various Authors

An error has occured while trying to process
Please contact web-master.