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. I have improved the Check Formulas interface.
Tue, 06 Aug 2019 16:19:00 GMT
Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. I have fixed a small bug pertaining to hard-coded strings in formulas.
Mon, 29 Jul 2019 16:45: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)
Putting Statistics
Because of my recent terrible putting, I decided to keep track of every putt to see what I can see about it. Here’s how I compiled the stats. I wrote down how many paces each putt was and assumed one step was 2.5 feet. The Made formula in the table is [crayon-5d625d1231b31593171481/] For that date […]
Mon, 19 Aug 2019 13:11:57 +0000

The Ken Puls Blog

By Ken Puls
Solutions for Power Query Challenge 6

This morning I logged in to check the solutions for Power Query Challenge 6 that were submitted and... Wow!  There were a bunch, and some cool variety there.  So now it's time to show you all what I came up … Continue reading

The post Solutions for Power Query Challenge 6 appeared first on The Excelguru Blog.

Fri, 02 Aug 2019 00:31:23 +0000

PTS Blog

By Jon Peltier
Error Bar Gantt Chart

Floating Bars and Gantt Charts Gantt charts are a special kind of floating bar chart used in scheduling and program management. A list of tasks or activities is plotted along the left hand axis, and dates along the bottom axis. Floating horizontal bars indicate when tasks begin and end, and which tasks are in progress […]

The post Error Bar Gantt Chart appeared first on Peltier Tech Blog.

Thu, 30 May 2019 15:00:10 +0000

Contextures Blog

By Debrah Dalgleish
Printable Excel Weekly Planner
Even if you love Excel, there might be times when you want to work on paper, instead of on the screen. I've made a printable Excel weekly planner, and you can customize the sections, and then print it out. Plan Your Week Even though I work in Excel all day, there are a few things … Continue reading "Printable Excel Weekly Planner"
Thu, 22 Aug 2019 04:02:00 +0000

Microsoft Excel on MSDN

By various Authors

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