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
Tame Power Query Workbook Privacy Settings

I recently built a cool Excel solution at work that uses Power Query to reach out and grab some weather data, then upload it into database.  We use that data in our dashboards, as weather is pretty important to the … Continue reading

The post Tame Power Query Workbook Privacy Settings appeared first on The Ken Puls (Excelguru) Blog.

Wed, 29 Oct 2014 13:00:00 +0000

.NET & Excel

By Dennis Wallentin

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

PTS Blog

By Jon Peltier
Error Bar Ideosyncrasy

After using Excel 2007 for a while, getting used to the idea that everything had changed and we weren’t going back to 2003 ever again, I started fooling around with charts and chart elements. I began to find lots of little changes, most of them actually good ones, even if they were implemented in a funny […]

The post Error Bar Ideosyncrasy appeared first on Peltier Tech Blog.

Wed, 29 Oct 2014 08:00:30 +0000

Contextures Blog

By Debrah Dalgleish
New Workbook Based On Old One

It's almost Halloween, and perhaps you're familiar with the horror story that I'm about to tell you. (And there is a treat at the end of the tale too.)

One day, not too long ago, Dr. Frankexcel needed to create new workbook. Instead of building the new workbook from scratch, Dr. F had a brilliant plan – open an old workbook, and use it as the base for the new file. Just open the old file, then quickly do a Save As, to create the new file, without damaging the existing one.

What could possibly go wrong? Bwaahhhaahhaa!


Continue reading New Workbook Based On Old One

Thu, 30 Oct 2014 04:02:00 +0000

Microsoft Excel on MSDN

By various Authors
Office 365 Search is now smarter about spreadsheets

Businesses use spreadsheets for many critical functions, such as financial reporting and investment modeling, and they need to minimize the risks that using these spreadsheets introduces. The need for strong spreadsheet management is emphasized in these stories compiled by the European Spreadsheet Risk Interest Group (EuSpRIG). Office responded to this need by introducing new features in Office 2013 to help manage the use of spreadsheets for important business functions, and…

The post Office 365 Search is now smarter about spreadsheets appeared first on Office Blogs.

Wed, 29 Oct 2014 16:00:37 +0000