Beginning (6-8 hours)

• Spreadsheet Basics
• Lotus/Windows Basics
• The Classic Menu
• Customizing the View
• Entering, Editing & Deleting Data
• Creating & Copying Formulas
• Saving, Opening & Printing Workbooks
• Alignment & Formatting of Ranges
• Using Built-In Functions
• Column Widths
• Inserting & Deleting Rows/Columns
• Spreadsheet Publishing
• Creating Charts
• Using Smartmaster Templates
• Spell Checking
• Absolute Cell Addressing

Intermediate (6-8 hours)

• Using Range Names
• Creating a Database
• Sorting Records
• Querying a Database
• Creating Forms
• Mailing Labels
• Creating Scripts
• Combining Workbooks
• Linking Files
• Multiple Worksheets
• Adding Page Breaks
• Hiding Columns/Ranges
• Protecting the Worksheet/WorkBook
• Creating Multiple Views
• Chart Options

Advanced (6-8 hours)

• Working with Dates
• Using Advanced @Functions
• Lookup Tables
• Working with External Databases
• Using the BackSolver
• Using Versions & Version Groups
• Annotating the Worksheet
• Working with Maps
• Working with Graphics
• Adding Cell Comments
• Creating OLE Links
• Importing/Exporting Files
• Customizing Workbook & 1-2-3 Properties
• Customizing SmartIcons & SmartFill