Explore how to add visual appeal to your spreadsheets and workbooks with this in-depth course on the powerful charting features of Microsoft Excel.
Overview
Syllabus
Introduction
- Add power to your data with charts
- Create charts with shortcuts and standard techniques
- Overview of chart types
- Choose styles and layouts
- Change chart orientation
- Move and resize worksheet charts
- Add a chart element
- Change the location of source data
- Deal with empty and hidden cells
- Change the default chart type and create a template
- Modify axes
- Work with chart and axes titles
- Link titles to content
- Add and edit data labels
- Add a data table
- Work with gridlines
- Use legends
- Add error bars, lines, and up-down bars
- Analyze existing and future data with trendlines
- Use pictures as chart elements
- Work with shapes and arrows
- Add shape styles and effects
- Add floating text and text boxes
- Work with chart text
- Apply WordArt styles
- Column and bar charts
- Line and area charts
- Pie charts and doughnut charts
- Combination charts
- Stock charts
- Scatter charts
- Bubble charts
- Radar charts
- Gantt charts
- Overview of new chart types
- TreeMap charts
- Sunburst charts
- Histogram chart
- Box and whisker chart
- Pareto chart
- Waterfall and funnel charts
- Map charts based on geographic data
- Create charts from multiple data sources
- Use a table as source data for a chart
- Print charts
- Copy and link charts with Word and PowerPoint
- Create graphic-in-cell charts with sparklines
- Use symbols and the REPT function for in-cell charts
- Create in-cell bar charts with conditional formatting
- Next steps
Taught by
Dennis Taylor