iCellini Computer Training

San Diego’s Onsite Computer Training Company

Microsoft Excel 2007/2010 Charts
Class 1: Introduction

Duration:	1 day
Prerequisite:	Basic knowledge of Excel including knowing how to perform basic tasks such as creating worksheets, selecting ranges, and managing files.
Course Materials:	Course manual with CD containing exercises
Prices:	$225 for 1 student (one-on-one training) $160 each for 2 to 3 students $130 each for 4 to 6 students $130 for the first 6 students, $100 for each additional student
Description:	This class teaches you how to create impressive, professional-looking Excel charts. You will learn about the various types of charts and how to choose the right one for your worksheets. You will learn how to transform a chart into a visually-appealing graphic that clearly conveys your message. You will also learn about the various ways to work with chart data series, trendlines, and error bars. Finally, you will learn how to use other graphics to enhance your message.

Introducing Excel Charts

What Is a Chart?
How Excel Handles Charts
Parts of a Chart
Basic Steps for Creating a Chart
Working with Charts

Understanding Chart Types

Conveying a Message with a Chart
Choosing a Chart Type
Excel’s Chart Types
Creating Combination Charts
Creating and Using Chart Templates

Working with Chart Series

Specifying the Data for Your Chart
Adding a New Series to a Chart
Deleting a Chart Series
Modifying the Data Range for a Chart Series
Understanding Series Names
Adjusting the Series Plot Order
Charting a Noncontiguous Range
Using Series on Different Sheets
Handling Missing Data
Controlling a Data Series by Hiding Data
Unlinking a Chart Series from Its Data Range
Working with Multiple Axes

Formatting and Customizing Charts

Chart Formatting Overview
Adjusting Fills and Borders: General Procedures
Formatting Chart Background Elements
Formatting Chart Series
Working with Chart Titles
Working with a Chart’s Legend
Working with Chart Axes
Working with Gridlines
Working with Data Labels
Working with a Chart Data Table
Formatting 3-D Charts

Working with Trendlines and Error Bars

Working with Trendlines
Linear Trendlines
Nonlinear Trendlines
Displaying a Moving Average
Using Error Bars in a Chart Series
Other Series Enhancements

Working with Shapes and Other Graphics

Using Shapes
Working with SmartArt
Using WordArt
Working with Other Graphic Types
A Gallery of Graphic Examples

Microsoft Excel 2007/2010 Charts, Class 2

Return to Microsoft Office list of classes

Classes Taught by a Certified Microsoft Master Instructor

Our Microsoft Office Access classes are taught by a Certified Microsoft Office Specialist Master Instructor.

Choose Your Own Training Dates and Class Hours

You can suggest your own dates for training. If the date is available we will schedule it.

You can also choose your own start time. We have started as early as 6 a.m. Start times are your choice.

We are open to discuss whatever special needs you might have.

Customize Your Classes

One of the advantages of choosing iCellini for your training needs is that we can customize classes to meet your needs. Our customized classes are very popular! For more information, see our Microsoft Excel Custom Class page.