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

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
Please contact web-master.

The Ken Puls Blog

By Ken Puls
Power Query – The Round Function
The other day I asked one of my co-workers how many ways he knew of to round a number.  His answer was one… if it ends in .4 it rounds down and if it ends in .5 it rounds up.  … Continue reading
Wed, 17 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
Worksheet Combo Box Problem in Excel 2013

On of my favourite Excel tricks is to show a combo box, when you click a cell that has a drop down list. The combo box can have larger font, and it autocompletes, so it’s easier for people to use.

There is only one ActiveX combo box on the worksheet, and it is hidden until you click on a drop down cell. When it appears, it shows the data validation list for the selected cell.

Combo Box Code

There is code on the worksheet, that automatically runs when you select a cell. It checks to see if the

Continue reading Worksheet Combo Box Problem in Excel 2013

Thu, 18 Sep 2014 04:00: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