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

File crashes Excel!!

Save my workbook!
The best tool for salvaging problematic workbooks.


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

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

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)
Good VBA Dates and Bad Excel Dates
No, I’m not launching a match making service for Excel nerds. I’m talking about calendar dates. I was importing some data from a system that doesn’t seem to care what dates you might enter. Here’s the offender [crayon-5882a4d4c4a42301903529/] Instead of 2016, the user entered 1206. VBA doesn’t care. [crayon-5882a4d4c4a4c718572662/] But Excel cares. As you know, […]
Thu, 19 Jan 2017 15:27:55 +0000

The Ken Puls Blog

By Ken Puls
Power BI Boot Camp

I'm pretty excited to announce that we have our very first Power BI Boot Camp coming up in Vancouver, BC on Feb 22-24.  This is something that I've wanted to do for a while, and it's going to be awesome! … Continue reading

The post Power BI Boot Camp appeared first on The Ken Puls (Excelguru) Blog.

Tue, 17 Jan 2017 19:00:00 +0000

PTS Blog

By Jon Peltier
Export an Excel Chart to Word

You can use VBA to streamline a lot of your day-to-day practices, eliminate boring tasks, and reduce tedium. On this blog I recently showed how to Export an Excel Chart to PowerPoint. In this article I will show how to Export an Excel Chart to Word. I’ll follow up soon with more intricate routines that […]

The post Export an Excel Chart to Word appeared first on Peltier Tech Blog.

Mon, 12 Dec 2016 13:00:34 +0000

Contextures Blog

By Debrah Dalgleish
How to Prevent Grouped Dates in Excel

As a teenager, group dates can be fun. If you have strict parents, that might be the only kind of dates they allow! But, in your Excel worksheets, it can be annoying when dates...

The post How to Prevent Grouped Dates in Excel appeared first on Contextures Blog.

Thu, 19 Jan 2017 05:01:00 +0000

Microsoft Excel on MSDN

By various Authors
Episode 114 on Azure Functions for SharePoint add-ins with Doug Ware—Office 365 Developer Podcast

In episode 114 of the Office 365 Developer Podcast, Richard diZerega and Andrew Coates talk to MVP Doug Ware about Azure Functions and using them with SharePoint add-ins.

The post Episode 114 on Azure Functions for SharePoint add-ins with Doug Ware—Office 365 Developer Podcast appeared first on Office Blogs.

Thu, 19 Jan 2017 19:00:57 +0000