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 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 added an option to display your formula as a mathematical equation.
Tue, 21 Jun 2016 14:55:00 GMT
Updated: An MSForms (all VBA) treeview.
Our All VBA treeview control now has a professional version which is ready for beta testing.
Thu, 16 Jun 2016 15:50:00 GMT

Excel Experts Nederland

Excel Expert Nederland Blog
Tref ons op de 10e Excel Experience Day!
Vrijwel al onze Excel Experts zullen op de 10e Excel Experience Day als spreker fungeren. Dus als u ons wilt ontmoeten (en -wellicht- spreken over toekomstige projecten), dan is dat een uitgelezen gelegenheid! Dus schrijf u nu in en tref ons 10 december in Burgers Zoo! Jan Karel Pieterse
Wed, 04 Nov 2015 16:47:27 +0000

Daily Dose Of Excel

By Dick Kusleika (et al)

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

The Ken Puls Blog

By Ken Puls
June 2016 Power Query Update

Yesterday, Microsoft released the June 2016 Power Query update.  Even though there are only four items on the list of new features, some of them are quite impactful. What’s new in the June 2016 Power Query Update The four new … Continue reading

The post June 2016 Power Query Update appeared first on The Ken Puls (Excelguru) Blog.

Wed, 22 Jun 2016 16:57:47 +0000

.NET & Excel

By Dennis Wallentin

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

PTS Blog

By Jon Peltier
Paired Waterfall Chart

The Paired Waterfall Chart I came across a new (for me) style or waterfall chart last month, which I call the paired waterfall chart. It is designed to show how an investment fund’s total holdings, comprised of stocks or other vehicles and cash, changes during a time period, based on changes in value of its […]

The post Paired Waterfall Chart appeared first on Peltier Tech Blog.

Thu, 12 May 2016 13:00:21 +0000

Contextures Blog

By Debrah Dalgleish
Keeping Track of Garbage in Excel

I’ve worked with “garbage” data many times in Excel. You know what I mean – data that is so messy it takes you hours (or days) to clean it up. This week though, I did a different type of garbage tracking -- an Excel waste collection schedule.

Maybe I went a little overboard, but you’ve probably done that too, right? Anyway, here’s how I spent way too much time on an Excel project, but had fun doing it. Don’t judge! What weird Excel projects have you done?

Fancy New Carts

In January, our city switched from weekly garbage collection,

Continue reading Keeping Track of Garbage in Excel

The post Keeping Track of Garbage in Excel appeared first on Contextures Blog.

Thu, 23 Jun 2016 04:01:00 +0000

Microsoft Excel on MSDN

By various Authors
Office 365 news roundup

Discover how much you can learn and do with Office 365—and take the opportunity to catch up on recent Office news.

The post Office 365 news roundup appeared first on Office Blogs.

Fri, 24 Jun 2016 20:30:24 +0000