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

File crashes Excel!!

Save my workbook!
The best tool for salvaging problematic workbooks.


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 on analysing conditional formatting formulas
Tue, 15 Aug 2017 13:20:00 GMT
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

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)
Inconsistent ListRow Copy
Here’s a cautionary tale for you. Let’s say you want to let users copy rows from a Source table row by row to a Dest table, by pushing a button: …so you whip up a bit of code like this, and assign it to that button: [crayon-599b7411af667320293705/] And when you run it, it works just […]
Sat, 29 Jul 2017 13:11:57 +0000

The Ken Puls Blog

By Ken Puls
Merge Files With Different Column Headers

A client contacted me today asking how to merge files with different column headers in Power Query.  The issue she's facing is that some of the files in her folder have a column called "customer", where others have a column … Continue reading

The post Merge Files With Different Column Headers appeared first on The Ken Puls (Excelguru) Blog.

Wed, 26 Jul 2017 20:36:29 +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 CONVERT Function With Drop Down Lists

With the Excel CONVERT function, you can change quantities from one measurement type to another. For example, a hot day in Celsius looks even worse in Fahrenheit! Get my CONVERT workbook, with drop down...

The post Excel CONVERT Function With Drop Down Lists appeared first on Contextures Blog.

Thu, 17 Aug 2017 04:01:00 +0000

Microsoft Excel on MSDN

By various Authors
Introducing the beta

Starting today, you can opt in to the beta—where our engineers and designers deploy their newest ideas—so you can tell us what you think. Together we’ll shape the future of

The post Introducing the beta appeared first on Office Blogs.

Tue, 08 Aug 2017 17:15:51 +0000