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: Compare Two Tables
I've added a new feature to the Compare2Tables tool. You can now select which difference tables you want the tool to produce.
Tue, 02 Apr 2019 16:40:00 GMT
Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. I have added a feature where pressing find precedents on a Pivot chart will select the underlying pivottable.
Tue, 26 Mar 2019 12:55: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
Creating a Fiscal Saturday Calendar

A recent question from one of our Power Query Academy registrants was about creating a fiscal Saturday calendar - or a calendar where periods end on the last Saturday of each month.  I cooked up a sample of one way … Continue reading

The post Creating a Fiscal Saturday Calendar appeared first on The Excelguru Blog.

Mon, 15 Apr 2019 18:41:51 +0000

PTS Blog

By Jon Peltier
Gantt Chart with Nice Date Axis

Simple Gantt Charts A year ago I wrote an article about Gantt Charts in Microsoft Excel. It was pretty comprehensive, showing how to make simple Gantt charts using worksheet conditional formatting and using regular Excel stacked bar charts, and it covered some advanced techniques for adding embellishments, such as a reference line for a given […]

The post Gantt Chart with Nice Date Axis appeared first on Peltier Tech Blog.

Mon, 20 May 2019 15:00:22 +0000

Contextures Blog

By Debrah Dalgleish
Excel Lookup Formula for Last Item in Column
How can you get the last number in an Excel column? I needed to do that in one of my sample files, so here's the formula that I used. Then, someone asked me how to get the last item (text or number) from a column, so there's a formula for that too. Column with Numbers … Continue reading "Excel Lookup Formula for Last Item in Column"
Thu, 16 May 2019 04:02:00 +0000

Microsoft Excel on MSDN

By various Authors

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