Excel Yourself/Excel Dashboards #1 - Guidelines

Dashboard #1 - Guidelines

In this recorded session we focus on chart and dashboard guidelines plus some techniques used to create small charts for dashboards.

We also look at creating a bullet chart, which is an alternative to gauge, speedo or dial chart.

The session covers
  • general chart guidelines
  • questions to ask yourself to develop better charts
  • best charts to use
  • charts and formats to avoid
  • using text boxes on dashboards
  • how to create small charts
  • chart templates
  • lining up and re-sizing charts
  • useful number formats for dashboard charts
  • using the #N/A error with charts
  • how to create a bullet chart

Level: Intermediate
Duration: 1 hour
Price: Free

  • Free

Excel Dashboards #1 - Guidelines

Lots of ideas to improve your charts and dashboards.

Contents

Course materials

The pdf manual plus the Excel file to work through during the session and the completed file.
Dashboard_Guidelines_2020.pdf
Dashboard_1_Guidelines_2020.xlsx
Dashboard_1_Guidelines_2020_complete.xlsx

Course Video recording

Excel Dashboard 1 - Guidelines.mp4