Home Courses Excel Charts

Courses


Excel Charts

Length: 0.5 Days    Cost: $285 + GST    Version: Excel

= Scheduled class    = Guaranteed to run    = Fully booked
Click on the dates to book online
CentreAprMayJunJul
Auckland--
17
16
06
Hamilton--
04
--
06
Christchurch--
15
--
07
Wellington--
25
--
02
Virtual Class -- -- -- --

Can't find a class in your area? Contact our sales team and request a class date.
Not sure about the version of your software? Click here to find out.
Want to know if this course is right for you? Assess your skills level with our online Skills Assessment tool.


About this Course

Visualise your data graphically and tell a story with Excel charts. In this specialized half-day course, you will use Excel Charts to communicate key information from your data. Learn how to customize and format the chart to meet your specific requirements, select the perfect chart to drive home your key message, and gain additional information with the use of trendlines, error bars and sparklines.



Audience


This course is designed for anyone tasked with visually presenting data in Excel. Take your Excel charts to the next level and see how easy it is to customise them, while still reliably communicating exactly the information needed.

Prerequisites

We recommend that students have knowledge equivalent to the topics covered in our Excel Essential Skills course, OR that students are:

  • Comfortable creating Excel formulae
  • Familiar with basic Excel functions (SUM, COUNT, AVERAGE)
  • Familiar with absolute references ($A$1)

If you are new to Excel, we suggest starting with Excel Essentials Skills before tackling this course. If you just need to brush up on a few of the skills above, check out our half day Excel Beyond the Basics course.

At Course Completion

You will have an in depth understanding of Excel charts; you will be able to use Excel Charts more effectively, apply custom formatting to make them easier to read, and choose the best chart for your data. In essence, you will be well-equipped to visualize your data in a way that effectively communicates your key insights.

Course Outline


Refresh Essential Chart Skills: You don’t need any chart experience to succeed in this course.

Work with Chart Elements: Titles, axis, legend, oh my! Make sense of Excel charts and take control.

Format a Chart: Find the perfect font, fill colour and number format, then save them as a template for future use.

Selecting the Correct Chart & Data: Explore all the chart types available in Excel and discuss best practice considerations for when to use each type.

Editing Chart Series: When you realize that you selected the wrong data for your chart, but don’t want to start from scratch.

Trendlines and Error Bars: Analyse and interpret your data and display margin of errors.

Create Sparklines: Graphically depict data trends with mini charts that fit within a single cell.


 Print this page