Excel 2003 Level 2

Cost: $440.00   Duration: 1 day

Prerequisites
Attendance at an Excel Level 1
course or equivalent experience.

Objectives
To provide a thorough understanding of the intermediate concepts and skills that will enable the participant to
effectively use Microsoft Excel.

Methodology
Group and individual instruction,
hands on practical exercises, visual aids, comprehensive course documentation.

At Drake Training, we've made it easier for students to complete their Microsoft applications training by combining all versions into one single session. Users of
the various Microsoft 2000, XP and 2003 applications will find that our courses prepare them to use all three products, which also means that our courses run more frequently since individual versions are not run in isolation. Our Office courses are also aligned to Microsoft Office
Specialist certifications.

Customising the Toolbar
Customising Toolbars
Displaying Toolbars
Creating Toolbars
Changing a Button’s Appearance
Removing Buttons from the Toolbar
Deleting a Toolbar
Personalised Menus and Toolbar Options

Working with Range Names
Creating and Defining a Range Name
Defining a Range Name
Editing a Range Name
Deleting a Range Name
Moving Quickly to a Named Range
Using Ranges in a Formula
Applying Range Names to Existing Formulae
Using Labels

Outlining
What is an Outline?
Creating an Outline Automatically
Copying Outline Data
Creating an Outline Toolbar
Removing an Outline

Working with Lists
List Management
Creating a New List
Editing Records Using the Data Form
Finding Records
Additional Criteria
Deleting Records Using the Data Form

Sorting and Filtering Data
Sorting
Performing a Secondary Sort
Creating Subtotals
Using the Summary Outline
Removing Subtotals
Applying Autofilter

Working with Functions
What is a Function?
Date and Time Functions
Date Functions
Pmt Function
Using Insert Function
The Vlookup Function

Working with Multiple Worksheets
Moving Around Multiple Worksheets
Renaming Worksheets
Inserting a Worksheet
Deleting a Worksheet
Copying Data between Worksheets
Copying and Moving Worksheets
Copying and Moving Worksheets Using the Mouse

Consolidating Data Across Multiple Worksheets
Grouping Multiple Worksheets
Filling a Group of Worksheets
Editing a Group of Worksheets
Colour Coding Worksheet Tabs

Data Validation
Indicating Data Type and Acceptable
Values
Creating a List of Acceptable Values
Using a Formula to Validate Input
Specifying an Input Message
Choosing an Error Alert Style

Inserting Clipart and Diagrams
Inserting Clip Art Pictures
Inserting Diagrams in Excel 2002 and 2003
The Diagram Toolbar in Excel 2002 and 2003
Inserting and Deleting Diagram Shapes in Excel 2002 and 2003
Resizing a Diagram in Excel 2002 and 2003
Changing the Style of the Diagram in Excel 2002 and 2003

Auditing Tools
Displaying the Formula Auditing Toolbar
Precedents and Dependents
Tracing Cell Dependents
Tracing Cell Precedents
Tracing Cell Errors
Using the Error Checking Options in Excel 2002 and 2003
Using the Trace Error Smart Tag in Excel 2002 and 2003
Circular References