Excel: Introduction to Charts and Graphs
1h 1mBeginner2024-04-04
Authors
Dennis Taylor
Excel expert with 25+ years of experience
Course details
Learn the basics of Excel charts and graphs in this concise course. Excel expert Dennis Taylor begins by explaining Excel chart concepts, including identifying the different elements of a chart and choosing the right chart type. Next, Dennis walks through creating a basic chart, using the Recommended Charts feature and keyboard shortcuts to get the job done quickly. Dennis then covers formatting charts with styles, colors, and more. Finally, he steps through the most popular chart options: column, bar, and line charts. Note that this course is recorded in Excel for Microsoft 365 but anyone using a recent version—including Office 365, 2019, 2016, and 2013—will be able to follow along.
Skills covered
Data VisualizationOffice 365Microsoft 365SpreadsheetsMicrosoft ExcelData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoftDeep Dive (X:Y)
Concepts
0. Introduction
- 01 - Craft engaging charts and graphs in Excel
1. Understanding Excel Chart Concepts
- 02 - Identifying chart elements
- 03 - Selecting the right chart type
- 04 - Understanding chart sub-types
- 05 - Using the chart design and format tabs
2. Creating Basic Charts Quickly
- 06 - Selecting data to display as a chart
- 07 - Creating charts instantly with shortcuts and Quick Analysis
- 08 - Creating charts with the Recommended Charts button
- 09 - Creating charts with standard menu commands
3. Modifying Chart Appearances
- 10 - Choosing a chart layout with Quick Layout
- 11 - Selecting a chart style
- 12 - Change the orientation of a chart
- 13 - Changing a chart's type
- 14 - Moving, copying, and resizing charts
4. Working with Column, Bar, and Line Charts
- 15 - Using column and bar charts
- 16 - Working with line charts
- 17 - Exploring other chart types
Conclusion
- 18 - Where to learn more about Excel