SPECIALISTS IN FINANCIAL MODELLING

Turning up the Heat with Excel Dashboards

You can view the presentation below.  During this 60 minute presentation you will hear from Dashboards and VBA expert, Marcus Small who leads us in this highly practical and hands-on session that covers:

  • The creation of an Excel heat map from scratch. Generating the scalable vector file (SVG) from Wiki Commons and passing it through Inkscape to Excel. *
  • Building in the formulation and creating the VBA which generates a predetermined colour scheme for a dashboard where the heat map will form the centre piece.
  • Layout and design when creating a dashboard, maximising design with very little effort.

View the presentation below.

For more information about our meetups and to see if we’ve got one running near you, see our meetups page.