Realdolmen Education

Details

Excel Charts Basics

This course is currently not scheduled on the open calendar, but can be organized on request.

Request Course

Duration

0.5 day(s)

MS Excel: Getting started with charts

Duration

0.5 day

Audience

This course is aimed at those who already have a good grounding in Excel but wish to expand their knowledge on working with simple charts.

Prerequisites

A good understanding of the basic concepts of Excel is required.

Objectives

During this course attendees will gain insight into creating and adjusting simple charts.

Methods

An interactive hands-on classroom-based training.??

Description

Excel is an excellent tool for creating charts. In this module you will learn how to make a simple chart. Many chart types are covered and participants will learn when to use which chart.

Asides from creating new charts, we will also look into the various options available for customizing charts. Elements that are discussed here include adjusting the range on which the chart is based, placing grid lines, working with a legend and many other formatting options.

Contents

  • Creation of a chart
    • The different types of charts
      • 2D charts
      • 3D charts
      • Combo charts
    • When to use which type?
  • Adjusting a chart
    • Changing the source data and its effects on the chart
    • Add / remove elements on the chart such as legend, grid lines, titles, ...
    • Adjust the different chart elements
  • Chart Formatting
  • Sparklines