Excel 7.0 for Windows


Beginning (6-8 hours)

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

Intermediate (6-8 hours)

  • Using Block Names
  • Sorting Records
  • AutoFilter & the Using Data Form
  • Creating Macros
  • Working with Arrays
  • Linking Files
  • Protecting Blocks/Worksheets
  • Hiding Columns/Blocks
  • Creating a Workspace
  • Multiple Worksheets & Tabs
  • Working with Chart Sheets
  • Formatting Shortcuts

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
  • Customizing the Toolbar
  • Setting Program Options

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.