Excel Charts: - Showcase your data with charts using Excel
CLASS DATE(s):
8/14/2020

COURSE LENGTH: 1/2

COURSE COST: $145

COURSE TIMES: 9:00am - 1:00pm

Printable version of this course
print
Register for this course
register

COURSE OVERVIEW

Students will create a variety of charts, with emphasis on selecting appropriate chart types and personalizing them by using various chart options. Here are the activities covered:
Picture your Excel data in a chart
Emphasize a single data range with a pie chart
Track data over time
Spice up your reports with charts

AUDIENCE AND PREREQUISITES

Students participating in this Lab should be educated Excel worksheet users who are familiar with:
The following course (or equivalent knowledge): Excel : Worksheets

  

*Course cost listed does not include the cost of courseware (required) or lunch (optional). Please contact us at learn@vtec.org or 207-775-0244 for additional pricing information, or if you have any questions.
Course subject to minimum enrollment.

COURSE TOPICS:


Lessons
Creating and saving a worksheet
Opening an existing worksheet and using simple editing techniques
Navigating and selecting ranges in a worksheet
Changing the appearance of data using formatting techniques

Lab Activity 1: Picture your Excel data in a chart
Create charts quickly with the F11 key and the Chart Wizard
Identify chart components

Lab Activity 2: Emphasize a single data range with a pie chart
Create a pie chart
Work with pie chart options
Change a chart's location

Lab Activity 3: Track data over time
Create column charts
Create line charts
Save chart settings

Lab Activity 4: Spice up your reports with charts
Include an embedded chart object
Include a linked chart object
Discover the differences between embedding and linking