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

Registratie geopend: Excel VBA voor Financials
Excel VBA voor Financials; Een twee-daagse Excel VBA cursus (19 november en 3 december 2014). Bespaar tijd door het automatiseren van uw rapportages! Ontsluier de geheimen van VBA en breng uw Excel kennis en vaardigheden op ongekende hoogte !
Mon, 08 Sep 2014 15:35:00 GMT
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

Excel Experts Nederland

Excel Expert Nederland Blog
Cursus Excel VBA voor Financials
VBA niet uw sterke punt? Veel werk aan uw maandrapportages? Misschien is onze tweedaagse cursus Excel VBA Voor Financials iets voor u? Excel VBA voor Financials Dag 1, 19 november 2014 – Utrecht Dag 2, 3 december 2014 – Utrecht Bespaar tijd door het automatiseren van uw rapportages! Na deze unieke en praktijkgerichte training bent u in staat om : •Uw weg te vinden in de macro-omgeving van Excel •Macro’s voor Financials te ontwikkelen en aan te passen •Inzichtelijke code te schrijven gebaseerd op Best Practices •Mogelijke fouten te traceren en af te vangen •Bestanden aan elkaar te koppelen zonder hinderlijke formules •GeĂŻmporteerde gegevensbestanden te converteren en op te schonen … Continue reading
Mon, 08 Sep 2014 14:18:21 +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
Un-pivoting With Subcategories in Power Query
My last few posts have been relatively technical, so this time I figured I’d look at something practical.  I can’t believe it’s been almost a year since I blogged about Un-Pivoting data in Power Query, so it’s about time we … Continue reading
Wed, 24 Sep 2014 15:00:00 +0000

.NET & Excel

By Dennis Wallentin
Articles about installing softwares from SamLogic
I’m aware of the fact that I nowadays rarely make any posts here at all. One explanation is that I’m learning about new tools and that I find it very satisfaction and enjoyable. Nevertheless, SamLogic, the Swedish vendor of Visual Installer and other excellent tools, have recently published some interesting articles which explain some important […]
Wed, 13 Aug 2014 09:55:33 +0000

PTS Blog

By Jon Peltier
Swimmer Plots in Excel

A reader of the Peltier Tech Blog asked me about Swimmer Plots. The first chart below is taken from “Swimmer Plot: Tell a Graphical Story of Your Time to Response Data Using PROC SGPLOT (pdf)“, by Stacey Phillips, via Swimmer Plot by Sanjay Matange on the Graphically Speaking SAS blog. The swimmer chart below is an attempt to show […]

The post Swimmer Plots in Excel appeared first on Peltier Tech Blog.


Mon, 08 Sep 2014 07:00:25 +0000

Contextures Blog

By Debrah Dalgleish
Excel Roundup 20140929

I’ve seen lots of non-spreadsheet items with “Excel” in their names, such as gum, and bowling gloves, and hand dryers.

However, this is the first time that I’ve seen a product named after a pivot table. Do you think that they help you analyze your data more efficiently? I wonder if they have a women’s version too.

Kenneth Cole REACTION Men's Pivot Table LE Oxford

Contextures Posts

Here’s what I posted recently:

Color data entry cells with conditional formatting, to make them easy to find Use GetPivotData function to pull the total amount from a pivot table on specific

Continue reading Excel Roundup 20140929


Mon, 29 Sep 2014 04:01:00 +0000

Microsoft Excel on MSDN

By various Authors
Excel Power Map September update

Each month, we strive to improve Excel Power Map with features that matter most to you, so you can tell richer and more creative stories with your data. This month we are rolling out two big features, Power Map Filtering and Custom Maps, to make your experience using Power Map easier and more exciting!

The post Excel Power Map September update appeared first on Office Blogs.


Tue, 09 Sep 2014 16:00:41 +0000