Excel 2002 Intermediate

1 day

Overview

Students will learn the skills and concepts necessary to work with intermediate features of Excel 2002 in Office XP.

Prerequisites

Excel 2002 Introduction, or equivalent knowledge.

Benefits

Students will learn how to validate data, use advanced formulas, create pivot tables, create charts from spreadsheet data, and sort and filter data.

Target student

Students should be familiar with data types (text and values), copying data, basic formulas and functions, and opening and saving files.

What's next

Excel 2002 Advanced is the third course in this series.

Further data entry techniques

Create and edit a comment
The AutoComplete feature

Customising your workbook

Apply Conditional Formatting
Add Data Validation Criteria
Customize Menus
Customize Toolbars
Group and Outline Structured Data

Working with Templates

Create a Workbook from an Excel Template
Create a Template
Create a Graphic
Create a Workbook from a User-Defined Template

Working with Advanced Formulas

Share Data Among Worksheets
Create a Name for a Range of Cells
Use Functions

Analyzing Data

Create a PivotTable Report
Create a PivotChart Report

Creating and Modifying Charts

Create a Chart
Modify Chart Items
Format a Chart
Change the Chart Type

Enhancing Your Worksheet using Charts

Chart Non-adjacent Data
Modify chart items
Create a Trend Line

Sorting and Filtering Data

Sort Data
Add Subtotals to a Worksheet
Filter Lists
Create and Apply Custom Filters

Collaboration

Insert and Edit a Hyperlink
Add and Edit Comments in a Worksheet
Create Discussion Comments
Respond to Discussion Comments

Systematix Training - tel: 0118 3243000 - www.systematix.co.uk
Excel 2002 Intermediate training courses