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
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.
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
Lessons
1. How to Create Charts in Excel
2. Arrange Chart Data Correctly
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.
