Excel 2000 Intermediate

Course Description
Course Outline

Course 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.

We offer a range of Excel training courses

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

Publisher:	Microsoft
Version:	2000
Length:	1 day
Course-ID:	SX115A

	Printer Friendly Version
	Download Outline As PDF

Related Courses

Small group, relaxed and open atmosphere. Felt comfortable admitting being lost or confused

- British Gas