Course Icon Excel Training

Excel Charting

Designed for Excel versions 2016,2013,2010,2007

0800 1337 401

Course Objectives

At the end of this course you will have a greater understanding of charting concepts, shortcuts and fine tuning.

Who Should Attend

Our Charting with Microsoft Excel course is suitable for those with an advanced working knowledge of Excel and familiarity of charts.

Course Syllabus

EXCEL CHARTING CONCEPTS

  • Understanding chart terminology
  • Identifying chart elements
  • Understanding the Ribbon and the Design, Layout, and Format tabs

CREATING A BASIC CHART

  • Selecting data to display as a chart
  • Creating charts instantly with shortcuts

LAYOUT TAB CONFIGURATION

  • Inserting Pictures, Shapes, and Text Boxes
  • Add Titles, Labels, and Legends
  • Add and editing chart titles
  • Show different scales
  • Adjust the position of tick marks and axis labels
  • Adjust the numeric format on labels
  • Adding, editing, and removing legends
  • Adding and editing data labels
  • Using and modifying Axes and Gridlines
  • Create Trendlines
  • Add high-low lines and up-down bars
  • Add error bars

DESIGN TAB CONFIGURATION

  • Switching rows and columns to change the data being plotted
  • Setting a default chart type and creating a template
  • Dealing with empty and hidden cells
  • Choosing a chart style from 48 colourful variations
  • Changing the location of a chart
  • Moving and resizing a chart

    FORMAT OPTIONS

  • Add WordArt Styles
  • Apply Fill colours
  • Apply Border Line styles, line weight and colour
  • Working with chart text
  • Changing the rotation of chart text

TEMPLATES AND DEFAULT CHARTS

  • Create your own default chart
  • Create a chart template
  • Produce a new chart based on a user defined template
  • Edit a user defined template

ADJUSTING SPECIFIC CHART TYPES

  • Column charts
  • Line charts
  • Pie charts
  • XY (Scatter) charts
  • Doughnut chart
  • Bubble chart
  • Radar chart
  • Area chart

CHANGING A CHARTS DATA SOURCE

  • Copy and Paste new data into a chart as a new series
  • Creating charts from multiple data sources
  • Edit the Data source for the chart

PRINTING AND SHARING CHARTS

  • Printing charts
  • Copying and linking charts with Word and PowerPoint
See all of the available Seven Institute Excel Courses