Microsoft^®

Excel 2003 Level 2

Prerequisites:

Students must have basic knowledge of Excel to progress to this level.

Course Content:

• Formulas with Several Operators and Cell Ranges
• Using the Formula Palette to Enter and Edit Formulas
• Creating and Using Range Names
• Selecting Nonadjacent Ranges and Using AutoCalculate
• Using the IF Function to Create Conditional Formulas
• Using the PMT Function
• Displaying and Printing Formulas
• Fixing Errors in Your Formulas

• Creating a Chart
• Moving and Resizing a Chart
• Formatting and Editing Objects in a Chart
• Changing a Chart's Source Data
• Changing a Chart Type and Working with Pie Charts
• Adding Titles, Gridlines, and a Data Table
• Formatting a Data Series and Chart Axis
• Annotating a Chart
• Working with 3-D Charts
• Selecting and Saving a Custom Chart
• Using Fill Effects

• Creating a List
• Working with Lists and Using the Total Row
• Adding Records Using the Data Form Dialog Box and Insert Row
• Using the Data Form to Add Records
• Finding Records
• Deleting Records
• Sorting a List
• Filtering a List with the AutoFilter
• Creating a Custom AutoFilter
• Filtering a List with an Advanced Filter
• Copying Filtered Records
• Using Data Validation

• Inserting an Excel Worksheet into a Word Document
• Modifying an Inserted Excel Worksheet
• Inserting a Linked Excel Chart in a Word Document
• Inserting a Graphic into a Worksheet
• Opening and Saving Files in Different Formats