The Excel 2003 QUICK Source Learning Series will show you the basics of how to use Excel 2003. 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 2003. 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 2003
  • Identifying the Parts of the Excel 2003 Window
  • Using the Task Pane
  • Creating a New Workbook
  • Opening an Existing Workbook
  • Searching for a Workbook
  • Saving a Workbook
  • Closing Workbooks
  • Using the Standard Toolbar
• Workbooks and Worksheets
  • Inserting Worksheets
  • Renaming a Worksheet
  • Moving, Copying, and Deleting a Worksheet
  • Color Coding a Worksheet Tab
  • Zooming In and Out on a Worksheet
  • Viewing Multiple Worksheets
  • Comparing Workbooks Side by Side
• Cells, Rows, and Columns
  • Selecting Cells, Rows, or Columns
  • Inserting Cells, Rows, or Columns
  • Deleting Cells, Rows, or Columns
  • Adjusting Row Height and Column Width
  • Splitting Worksheet Panes
  • Freezing Rows and Columns
  • Changing the Color of Cell Gridlines
  • Hiding Cell Gridlines
  • Printing Cell Gridlines
• Data
  • Entering Data
  • Using the AutoFill Feature
  • Using the AutoFormat Feature
  • Moving or Copying Data
  • Using the Office Clipboard
  • Using Repeat, Undo, and Redo
  • Sorting Data
  • Filtering Data
  • Using the Research Task Pane
• Formatting Cells
  • Assigning a Number Format for a Cell
  • Changing the Font, Font Size, and Text Color
  • Applying Bold, Italics, or Underline to Text
  • Aligning Text
  • Displaying Multiple Lines of Text in a Cell
  • Merging Cells
  • Formatting Cell Borders
  • Applying Shading to Cells
  • Using the Format Painter
  • Clearing Cell Formats
• Formulas
  • Understanding Formulas
  • Creating and Editing a Formula
  • Inserting Functions in Formulas
  • Using the AutoSum Tool
  • Moving or Copying a Formula
  • Working with Formulas
  • Naming a Cell or Range of Cells
  • Using the Watch Window
• Output
  • Creating Headers and Footers
  • Previewing a Worksheet
  • Using Page Break Preview
  • Defining the Page Setup
  • Printing Worksheets and Selections
  • Setting Up the Print Area
  • E-Mailing a Workbook
  • Printing Row and Column Headings on Every Page
• Getting Help
  • Using the Type a Question for Help Box
  • Using the Help Task Pane
  • Using the Office Assistant
  • Hiding or Turning Off the Assistant
  • Changing the Assistant
  • Getting Help in a Dialog Box
  • Getting Help from Office Online
  • Printing a Help Topic

• E03B1 - Getting Started
• E03B2 - Workbooks and Worksheets
• E03B3 - Cells, Rows, and Columns
• E03B4 - Data
• E03B5 - Formatting Cells
• E03B6 - Formulas
• E03B7 - Output
• E03B8 - Getting Help

• Microsoft Excel 2003 Basic