Charts in depth

Summary

This beginner’s course will teach you to create, format & edit professional-standard charts Microsoft Excel.  You will learn how to build a wide variety of different charts, you will also learn when to use different chart types & make decisions between line-charts and pie-charts so as to best communicate your message.  Created & customized for Chartered Accountants Ireland by kubicle.com

Venue details:  
Online, ,
Start date & time:  
03 December 2018 00:00
End date & time:  
01 January 2020 00:00
Price: €50.00  (€50.00 Member price)
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
2.00
CPD hours:  
2.00
Speaker details
No speakers have been associated with this event.

Description

Product type:  
CPD online course
Category:  
Information technology

Who Should Attend?

This course is suitable for beginner learners who have a very basic level of familiarity with Microsoft Excel. It is best suited to accountants, management consultants, analysts and other business professionals.

Course Overview

This Kubicle course contains 12 lessons, 3 exercises and 1 Exam. It covers the following topics:

  • How to create charts in Excel
  • Arrange chart data correctlye
  • Formatting the vertical axis
  • Formatting the horizontal axis
  • Changing the chart color scheme
  • Adding labels to column charts
  • Adding labels to other charts
  • Formatting chart titles
  • Legends and data tables
  • Selecting the correct chart
  • Actual vs target charts
  • Export charts to Word and PowerPoint

Key Outcomes

Once you have completed this course you will know how to create all the major chart types in Excel (e.g. Line chart, Stacked Column chart, Bar chart etc. ). You will also now what type of data is best suited to each of these chart types. Lastly, you will know how to format these charts correctly, so they are production read and you will know how to export these charts to Word and PowerPoint.