View ECDL/ICDL Site

Microsoft Excel XP | Excel 2002 Course
Advanced Level Courseware Training Materials

Training Course Outline

1. IMPORTING DATA

IMPORTING DATA FROM EXTERNAL SOURCES

• Using Database Terminology
• Importing Data into Excel

IMPORTING TEXT FILES

• Importing text files into Excel
• Importing text using the Text Import Wizard
• Refreshing data from imported text files

USING MICROSOFT QUERY

• Adding a Data Source
• Creating a Query

QUERYING DATA FROM THE WEB

• Using Web Queries
• Accessing the New Web Query dialog box
• Creating a new Web Query
• Saving a Web Query
• Setting Web Query options
• Running a saved Web Query
• Refreshing a Web Query

REFRESHING DATA

• Refreshing external data without losing the formatting
• Refreshing external data automatically

2. TEMPLATES AND STYLES

WORKING WITH TEMPLATES

• Using Templates
• Creating a Template
• Applying Templates

WORKING WITH STYLES

• Using Styles
• Creating a Style
• Applying a Style
• Editing a Style
• Deleting a Style
• Copying Styles from another Workbook

3. ANALYZING DATA

WHAT-IF ANALYSIS

• Using What-If Analysis

GOAL SEEK

• Using Goal Seek
• Applying Goal Seek

DATA TABLES

• Using Data Tables
• Creating a one-variable Data Table
• Creating a two-variable Data Table
• Speeding up calculations with Data Tables

SCENARIO MANAGER

• Using Scenario Manager
• Adding a Scenario
• Showing a Scenario
• Deleting a Scenario
• Editing an existing Scenario
• Summarizing Scenarios

SOLVER

• Using Solver
• Installing Solver
• Applying Solver
• Changing a Constraint
• Deleting a Constraint

4. MACROS AND CUSTOM CONTROLS

WORKING WITH MACROS

• Using Macros
• Recording a Macro
• Assigning a shortcut key to your Macro

RUNNING MACROS

• Running a Macro using the main menu
• Running a Macro using a shortcut key
• Running a Macro using a button

ADDING CUSTOM CONTROLS

• Working with Buttons
• Creating a new Button
• Renaming a Button
• Formatting Buttons
• Linking an existing Macro to a Button
• Deleting a Button

5. SECURITY AND PROOFING

SECURITY FEATURES

• Working with Security Features

PROTECTING EXCEL FILES

• Specifying a password for opening a workbook
• Specifying a password for saving a workbook
• Removing a Workbook Password
• Using the Read-only option
• Creating backup files automatically

WORKSHEET PROTECTION

• Protecting Worksheets
• Un-Protecting Worksheets
• Protecting Cells

WORKING WITH DIGITAL SIGNATURES

• Using Digital Signatures
• Signing a File
• Removing a digital signature from a file

CHECKING SPELLING

• Using the Spell Checker

USING DATA VALIDATION

• Setting data validation
• Creating the Input Message
• Displaying an Input Message
• Creating the Error Alert
• Displaying an Error Alert

USING TEXT TO SPEECH

• Reading back a group of cells
• Using Speak On Enter
• Turning off Speak On Enter

DOCUMENTATION

• Working with Comments
• Adding a Comment
• Displaying a Comment
• Editing a Comment
• Deleting a Comment

6. CUSTOMIZING EXCEL XP

CONFIGURING EXCEL XP OPTIONS

• Customizing Excel Options
• Customizing View Options
• Customizing Calculation Options
• Customizing Edit Options
• Customizing General Options
• Customizing Transition Options
• Customizing Custom Lists Options
• Customizing Chart Options
• Customizing Color Options
• Customizing International Options
• Customizing Save Options
• Customizing Error Checking Options
• Customizing Spelling Options
• Customizing Security Options

CUSTOMIZING THE EXCEL ENVIRONMENT

• Displaying Toolbars using the Customize dialog box
• Creating a Custom Toolbar
• Adding a Menu to a Toolbar
• Attaching a Toolbar
• Deleting a Custom Toolbar
• Resetting a Menu
• Resetting a Toolbar

WORKING WITH WORKSPACES

• Using Workspace files
• Saving your Workspace

7. COLLABORATION AND CONSOLIDATION

SHARING WORKBOOKS

• Using Shared Workbooks
• Allowing Workbook Sharing
• Customizing Workbook Sharing Options
• Comparing and Merging Shared Workbooks

SENDING WORKBOOKS

• Sending Workbooks for Review
• Sending a Worksheet as Attachment
• Routing a Workbook
• Routing a Workbook to the next recipient

CONSOLIDATION

• Consolidating data over several Worksheets
• Consolidating selected rows and columns from several Worksheets

Other Microsoft Office 2002 Courseware materials

• Microsoft Access 2002 Foundation Courseware materials
• Microsoft Access 2002 Intermediate Courseware materials
• Microsoft Access 2002 Advanced Courseware materials
• Microsoft Excel 2002 Foundation Courseware materials
• Microsoft Excel 2002 Intermediate Courseware materials
• Microsoft Excel 2002 Advanced Courseware materials
• Microsoft FrontPage 2002 Foundation Courseware materials
• Microsoft FrontPage 2002 Intermediate Courseware materials
• Microsoft Outlook 2002 Foundation Courseware materials
• Microsoft PowerPoint 2002 Foundation Courseware materials
• Microsoft PowerPoint 2002 Intermediate Courseware materials
• Microsoft Project 2002 Foundation Courseware materials
• Microsoft Publisher 2002 Foundation Courseware materials
• Microsoft Publisher 2002 Intermediate Courseware materials
• Microsoft Visio 2002 Foundation Courseware materials
• Microsoft Word 2002 Foundation Courseware materials
• Microsoft Word 2002 Intermediate Courseware materials
• Microsoft Word 2002 Advanced Courseware materials