Excel Charts
Upcoming dates
Click a date to book online.
| Location | Sept 26 | Oct 26 | Nov 26 | Dec 26 |
|---|---|---|---|---|
| Auckland | ||||
| Hamilton | ||||
| Wellington | ||||
| Christchurch | ||||
| Virtual |
Overview
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.
Who should attend
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
- Familiar with absolute references
If you are new to Excel, we suggest starting with Excel Essentials Skills before tackling this course.
What you'll learn
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 content
This course will teach you how to:
- 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.
- Select the Correct Chart & Data: Explore all the chart types available in Excel and discuss best practice considerations for when to use each type.
- Edit a Chart Series: When you realize that you selected the wrong data for your chart, but don’t want to start from scratch.
- Use 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.
Common questions
When does Excel Charts next run?
The next date is Thu, 10 Sept 2026, and there are 10 further dates scheduled. Delivered ACE Training Auckland, ACE Training Christchurch, ACE Training Hamilton, ACE Training Wellington. Every date and its format is listed on this page.
How much does Excel Charts cost?
From $325 + GST per person. Pricing can differ by date and location, so check the option you want before booking.
Can we pay by invoice instead of by card?
Yes. Choose 'Pay by invoice' when you book and we'll hold your place and send the invoice to your accounts address, with a purchase order number on it if you need one. You can also pay by card at the time of booking if that's easier.
Do I need any prior experience?
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 Familiar with absolute references If you are new to Excel, we suggest starting with Excel Essentials Skills befo…
Can I attend online, or does it have to be in a classroom?
Both. Some dates run live online and others in-class — each date on this page shows its format, so pick whichever suits.
Can you run this course for my team?
Yes. Any ACE course can be delivered in-house at your workplace and tailored to your team's tools and goals — quote course code Excel-Charts when you enquire.