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. Improved performance of formula checking and added formula block highlighting. 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.
Fri, 20 Jun 2014 15:50:00 GMT
Commenting has been fixed
I somehow managed to break the commenting function of my site. Today I fixed it again and you can go ahead and ask your questions or add your comments once more.
Mon, 02 Jun 2014 06:30:00 GMT

Excel Experts Nederland

Excel Expert Nederland Blog
The Amsterdam Excel Summit
Een unieke kans! Beste Excel liefhebbers! Is Excel de eerste en laatste applicatie die u iedere dag gebruikt? Wilt u uw Excel vaardigheden verbeteren en tips krijgen van de absoluut beste Excel experts ter wereld? Dan is dit unieke evenement iets voor u! Excel experts van wereldklasse Een absoluut unieke groep Excel MVP’s zal in mei 2014 in Amsterdam zijn om hun geweldige Excel kennis met u te delen. Deze MVP’s zijn in Amsterdam voor een bijeenkomst en wij zijn erin geslaagd om deze mensen voor ons evenement te boeken. Er is slechts weinig kans dat een dergelijke mogelijkheid zich nogmaals zal voordoen, dus wees er snel bij als u … Continue reading
Sun, 16 Feb 2014 19:54:42 +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
Pain Points – Power Query Credential Management
After my last post on Power Query Security Woes, Ehren – a developer on the Power Query team – sent me a message on Twitter about it.  I will blog about that later, after I’ve had a chance to test … Continue reading
Fri, 25 Jul 2014 16:36:29 +0000

.NET & Excel

By Dennis Wallentin
Free ApressOpen eBook: Office 365
I’m still alive although it was quite a long time ago I published any article here. But now that I’m back I hope I will speed things up so You will see more activity of my blog. Apress have a series of books that are made available for free. The series is  named ApressOpen eBooks […]
Tue, 13 May 2014 17:31:55 +0000

PTS Blog

By Jon Peltier
Peltier Tech Advanced Chart Utilities for Mac

The Peltier Tech Advanced Chart Utilities for Mac is here. Over the past month a month, I’ve converted the Advanced Edition of the Peltier Tech Chart Utility so that it works on a Mac as well as in Windows. I’m pleased that every feature from the Windows version has made it into the Mac version, though […]

The post Peltier Tech Advanced Chart Utilities for Mac appeared first on Peltier Tech Blog.

Tue, 08 Jul 2014 06:10:06 +0000

Contextures Blog

By Debrah Dalgleish
Excel Roundup 20140728

The Office 365 Garage Series has a video on what’s new in the Office Apps, and they demonstrate some cool new features. The Excel App is mentioned at the 7:12 mark, when they look at the new APIs for formatting.

However, at the 3:12 mark, they downplay the old development methods, including VBA and COM, and rave about the new methods -- HTML and JavaScript, that are used for the online versions of Office.

Apparently it’s almost impossible to find people who are still working in the older development platforms. What do you think of the chart they use to

Continue reading Excel Roundup 20140728

Mon, 28 Jul 2014 04:02:00 +0000

Microsoft Excel on MSDN

By various Authors
The Garage Series for Office 365: What’s new in the world of apps for Office?

This week hosts Jeremy Chapman and Richard diZerega explore what’s new in the new world of apps for Office. They look at the top 5 new features including amazing content apps for PowerPoint, Excel APIs for formatting, content apps for Access, mail APIs for body and attachments and compose mail apps. Watch as Richard masterfully demonstrates all of this along the way. Last week we caught up with Jeremy Thake…

The post The Garage Series for Office 365: What’s new in the world of apps for Office? appeared first on Office Blogs.

Wed, 23 Jul 2014 19:40:31 +0000