The global body for professional accountants

10
UNITS

Online course | SumProduct

Charts and dashboards

Make your charts dynamic and create effective and exciting dashboards

Overview

Woman wearing headset and touching screen

Do you need to know what charts are available in Excel and when to use them to get your message across? Are you able to modify chart elements so that your dashboards are easy to understand immediately?

We explain how to create each type of standard chart, from column charts to waterfall charts, and show you how to create complex bespoke charts.

We demonstrate how to make charts dynamic and create an effective dashboard design, including some tips on how to use VBA to enhance the user experience.

This course will help you make your Excel dashboards more exciting with eye-catching visuals, that are easy for your audience to understand.

 

You will learn:

  • the types of charts that are available in Excel and when to use them
  • how to present data effectively
  • how to create bespoke and dynamic charts, using the latest Excel functions
  • how to create effective dashboards that tell a story.
 
  • This course contains a collection of interactive slides and videos for you to follow, and exercises for you to complete within Excel.
  • This course requires you to use (for Windows) Excel 2016 or newer, Excel for the web or Excel 365; (for Mac) Excel 2021.
  • The recommended operating systems for Windows are Windows 10 or 11; for MacOS is Big Sur 11 or later.
  • This course requires you to have a basic understanding of Microsoft Excel.
  • CPD certificate is available upon successful completion of the course.
  • 12-month access.

Price

Price 200 GBP

Location

Global

Date & time

On demand

Course provider

ACCA logo and Sum Product logo