Mastering Microsoft Excel Charts
Digital, Excel & AIInternational · all countries
Enrol in this Course
- 📦 1 module
- 📹 6 lessons
- 📝 1 quiz
- 🎓 Certificate on completion
- ♾ Learn at your own pace, online
This course teaches learners to create charts in Microsoft Excel that communicate clearly without the author being present to explain them. By the end, learners can select the right data (adjacent and non-adjacent columns), choose the right chart type, add the right chart elements, and produce a chart that is a self-explanatory report.
Learning Objectives
- Select columns that follow each other (adjacent) for a chart.
- Select columns that do NOT follow each other (non-adjacent) using the Ctrl key.
- Locate all chart types in Excel (Insert tab > Charts group, Recommended Charts, and the full chart dialog).
- Identify the most popular chart types and know when to use each one.
- Add and format chart elements (title, axis titles, legend, data labels, gridlines).
- Identify which elements are critical so a chart can ‘speak’ on its own.
Course Curriculum
1 module · 6 lessons · 1 quiz
Chart Mastery
- Selecting Data: Columns That Follow Each Other
- Selecting Data: Columns That Do NOT Follow Each Other
- Where Are ALL the Charts?
- The Most Popular Charts and When to Use Them
- Adding Chart Elements
- Critical Elements: The Report Must Speak in Your Absence
-
Quiz Test Enrol to take