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: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Improved performance for Excel 2013 and 2016
Wed, 26 Apr 2017 14:20:00 GMT
Our Amsterdam Excel Summit was great
Our Amsterdam Excel Summit has been a great success. We had two very well received days full of Excel and Power BI sessions. Find links to photo impressions on my events page.
Tue, 25 Apr 2017 10:40: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)
Test Your Excel, VBA, and SQL Skills
I recently saw a resume with a bunch of VBA and SQL skills on it. I’ve never seen anything like it. I gave up trying to find someone with the right combination of skills a long time ago. Someone to whom I could offload some of my projects. But this had promise. I couldn’t get […]
Tue, 18 Apr 2017 18:48:04 +0000

The Ken Puls Blog

By Ken Puls
Create Column From Examples

I knew that the create Column From Examples feature had been released to Power BI Desktop, but it just showed up in my Excel 2016 build today.  And man is it cool! A scenario for Create Column From Examples A … Continue reading

The post Create Column From Examples appeared first on The Ken Puls (Excelguru) Blog.

Tue, 11 Apr 2017 17:00:14 +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 Price Lookup for Date and Product Name

If there’s just one price per product in an Excel lookup table, you could use the INDEX and MATCH functions to to get that price. But what if the price changes occasionally, and your...

The post Excel Price Lookup for Date and Product Name appeared first on Contextures Blog.

Thu, 27 Apr 2017 04:01:00 +0000

Microsoft Excel on MSDN

By various Authors
Outlook Customer Manager now rolling out worldwide with enhanced capabilities

Outlook Customer Manager provides an easy way for small businesses to track and grow customer relationships from right within Outlook.

The post Outlook Customer Manager now rolling out worldwide with enhanced capabilities appeared first on Office Blogs.

Mon, 24 Apr 2017 16:00:44 +0000