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

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
Please contact web-master.

The Ken Puls Blog

By Ken Puls
Power Query Security Woes
Recently I’ve been working on automating a business process for a client.  It’s become a really interesting project that uses a mix of Excel tables, Power Query, Power Pivot and VBA, as well as a WinAutomation script.  Before I talk … Continue reading
Mon, 21 Jul 2014 15:05:34 +0000

.NET & Excel

By Dennis Wallentin
Free ApressOpen eBook: Office 365
I’m still alive although it was quite a long time ago I published any article here. But now that I’m back I hope I will speed things up so You will see more activity of my blog. Apress have a series of books that are made available for free. The series is  named ApressOpen eBooks […]
Tue, 13 May 2014 17:31:55 +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 20140714

Are you using Power Pivot or any of the other Power BI tools in Excel 2013? If you’re not sure where to start, there is a new series on the Power BI blog, that will help you dive into the new BI and visualization features.

The series outline is here, and it will have links to all the articles, as they are added to the blog. The first article is Getting Started with Power Query – Part 1, and it features the 15-minute video shown below. You’ll need Excel 2013, and the article has a link to download the Power

Continue reading Excel Roundup 20140714

Mon, 14 Jul 2014 04:02:00 +0000

Microsoft Excel on MSDN

By various Authors
Webinar: Understanding the Excel Data Model
The Excel Data Model is revolutionizing how you can work with data in Excel. In this webinar, guest host Owen Duncan teaches us how Excel Data Models provide lightning fast data analysis and visualizations. Need a 30-second sneak peek? Here’s a 30-second trailer perfect for sharing in social media. What you will learn What an Excel Data Model is How to get data into a Data Model How to create relationships…
Mon, 14 Jul 2014 19:16:30 +0000