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

FastExcel
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 www.jkp-ads.com
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 http://www.dailydoseofexcel.com/feed/
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 http://xldennis.wordpress.com/feed
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
Ignore Blank Cells When Pasting

Last week, I was working on a client's file, and we wanted to get any new information from an update file, and paste it into the current record.

Both files were set up with the same columns, but the update file only had a few of the fields filled in. We could have used a macro to loop through the fields, grab any new information, and paste it to the current record. However, that would be a slow way to update the records, especially in a large file.

Fortunately, there is a built-in feature in Excel, that will copy a

Continue reading Ignore Blank Cells When Pasting


Thu, 20 Nov 2014 05:02:00 +0000

Microsoft Excel on MSDN

By various Authors
Introducing a new feature in Access 2013 web apps—Download in Excel

We’re proud to announce that a new feature called, “Download in Excel” is available to all of our Access 2013 Office 365 customers, which makes this process much simpler. This update is available for customers using Office 365 with Access Services so look for this feature soon within your web apps and try it out.

The post Introducing a new feature in Access 2013 web apps—Download in Excel appeared first on Office Blogs.


Fri, 21 Nov 2014 17:00:38 +0000