Excel Charts Basics
This course is currently not scheduled on the open calendar, but can be organized on request.
Request CourseDuration
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?
- The different types of charts
- 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