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
|