MS Excel 2003, 2002, 2000 Level 2

1 Day Training Class

Performance-based objectives of this MS Excel 2003 training class:

• Create charts that graphically represent worksheet data.
• Modify charts.
• Customize charts by applying formatting.
• Enhance worksheets and charts by using the drawing tools to add graphic objects.
• Sort information in a list by using the Data, Sort command.
• Locate information quickly in a list that meets specified conditions by using the Advanced filter feature.
• Very useful functions: Sumif, Countif, IF, Concatenate
• Conditionally format data

Training Course Content:

Lesson 1: Creating Charts

• Creating a Chart Sheet
• Creating an Embedded Chart
• Comparing Chart Sheets with Embedded Charts

Lesson 2: Modifying Charts

• Chart Types
• Modifying Embedded Charts
• Adding and Deleting Chart Items
• Moving and Sizing Chart Items

Lesson 3: Formatting a Chart

• Formatting Chart Text
• Formatting Labels
• Formatting the Chart
• Printing a Chart Sheet

Lesson 4: Using Graphic Objects

• Adding Graphic Objects
• Formatting Graphic Objects
• Using Graphic Objects to Enhance Worksheets and Charts

Lesson 5: Sorting Data

• Single-level Sorting
• Multiple-level Sorting
• Sorting Options
• Importing Data
• Design Considerations

Lesson 6: Filtering Data

• Filtering a List
• Custom Criteria
• Multiple-condition Criteria
• Managing a Filtered List

Useful functions and Tools

• IF
• Sumif
• Countif
• Concatenate
• Conditional formatting
• Text to columns

What's Next?  DSOC0263 Microsoft Excel 2003, 2002, 2000 Level 3