Experience Digitally Assisted Learning at it's Best

Excel 2002 Series

Total Time: 22 hours

 

Excel 2002: Working with Cells Time: 4 hours EXPM01

Excel 2002: Working with Cells shows users how to enter and edit data in Excel 2002 worksheet cells and create hyperlinks.

  • Entering Data
  • Editing a Cell
  • Editing Multiple Cells
  • Replacing Values and AutoFilling
  • Creating Hyperlinks


 

Excel 2002: Working with Files Time: 3 hours EXPM02

Excel 2002: Working with Files shows users how to locate, open, and save files in Excel 2002.

  • Opening Files
  • Saving Files
  • Files and the Internet
  • Working with Comments
  • Using the Office Assistant


 

Excel 2002: Formatting Worksheets Time: 4 hours EXPM03

Excel 2002: Formatting Worksheets shows users how to format and adjust cells, adjust rows and columns, and apply formatting and styles in an Excel 2002 worksheet.

  • Formatting Cells
  • Adjusting Cells
  • Formatting Numbers
  • Adjusting Rows and Columns
  • Using AutoFormatting and Styles


 

Excel 2002: Page Setup and Printing Time: 2 hours EXPM04

Excel 2002: Page Setup and Printing shows users how to preview and print worksheets and workbooks; add headers, footers, and titles, and adjust page settings in Excel 2002 worksheets.

  • Previewing
  • Printing
  • Page Setup
  • Headers, Footers, and Titles


 

Excel 2002: Worksheets and Workbooks Time: 4 hours EXPM05

Excel 2002: Worksheets and Workbooks shows users how to work with worksheet rows and columns, move between worksheets in a workbook, consolidate data, change the zoom setting, and check spelling in Excel 2002 worksheets.

  • Working with Rows and Columns
  • Working with Worksheets
  • Linking Worksheets and Consolidating Data
  • Zooming and Spell-Checking
  • Using a Data Filter


 

Excel 2002: Formulas and Functions Time: 3 hours EXPM06

Excel 2002: Formulas and Functions shows users how to work with formulas and functions in Excel 2002 worksheets.

  • Working with Formulas
  • Using References and AutoSum
  • Entering Functions
  • Using Basic and Date Functions
  • Using Financial and Logical Functions


 

Excel 2002: Charts and Objects Time: 2 hours EXPM07

Excel 2002: Charts and Objects shows users how to create, modify, and print charts, insert, move and delete pictures, and draw lines and shapes in Excel 2002 worksheets.

  • Creating Charts
  • Modifying and Printing Charts
  • Working with Objects
  • Drawing Lines and Shapes

 

 


© 2003 Bridgeway Cyber Academy
334 Second Street
Catasauqua PA 18032

Designed & Administered by PolyWeb Development