Microsoft Excel XP Intermediate
Training Course Outline

1-day course

This course includes the following topics:

1). VIEWING WORKSHEETS

CUSTOMIZING VIEW OPTIONS
Customizing the Excel window display
Customizing the Comments View options
Customizing the Objects View options
Customizing the Worksheet View options

DISPLAYING AND CUSTOMIZING TOOLBARS
Choosing a Toolbar
Displaying Toolbars
Customizing Toolbar Options
Adding Commands to a Toolbar

HIDING WORKBOOKS AND WORKSHEETS
Hiding a Workbook
Hiding Worksheets
Displaying hidden Workbooks
Displaying hidden Worksheets

FREEZING PANES
Freezing a horizontal pane
Freezing a vertical pane
Freezing horizontal and vertical panes
Unfreezing panes

GROUPING AND UNGROUPING WORKSHEETS
Grouping Worksheets
To select all Worksheets
To select several Worksheets
Ungrouping Worksheets

 

2). MORE FORMATTING TECHNIQUES

USING STYLES
Creating a new style
Applying a style
Changing the formatting of a style
Removing a style from cells
Deleting a style

CONDITIONAL FORMATTING
Using conditional formatting
Changing conditional formatting
Deleting conditional formatting
Finding cells with conditional formatting

USING THE FORMAT PAINTER
Copying and applying cell formatting with the Format Painter
Copying and applying column width or row height with the Format Painter
Copying and applying cell formatting with the Format Painter
Copying and applying the Format Painter in multiple locations

USING GUIDELINES
Changing the color of the Gridlines
Turning off the onscreen Gridlines
Printing Gridlines

HIDING AND DISPLAYING CELLS
Hiding Columns
Hiding Rows
Using the mouse to hide Columns
Using the mouse to hide Rows
Displaying hidden Columns
Displaying hidden Rows
Using the mouse to display hidden Columns
Using the mouse to display hidden Rows

 

3). MORE FORMULAS AND FUNCTIONS

USING THE SERIES COMMAND
Using the Series Command
Applying a list series
Applying a numeric series
Applying a basic numeric series
Creating a custom list series

USING THE INSERT FUNCTION WIZARD
Displaying the Insert Function wizard
Choosing a function from the Insert Function wizard
Entering Function Arguments in the Insert Function wizard

USING THE EXCEL FUNCTION CATEGORIES
Using the Most Recently Used function category
Using the Financial function category
Using the Date & Time function category
Using the Math & Trig function category
Using the Statistical function category
Using the Lookup & Reference function category
Using the Database function category
Using the Text function category
Using the Logical function category
Using the Information function category

CORRECTING FORMULAS
Finding and correcting errors in Formulas
Finding error values
Correcting error values

USING THE FORMULA ERROR CHECKER
Using the Formula error checker
Rechecking ignored errors
Customizing the Formula error checker

USING THE FORMULA AUDITING TOOLBAR
Displaying the Formula Auditing toolbar
Using the Formula Auditing toolbar
Tracing Precedents
Removing Precedent Arrows
Tracing Dependents
Removing Dependent Arrows
Adding a new comment
Evaluating Formulas one step at a time

USING THE WATCH WINDOW
Using the Watch Window
Adding a Watch to a cell
Adding a Watch to all the cells with Formulas
Displaying a cell in the Watch Window
Deleting a Watch
Hiding the Watch Window

 

4). DATABASE AND LIST MANAGEMENT

USING DATABASES
Using the Excel database features
Using database terminology

CREATING AND EDITING A DATABASE
Creating an Excel database
Working with an Excel database

SORTING A DATABASE
Sorting data within a database
Adding other sorting criteria

USING AUTOFILTERS
Filtering data
Filtering data with AutoFilter
Specifying a conditional filter with AutoFilter
Using the Top 10 AutoFilter
Removing all AutoFilters

ADVANCED FILTERS
Using Advanced Filters
Removing all Advanced Filters

WORKING WITH FILTERED DATA
Manipulating Filtered Data
Totaling fields within a filtered database list
Creating Subtotals
Remove Subtotals

USING DATA FORMS
Using a Data Form
Adding a new record
Moving between records
Finding records
Editing a record
Deleting a record
Closing a Data Form

 

5). CHARTS

CHART WIZARD
Using the Chart Wizard
Selecting the Chart Type
Specifying the Data Source
Customizing the Chart
Defining the Chart Location

CHART TOOLBAR
Displaying the Chart toolbar
Using the Chart toolbar
Selecting a Chart
Selecting Chart objects

WORKING WITH CHARTS
Changing the Chart Type
Adding data to a Chart
Removing data from a Chart
Moving a Chart
Resizing a Chart
Deleting a Chart

FORMATTING THE CHART
Formatting the Chart Area
Formatting the Chart Title
Formatting the Plot Area
Formatting the Axis
Formatting the Axis Title
Formatting the Legend
Formatting the Gridlines
Formatting the Data Series

 

6). DRAWING AND PICTURE OBJECTS

DRAWING TOOLBAR
Displaying the Drawing toolbar
Using the Drawing toolbar

WORKING WITH AUTOSHAPES
Inserting an AutoShape object
Drawing common objects
Formatting AutoShape objects
Selecting an object
Changing the look of AutoShape lines
Changing the look of AutoShape arrows
Adding a shadow
Applying the 3-D option
Moving an object
Copying objects
Resizing an object

CREATING TEXT BOXES
Creating a text box
Editing text in a text box
Resizing a text box
Deleting a text box

ADDING PICTURES
Inserting Clip Art
Inserting a picture
Using the Picture toolbar
Moving a clip art or picture
Copying a clip art or picture
Resizing an object

LAYERING OBJECTS
Changing the layer order of objects

GROUPING AND UNGROUPING OBJECTS
Grouping objects
Ungrouping objects

 

7). EXCEL XP AND OTHER APPLICATIONS

CONVERTING FILES FROM OTHER APPLICATIONS
Converting spreadsheets from other applications

COPYING DATA FROM ANOTHER APPLICATION
Using the Office Clipboard
Using Paste Special
Using Paste Special with content from Excel
Using Paste Special with content from other application
Changing data to graphic objects

EMBEDDING AND LINKING OBJECTS
Embedding data
Embedding an existing document
Linking data
Creating a link to an existing file
Linking data from Microsoft Word

HYPERLINKS
Using Hyperlinks
Creating a Hyperlink

MANAGING LINKS
Updating Links
Editing Links
Checking the status of a Link
Breaking Links

 

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.