Microsoft® Office Excel: Charting Essentials

Training Course Content (3.5 hours)

Course Summary: Present data graphically with various visually appealing charts, and analyze data through a variety of charting options. This course expands on the Charting skills introduced in our Excel Level 2 course.

Prerequisites: To ensure your success, we recommend that you have previous experience with Excel formulas, data filtering, pivot tables, and basic charting. Students can obtain this level of skill through our Level 1 and 2 courses.

Contact us to discuss if this class is right for you.

Lesson 1: Inserting a Chart

Topic 1A: Insert an Embedded Chart
Topic 1B: Insert Full-Sized Chart
Topic 1C: Inserting Different Chart Types

Lesson 2: Understanding Chart Types

Topic 2A: Explore Chart Elements
Topic 2B: Explore Chart Types
Topic 2C: Explore Chart Customizations
Topic 2D: Explore Chart Variations
Topic 2E: Switching Chart Types

Lesson 3: Modifying Chart Options

Topic 3A: Add and Remove Data Series
Topic 3B: Modify Data Series
Topic 3C: Present Data Analytically with Options and Features
Topic 3D: Format Chart Elements

Lesson 4: Advanced Charting

Topic 4A: Create a Chart with 2 Value Axes
Topic 4B: Create a Chart with 2 Chart Types
Topic 4C: Create a 3-D Chart
Topic 4D: Project Trends using Trendlines
Topic 4E: Interactive PivotCharts

Lesson 5: Presenting a Chart

Topic 5A: Print Options
Topic 5B: Link a Chart to Other Applications
Topic 5C: Add Chart Comments and Annotations

Excel 2010 Training Class Outlines:

Excel 2010 Level 1: Fundamentals of Excel
Excel 2010 Level 2: Intermediate Functions and Features
Excel 2010 Level 3: Advanced Tools and Collaboration Features
Excel 2010 Level 4: Advanced Formulas and Functions
Excel 2010 Level 5: Introduction To VBA Macros
Excel 2010 Level 6: Advanced VBA Macros