Share
Create bookmark
Microsoft® Office Specialist Study Guide Office 2003 Edition
Notes
Please login to add notes
- + Cover
- Contents
-
+
Introduction
-
+
Part I Microsoft Office Specialist Word 2003 Core Exam
- Knowledge You Need Before Studying for This Exam
- + W03C-1 Creating Content
-
+
W03C-2 Organizing Content
-
+
W03C-3 Formatting Content
-
+
W03C-4 Collaborating
-
+
W03C-5 Formatting and Managing Documents
- + Create New Documents Using Templates
- + Review and Modify Document Properties
- + Organize Documents Using File Folders
- + Save Documents in Appropriate Formats for Different Uses
- + Print Documents, Envelopes, and Labels
- + Preview Documents and Web Pages
- + Change and Organize Document Views and Windows
- W03C-5 Review
-
+
Part II Microsoft Office Specialist Word 2003 Expert Exam
- Knowledge You Need Before Studying for This Exam
- + W03E-1 Formatting Content
-
+
W03E-2 Organizing Content
- + Sort Content in Lists and Tables
- + Perform Calculations in Tables
- + Modify Table Formats
- + Summarize Document Content Using Automated Tools
- + Use Automated Tools for Document Navigation
- + Merge Letters with Other Data Sources
- + Merge Labels with Other Data Sources
- + Structure Documents Using XML
- W03E-2 Review
- + W03E-3 Formatting Documents
-
+
W03E-4 Collaborating
-
+
W03E-5 Customizing Word
-
+
Part III Microsoft Office Specialist Excel 2003 Core Exam
- + Knowledge You Need Before Studying for This Exam
-
+
E03C-1 Creating Data and Content
-
+
E03C-2 Analyzing Data
-
+
E03C-3 Formatting Data and Content
- + E03C-4 Collaborating
-
+
E03C-5 Managing Workbooks
- + Create New Workbooks from Templates
- + Insert, Delete, and Move Cells
- + Create and Modify Hyperlinks
- + Organize Worksheets
- + Preview Data in Other Views
- + Customize Window Layout
- + Set Up Pages for Printing
- + Print Data
- + Organize Workbooks Using File Folders
- + Save Data in Appropriate Formats for Different Uses
- E03C-5 Review
-
+
Part IV Microsoft Office Specialist Excel 2003 Expert Exam
- Knowledge You Need Before Studying for This Exam
-
+
E03E-1 Organizing and Analyzing Data
- + Use Subtotals
- + Define and Apply Advanced Filters
- + Group and Outline Data
- + Use Data Validation
- + Create and Modify List Ranges
- + Add, Show, Close, Edit, Merge, and Summarize Scenarios
- + Perform Data Analysis Using Automated Tools
- + Create PivotTable and PivotChart Reports
- + Use Lookup and Reference Functions
- + Use Database Functions
- + Trace Formula Precedents, Dependents, and Errors
- + Locate Invalid Data and Formulas
- + Watch and Evaluate Formulas
- + Define, Modify, and Use Named Ranges
- Using a Name in a Formula
- + 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
-
+
Part V Microsoft Office Specialist PowerPoint 2003 Exam
- + Knowledge You Need Before Studying for This Exam
-
+
P03C-1 Creating Content
-
+
P03C-2 Formatting Content
-
+
P03C-3 Collaborating
-
+
P03C-4 Managing and Delivering Presentations
- + Organize a Presentation
- + Set Up Slide Shows for Delivery
- + Rehearse Timing
- + Deliver Presentations
- + Prepare Presentations for Remote Delivery
- + Save and Publish Presentations
- + Print Slides, Outlines, Handouts, and Speaker Notes
- + Export a Presentation to Another Microsoft Office Program
- P03C-4 Review
-
+
Part VI Microsoft Office Specialist Access 2003 Exam
- Knowledge You Need Before Studying for This Exam
-
+
A03C-1 Structuring Databases
- + Create Access Databases
- + Create and Modify Tables
- + Define and Create Field Types
- + Modify Field Properties
- + Create and Modify One-to-Many Relationships
- + Enforce Referential Integrity
- + Create and Modify Queries
- + Create Forms
- + Add and Modify Form Controls and Properties
- + Create Reports
- + Add and Modify Report Control Properties
- + Create a Data Access Page
- A03C-1 Review
-
+
A03C-2 Entering Data
-
+
A03C-3 Organizing Data
-
+
A03C-4 Managing Databases
-
+
Part VII Microsoft Office Specialist Outlook 2003 Exam
- + About the Authors
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.
Test the closed alpha on paperc.com
Book Details
Authors
Joyce Cox Joyce Cox, Joan Lambert Joan Lambert, and Online Inc. Online Inc.
Categories
Publishers
Publication year : 2009
License: All rights reserved ©
Times read: 13
