New Horizons Computer Learning Center
410-597-9722

Excel 2007 - Charts and Graphs

Course Length: 1 Day

Overview:
Excel 2007 offers a greater depth for creating and designing charts than previous versions. This course is designed to explore those depths for the effective demonstration of numbers.

Prerequisites:
Excel 2007 - Level 1
Excel 2007 - Level 2

Course Content

Lesson 1: Charting Essentials

• Data Selection and Chart Creation
1. Selection Techniques
2. Chart Creation Methods
• Basic Chart Design
1. The Ribbon Design Tab
2. Chart Types
3. Chart Layout and Options
4. Color Schemes
• Chart Elements and Formatting
1. The Ribbon Formatting Tab
2. The Chart and Plot Area
3. Titles, Axes and Legend
4. Data Labels
5. Trendlines
6. 3-D Charts and Elements
• Lab Exercise

Lesson 2: Relationship Based Charts

• XY Scatter Plot Charts
• Showing Trends and Correlations
1. Trendline Types and Uses
2. Multiple Trendlines
• Surface Charts and Contrasts
1. Using Graphics
• Lab Exercise: Is There a Connection?

Lesson 3: Trend Based Charts

• Line Charts and Trendlines
1. Drop Lines and Data Markers
• Changing Column and Line Graphics
1. Using Autoshapes for Columns
2. Line Changes
• Lab Exercise: What's the Forecast?

Lesson 4: Charts Showing Differences

• Pie and Doughnut Charts
1. Exploding Slices
2. 3-D Pies
3. Benefits and Disadvantages
• Stacked and 100% Columns
• Waterfall Charts
• Lab Exercise

Lesson 5: Stock Charts and Other Chart Types

• Stock Chart Types
• Candlestick Charts
• Mixing Two Chart Types
• Thermometer Charts
• Benchmark Charts
• Delta Charts
• Lab Exercise: Creative Thinking

Lesson 6: Exporting Your Charts

• Presenting Charts in Word and PowerPoint
1. Linking a Chart
2. Embedding a Chart
3. Modifying a Chart in Word and PowerPoint
• Exporting a Chart as a Graphic
• Creating a Web Presentation for Your Charts

6940 Tudsbury Road, Baltimore, MD 21244
P: 410-597-9722
www.nhbaltimore.com