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.


Excel VBA Masterclass (English)
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

Update: Excel File Remediation Utility
Our Excel File Remediation Utility has just been updated. I have added an option to remove all styles from the workbooks. This is very useful if you have Excel files with corrupt styles.
Thu, 23 Mar 2017 15:40:00 GMT
Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Added jump to pivotsource when you trace precedents when in a pivottable.
Fri, 03 Mar 2017 13:00:00 GMT

Excel Experts Nederland

Excel Expert Nederland Blog

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

Daily Dose Of Excel

By Dick Kusleika (et al)
KwikOpen Exclusions
I use a product called SQL Prompt from Redgate in SSMS. Honestly I can’t image life without it. They added a new feature to the grid right-click menu called Open in Excel. It’s very handy and definitely worth the trip over to my mouse. My only complaint about it is that it adds the resulting […]
Tue, 21 Mar 2017 13:28:33 +0000

The Ken Puls Blog

By Ken Puls
Calculate Start and End Dates

I got an email from a reader this morning who asked how to calculate start and end dates for a given employee when they have had multiple terms of employment.  Since it's been a while since we've had a technical … Continue reading

The post Calculate Start and End Dates appeared first on The Ken Puls (Excelguru) Blog.

Tue, 14 Mar 2017 18:00:00 +0000

PTS Blog

By Jon Peltier
Peltier Tech Charts for Excel – Demo Version

I’ve finally finished a demo version of Peltier Tech Charts for Excel 3.0. This trial version will allow potential users to try the software before they buy a license. In 2008 I launched my first commercial Excel add-in, Peltier Tech Waterfall Chart Utility. All it did was make waterfall charts. Over the years I made […]

The post Peltier Tech Charts for Excel – Demo Version appeared first on Peltier Tech Blog.

Wed, 22 Mar 2017 13:00:29 +0000

Contextures Blog

By Debrah Dalgleish
Excel Freeze All Worksheets Macro

If you’re working with a large worksheet in Excel, it usually helps if you freeze the cells at the top and/or the left side of the sheet. That way, your headings are always visible,...

The post Excel Freeze All Worksheets Macro appeared first on Contextures Blog.

Thu, 23 Mar 2017 04:01:00 +0000

Microsoft Excel on MSDN

By various Authors
Learn how to stay ahead of the curve in the future of work

Join us for the next episode of Modern Workplace, “The Future of Work: Build, attract, connect.”

The post Learn how to stay ahead of the curve in the future of work appeared first on Office Blogs.

Tue, 28 Mar 2017 19:00:09 +0000