Charts and Visualisations in Excel

Summary

Microsoft Excel provides you with a host of charts and visualisations to tell a story with your data. In this course explore the basics of creating charts in Excel and what makes a good chart.

This course is provided by a third party provider accountingcpd.net and the fee charged is exclusive of VAT. 

Venue details:  
Online EU, ,
Start date & time:  
01 January 2021 00:00
End date & time:  
01 January 2022 00:00
Price:  
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
3.50 Training Tickets accepted
CPD hours:  
4.00
Speaker details
First nameLast name
AccountingCPD. net

Description

Product type:  
CPD online course
Category:  
AccountingCPD.net, Strategic finance and management reporting

Booking with a Training Ticket

Once you have booked your course, you will receive an email with your booking confirmation. The steps you will need to follow to access your online course will arrive in a separate email within 48 hours of your order being processed.

Please be aware that participants will have access to this course for 120 days from the date of receiving access via email notification

Course overview 

We all know how to use simple column and bar charts in Excel, but do you know how, when and why to use less common charts such as the bubble chart or a heat map? In recent years Microsoft has created a much broader range of charts and visualisations for you to choose from. These new options, along with the classic suite, allow you to tell the story of your data.

This course will enable you to make the most of the tools at your disposal, understanding what makes a good or bad chart and how to create effective data visualisations. From the basics of how to add and amend charts and apply templates to them, through commonly used charts and formatting options, to some of the less common charts that will really mark you out as an expert.

In this course you will

  • Tell a compelling story with your data by inserting, amending and formatting charts in Excel
  • Use a wide range of charts including some less well known ones like bubble charts, box and whisker charts, waterfall charts, heat maps and stock charts
  • Know the difference between good and bad charts and apply best practice to creating data visualisations
  • Understand the different Excel formatting options and create an effective common chart for your data