Microsoft Excel 2000 - Day 3 (Advanced Databases)

The purpose of the advanced course is to familiarise users with further features and
functions of this package. This will be done by using a series of hands-on exercises. It is assumed that the delegates have attended the Day 1 introductory and Day 2 intermediate courses, or have knowledge of the Day 1 and day 2 course levels.

Level of the course: Third
Duration: 1 day
Hours: 9.30am - 4.30pm

A certificate will be issued to each delegate and will contribute to units of the appropriate NVQ.

Topics Covered:-

Using Excel as a database
Concepts
Creating a database
Data Validation
Using a database form
Selection Criteria
Logical operators and wild cards
Querying the database using filters
Database functions
Database subtotals
Creating a pivot table
Producing a multi-page report from a pivot table
Editing a pivot table
Advanced functions
Lookup and reference functions
Information and logical functions
Hyperlinks

As with all our training courses, Harlow ITeC will willingly tailor this course to provide added emphasis to your particular needs.

Issue: 26/1/01
Course Code: Excel2000D3