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

Updated : Table Tools
I updated the TableTools add-in, with a couple of bug fixes.
Mon, 12 Nov 2018 15:15:00 GMT
Updated : Table Tools
I updated the TableTools add-in, which now ensures name changes of Tables are updated in PowerQuery queries!
Fri, 09 Nov 2018 08:30: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)
Keyboard Metrics III
In the grand tradition of Keyboard Shortcut Metrics and More Keyboard Metrics, here’s this: Procedure 2016 2017 2018 Grand Total MakeComma 20.54% 18.67% 19.01% 19.19% WrapSheetsDown 13.80% 17.15% 9.93% 14.93% WrapSheetsUp 8.60% 15.36% 7.33% 12.16% FillVirtualScreen 10.50% 11.04% 8.42% 10.40% CopyPasteValues 14.00% 4.84% 2.20% 6.54% ShowFormatting 5.85% 5.13% 7.04% 5.68% IncrementDate 4.25% 4.08% 9.77% 5.23% […]
Mon, 12 Nov 2018 13:00:34 +0000

The Ken Puls Blog

By Ken Puls
One Solution to Challenge 4

Yesterday, I posted a new Power Query Challenge, and in this post I'm going to show my solution to challenge 4.  You can pick up this solution as well as solutions created by the community in this thread of the … Continue reading

The post One Solution to Challenge 4 appeared first on The Ken Puls (Excelguru) Blog.

Fri, 30 Nov 2018 18:27:38 +0000

PTS Blog

By Jon Peltier
Can You Answer This Quora Question?

Lately I’ve started getting questions from the online forum Quora in my inbox. Maybe because I’ve answered a question or two, they think they’ve found a new source. Mostly I ignore these questions, because who has time. But recently, I answered the question, How can I have multiple scatter plots and one trendline for all of […]

The post Can You Answer This Quora Question? appeared first on Peltier Tech Blog.

Thu, 13 Dec 2018 19:18:47 +0000

Contextures Blog

By Debrah Dalgleish
Allow Weekend Dates Only in Excel
With Excel Data Validation, you can add rules to a data entry sheet, and control what people put in the cells. In today's example, we'll set up a cell that only allows you to enter a weekend date. Just remember that Data Validation isn't foolproof, and people can find ways around your rules. Weekend Date … Continue reading "Allow Weekend Dates Only in Excel"
Thu, 13 Dec 2018 05:01:00 +0000

Microsoft Excel on MSDN

By various Authors

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