Excel 2000 Intermediate Courseware Outline

---

Worksheets, a Further Look

• Renaming Worksheets
• Deleting and Inserting Worksheets
• Finding Files
• Displaying Other Toolbars
• Customizing the Look of the Toolbars
• Freeze Panes
• Grouping and Ungrouping Worksheets
• The Series Command

Further Formatting Techniques

• Conditional Formatting
• Creating New Styles Based on Existing Cell Formatting
• Using Colors in Excel 2000
• Using Colors Based on Values
• Gridlines
• Hiding Data and Re-displaying Data

Further Functions

• What Are Functions?
• Using Paste Function
• The IF( ) Function
• Data Validation Functions
• The HLOOKUP / VLOOKUP Functions
• A Sample HLOOKUP
• The Choose Function
• Entering a CHOOSE Function
• The Date Functions
• Mathematical Date Functions
• Time Functions
• Text Manipulation Functions

Database and List Management

• What is a Database?
• Excel 2000 Databases
• Database Terminology
• Creating, Editing and Navigating a Database
• Sorting an Internal Excel 2000 Database
• What is AutoFilter?
• Filtering Data
• Top 10 AutoFilter
• Advanced Filtering
• Totaling and Manipulating Filtered Data
• Creating Subtotals
• Using Data Forms
• The Excel 2000 Data Form

Customizing Charts

• The Chart Wizard (1) - Chart Type
• The Chart Wizard (2) - Data Source
• The Chart Wizard (3) - Chart Options
• The Chart Wizard (4) - Chart Location
• Adding and Removing Data
• Changing Data By Dragging and Dropping Columns
• Formatting the Chart Area
• Chart Formatting - Legends
• Chart Formatting - Axis
• Chart Formatting - The Plot Area
• Chart Formatting - Gridlines
• Chart Formatting - The Data Series

Drawing and Pictures

• Drawing Lines, Boxes, Ovals and Arcs
• Using AutoShapes
• Creating Text Boxes
• Pictures
• Bring to Front/Send to Back
• Grouping and Un-grouping Objects

Excel 2000 and Other Applications

• Using the Conversion Feature
• Cut, Copy and Paste - Using the Clipboard
• Using Paste Special
• OLE - Embedding vs. Linking
• Linking Data From Other Worksheets
• Linking Data From Word
• Linking Data To Word