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

Nieuw artikel: Cocreatie in Office 365
Ik heb vandaag een nieuw artikel toegevoegd over Cocreatie in Excel 2016
Thu, 29 Jun 2017 07:00:00 GMT
New article: Co-authoring in Office 365
I have added a new article today about co-authoring in Excel 2016
Fri, 23 Jun 2017 16:00: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)
Always Use Stored Procedures
I take data that has been entered in Excel and I store it in SQL Server. A lot. I do that a lot. The proper way to do that is to create a stored procedure for every database operation you need and to execute that stored procedure from VBA. The quick and dirty way is […]
Thu, 13 Jul 2017 22:09:29 +0000

The Ken Puls Blog

By Ken Puls
Reduce Development Lag

How we reduce development lag when building queries in Power Query is a question that came up in my blog post at PowerPivotPro last week, even though that wasn't the main issue.  I thought it might be a good idea … Continue reading

The post Reduce Development Lag appeared first on The Ken Puls (Excelguru) Blog.

Thu, 20 Jul 2017 19:49:00 +0000

PTS Blog

By Jon Peltier
Drop Buttons on VBA UserForm Controls

What Are Drop Buttons Drop Buttons are buttons which are part of another control. For example, in a ComboBox, the Drop Button is a small button with an arrow; when clicked this Drop Button drops down a list of options for the user to select from. Drop Buttons are very useful with Textboxes, where they […]

The post Drop Buttons on VBA UserForm Controls appeared first on Peltier Tech Blog.

Thu, 20 Jul 2017 13:00:59 +0000

Contextures Blog

By Debrah Dalgleish
Excel Pop Up Selector Tool With Slicer

Slicers make it easy to select from a list of items, but they take up valuable space on your worksheet. To get the benefits of a Slicer, without the real estate cost, AlexJ made...

The post Excel Pop Up Selector Tool With Slicer appeared first on Contextures Blog.

Thu, 20 Jul 2017 04:04:00 +0000

Microsoft Excel on MSDN

By various Authors
Get the most out of your day with new calendar features in

Your life is busy, and your time is valuable—so it’s essential to have a calendar that is both powerful and easy to use. Today, we’re introducing several new features that make your calendar more intelligent and helpful.

The post Get the most out of your day with new calendar features in appeared first on Office Blogs.

Wed, 19 Jul 2017 16:00:50 +0000