Excel 2002 An Advanced Course for Students
Jim Muir

This is one of a series of course books for students, teaching the skills required to make full and effective use of spreadsheet software. It can be used as a course text for group learning, or individually for independent learning. This advanced book does not assume any previous knowledge of Excel 2002, but it introduces concepts and functions at a rapid pace, and deals with advanced features of the software. The author takes the approach that users will learn best by doing. Each topic includes exercises to complete which illustrate the theory and help to reinforce the learning.

Key Features:

• Progress through the course topic by topic
• Clear learning objectives
• Clear learning objectives

Contents:

• Workbook basics
• Printing, formatting and copying your worksheet
• Excel charts
• Further chart operations
• Excel databases
• Using linked workbooks
• Data tables
• Analysis tools - goal seek and solver
• Excel functions
• Workbook protection and auditing
• Macros
• Creating a custom application
• Excel on the web

Author:

Jim Muir, Bournemouth University