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

The Amsterdam Excel Summit 2018: Dates are set!
Come and join us in Amsterdam on June 7 and 8, 2018 for our fifth famous Amsterdam Excel Summit. We have just fixed the dates so make sure you Visit the Amsterdam Excel Summit Website
Tue, 20 Feb 2018 16:40:00 GMT
Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Improved performance of looking for dependents.
Wed, 15 Nov 2017 17: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)
Seven steps to (almost) protected Calculated Columns
Earlier I complained about how you can’t lock down Calculated Columns in Tables, while still allowing users to insert new rows. Dick gave me half a hack in the comments of that post, and I’ve come up with the other half to give you an almost-foolproof way to protect those precious Calculated Columns from your […]
Mon, 11 Dec 2017 02:48:19 +0000

The Ken Puls Blog

By Ken Puls
Extract Data Based on the Previous Row

This is a cool example of how to Extract Data Based on the Previous Row, which came up as a viewer's question inside our Power Query Academy.  Let's look at how we solved it… What Kind of Data Needs This … Continue reading

The post Extract Data Based on the Previous Row appeared first on The Ken Puls (Excelguru) Blog.

Wed, 07 Feb 2018 17:00:00 +0000

PTS Blog

By Jon Peltier
Extract Labels from Category Axis in an Excel Chart (VBA)

Question: Extract a Category Label for a Point I came across a question in the Excel Reddit, Is there a way to select a chart series point and have the label name of that point be copied into a cell? Answer 1: Chart with Simple Axis The short answer is the following function: you get […]

The post Extract Labels from Category Axis in an Excel Chart (VBA) appeared first on Peltier Tech Blog.

Thu, 15 Feb 2018 13:00:17 +0000

Contextures Blog

By Debrah Dalgleish
Excel Budget Report with Value Selector

Instead of showing a budget's forecast, actual and variance data all at once, click a button to view the values one at a time. That makes the report easier to read, and takes less...

The post Excel Budget Report with Value Selector appeared first on Contextures Blog.

Thu, 22 Feb 2018 05:02:00 +0000

Microsoft Excel on MSDN

By various Authors
Microsoft 365 provides an information protection strategy to help with the GDPR

Intelligent compliance solutions in Microsoft 365 support your journey to GDPR compliance by enabling you to assess and manage your compliance posture and leveraging the cloud to identify, classify, protect, and monitor sensitive data residing in hybrid and heterogeneous environments.

The post Microsoft 365 provides an information protection strategy to help with the GDPR appeared first on Office Blogs.

Thu, 22 Feb 2018 14:00:52 +0000