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: Name Manager
Name Manager has just been updated to build 669. When a name is renamed, PowerQuery M code will be checked for existence of the name and updated accordingly
Fri, 21 Feb 2020 13:40:00 GMT
Webinar recording: Working with tables in Microsoft Excel
Ever used Format as Table in Microsoft Excel? Did you know Format as Table can be a whole lot more than just fancy formating? Join Jan Karel Pieterse as he discusses working with tables and how they can help you in your everyday work with Excel.
Fri, 31 Jan 2020 10:50:00 GMT

Excel Experts Nederland

Excel Expert Nederland Blog
Nieuw: ons Excel Forum
Wij kregen tamelijk veel Excel gerelateerde vragen in onze commentaren. Om deze vragen beter te kunnen kanaliseren zijn we daarom een Excel forum gestart. Heb je een vraag? Word lid van ons forum en stel hem hier: Excel Experts Nederland Forum
Mon, 30 Jan 2017 16:38:13 +0000

Daily Dose Of Excel

By Dick Kusleika (et al)
International Keyboard Shortcut Day 2019
The first Wednesday of every November is International Keyboard Shortcut Day. This Wednesday, people from all over the world will become far less efficient for a short time in an effort to be far more efficient the rest of the year. “WASD V2 88-Key ISO Custom” by Bitboxer is licensed under CC BY-NC-SA 2.0 This […]
Mon, 04 Nov 2019 14:12:45 +0000

The Ken Puls Blog

By Ken Puls
Monkey Tools is Here

We are super excited to announce that we’ve (at last) released the first version of our Monkey Tools software!  Ken has been working on this software on and off for the better part of 8 years now.  But after showing … Continue reading

The post Monkey Tools is Here appeared first on The Excelguru Blog.

Mon, 23 Mar 2020 17:02:54 +0000

PTS Blog

By Jon Peltier
Assign Chart Series Names or Categories with VBA

This tutorial shows VBA code to find ranges or allow a user to select ranges that have series names or category labels and apply them to the active chart.

The post Assign Chart Series Names or Categories with VBA appeared first on Peltier Tech Blog.

Wed, 12 Feb 2020 19:50:03 +0000

Contextures Blog

By Debrah Dalgleish
Excel Pivot Table Refresh Error with Data Model

Written by Debra Dalgleish from Contextures Blog

A simple data change can cause a strange pivot table refresh error, if you added the data to the Data Model. The problem is easy to fix, once you see what's causing it, but the error message, shown below, isn't much help! I'd never heard of function PCMinorObjectCollection, had you? Strange Error Message I learned … Continue reading "Excel Pivot Table Refresh Error with Data Model"

Excel Pivot Table Refresh Error with Data Model is a post from Contextures Blog and is not allowed to be copied to other sites

Thu, 26 Mar 2020 04:02:00 +0000

Microsoft Excel blog on TechCommunity

By various Authors
Excel for good: Supporting your child’s learning at home

We’re living in unprecedented times. For many, staying home and staying healthy while taking care of your family – and working remotely – are all of a sudden the new normal.

While it’s tough, we can and will absolutely get through it, especially as we come together and help one another.

As an example, I want to share a story from MVP Dave Paradi. Few years back, Dave had created math worksheets for his then elementary school-age kids to practice at home. Now he’s updated these practice sheets to help other parents work on math skills with their children during school closures. Read more >


We want to hear your stories – please add them in the comments below.




Fri, Mar 27 2020 15:05:27 +0000