Microsoft Excel 2002 Core: Beginning to Use Worksheets

Overview/Description
Microsoft Excel 2002 is a powerful spreadsheet program. The help system and the many intuitive features make Excel easy to learn and use. This course, Beginning to use Worksheets, presents introductory techniques for creating, formatting, and printing worksheets.

Target Audience
This course is designed for Microsoft Excel 2002 beginners or those new to Microsoft Excel 2002. No prior experience is required; however, some experience using a keyboard and mouse is helpful.

Expected Duration
This course, including the practice exercises, will take up to four hours to complete.

Objectives:

Mastering Excel Fundamentals

  • Start the Excel application
  • Recognize elements in the Excel window
  • Move a toolbar
  • Display toolbars and toolbar buttons
  • Display menus
  • Identify the elements in Excel workbooks and worksheets
  • Exit Excel
  • Open the Excel Help window
  • Use the Answer Wizard
  • Display a ScreenTip
  • Use Ask a Question
  • Access the Office Assistant
  • Create a new workbook
  • Locate and open a workbook
  • Switch between open workbooks
  • Navigate worksheets
  • Name and save a new workbook
  • Close a workbook
  • View and set workbook properties

    • Getting Started with Worksheets

  • Navigate cells in a worksheet
  • Select rows and columns
  • Select a range of adjacent cells
  • Select a range of nonadjacent cell groups
  • Enter and edit labels
  • Enter and edit numbers
  • Clear the contents of cells
  • Check spelling in a worksheet
  • Apply formats to numbers
  • Set options for number formats
  • Align and orient cell contents
  • Wrap labels
  • Merge and split cells
  • Set font attributes for labels and numbers
  • Apply cell border styles
  • Apply cell background styles
  • Copy and clear cell formats

    • Editing Worksheets

  • Copy and paste cells
  • Copy and insert cells
  • Move cells using cut and paste
  • Move cells using cut and insert
  • Move cells using drag and drop
  • Paste and clear entries using the Clipboard task pane
  • Edit cell contents using Find and Replace
  • Fill and edit cells using AutoComplete
  • Fill and edit cells using the cell shortcut menu
  • Copy data using AutoFill
  • Extend a data series using AutoFill

    • Using Data Lists in Worksheets

  • Identify elements of a worksheet list
  • Design a worksheet that contains a list
  • Display a data form for a list
  • Browse through records in a data form
  • Set criteria in a data form
  • Add records using a data form
  • Edit records using a data form
  • Delete a record using a data form
  • Identify the basics and defaults of sorting
  • Sort data records and fields
  • Filter lists using AutoFilter


    • Course Number: MOFF0211