Creating Dashboards in Excel - eLearning

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. 

Benefits:
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.