Course
|
Excel

Charts in Depth

Creating charts is a very common task in Excel. This course shows you how to create, format and edit charts so that they are easy to understand and look professional.
2 HOURS
Beginner
13 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Create various charts such as bar, column, and line charts
Arrange the data on your charts correctly
Format the axes of a chart
Leave your number for the fastest response

Get More Info

Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
helping to build
data, Tech & ai skills in
g2-badgebritish-airwaysjotunamazon-logopwc-logoford-logo
Course
|
Excel

Charts in Depth

Creating charts is a very common task in Excel. This course shows you how to create, format and edit charts so that they are easy to understand and look professional.
2 HOURS
Beginner
13 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Create various charts such as bar, column, and line charts
Arrange the data on your charts correctly
Format the axes of a chart
Leave your number for the fastest response

Get More Info

Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

What’s Included

13 Lessons
How to Create Charts in Excel
4 MINS
LESSON
How to Create Charts in Excel
Exercise

Charts can be created in a couple of different ways. In this lesson, I'll explain the pros and cons of each method, depending on how your dataset is arranged.

Arrange Chart Data Correctly
5 MINS
LESSON
Arrange Chart Data Correctly
Exercise

Charts can be made much more readable by arranging the chart data correctly. In this lesson, I'll show you a few tips on how to do this for various charts.

Formatting the Vertical Axis
4 MINS
LESSON
Formatting the Vertical Axis
Exercise

The vertical axis often needs to be altered when building charts. Find out how to make changes to the axis correctly in this lesson.

Formatting the Horizontal Axis
4 MINS
LESSON
Formatting the Horizontal Axis
Exercise

The horizontal axis needs to be adjusted when you have many datapoints in your dataset. In this lesson, learn how to format the axis to cater for an oil shareprice chart.

Changing the Chart Color Scheme
3 MINS
LESSON
Changing the Chart Color Scheme
Exercise

By default, Excel's colour scheme is not easy on the eye. Let's change this by creating our own colour scheme and saving it as a template for future use.

Adding Labels to Column Charts
4 MINS
LESSON
Adding Labels to Column Charts
Exercise

Labels can be used on column charts instead of a vertical axis. However, they should only be used when you have a small number of data points on a chart.

Adding Labels to Other Charts
3 MINS
LESSON
Adding Labels to Other Charts
Exercise

In this lesson, I'll show you how to add labels to add labels to other chart types including pie charts and bar charts. I'll also show you when not to use labels.

Formatting Chart Titles
4 MINS
LESSON
Formatting Chart Titles
Exercise

Chart titles need to be written and formatted correctly so they are easy to read and understand. Learn how to create static and dynamic chart titles for your charts.

Legends and Data Tables
3 MINS
LESSON
Legends and Data Tables
Exercise

Legends and data tables are both used to enhance the audience's understanding of chart. Find out how to use and format this tools in this lesson.

Creating Sparklines
4 MINS
LESSON
Creating Sparklines
Exercise

Sparklines are miniature charts that can be added to your dataset to quickly understand it visually. Learn how to create them in this lesson.

Selecting the Correct Chart
3 MINS
LESSON
Selecting the Correct Chart
Exercise

The chart you choose to use depends entirely on the data you wish to chart. In this lesson, learn which charts are the best to use for a number of different datasets.

Actual Versus Target Charts
3 MINS
LESSON
Actual Versus Target Charts
Exercise

A common chart we need in business is plotting actual numbers vs targets. Here, we'll learn how to create this chart in an easy-to-read format.

See More
See Less
Certifications
Earn a certificate with every exam you complete. All successful course completions are recognized by CPD, CPE, and NASBA. As your team gains confidence, skill, and speed, your firm becomes more competitive.
Earn cPE / CPD Credits
No items found.
Get More Info
Looking to understand how Kubicle can better help your organization meet its learning objectives?  Book some time with one of our consultants today.
Contact Information
Looking to speak to someone directly?
01 700 9000
info@kubicle.com
Dublin, Ireland
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Plus Size YourLearning with Academies+
THE PLATFORM OF CHOICE FOR 1M+ USERS

A Learner Experience Designed to Deliver Transformation

Testimonials

How Leading Teams Use Kubicle to Upskill & Excel

Heineken Case Study
ADL Logo