Book description
Get in-depth, all-in-one exam prep for the Microsoft Office Specialist (MOS) exams for the Microsoft Office 2003 Editions track, including Microsoft Office Word, Excel, Access, PowerPoint®, and Outlook®.
Table of contents
- Microsoft® Office Specialist Study Guide—Office 2003 Edition
- A Note Regarding Supplemental Files
- Introduction
-
I. Microsoft Office Specialist Word 2003 Core Exam
-
W03C-1. Creating Content
-
W03C-1-1. Insert and Edit Text, Symbols, and Special Characters
- Inserting Visible and Hidden Text
- Practice Exercise
- Inserting Symbols and Special Characters
- Practice Exercise
- Editing and Deleting Text
- Practice Exercise
- Moving and Copying Text
- Practice Exercise
- Checking Spelling and Grammar
- Practice Exercise
- Using the Thesaurus to Find the Best Word
- Practice Exercise
- W03C-1-2. Insert Frequently Used and Predefined Text
- W03C-1-3. Navigate to Specific Content
- W03C-1-4. Insert, Position, and Size Graphics
- W03C-1-5. Create and Modify Diagrams and Charts
- W03C-1-6. Locate, Select, and Insert Supporting Information
- W03C-1. Review
-
W03C-1-1. Insert and Edit Text, Symbols, and Special Characters
- W03C-2. Organizing Content
- W03C-3. Formatting Content
- W03C-4. Collaborating
-
W03C-5. Formatting and Managing Documents
- W03C-5-1. Create New Documents Using Templates
- W03C-5-2. Review and Modify Document Properties
- W03C-5-3. Organize Documents Using File Folders
- W03C-5-4. Save Documents in Appropriate Formats for Different Uses
- W03C-5-5. Print Documents, Envelopes, and Labels
- W03C-5-6. Preview Documents and Web Pages
- W03C-5-7. Change and Organize Document Views and Windows
- W03C-5. Review
-
W03C-1. Creating Content
-
II. Microsoft Office Specialist Word 2003 Expert Exam
- W03E-1. Formatting Content
-
W03E-2. Organizing Content
- W03E-2-1. Sort Content in Lists and Tables
- W03E-2-2. Perform Calculations in Tables
- W03E-2-3. Modify Table Formats
- W03E-2-4. Summarize Document Content Using Automated Tools
- W03E-2-5. Use Automated Tools for Document Navigation
- W03E-2-6. Merge Letters with Other Data Sources
- W03E-2-7. Merge Labels with Other Data Sources
- W03E-2-8. Structure Documents Using XML
- W03E-2. Review
- W03E-3. Formatting Documents
- W03E-4. Collaborating
- W03E-5. Customizing Word
-
III. Microsoft Office Specialist Excel 2003 Core Exam
- E03C-1. Creating Data and Content
- E03C-2. Analyzing Data
- E03C-3. Formatting Data and Content
- E03C-4. Collaborating
-
E03C-5. Managing Workbooks
- E03C-5-1. Create New Workbooks from Templates
- E03C-5-2. Insert, Delete, and Move Cells
- E03C-5-3. Create and Modify Hyperlinks
- E03C-5-4. Organize Worksheets
- E03C-5-5. Preview Data in Other Views
- E03C-5-6. Customize Window Layout
- E03C-5-7. Set Up Pages for Printing
- E03C-5-8. Print Data
- E03C-5-9. Organize Workbooks Using File Folders
- E03C-5-10. Save Data in Appropriate Formats for Different Uses
- E03C-5. Review
-
IV. Microsoft Office Specialist Excel 2003 Expert Exam
-
E03E-1. Organizing and Analyzing Data
- E03E-1-1. Use Subtotals
- E03E-1-2. Define and Apply Advanced Filters
- E03E-1-3. Group and Outline Data
- E03E-1-4. Use Data Validation
- E03E-1-5. Create and Modify List Ranges
- E03E-1-6. Add, Show, Close, Edit, Merge, and Summarize Scenarios
- E03E-1-7. Perform Data Analysis Using Automated Tools
- E03E-1-8. Create Pivot Table and PivotChart Reports
- E03E-1-9. Use Lookup and Reference Functions
- E03E-1-10. Use Database Functions
- E03E-1-11. Trace Formula Precedents, Dependents, and Errors
- E03E-1-12. Locate Invalid Data and Formulas
- E03E-1-13. Watch and Evaluate Formulas
- E03E-1-14. Define, Modify, and Use Named Ranges
- Using a Name in a Formula
- E03E-1-15. Structure Workbooks Using XML
- E03E-1. Review
- E03E-2. Formatting Data and Content
- E03E-3. Collaborating
- E03E-4. Managing Data and Workbooks
- E03E-5. Customizing Excel
-
E03E-1. Organizing and Analyzing Data
-
V. Microsoft Office Specialist 2003 Exam
- P03C-1. Creating Content
- P03C-2. Formatting Content
- P03C-3. Collaborating
-
P03C-4. Managing and Delivering Presentations
- P03C-4-1. Organize a Presentation
- P03C-4-2. Set Up Slide Shows for Delivery
- P03C-4-3. Rehearse Timing
- P03C-4-4. Deliver Presentations
- P03C-4-5. Prepare Presentations for Remote Delivery
- P03C-4-6. Save and Publish Presentations
- P03C-4-7. Print Slides, Outlines, Handouts, and Speaker Notes
- P03C-4-8. Export a Presentation to Another Microsoft Office Program
- P03C-4. Review
-
VI. Microsoft Office Specialist Access 2003 Exam
-
A03C-1. Structuring Databases
- A03C-1-1. Create Access Databases
- A03C-1-2. Create and Modify Tables
- A03C-1-3. Define and Create Field Types
- A03C-1-4. Modify Field Properties
- A03C-1-5. Create and Modify One-to-Many Relationships
- A03C-1-6. Enforce Referential Integrity
-
A03C-1-7. Create and Modify Queries
- Creating a Query by Using the Simple Query Wizard
- Practice Exercise
- Modifying a Query in Design View
- Practice Exercise
- Creating a Crosstab Query
- Practice Exercise
- Finding Duplicate Records
- Practice Exercise
- Finding Unmatched Records
- Practice Exercise
- Updating Information with an Action Query
- Practice Exercise
- A03C-1-8. Create Forms
- A03C-1-9. Add and Modify Form Controls and Properties
- A03C-1-10. Create Reports
- A03C-1-11. Add and Modify Report Control Properties
- A03C-1-12. Create a Data Access Page
- A03C-1. Review
- A03C-2. Entering Data
- A03C-3. Organizing Data
- A03C-4. Managing Databases
-
A03C-1. Structuring Databases
-
VII. Microsoft Office Specialist Outlook 2003 Exam
-
O03C-1. Messaging
- O03C-1-1. Originate and Respond to E-Mail and Instant Messages
- O03C-1-2. Attach Files to Items
- O03C-1-3. Create and Modify a Personal Signature for Messages
- O03C-1-4. Modify E-Mail Message Settings and Delivery Options
- O03C-1-5. Create and Edit Contacts
- O03C-1-6. Accept, Decline, and Delegate Tasks
- O03C-1. Review
- O03C-2. Scheduling
-
O03C-3. Organizing
- O03C-3-1. Create and Modify Distribution Lists
- O03C-3-2. Link Contacts to Other Items
- O03C-3-3. Create and Modify Notes
-
O03C-3-4. Organize Items
- Adding and Deleting Fields from Folder Views
- Practice Exercise
- Sorting Outlook Items
- Practice Exercise
- Filtering E-Mail Messages
- Practice Exercise
- Organizing Outlook Items by Using Colors
- Practice Exercise
- Organizing E-Mail Messages by Using Rules
- Practice Exercise
- Organizing Outlook Items by Using Views
- Practice Exercise
- O03C-3-5. Organize Items Using Folders
- O03C-3-6. Search for Items
- O03C-3-7. Save Items in Different File Formats
- O03C-3-8. Assign Items to Categories
- O03C-3-9. Preview and Print Items
- O03C-3. Review
-
O03C-1. Messaging
- About the Authors
- Index
- About the Authors
- Copyright
Product information
- Title: Microsoft® Office Specialist Study Guide Office 2003 Edition
- Author(s):
- Release date: July 2004
- Publisher(s): Microsoft Press
- ISBN: 9780735621107
You might also like
book
Microsoft ® Office 2007 Business Intelligence
Extract and analyze mission-critical enterprise data using Microsoft Office 2007 This authoritative volume is a practical …
book
Microsoft® Office 2013 QuickSteps, 3rd Edition
Full-color, step-by-step guide to the new release of the world’s most popular productivity suite of applications …
book
Office 2013 In Depth
Both an unparalleled reference and an exceptionally practical deskside resource, Office 2013 In Depth is the …
book
Office 2007: The Missing Manual
Quickly learn the most useful features of Microsoft Office 2007 with our easy to read four-in-one …