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

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-5887180c9d511525622601/] Instead of 2016, the user entered 1206. VBA doesn’t care. [crayon-5887180c9d51a895108673/] 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
FastTrack expands to support Windows 10, Dynamics 365 and Microsoft Teams

We are very excited to announce several enhancements to Microsoft FastTrack, our customer success service for the Microsoft Cloud, including the previews of FastTrack for Windows 10 and Dynamics 365, as well as onboarding and user adoption assistance for Microsoft Teams.

The post FastTrack expands to support Windows 10, Dynamics 365 and Microsoft Teams appeared first on Office Blogs.

Mon, 23 Jan 2017 17:00:42 +0000