Excel 2000 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 modern software. It can be used as a course text for group learning, or individually for independent learning. The series covers the key Microsoft Office 2000 components of Access, Excel and Word, and for each of these applications there is an introductory and an advanced book. This advanced book does not assume any previous knowledge of Excel 2000, but it introduces concepts and functions at a rapid pace, and deals with advanced features of the software. The approach of the book is that the user will be able to learn by doing. Each topic includes exercises to complete which illustrate the theory and help to reinforce learning.

Key Features:

• Progress through the course topic by topic
• Clear learning objectives
• Tasks help to embed learning
• Theory illustrated with practical examples

Contents:

• Workbook basics
• Printing, formatting and copying your worksheet
• Excel charts
• Further chart operations
• Excel databases
• Using linked workbooks
• Input and lookup 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