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 958. Fixed a problem caused by a Windows 10 bug.
Fri, 06 Jul 2018 14:05:00 GMT
Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Improved performance of formula checking and reporting significantly.
Thu, 14 Jun 2018 19:05: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)
Copying and Filling Table Totals
Suppose you have a table with a number of columns. And suppose you wanted to sum the Num6 column. You’d select a cell in that column and use Alt+JT+T to add the totals row. But Excel always sums the last column (that it’s able to) when it should really sum the one you’re on. That’s […]
Fri, 06 Jul 2018 12:52:04 +0000

The Ken Puls Blog

By Ken Puls
Disaster Recovery in Puerto Rico with Power Query

When Ken was at the Microsoft Business Applications Summit a few weeks ago, he met Mr. J.A. Garcia who has been doing some amazing work with Power Query. We wanted to share his story about how he has been using … Continue reading

The post Disaster Recovery in Puerto Rico with Power Query appeared first on The Ken Puls (Excelguru) Blog.

Thu, 16 Aug 2018 19:47:15 +0000

PTS Blog

By Jon Peltier
Step Charts in Excel

Step Charts are useful for showing values that don’t change steadily from one point to the next, but that instead are constant for a period of time, then jump to the next level, and are constant for another period of time. For example, step charts are good for showing how things like postal rates or […]

The post Step Charts in Excel appeared first on Peltier Tech Blog.

Thu, 19 Jul 2018 12:00:17 +0000

Contextures Blog

By Debrah Dalgleish
Resize Excel Comments with Macros
If you add comments to worksheet, eventually those comments might wander away from their original locations. Sometimes the comments change size too, and you need to adjust them. Instead of making changes manually, move or resize Excel comments with macros, to save time. Long ago, I shared macros to add comments, format or number them, … Continue reading "Resize Excel Comments with Macros"
Thu, 09 Aug 2018 04:01:00 +0000

Microsoft Excel on MSDN

By various Authors

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