Excel 2000 Intermediate

1 day

Overview

Students will learn the skills and concepts necessary to work with intermediate features of Excel 2000.

Prerequisites

Excel 2000 Introduction, or equivalent knowledge.

Benefits

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

Target student

Students should already understand the basic concepts involved in using Excel 2000. For example, 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 2000 Advanced is the third course in this series.

Further data entry techniques

Creating and editing a comment
The AutoComplete feature
Using data validation

Additional formatting techniques

Using conditional formatting
Shrinking text

Customising the work area

Working with existing toolbars
Using custom toolbars
Creating and using styles
Using templates

Formula construction

Using names
The IF function COUNTIF

Pivot tables

Creating and working with pivot tables
Grouping and summarizing data in a pivot table

Creating charts

Creating a chart sheet
Creating an embedded chart
Comparing chart sheets with embedded charts

Modifying charts

Chart types
Modifying embedded charts
Adding and deleting chart items
Moving and sizing chart items

Formatting a chart

Formatting chart text and numbers
Formatting labels
Formatting the chart
Printing a chart sheet

Sorting data

Single-level sorting
Multiple-level sorting
Sorting options
Design considerations

Filtering data

Filtering a list
Custom criteria