Excel 97 Advanced

Course Description
Course Outline

Course Overview

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

Prerequisites

Excel 97 Intermediate or equivalent knowledge.

Benefits

Students will learn how to use add graphics to a worksheet or chart, perform advanced filters and queries on data, create advanced formulas, link files, consolidate data, and record macros.

Target student

Students attending this course should be confident in working with worksheets and charts and using basic formulas and functions.

What's next

For those wishing to create and edit custom macros, and gain an understanding of VBA code, Excel 97 VBA Programming is the next course in the series.

We offer a range of Excel training courses

Using graphic objects
Adding graphic objects Formatting graphic objects Using graphic objects to enhance worksheets and charts
Advanced techniques for filtering data
Multiple-condition criteria Managing a filtered list
Querying data
Database functions External databases and queries Running a Web Query on the Internet
Advanced formula construction
The VLOOKUP function Error handling and the Auditing features
Multiple file linking
Working with workbooks Linking individual cells Workbooks versus links and workspaces
Consolidating data and using analysis tools
Consolidating worksheets Using the Goal Seeker and Solver utilities Creating a scenario by using Scenario Manager
Protect and display options
Using comments Protecting the worksheet Hiding information Custom views Report Manager
Introduction to macros
Running a macro Recording a macro Viewing and editing VBA code

Publisher:	Microsoft
Version:	97
Length:	1 day
Course-ID:	052222

	Printer Friendly Version
	Download Outline As PDF

Related Courses

The trainer is always very knowledgeable, not only about the subject being taught, but other related topics ... having the all round knowledge sets you apart. Thanks again

- Heart of England TEC