Webinar – Dashboards #2 – Formulas and Functions

Price $25 incl GST

This is the old school technique of creating dashboards in Excel.

We will create summary reports from the data and from those summary reports we will extract the chart data which we will then base our charts on.

We will look at techniques to create small charts and how we can combine those on a dashboard.

The session includes

  • formula basics
  • formulas that work with dates
  • automating headings
  • SUMIFS function
  • INDEX function
  • formats for dashboards
  • using templates

As always, I will share other tips and tricks along the way.

Date: May 9, 2019
Time: 1:00 PM AEST
Event: Webinar - Dashboards #2 - Formulas and Functions
Topic: Array Formulas
Public: Public
Registration: Click here to register.