Excel 4.0 for Windows


Beginning (6-8 hours)

  • Spreadsheet Basics
  • Excel Basics (Screen, Menu, Help)
  • Entering, Editing & Deleting Data
  • Creating & Copying Formulas
  • Saving, Opening & Printing Worksheets
  • Formatting (Alignment, Attributes, etc.)
  • Using Built-In Functions
  • Column Widths
  • Inserting & Deleting Rows/Columns
  • Copying & Moving Between Files
  • Working with Charts

Intermediate (6-8 hours)

  • Using Block Names
  • Creating a Database
  • Sorting Records
  • Finding, Extracting & Deleting Records
  • Using the Data Form
  • Creating Macros
  • Working with Arrays
  • Linking Files
  • Protecting the Worksheet
  • Hiding Columns
  • Creating a Workspace/Workbook
  • Custom Formatting
  • Advanced Chart Options

Advanced (6-8 hours)

  • Creating Outlines
  • Advanced Graphics
  • Annotating the Worksheet
  • Using the Goal Seek
  • Consolidating Worksheets
  • Cell Notes
  • Info Window
  • Work Groups
  • Advanced Macros
  • 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.