Microsoft® Office Specialist Study Guide Office 2003 Edition

Larger Cover

By Joan Lambert, Joyce Cox

Publisher: Microsoft Press

Released: July 2004

Pages: 760

Demonstrate your expertise with Microsoft Office! Designed to help you practice and prepare for Microsoft Office Specialist certification, this easy-to-use study guide features:

Step-by-step exercises for building and strengthening your skills
Practice files on CD
End-of-chapter objective reviews
MeasureUp practice test to assess your exam readiness

With in-depth preparation for all the exam objectives on the Microsoft Office 2003 Editions track, including both core- and expert-level certifications, you’ll gain the skills and knowledge you need to help you ace the exam!

Includes one free practice test from MeasureUp!

Take an online skills test—looks and scores like the certification exam
Test yourself within the real application
Get feedback on correct and incorrect answers
Identify where you need to focus your study time

Covers all the exam objectives for:

Microsoft Office Word 2003 Core
Microsoft Office Word 2003 Expert
Microsoft Office Excel 2003 Core
Microsoft Office Excel 2003 Expert
Microsoft Office PowerPoint 2003
Microsoft Office Access 2003
Microsoft Office Outlook 2003

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.

Microsoft Office Specialist Word 2003 Core Exam
1. Chapter W03C-1 Creating Content
  1. Insert and Edit Text, Symbols, and Special Characters
  2. Insert Frequently Used and Predefined Text
  3. Navigate to Specific Content
  4. Insert, Position, and Size Graphics
  5. Create and Modify Diagrams and Charts
  6. Locate, Select, and Insert Supporting Information
  7. Review
2. Chapter W03C-2 Organizing Content
  1. Insert and Modify Tables
  2. Create Bulleted Lists, Numbered Lists, and Outlines
  3. Insert and Modify Hyperlinks
  4. Review
3. Chapter W03C-3 Formatting Content
  1. Format Text
  2. Format Paragraphs
  3. Apply and Format Columns
  4. Insert and Modify Content in Headers and Footers
  5. Modify Document Layout and Page Setup
  6. Review
4. Chapter W03C-4 Collaborating
  1. Circulate Documents for Review
  2. Compare and Merge Document Versions
  3. Insert, View, and Edit Comments
  4. Track, Accept, and Reject Proposed Changes
  5. Review
5. Chapter W03C-5 Formatting and Managing Documents
  1. Create New Documents Using Templates
  2. Review and Modify Document Properties
  3. Organize Documents Using File Folders
  4. Save Documents in Appropriate Formats for Different Uses
  5. Print Documents, Envelopes, and Labels
  6. Preview Documents and Web Pages
  7. Change and Organize Document Views and Windows
  8. Review
Microsoft Office Specialist Word 2003 Expert Exam
1. Chapter W03E-1 Formatting Content
  1. Create Custom Styles for Text, Tables, and Lists
  2. Control Pagination
  3. Format, Position, and Resize Graphics Using Advanced Layout Features
  4. Insert and Modify Objects
  5. Create and Modify Diagrams and Charts Using Data from Other Sources
  6. Review
2. Chapter W03E-2 Organizing Content
  1. Sort Content in Lists and Tables
  2. Perform Calculations in Tables
  3. Modify Table Formats
  4. Summarize Document Content Using Automated Tools
  5. Use Automated Tools for Document Navigation
  6. Merge Letters with Other Data Sources
  7. Merge Labels with Other Data Sources
  8. Structure Documents Using XML
  9. Review
3. Chapter W03E-3 Formatting Documents
  1. Create and Modify Forms
  2. Create and Modify Document Background
  3. Create and Modify Document Indexes and Tables
  4. Insert and Modify Endnotes, Footnotes, Captions, and Cross-references
  5. Create and Manage Master Documents and Subdocuments
  6. Review
4. Chapter W03E-4 Collaborating
  1. Modify Track Changes Options
  2. Publish and Edit Web Documents in Word
  3. Manage Document Versions
  4. Protect and Restrict Forms and Documents
  5. Attach Digital Signatures to Documents
  6. Customize Document Properties
  7. Review
5. Chapter W03E-5 Customizing Word
  1. Create, Edit, and Run Macros
  2. Customize Menus and Toolbars
  3. Modify Word Default Settings
  4. Review
