The Excel 2002 QUICK Source Learning Series will show you the basics of how to use Excel 2002. The QUICK Source Learning Series combines three levels of training: Teaching, Trying, and Testing. The teaching section includes high-quality video so you are able to see what the instructor is teaching you to do. The trying section allows you to practice what you have learned right in our program. There is no need to switch between our software and Excel 2002. The testing section involves a variety of test questions with immediate feedback. Trainers can track users’ progress, view test scores, and print out reports.

• GETTING STARTED
  • Starting and Exiting Excel 2002
  • Identifying the Parts of the Excel 2002 Window
  • Opening a Workbook or Creating a New Workbook
  • Using the New Task Pane Feature
  • Searching for a File
  • Saving and Closing a Workbook
  • E-mailing a Workbook
  • Moving Around a Workbook and Entering Data in a Cell
  • Using the Standard toolbar
• WORKBOOKS AND WORKSHEETS
  • Inserting Worksheets
  • Renaming a Worksheet
  • Moving, Copying, or Deleting a Worksheet
  • Color-Coding a Worksheet Tab
  • Creating Headers and Footers
• ROWS AND COLUMNS
  • Selecting Rows and Columns
  • Inserting or Deleting a Row or Column
  • Adjusting Row Height or Column Width
  • Freezing a Row or Column
  • Splitting a Worksheet
• CELLS
  • Selecting a Number Format
  • Changing the Font, Font Size, and Color
  • Applying Bold, Italics, or Underline to Text
  • Changing the Underline Style
  • Aligning Text
  • Merging and Unmerging Cells
  • Selecting Cell Borders
  • Using the Format Painter
• DATA
  • Entering Data
  • Entering Data into Several Cells at Once
  • Using the AutoFill Feature
  • Using AutoFormat Features
  • Clearing Cell Formats or Contents
  • Moving or Copying Data
  • Using the Office Clipboard
  • Using the Repeat and Undo Commands
  • Using the New Smart Tags Feature
• FORMULAS
  • Understanding Formulas
  • Creating and Editing a Formula
  • Using the Formula Palette
  • Using the Function Wizard
  • Using the Watch Window
  • Using the AutoSum Button
  • Copying a Formula to a Range of Cells
  • Sorting Cells
  • Naming a Range of Cells
• VIEWING AND PRINTING
  • Zooming In and Out of a Worksheet
  • Viewing Multiple Workbooks
  • Previewing a Worksheet
  • Using Page Break Preview
  • Defining Page Setup
  • Selecting Print Options and Printing a Worksheet
  • Printing a Selection
• OFFICE TOOLS AND HELP
  • Using the Speech Recognition Tool
  • Using the Handwriting Recognition Tool
  • Using the Speech Playback Feature
  • Using the What’s This Option
  • Using the Ask a Question Box
  • Using the Office Assistant
  • Changing the Assistant
  • Hiding and Turning Off the Office Assistant
  • Using Microsoft Excel Help

• E02B1 - Getting Started
• E02B2 - Workbooks and Worksheets
• E02B3 - Rows and Columns
• E02B4 - Cells
• E02B5 - Data
• E02B6 - Formulas
• E02B7 - Viewing and Printing
• E02B8 - Office Tools and Help