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. I have added an option to report all unique formulas in your workbook. 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.
Thu, 23 Oct 2014 16:45:00 GMT
Celebrating my MVP award: Discount offer
Every quarter Microsoft announces who are the lucky ones to receive their Most Valuable Professional Award. I got re-awarded! To celebrate that I am offering a 3 day 50 percent discount on RefTreeAnalyser. From October 8, 2014 to October 10, 2104 you receive 50 % off of the list price when you enter this coupon code: MVP2014 Head over to my website now and download the tool, you can try it for free!
Tue, 07 Oct 2014 09:30:00 GMT

Excel Experts Nederland

Excel Expert Nederland Blog
Weer een jaar MVP
Hallo allemaal! Ieder kwartaal maakt Microsoft bekend wie de gelukkige ontvangers zijn van hun Most Valuable Professional Award. Een MVP award geldt voor een jaar, dus voor een kwart van de MVPs is 1 oktober een spannende dag. En ik heb de award weer gekregen!! Om dat te vieren bied ik een 3 dagen durende kortingsactie aan op mijn Formula auditing tool: RefTreeAnalyser Vanaf 8 oktober 2014 tot en met 10 oktober 2104 ontvang je 50 % korting op de tool als je deze couponcode invoert tijdens het bestelproces: MVP2014 Haast je naar mijn website en download de tool, je kunt deze gratis uitproberen! Groetjes, Jan Karel Pieterse
Tue, 07 Oct 2014 07:28:25 +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
Refresh Power Query With VBA

When I’ve finished building a solution in Excel, I like to give it a little polish, and really make it easy for my users to update it.  The last thing I want to do is to send them right clicking … Continue reading

The post Refresh Power Query With VBA appeared first on The Ken Puls (Excelguru) Blog.

Wed, 22 Oct 2014 13:00:00 +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
Pivot Tables in Microsoft Excel: Links

This introduction has been contributed by Debra Dalgleish, Excel MVP.  Contextures, Copyright © 2014. All rights reserved. Debra Dalgleish, Excel MVP since 2001, is the author of three books on pivot tables, published by Apress. She shares Excel tips, tutorials, and videos on her websites, and Web Sites Peltier Tech Blog – Pivot […]

The post Pivot Tables in Microsoft Excel: Links appeared first on Peltier Tech Blog.

Mon, 06 Oct 2014 08:15:51 +0000

Contextures Blog

By Debrah Dalgleish
Excel Chart Compares High and Low Scores

Last weekend, I helped someone who needed a chart for a fantasy football league, to show the highest and lowest win/loss scores for each week. To help explain what it should look like, they posted a picture of a hand drawn chart, similar to the picture below.

By the way, I created the sketch in Excel, by using the Marker option, in the Artistic Effects. Who knew that Excel was so artistically talented?

Set Up the Data

The win/loss data was set up with a separate column for each week, and rows for the win and loss highs

Continue reading Excel Chart Compares High and Low Scores

Thu, 23 Oct 2014 04:01:00 +0000

Microsoft Excel on MSDN

By various Authors
Microsoft sponsors the Financial Modeling World Championships for Excel power users

ModelOff, the Financial Modeling World Championships for Excel, is a fun and educational international competition for students and professionals. This year, Microsoft continues the tradition of sponsoring this exciting event.

The post Microsoft sponsors the Financial Modeling World Championships for Excel power users appeared first on Office Blogs.

Thu, 23 Oct 2014 17:53:04 +0000