Microsoft Office Specialist Excel 2003 Core Exam
1. Chapter E03C-1 Creating Data and Content
  1. Enter and Edit Cell Content
  2. Navigate to Specific Cell Content
  3. Locate, Select, and Insert Supporting Information
  4. Insert, Position, and Size Graphics
  5. Review
2. Chapter E03C-2 Analyzing Data
  1. Filter Lists Using AutoFilter
  2. Sort Lists
  3. Insert and Modify Formulas
  4. Use Statistical, Date and Time, Financial, and Logical Functions
  5. Create, Modify, and Position Diagrams and Charts Based on Worksheet Data
  6. Review
3. Chapter E03C-3 Formatting Data and Content
  1. Apply and Modify Cell Formats
  2. Apply and Modify Cell Styles
  3. Modify Row and Column Formats
  4. Format Worksheets
  5. Review
4. Chapter E03C-4 Collaborating
  1. Insert, View, and Edit Comments
  2. Review
5. Chapter E03C-5 Managing Workbooks
  1. Create New Workbooks from Templates
  2. Insert, Delete, and Move Cells
  3. Create and Modify Hyperlinks
  4. Organize Worksheets
  5. Preview Data in Other Views
  6. Customize Window Layout
  7. Set Up Pages for Printing
  8. Print Data
  9. Organize Workbooks Using File Folders
  10. Save Data in Appropriate Formats for Different Uses
  11. Review
Microsoft Office Specialist Excel 2003 Expert Exam
1. Chapter E03E-1 Organizing and Analyzing Data
  1. Use Subtotals
  2. Define and Apply Advanced Filters
  3. Group and Outline Data
  4. Use Data Validation
  5. Create and Modify List Ranges
  6. Add, Show, Close, Edit, Merge, and Summarize Scenarios
  7. Perform Data Analysis Using Automated Tools
  8. Create Pivot Table and PivotChart Reports
  9. Use Lookup and Reference Functions
  10. Use Database Functions
  11. Trace Formula Precedents, Dependents, and Errors
  12. Locate Invalid Data and Formulas
  13. Watch and Evaluate Formulas
  14. Define, Modify, and Use Named Ranges
  15. Using a Name in a Formula
  16. Structure Workbooks Using XML
  17. Review
2. Chapter E03E-2 Formatting Data and Content
  1. Create and Modify Custom Data Formats
  2. Use Conditional Formatting
  3. Format and Resize Graphics
  4. Format Charts and Diagrams
  5. Review
3. Chapter E03E-3 Collaborating
  1. Protect Cells, Worksheets, and Workbooks
  2. Apply Workbook Security Settings
  3. Share Workbooks
  4. Merge Workbooks
  5. Track, Accept, and Reject Changes to Workbooks
  6. Review
4. Chapter E03E-4 Managing Data and Workbooks
  1. Import Data to Excel
  2. Export Data from Excel
  3. Publish and Edit Web Worksheets and Workbooks
  4. Create and Edit Templates
  5. Consolidate Data
  6. Define and Modify Workbook Properties
  7. Review
5. Chapter E03E-5 Customizing Excel
  1. Customize Toolbars and Menus
  2. Create, Edit, and Run Macros
  3. Editing a Macro
  4. Modify Excel Default Settings
  5. Review
Microsoft Office Specialist 2003 Exam
1. Chapter P03C-1 Creating Content
  1. Create New Presentations from Templates
  2. Insert and Edit Text-Based Content
  3. Insert Tables, Charts, and Diagrams
  4. Insert Pictures, Shapes, and Graphics
  5. Insert Objects
  6. Review
2. Chapter P03C-2 Formatting Content
  1. Format Text-based Content
  2. Format Pictures, Shapes, and Graphics
  3. Format Slides
  4. Apply Animation Schemes
  5. Apply Slide Transitions
  6. Customize Slide Templates
  7. Work with Masters
  8. Review
3. Chapter P03C-3 Collaborating
  1. Track, Accept, and Reject Changes in a Presentation
  2. Add, Edit, and Delete Comments in a Presentation
  3. Compare and Merge Presentations
  4. Review
