Excel 2000 Advanced Courseware Outline

---

Templates and Styles

• What are Templates?
• Creating Templates
• Using Templates
• What are Styles?
• Creating and Using Styles

Importing Data

• Why Import Data?
• The Text Wizard
• Importing From a Database
• Database Terminology
• Using Microsoft Query

"What If?" Utilities

• Excel "What If?" Type Utilities
• Goal Seek
• Graphical Goal Seeking
• Scenario Manager
• Solver
• Solver Terminology
• Solver - An Example

Macros and Custom Controls

• What are Macros?
• To Record a Macro
• Running Macros
• Creating a Button in a Worksheet and Assigning a Macro to it
• Attaching Macros to a Button
• Drawing, Editing and Formatting Buttons

Customizing Excel

• Customizing Excel 2000 - Options
• Customizing Toolbars

Security and Proofing within Excel

• Auditing and Security Features within Excel 2000
• The Spell Checker
• What Are Shared Workbooks?
• Advanced Workbook Sharing Options
• Data Validation
• Workbook Password Protection
• Workbook Protection
• Worksheet Protection
• Cell Protection
• Excel 2000 Auditing Tools
• Auditing Worksheets
• Cell Comments

Data Maps

• What Are Data Maps?
• The Data Map Control Dialog Box
• Placing Data on a Map
• Formatting a Data Map

Consolidation

• What is Consolidation?
• Consolidating Rows and Columns