Microsoft Excel XP Advanced
Training Course Outline

1-day course

This course includes the following topics:

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

Pivot Tables
Creating a Pivot Table
Using the Pivot Table Wizard
Using the Pivot Chart Wizard
Adding Page, Row and Column Fields
Modifying a Pivot Table
Renaming Data Fields
Field Settings

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

 

For further details, or to book a course, please contact us:
email:        training@ictwizard.com
telephone:  01382 453447
 

Our Excel courses include:

Excel 2007 Foundation

Excel 2007 Intermediate

Excel 2007 Advanced

Excel 2007 Power User

Excel 2003 Foundation 

Excel 2003 Intermediate 

Excel 2003 Advanced

Excel VBA

Bespoke Excel Training
We can design an Excel course to suit your requirements. Contact us to arrange a tailored Excel course.

 

ICT Wizard courses:

• on your site or locations throughout the UK
• Computer training courses in Aberdeen, Dundee, Glasgow, Edinburgh and London
• delivered by Certified Master Instructors.