4. Chapter P03C-4 Managing and Delivering Presentations
  1. Organize a Presentation
  2. Set Up Slide Shows for Delivery
  3. Rehearse Timing
  4. Deliver Presentations
  5. Prepare Presentations for Remote Delivery
  6. Save and Publish Presentations
  7. Print Slides, Outlines, Handouts, and Speaker Notes
  8. Export a Presentation to Another Microsoft Office Program
  9. Review
Microsoft Office Specialist Access 2003 Exam
1. Chapter A03C-1 Structuring Databases
  1. Create Access Databases
  2. Create and Modify Tables
  3. Define and Create Field Types
  4. Modify Field Properties
  5. Create and Modify One-to-Many Relationships
  6. Enforce Referential Integrity
  7. Create and Modify Queries
  8. Create Forms
  9. Add and Modify Form Controls and Properties
  10. Create Reports
  11. Add and Modify Report Control Properties
  12. Create a Data Access Page
  13. Review
2. Chapter A03C-2 Entering Data
  1. Enter, Edit, and Delete Records
  2. Find and Move Among Records
  3. Import Data to Access
  4. Review
3. Chapter A03C-3 Organizing Data
  1. Create and Modify Calculated Fields and Aggregate Functions
  2. Modify Form Layout
  3. Modify Report Layout and Page Setup
  4. Format Datasheets
  5. Sort Records
  6. Filter Records
  7. Review
4. Chapter A03C-4 Managing Databases
  1. Identify and Modify Object Dependencies
  2. View Objects and Object Data in Other Views
  3. Print Database Objects and Data
  4. Export Data from Access
  5. Back Up a Database
  6. Compact and Repair Databases
  7. Review
Microsoft Office Specialist Outlook 2003 Exam
1. Chapter O03C-1 Messaging
  1. Originate and Respond to E-Mail and Instant Messages
  2. Attach Files to Items
  3. Create and Modify a Personal Signature for Messages
  4. Modify E-Mail Message Settings and Delivery Options
  5. Create and Edit Contacts
  6. Accept, Decline, and Delegate Tasks
  7. Review
2. Chapter O03C-2 Scheduling
  1. Create and Modify Appointments, Meetings, and Events
  2. Update, Cancel, and Respond to Meeting Requests
  3. Customize Calendar Settings
  4. Create, Modify, and Assign Tasks
  5. Review
3. Chapter O03C-3 Organizing
  1. Create and Modify Distribution Lists
  2. Link Contacts to Other Items
  3. Create and Modify Notes
  4. Organize Items
  5. Organize Items Using Folders
  6. Search for Items
  7. Save Items in Different File Formats
  8. Assign Items to Categories
  9. Preview and Print Items
  10. Review

Appendix About the Authors
1. Online Training Solutions, Inc. (OTSI)

Title:

Microsoft® Office Specialist Study Guide Office 2003 Edition

By:

Joan Lambert, Joyce Cox

Publisher:

Microsoft Press

Formats:

Print
Ebook
Safari Books Online

Print:

July 2004

Ebook:

November 2009

Pages:

760

Print ISBN:

978-0-7356-2110-7

| ISBN 10:

0-7356-2110-1

Ebook ISBN:

978-0-7356-3010-9

| ISBN 10:

0-7356-3010-0

Joan Lambert

Joan Lambert is the author or coauthor of more than a dozen books about Windows® and Microsoft Office, including the popularMicrosoft Windows XP Step by Step and 2007 Microsoft OfficeSystem Step by Step. Having learned about computers literally at herfather's knee, Joan's wide-ranging experiences in various facets ofthe computer industry contribute to her enthusiasm for producinginteresting, useful, and understandable training materials. Joan isthe President of Online Training Solutions, Inc. (OTSI) and an avidtelecommuter. The power of the Internet and an obsession withtechnology have made it possible for Joan to live and work in NewZealand, Sweden, Denmark, and various locations in the US duringthe past 15 years. Having finally discovered the delights of a dailydose of sunshine, Joan has settled in San Diego.

View Joan Lambert's full profile page.
Joyce Cox

Joyce Cox has 25 years’ experience developing training materials on technical subjects for non-technical audiences, and has writtendozens of books about Microsoft Office and Windows technologies.

View Joyce Cox's full profile page.