Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Excel 2013: Charts in Depth

via LinkedIn Learning

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
Present data to your audience in a more visually compelling way with charts in this Excel tutorial.

Syllabus

Introduction
  • Welcome
  • Using the exercise files
1. Understanding Excel Chart Concepts
  • Identifying chart elements
  • Selecting the right chart type
  • Understanding chart terminology
  • Understanding the Chart Tools Ribbon
2. Creating Basic Charts Quickly
  • Selecting data to display as a chart
  • Creating charts with the keyboard and the Quick Analysis tool
  • Creating charts with the Recommended Charts feature
  • Creating charts with standard menu commands
  • Creating graphic-in-cell charts with sparklines
3. Fine-Tuning Charts with Design Tab Choices
  • Adding a chart element
  • Choosing a chart layout with the Quick Layout option
  • Selecting chart colors from the Colorful and Monochromatic palettes
  • Choosing a chart style from a gallery of colorful variations
  • Switching rows and columns for a different view of the data
  • Changing the location of a chart's source data
  • Dealing with empty and hidden cells
  • Changing a chart's type
  • Changing the default chart type and creating a template
  • Changing the location of a chart
  • Moving and resizing a chart within a worksheet
4. Changing Chart Options
  • Modifying axes
  • Adding, editing, and removing chart titles
  • Linking titles to content
  • Adding and editing data labels
  • Adding a data table
  • Adding error bars
  • Working with gridlines
  • Adding, editing, and removing legends
  • Adding drop lines and up-down bars
  • Analyzing existing and future data with trendlines
5. Format Tab Options: Inserting Pictures, Shapes, and Text Boxes
  • Using pictures as chart elements
  • Adding shapes and arrows
  • Adding floating text and text boxes
  • Selecting shape styles, fill, and the outline
  • Adding shape effects
  • Applying WordArt styles
  • Working with chart text
  • Changing the rotation of chart text
6. Adjusting Specific Chart Types
  • Using column and bar charts
  • Using line charts
  • Using pie charts
  • Using area, stock, and XY charts
  • Using doughnut, bubble, and radar charts
7. Changing a Chart's Data Source
  • Pasting new data into a chart
  • Creating charts from multiple data sources
  • Adding new data using a table
  • Creating dynamic charts that always show the last "N" periods of data
8. Specialized Excel Charts
  • Creating combination charts
  • Creating Gantt charts
  • Creating Pareto charts
  • Creating frequency charts
  • Using Form controls to create dynamic charts
  • Producing dynamic charts by using filters
9. Printing and Sharing Charts
  • Printing charts
  • Copying and linking charts with Word and PowerPoint
Conclusion
  • Goodbye

Taught by

Dennis Taylor

Reviews

4.4 rating at LinkedIn Learning based on 26 ratings

Start your review of Excel 2013: Charts in Depth

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.