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: GoBack.
Finally got some time to include an Excel 2007-2013 version of this little tool that traces where you went in your Excel files and gets you back easily!
Wed, 19 Nov 2014 06:45:00 GMT
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

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
Treat Consecutive Delimiters As One

A couple of weeks back, I received a comment on my “Force Power Query to Import as a Text File” blog post.  Rudi mentioned that he’d really like to see a method that would let us Treat Consecutive Delimiters as One; … Continue reading

The post Treat Consecutive Delimiters As One appeared first on The Ken Puls (Excelguru) Blog.

Wed, 17 Dec 2014 14: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
Chart Partial Range Between Variable Endpoints

Plotting Part of a Data Range Excel is pretty handy for collecting, analyzing, and charting lots of data. If you want to plot a subset of your data, you can manually adjust the data range used by the chart. But there are easier ways to select partial data ranges, and to make this selection less […]

The post Chart Partial Range Between Variable Endpoints appeared first on Peltier Tech Blog.

Thu, 20 Nov 2014 07:30:36 +0000

Contextures Blog

By Debrah Dalgleish
Count Activities in a Date Range

Today's challenge is to count how many guests stayed at a hotel, in a specific date range, based on the guest arrival and departure dates.

Find Specific Dates

In previous examples, we've seen how to check if a specific date falls within a date range. For example, if you have a list of orders, you can use SUMIF or SUMIFS, to add up all the orders between a start and end date. You can see the written instructions for this on my website.

Guest Visits

It is a little trickier to count hotel guests though, because the

Continue reading Count Activities in a Date Range

Thu, 18 Dec 2014 05:02:00 +0000

Microsoft Excel on MSDN

By various Authors
Announcing new Excel 2013 BI stability and usability improvements

Recently we announced a new public update to Excel 2013 that includes major stability and usability improvements in Self Service BI scenarios—especially when Power Query, Power Pivot and Power View are involved.

The post Announcing new Excel 2013 BI stability and usability improvements appeared first on Office Blogs.

Tue, 16 Dec 2014 19:20:09 +0000