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
Combine Multiple Worksheets Using Power Query

In last week’s post we looked at how to combine multiple files together using Power Query.  This week we’re going to stay within the same workbook, and combine multiple worksheets using Power Query. Background Scenario Let’s consider a case where … Continue reading

The post Combine Multiple Worksheets Using Power Query appeared first on The Ken Puls (Excelguru) Blog.

Wed, 19 Nov 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
Excel Roundup 20141124

In a short video, Sara Silverstein shows 6 keyboard shortcuts for formatting numbers in Excel. Do you use any of these?

You can see the shortcuts in the video below, or on the Business Inside website.

Contextures Posts

Here’s what I posted recently:

Ignore blank cells when copying and pasting on a worksheet Create a simple calculated field in a pivot table For a humorous peek at what other people are saying about spreadsheets, read the latest collection of Excel tweets, on my Excel Theatre blog. There is a poll at the end, so please vote for your

Continue reading Excel Roundup 20141124

Mon, 24 Nov 2014 05:02:00 +0000

Microsoft Excel on MSDN

By various Authors
Power Query November 2014 update—Connect to Analysis Services, Salesforce and more! 

We are happy to announce the availability of the November 2014 update for Power Query—packed with lots of new features that we hope you will enjoy and thank us for them (since we are in the Thanksgiving week).

The post Power Query November 2014 update—Connect to Analysis Services, Salesforce and more!  appeared first on Office Blogs.

Tue, 25 Nov 2014 17:00:13 +0000