Most Valuable Professional


View Jan Karel Pieterse's profile on LinkedIn subscribe to rss feed
Subscribe in a reader

Subscribe to our mailing list

* indicates required

Audit !!!

Check out our RefTreeAnalyser
the ultimate Excel formula auditing tool.

Trainings

Excel VBA Masterclass (English)
Excel VBA for Financials (Dutch)

Third party tools

Speed up your file

FastExcel
The best tool to optimise your Excel model!

Repair your file

Stellar Phoenix Excel Repair
Best tool to repair corrupt Excel sheets and objects
Home > English site > Headlines

Excel Headlines

My very own list of news on Excel, gathered from various sources!

This site

New article: Excel add-ins fail to load
A recent Office update may cause your add-ins to be ignored by Excel. This article shows you how to fix that.
Wed, 17 Aug 2016 15:45:00 GMT
Updated: FollowCellPointer
I have just updated the small tool which follows your cell pointer by placing two arrows on top of your sheet pointing to the active cell. Fix: enabled for 64 bit Excel.
Mon, 15 Aug 2016 09:00:00 GMT

Excel Experts Nederland

Excel Expert Nederland Blog
Tref ons op de 10e Excel Experience Day!
Vrijwel al onze Excel Experts zullen op de 10e Excel Experience Day als spreker fungeren. Dus als u ons wilt ontmoeten (en -wellicht- spreken over toekomstige projecten), dan is dat een uitgelezen gelegenheid! Dus schrijf u nu in en tref ons 10 december in Burgers Zoo! Jan Karel Pieterse
Wed, 04 Nov 2015 16:47:27 +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
Fix: Excel Formulas don’t update in Power Query tables

If you’re new to Power Query, chances are you’re more comfortable doing tricky mathematics using Excel formulas, rather that Power Query formulas.  No shame there, but you’ve probably run into a situation where you set up the formulas, refresh your … Continue reading

The post Fix: Excel Formulas don’t update in Power Query tables appeared first on The Ken Puls (Excelguru) Blog.


Tue, 23 Aug 2016 16:58:44 +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
VB Password Prompt when Closing Excel

The VB Password Prompt Problem The VB Password Prompt is a (usually) rare problem that occurs when you are using a workbook or add-in with a password protected Visual Basic project. When you quit Excel, you are asked for a password to open the VB project. You may not know the password, so you click Cancel once, […]

The post VB Password Prompt when Closing Excel appeared first on Peltier Tech Blog.


Tue, 23 Aug 2016 15:15:39 +0000

Contextures Blog

By Debrah Dalgleish
Quick Ways to Unpivot Excel Data

Before you can build a flexible pivot table, you might need to rearrange the data. For example, if the data has a separate column for each month’s sales, that won’t work well in a pivot table. You need to “unpivot” your data first. Here’s what that means, and 2 quick ways to unpivot Excel data.

Excel Dashboards

First, a reminder that today, Thursday August 18th, is the last day to register for Mynda Treacy's highly-rated Excel dashboard course. Don't miss out – it well be a few months before the course opens again! You’ll learn how to create awesome

Continue reading Quick Ways to Unpivot Excel Data

The post Quick Ways to Unpivot Excel Data appeared first on Contextures Blog.


Thu, 18 Aug 2016 04:02:00 +0000

Microsoft Excel on MSDN

By various Authors
Grundfos makes global business happen withOffice 365

"During our global growth phase, Grundfos chose Office 365 as the foundation for a modern, connected workplace used by more than 18,652 employees around the world. Today, we all use Office 365 applications to connect with each other…." —Continue to read the complete Leadership blog by Jens Hartmann, CIO and group vice president at Grundfos Holding.

The post Grundfos makes global business happen with
Office 365
appeared first on Office Blogs.


Fri, 26 Aug 2016 23:00:58 +0000