Microsoft Excel 2003

Introduction

Fly through spreadsheet basics by mastering fundamental terms, tools, and features. Learn to create and navigate a worksheet; enter, edit, format, and move data; freeze panes to control the data view; and put Excel to work in formulas using built-in functions. Understand why and how to use absolute or relative cell references in formulas. Come in for a hard-copy landing with an overview of print options.

Course Outline

• Lesson 1: Basic Terminology (3 min. and 57 sec.)
• Lesson 2: Enter and Modify Worksheet Data (4 min. and 43 sec.)
• Lesson 3: Navigation and Pane Freezing (4 min. and 37 sec.)
• Lesson 4: Select and Enter Data into Ranges (4 min. and 8 sec.)
• Lesson 5: Introduction to Text and Number Formatting (3 min. and 6 sec.)
• Lesson 6: Number Formatting (3 min. and 17 sec.)
• Lesson 7: Insert Rows, Columns and Cell Ranges (3 min. and 12 sec.)
• Lesson 8: Introduction to Formulas (2 min. and 55 sec.)
• Lesson 9: Using Built-in Functions (6 min. and 12 sec.)
• Lesson 10: Move and Copy Data (2 min. and 53 sec.)
• Lesson 11: Using Relative and Absolute References (4 min. and 4 sec.)
• Lesson 12: Printing Overview (7 min. and 45 sec.)
• Lesson 13: Integrating Multiple Worksheets (4 min. and 02 sec.)