SPECIALISTS IN FINANCIAL MODELLING
0 item(s) $0.00 AUD + GST

Meetup Presentation: Turning up the Heat with Excel Dashboards

26 September, 2016

Heat maps have evolved considerably in recent versions of Excel from a matrix of colours to become a powerful graphical representation of data displayed in a dashboard. Excel has the capacity to add conditional colour to images based on an agreed set of parameters or key performance indicators. With a little corralling, a heat map nestled inside a dashboard can add a powerful visual element to an otherwise plain and simple report. 

You will hear from Dashboards and VBA expert, Marcus Small who leads us in this highly practical and hands-on workshop session. This 60-minute presentation covers:

  • The creation of an Excel heat map from scratch. Generates the scalable vector file (SVG) from Wiki Commons and passes it through Inkscape to Excel. 
  • Builds in the formulation and creates the VBA which will generate 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.

By the end of the session you will know how you can create an interactive heat map using just about any imaginable image and include it in your own Excel Dashboards.

Marcus Small holds a Master’s Degree in Finance from ANU and has worked in the Big 4, Investment Banking and within industry both here and overseas. He is the founder of www.thesmallman.com, a website dedicated to Excel and VBA development with an acute focus on dashboard design and financial modelling. Additionally, Marcus moderates both Ozgrid and Chandoo forums, which are amongst the web’s largest online Excel resources.

Access the presentation and also the files below:

Access Now

Comments

Great webinar / short course. A really well thought through topic and the support documents are awesome. Even the document layout is a presentation in its self of thoughtful planning and cleanliness of data. An excellent resource - very sincere Thank You to Marcus for this Presentation and Data.

Submitted by Anonymous on Tue, 27/09/2016 - 16:25.

Post new comment

  • Allowed HTML tags: <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>

More information about formatting options

By submitting this form, you accept the Mollom privacy policy.