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.


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

Third party tools

Speed up your file

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 download: Excel Spreadsheet Model Template
To help in the battle towards better spreadsheets I have uploaded an Excel Spreadsheet Model Template.
Wed, 20 Nov 2019 09:05:00 GMT
Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Fixed the wrong calculation setting (use 1 core only) of the add-in
Tue, 12 Nov 2019 09:45:00 GMT

Excel Experts Nederland

Excel Expert Nederland Blog
Nieuw: ons Excel Forum
Wij kregen tamelijk veel Excel gerelateerde vragen in onze commentaren. Om deze vragen beter te kunnen kanaliseren zijn we daarom een Excel forum gestart. Heb je een vraag? Word lid van ons forum en stel hem hier: Excel Experts Nederland Forum
Mon, 30 Jan 2017 16:38:13 +0000

Daily Dose Of Excel

By Dick Kusleika (et al)
International Keyboard Shortcut Day 2019
The first Wednesday of every November is International Keyboard Shortcut Day. This Wednesday, people from all over the world will become far less efficient for a short time in an effort to be far more efficient the rest of the year. “WASD V2 88-Key ISO Custom” by Bitboxer is licensed under CC BY-NC-SA 2.0 This […]
Mon, 04 Nov 2019 14:12:45 +0000

The Ken Puls Blog

By Ken Puls
Using Script Lab to Create a PivotTable with JavaScript

"Microsoft Excel is not a spreadsheet application anymore, it’s a medium to store, present, and analyze data." - Puneet Gogia The way Excel has evolved in the past few years, it’s almost impossible to work without it in this present … Continue reading

The post Using Script Lab to Create a PivotTable with JavaScript appeared first on The Excelguru Blog.

Fri, 15 Nov 2019 00:03:47 +0000

PTS Blog

By Jon Peltier
Geography and Maps in Excel

Excel has introduced Geography Rich Data Types and Filled Maps, making it easy to acquire, analyze, and visualize geographical information, as shown here.

The post Geography and Maps in Excel appeared first on Peltier Tech Blog.

Wed, 06 Nov 2019 15:00:25 +0000

Contextures Blog

By Debrah Dalgleish
Change Excel Shape Colour Automatically

Written by Debra Dalgleish from Contextures Blog

We all want to be remembered for our contributions to humanity. That's why, way back in 2004, I made an Excel Smiley Face sample (aka "Happy Face"). There was a new version in 2009, and here's another update, to change the Smiley Face shape colour automatically. You can do the same thing with other shapes … Continue reading "Change Excel Shape Colour Automatically"

Change Excel Shape Colour Automatically is a post from Contextures Blog and is not allowed to be copied to other sites

Thu, 21 Nov 2019 05:01:00 +0000

Microsoft Excel blog on TechCommunity

By various Authors
Create data-driven Visio diagrams directly in Excel

We are excited to announce a new way to create impactful Visio diagrams from your data directly in Excel with the public preview of the Visio Data Visualizer add-in. Use the add-in to create flowcharts, cross-functional flowcharts (or Swimlane diagrams), and organizational charts. All you need to get started is an Office 365 subscription—no Visio subscription is required.

BF Sample.png


Learn more about the detailed scenarios and find additional resources in the public preview announcement blog on the Visio Tech Community.


Get a quick overview of the add-in the video below.

Add-in for Excel Win32 GIF.gif


Try the add-in now

You can use the add-in in Excel for Windows (2016 or later), Mac (2016 or later), or the web, in three simple steps:

  1. In a new workbook, click Insert > Get Add-ins.
  2. In the Office Add-ins Store, search for “Visio Data Visualizer" and click Add. If you see a security message regarding the add-in, select Trust this add-in.
  3. Sign in with your Office 365 subscription account.



  • The add-in currently only supports English.
  • When using the add-in in Excel for the web, please ensure that third-party cookies are enabled in your browser.
  • We recommend using the add-in on the latest Monthly Channel (Targeted) build for the best experience.

Support and feedback

Access additional support and send us your feedback directly from the add-in by clicking the ellipses and clicking Help or Send feedback.


We’d love to hear how you’re using the Visio Data Visualizer add-in for Excel! Engage with us on the Visio Tech Community or follow us on Facebook and Twitter to stay current on the latest releases.


Shashank Gandhi is a Program Manager on the Visio team.


Mon, Nov 04 2019 07:46:36 +0000