Skip to main content
Charts and Dashboards

Charts in Depth

One of the most effective ways of presenting large amounts of data is through charts and Excel offers a wide selection of types to choose from. This course will show you how to create, format and edit charts so that they are accessible and impactful for your audience.

Beginner        13 Lessons        90 Minutes        CPD Credits
Start Today

About This Course

The way you visualize your data impacts how your audience will understand what you are telling them. Charts are an easy way to deliver complex information in a simple format. This course will help you master that skill.

Across 13 lessons, you’ll learn the different ways on how charts can be created, which chart to use based on your business need, along with the pros and cons of each option.

By the end of this course, you’ll understand how much easier presenting your data becomes when you have a chart to do the hard work for you.

Start Today

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
  • Change the color scheme of a chart
  • Adjust chart labels, titles, and legends
  • Understand how to select the right chart for a given situation
  • Export charts from Excel to Word and PowerPoint


1. How to Create Charts in Excel
2. Arrange Chart Data Correctly
3. Formatting the Vertical Axis
4. Formatting the Horizontal Axis
5. Changing the Chart Color Scheme
6. Adding Labels to Column Charts

Read More

7. Adding Labels to Other Charts
8. Formatting Chart Titles
9. Legends and Data Tables
10. Creating Sparklines
11. Selecting the Correct Chart
12. Actual Versus Target Charts
13. Export Charts to PowerPoint and Word
Learning Certificates

Showcase Your Skills

Each time you complete a course exam, you earn a certificate that demonstrates your proficiency in that subject matter. We are proud to be able to say that Kubicle certificates are recognized by the most respected employers from around the world.

When you earn internationally-recognized certificates, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability.

What Our Students Say

We don’t aim to satisfy, we aim to delight

Become A Data Citizen

Ready yourself for the rapidly changing world