Beginning (6-8 hours)
- Spreadsheet Basics
- Excel Basics (Screen, Menu, Help, Office Assistant)
- Entering, Editing, Deleting & Undeleting Data
- Working with Blocks
- Adjusting Column Widths
- Creating & Filling Formulas, Natural Language Formulas
- Saving, Opening & Printing Workbooks
- Copying & Moving (Drag & Drop)
- Formatting (Alignment, Attributes, Borders)
- Using Built-In Functions (Function Wizard)
- Inserting & Deleting Rows/Columns
- Custom Cell Formats
- AutoFormat & using the Format Painter
- Working with Charts & Templates
- Using the Spell Checker
Intermediate (6-8 hours)
- Using Block Names
- Creating a Database
- Sorting Records
- AutoFilter & Custom Filters
- Using a Data Form
- Working with Macros
- Creating an Array Formula
- Linking Files
- Creating a Workspace
- Protecting Blocks/Worksheets
- Hiding Columns/Blocks
- Multiple Worksheets & Tabs
- Working with Chart Sheets
- Creating Map Charts
- Conditional Formatting
Shortcuts & Custom Formatting
Advanced (6-8 hours)
- Creating Outlines
- Using Excel's Drawing Tools
- Cell Comments
- Using the Goal Seek
- Using Pivot Tables
- Consolidating Data
- Scenario Manager
- Advanced Chart Options
AutoShapes, WordArt
Importing & Exporting
Working with Styles
Custom Views
Customizing the Toolbar
Setting Program Options
|
