Excel 97 Intermediate

Course Description
Course Outline

Course Overview

Students will learn the skills and concepts necessary to work with advanced features of Excel 97.

Prerequisites

Excel 97 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 97. 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 97 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 Creating a new toolbar Creating and using styles Creating templates
Formula construction
Naming ranges Absolute references Nested functions The IF function COUNT..IF
Pivot tables
Creating and working with pivot tables Viewing pivot tables at different levels
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 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:	97
Length:	1 Day
Course-ID:	SX127A

	Printer Friendly Version
	Download Outline As PDF

Related Courses

Still after my third visit I am very impressed with trainers/techniques

- Royal Mail