iCellini Computer Training

San Diego’s Onsite Computer Training Company

Microsoft Excel 2007/2010 Charts
Class 2: Mastering Charts

Duration:	1 day
Prerequisite:	Microsoft Excel 2007/2010 Charts Introduction.
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 covers Intermediate to Advanced topics. We start by learning about interactive charts—charts that can be modified easily by an end user. We then learn about a variety of chart techniques and tricks such as in-cell charting and mathematical techniques. Finally, we discuss ways to avoid mistakes and make your charts more visually appealing.

Creating Interactive Charts

Introducing Interactive Charts
Creating a Self-Expanding Chart
Controlling a Series with a Scroll Bar
Specifying the Beginning and End Point for a Series
Specifying the First Point and Number of Points for a Series
Plotting the Last n Data Points in a Series
Plotting Every nth Data Point in a Series
Using Check Boxes to Select Series to Plot
Creating a Very Interactive Chart

Charting Techniques and Tricks

Adding Lines and Backgrounds to a Chart
Charts That Use a Single Data Point
Using a Dummy Axis
Column and Bar Chart Variations
Creating a Timeline
Creating "Impossible" Charts by Stacking and Overlaying

In-Cell Charting Techniques

Visualizing Data with Conditional Formatting
Plotting Data without a Chart
Creating Sparline Charts

Mathematical and Statistical Charting Techniques

Drawing a Circle with an XY Series
Connecting Scatter Chart Data Points to the Axes with Error Bars
Connecting XY Points to the Origin
Creating Frequency Distributions and Histograms
Plotting a Normal Curve
Plotting Z-Scores with Standard Deviation Bands
Calculating the Area under a Curve
Creating a Box Plot
Plotting Mathematical Functions
Creating a 3-D Scatter Plot

Using Pivot Charts

What is a Pivot Table?
Creating a Pivot Table
Working with Pivot Charts
Pivot Chart Examples

Avoiding Common Chart-Making Mistakes

Know your Audience
Chart Accuracy
Problems with Chart Type Selection
Chart Complexity
Chart Style
A Chart Maker's Checklist

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.