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 of looking for dependents.
Wed, 15 Nov 2017 17:30:00 GMT
Name manager updated
Name Manager for Excel has been updated. Fixed an issue caused by a Windows 10 bug. Renaming a name now also fixes hyperlinks using that name
Tue, 31 Oct 2017 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)
BBj Developer Wanted
I’m looking to hire a BBj developer in the Omaha, NE area. Why would a reader of an Excel blog care? I’m glad you asked. BBj used to be called BBx. And that was formerly known as Business Basic. If you’re a decent VBA or VB6.0 programmer, BBj will look pretty familiar to you. I’ve […]
Thu, 02 Nov 2017 23:33:15 +0000

The Ken Puls Blog

By Ken Puls
Unpivoting SubCategories

Ages ago I posted an article on unpivoting subcategories using Power Query.  The technique is still valid and, in fact, it’s one that I still teach using the same data set.  I’ve been able to use it on data with … Continue reading

The post Unpivoting SubCategories appeared first on The Ken Puls (Excelguru) Blog.

Mon, 30 Oct 2017 18:37:17 +0000

PTS Blog

By Jon Peltier
Designing UserForms for Mac and Windows

The Problem. There are many annoyances when designing a VBA project to run on both Windows and Mac computers. One of the most noticeable is related to the difference in screen resolution between the two platforms. On the Mac, it’s 96 dpi, where each dot represents a pixel. In Windows, screen resolution is 72 dpi […]

The post Designing UserForms for Mac and Windows appeared first on Peltier Tech Blog.

Thu, 09 Nov 2017 13:00:29 +0000

Contextures Blog

By Debrah Dalgleish
Do You Still Need Excel Subtotals?

Excel has a SUBTOTAL function, which ignores hidden or filtered rows. There is a Subtotal feature too, that quickly groups your data, and adds one or more rows of subtotals. Do we still need...

The post Do You Still Need Excel Subtotals? appeared first on Contextures Blog.

Thu, 16 Nov 2017 05:02:00 +0000

Microsoft Excel on MSDN

By various Authors
Microsoft 365 helps businesses increase trust and innovation through compliance with Compliance Manager Preview

With the increased use of personal data to customize user experiences, new compliance laws—such as the General Data Protection Regulation (GDPR)—are a logical policy component of our technology landscape. Microsoft 365 offers a complete cloud solution to help you with GDPR compliance, while Compliance Manager helps you assess and manage your compliance risk.

The post Microsoft 365 helps businesses increase trust and innovation through compliance with Compliance Manager Preview appeared first on Office Blogs.

Thu, 16 Nov 2017 16:00:04 +0000