Most Valuable Professional


View Jan Karel Pieterse's profile on LinkedIn subscribe to rss feed
Subscribe in a reader

Audit !!!

Check out our RefTreeAnalyser
the ultimate Excel formula auditing tool.

Speed up your file

FastExcel
The best tool to optimise your Excel model!
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 added formula block highlighting. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.
Fri, 20 Jun 2014 15:50:00 GMT
Commenting has been fixed
I somehow managed to break the commenting function of my site. Today I fixed it again and you can go ahead and ask your questions or add your comments once more.
Mon, 02 Jun 2014 06:30:00 GMT

Excel Experts Nederland

Excel Expert Nederland Blog
The Amsterdam Excel Summit
Een unieke kans! Beste Excel liefhebbers! Is Excel de eerste en laatste applicatie die u iedere dag gebruikt? Wilt u uw Excel vaardigheden verbeteren en tips krijgen van de absoluut beste Excel experts ter wereld? Dan is dit unieke evenement iets voor u! Excel experts van wereldklasse Een absoluut unieke groep Excel MVP’s zal in mei 2014 in Amsterdam zijn om hun geweldige Excel kennis met u te delen. Deze MVP’s zijn in Amsterdam voor een bijeenkomst en wij zijn erin geslaagd om deze mensen voor ons evenement te boeken. Er is slechts weinig kans dat een dergelijke mogelijkheid zich nogmaals zal voordoen, dus wees er snel bij als u … Continue reading
Sun, 16 Feb 2014 19:54:42 +0000

Daily Dose Of Excel

By Dick Kusleika (et al)

An error has occured while trying to process http://www.dailydoseofexcel.com/feed/
Please contact web-master.


The Ken Puls Blog

By Ken Puls
Power Query – The IF function
In my last post I talked about useful text functions, and how they differed between Excel and Power Query.  Today we’re going to look at another compare/contrast scenario, but this time it’s going to be the IF function. Critical background … Continue reading
Wed, 27 Aug 2014 16:15:51 +0000

.NET & Excel

By Dennis Wallentin
Articles about installing softwares from SamLogic
I’m aware of the fact that I nowadays rarely make any posts here at all. One explanation is that I’m learning about new tools and that I find it very satisfaction and enjoyable. Nevertheless, SamLogic, the Swedish vendor of Visual Installer and other excellent tools, have recently published some interesting articles which explain some important […]
Wed, 13 Aug 2014 09:55:33 +0000

PTS Blog

By Jon Peltier
Peltier Tech Advanced Chart Utilities for Mac

The Peltier Tech Advanced Chart Utilities for Mac is here. Over the past month a month, I’ve converted the Advanced Edition of the Peltier Tech Chart Utility so that it works on a Mac as well as in Windows. I’m pleased that every feature from the Windows version has made it into the Mac version, though […]

The post Peltier Tech Advanced Chart Utilities for Mac appeared first on Peltier Tech Blog.


Tue, 08 Jul 2014 06:10:06 +0000

Contextures Blog

By Debrah Dalgleish
Excel Roundup 20140825

There is a free app available for Excel (2013 or Online version), that lets you create 8 different chart types, including some that aren’t standard Excel charts, such as box plots. The app is called XLMiner Data Visualization, and it’s created by Frontline Systems, which also makes the Solver add-in.

If you log in to your Microsoft account, you can download and install the app from the Microsoft Store. Then select data, and the chart appears in the app’s window. In the screen shot below, you can see the box plot chart that I created, in just a few seconds.

Continue reading Excel Roundup 20140825


Mon, 25 Aug 2014 04:01:00 +0000

Microsoft Excel on MSDN

By various Authors
The Garage Series for Office 365: What’s new in the world of apps for Office?

This week hosts Jeremy Chapman and Richard diZerega explore what’s new in the new world of apps for Office. They look at the top 5 new features including amazing content apps for PowerPoint, Excel APIs for formatting, content apps for Access, mail APIs for body and attachments and compose mail apps. Watch as Richard masterfully demonstrates all of this along the way. Last week we caught up with Jeremy Thake…

The post The Garage Series for Office 365: What’s new in the world of apps for Office? appeared first on Office Blogs.


Wed, 23 Jul 2014 19:40:31 +0000