Creating Dashboards in Excel - eLearning

This activity is published by accountingcpd. 
All year round, and on every accountingcpd purchase you make, get 10% off as a CA ANZ member. Just use code CAANZ101. 
Please note you will be directed to accountingcpd to purchase this product.


As accountants, we often have vast amounts of data to present. Creating dashboards is a very useful way of transforming complex data into clear, and presentable information. Using dashboards, we can convey the meaning behind data quickly and effectively. 

This course will enable you to create visually appealing and informative dashboards in Excel. It guides you through the steps needed to organise and collect your data, and how to create professional charts and interactive visualisations that will inform users. 

Upon satisfactory completion of this activity you will be able to: 
  • Produce visually appealing and informative dashboards. 
  • Create a variety of popular Excel charts. 
  • Create interactive visualisations for the analysis of dashboards, using dynamic functions. 
  • Hide sheets, use scroll lock and protect your dashboards. 

A well-designed dashboard provides on-demand access of all of your most important metrics. That means you can immediately see a detailed overview of your business in one quick glance. 


Topic: Business Mindset

Sub-Topic: Information & Communication Technology

Format: eLearning

Proficiency Level: Foundation, Intermediate

CPD: Upto 4 hours