Microsoft Excel Charts Training Course

Audience: Anyone needing to be able to communicate quantitative information visually using Excel charts. This Excel Charts course includes a discussion of the standard chart types and how they should be best used.

Course Duration: Half day module to be combined with any other half day module in the Microsoft Office suite.

Course Availability: Monday – Saturday

Course Types: Group bookings, public courses, 1-2-1 sessions, bespoke tailored courses and office migrations.

Course Location: This Microsoft Excel Charts training course can be delivered either at our London training venue or at your offices. 

Tailored Course Content: Course content can be customised to meet your specific requirements, with scheduled dates to suit you.

At Course Completion

After completing this course, students will be able to:

  • Create basic Charts
  • Fine-Tune your Chart
  • Change Chart Options
  • Add Graphics
  • Change a Chart’s Source Data
  • Print and Share Charts

Course Outline

Module 1: Creating Basic Charts

  • Selecting data to display as a chart
  • Creating in-cell charts with Sparklines

Module 2: Fine-Tuning your Chart

  • Adding a chart element
  • Choosing a chart style from the gallery
  • Switching data rows and columns
  • Changing the chart’s source data
  • Dealing with empty and hidden cells
  • Changing a chart’s type
  • Changing the default chart type and creating a template

Module 3: Changing Chart Options

  • Modifying axes
  • Adding, editing, and removing chart titles
  • Linking titles to content
  • Analysing data with trendlines

Module 4: Adding Graphics

  • Using pictures as chart elements
  • Adding shapes and arrows
  • Adding floating text and text boxes
  • Understanding 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

Module 5: Changing a Chart’s Source Data

  • Creating charts from multiple data sources
  • Creating dynamic charts that always show specific periods of data

Module 6: Printing and Sharing Charts

  • Printing charts
  • Linking charts with Word and PowerPoint
, Microsoft Excel Charts Training Course
, Microsoft Excel Charts Training Course