Excel 5.0 for Windows

Beginning (6-8 hours)

  • Spreadsheet Basics
  • Excel Basics (Screen, Menu, Help)
  • Tip Wizards
  • Entering, Editing & Deleting Data
  • Creating & Filling Formulas
  • Saving, Opening & Printing Workbooks
  • Formatting (Alignment, Attributes, Borders)
  • Using Built-In Functions (Function Wizard)
  • Column Widths
  • Inserting & Deleting Rows/Columns
  • Copying & Moving (Drag & Drop)
  • Working with Charts

Intermediate (6-8 hours)

  • Using Block Names
  • Sorting Records
  • AutoFilter
  • Creating Macros
  • Working with Arrays
  • Linking Files
  • Protecting the Worksheet
  • Hiding Columns
  • Creating a Workspace
  • 3-D Worksheets & Tabs
  • Working with Chart Sheets

Advanced (6-8 hours)

  • Creating Outlines
  • Using Excel's Drawing Tools
  • Annotating the Worksheet
  • Using the Goal Seek
  • Using Pivot Tables
  • Cell Notes
  • Workgroups
  • Scenario Manager
  • Customizing the Workspace
  • Importing & Exporting

EZ-REF Home Page
Home Page

© 2005 EZ-REF Courseware.
 The copying of text, images, source code or other
information from this Web site without permission from
EZ-REF Courseware constitutes a copyright violation.