VTEC Training
Course Code: 869
Excel Charts: - Showcase your data with charts using Excel
VTEC Training
Portland,
ME
Class Dates:
12/20/2024
Length:
1/2 Days
Cost:
$195.00
Class Time:
Technology:
Office
Delivery:
Instructor-Led Training, Virtual Instructor-Led Training
Overview
- 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
- Students participating in this Lab should be educated Excel worksheet users who are familiar with:
Prerequisites
- The following course (or equivalent knowledge): Excel : Worksheets
Course Details
- 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