Easy to follow step by step lessons enable students to quickly and efficiently learn the features of Microsoft Excel 2003 and how to use them at school, at home, and in the workplace. This Microsoft Official Academic Course offers friendly, straightforward instruction with a focus on real-world business scenarios. Included with the book is a 180-day trial version of Microsoft Office Professional 2003 and dynamic interactive tutorials from the Microsoft eLearning Library. Skills covered in the book correspond to the objectives tested on the Microsoft Office Specialist Excel 2003 Core examination. A complete instructor support program is available with the text.

Table of Contents

Course Overview.

Conventions And Features Used in this Book.

Using the CD-ROMs.

MOS Objectives.

Taking a Microsoft Office Specialist Certification Test.

Microsoft e-Learning Library.

Lesson 1 Working with Workbooks.

Lesson 2 Working with Data and Named Ranges.

Lesson 3 Creating and Using Excel Lists.

Lesson 4 Displaying and Formatting Data.

Lesson 5 Auditing a Workbook.

Lesson 6 Using Data Analysis Tools and Features.

Lesson 7 Sharing Workbooks.

Lesson 8 Publishing Information on the Web.

Lesson 9 Creating, Customizing, and Using Templates.

Lesson 10 Using Macros.

Lesson 11 Customizing the Excel Environment.

Glossary.

Index.