Beginning (6-8 hours)
- Spreadsheet Basics
- Excel Basics (Screen, Menu)
- Using Help and the Office
Assistant
- Entering, Editing, Deleting & Undeleting Data
- Working with Blocks
- Adjusting Column Widths
& Row Height
- Creating & Filling Formulas
- Entering Natural Language Formulas
- Using the Spell Checker
- Saving, Opening & Printing Workbooks
- Setting Print Options
- Copying & Moving (Drag & Drop)
- The Office Clipboard
- Formatting (Alignment, Attributes, Borders)
- Inserting & Deleting Rows/Columns
- Using Built-In Functions
- Custom Cell Formats
- AutoFormat
- The Format Painter
- Working with Charts
- Using & Creating Templates
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
- File Management
- Sharing Workbooks
- Tracking Changes
- Routing a Workbook
- Conditional Formatting
- Formatting Shortcuts
- Custom Formats
Advanced (6-8 hours)
- Creating Outlines
- Pivot Tables & Pivot Charts
- Advanced Chart Options
- Adding Clipart, Graphic Files, AutoShapes
- Using Excel's Drawing Tools
- Adding Word Art
- Using the Goal Seeker
- Creating Scenarios
- Cell Comments
- Consolidating Data
- Importing & Exporting
- Customizing the Toolbar
- Working with Styles
- Custom Views
- File Properties
- Setting Program Options
- Working with Maps
|
