New Horizons Computer Learning Center
410-597-9722

Effectively Communicating Numbers with Graphs and Charts

Course Length: 1 Day

Overview:
In this course, students will learn methods of effective chart building and formatting in Excel for enhanced visual presentations.

Prerequisites:
Excel 2003 - Level 1
Or equivalent knowledge

Course Objectives:
Upon successful completion of this course, students will be able to:

• Effectively format and display data using Excel

Course Content

• Explain the Importance of Effective Data Analysis and Presentation
1. Brief Discussion on Office Applications
2. Spreadsheets
3. Lists of Data
4. Charts and Graphs
• Explore Bad Examples of Data Presentation
1. 2D vs. 3D Charts
2. Skipping Rows and Columns
3. Excessive Formatting
• Building the Theory
1. Simplicity vs. Complexity
2. Data That Makes an Impact

Lesson 2: Spreadsheets and Lists

• Generating a Table and List Structure To Get the Most Out of Your Data
1. Excel Spreadsheet and Data List Fundamentals
• Maximizing Readability Through Formatting
1. Number Formats
2. Aligning Data
3. Rotating Text
4. Borders
5. Shading
6. Conditional Formatting
• Sorting and Filtering Techniques
1. Establishing Sort Order
2. Using the AutoFilter

Lesson 3: Charts and Graphs

• Transforming Information into Intelligence: Selecting the Right Information
1. What's Important to Select
2. Selection Techniques
• Choosing the Best Chart Type
1. Bar Charts
2. Column Charts
3. Line Charts
4. Pie and Donut Charts
5. Other Chart Types
• Modifying and Formatting for Maximum Results
1. Setting Chart Options
2. Text and Font Selection
3. Effective Borders and Shading
4. Line Chart Formatting
5. Pie Chart Formatting
• Trend Lines and Callout Graphics for Presentations
1. When To Use Trend Lines
2. Trend Line Types
3. Trend Line Options and Formatting
4. Using the Drawing Toolbar
• Saving Custom Designs and Setting Default Chart Type
1. Custom Chart Types
2. Storing Your Formatting for Next Time
3. Setting the Default Chart Type

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