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 formula checking and reporting significantly.
Thu, 14 Jun 2018 19:05:00 GMT
Update: Privacy Beleid JKP-ADS
Il weet het, saaaaai. Maar het moest er van komen ivm de AVG. Ons Privacy Beleid is aan onze site toegevoegd.
Mon, 28 May 2018 10:25: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)
Office 365 Pro Plus meets Windows 10S, they don’t fall in love.
I recently purchased a couple of Surface Laptops, that run Windows 10S. I went to install a couple of my Office 365 Pro Plus licenses on them. Now I’m wondering what that S stands for (apart from ‘Security’), after coming up against these three immutable laws: If you’ve got Windows 10S, you can only install […]
Sun, 03 Jun 2018 10:10:30 +0000

The Ken Puls Blog

By Ken Puls
Ranking Method Choices in Power Query

My recent post on showing the Top X with Ties inspired a discussion on ranking methods.  Where I was looking to rank using what I now know as a standard competition rank, Daniil chose to use a dense ranking method … Continue reading

The post Ranking Method Choices in Power Query appeared first on The Ken Puls (Excelguru) Blog.

Thu, 14 Jun 2018 19:39:45 +0000

PTS Blog

By Jon Peltier
Importing and Cleaning Data with Power Query

If you work with any type of data, then you know that rarely does it come perfectly in the format you need. Power Query (also called Get & Transform in Excel 2016) is the solution to this problem. Power Query is an amazing ETL tool (Extract, Transform, and Load). If you’re not using it then […]

The post Importing and Cleaning Data with Power Query appeared first on Peltier Tech Blog.

Tue, 19 Jun 2018 12:00:34 +0000

Contextures Blog

By Debrah Dalgleish
Excel Mileage Lookup With Total Distance
If you’re planning a vacation trip, Excel can help. It’s a great place to keep your packing lists, and you can track your vacation spending too (if you really want to know the total!). I’ve just uploaded a new sample file that will show how far you’ll travel. Select cities, and formulas do a mileage … Continue reading "Excel Mileage Lookup With Total Distance"
Thu, 14 Jun 2018 04:02:00 +0000

Microsoft Excel on MSDN

By various Authors

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