Excel 2000 Advanced

Course Description
Course Outline

Course Overview

Students will learn various advanced techniques for analyzing and manipulating data and to use the list-management capabilities in Excel 2000.

Prerequisites

Excel 2000 Intermediate, or equivalent knowledge.

Benefits

Students will learn how to 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 should already understand basic concepts involved in using Excel 2000. For example, they should be familiar with data types (text and values), copying data, basic formulas and functions, and opening and saving files.

What's next

For those wishing to create and edit custom macros, and gain an understanding of VBA code, Excel 2000 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 Using IS functions and the Auditing features
Working with multiple worksheets
Working with workbooks Linking cells in different workbooks Workbooks versus links and workspaces
Consolidating and analyzing data
Consolidating data from more than one worksheet Using the Goal Seek and Solver utilities Using Scenario Manager to view a worksheet with different input values
Protect and display options
Using comments Protecting workbooks Using custom views Report Manager
Introduction to macros
Running a macro Recording a macro Viewing and editing VBA code
Working with interactive Excel Web documents
Saving Excel worksheets as Web documents Spreadsheet Web Components

Publisher:	Microsoft
Version:	2000
Length:	1 Day
Course-ID:	074202

	Printer Friendly Version
	Download Outline As PDF

Related Courses

Each of us returned extremely positive and motivated - the arrangements, as usual, ran like clockwork - we certainly felt the course was of benefit

- Local Charity