Synopses & Reviews
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
For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
Synopsis
Helping readers prepare for one or more of the Microsoft Office Specialist exams for the Microsoft Office 2003 Editions track, this guide covers all objectives and sub objectives for the Microsoft Official Specialist exams for Microsoft Office Word 2003, Word 2003 Expert, Excel 2003, Excel 2003 Expert, PowerPoint 2003, Access 2003, and Outlook 2003. The CD includes practice files and practice exams.
Synopsis
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, youll gain the skills and knowledge you need to help you ace the exam!
Includes one free practice test from MeasureUp!
- Take an online skills testlooks 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
About the Author
Joan Lambert has worked in the training and certification industry since 1997. As president of Online Training Solutions, Inc. (OTSI), Joan is responsible for guiding the translation of technical information and requirements into useful, relevant, and measurable training, learning, and certification deliverables. An MCTS, MOM, MCAS, and MCT, Joan is the author or coauthor of more than two dozen books about Windows and Microsoft Office (for Windows and for Mac).
Joyce Cox has more than 30 years' experience in the development of training materials about technical subjects for non-technical audiences and is the author of dozens of books about Office and Windows technologies. Joyce is vice president of Online Training Solutions, Inc. (OTSI). Previously, she was president of and principal author for Online Press, where she developed the Quick Course series of computer training books for beginning and intermediate adult learners. She was also the first managing editor of Microsoft Press, an editor for Sybex, and an editor for the University of California.
Table of Contents
Introduction; About Microsoft Office Specialist Certification; About This Book; About the Books CD-ROM; How to Get Help; Part I: Microsoft Office Specialist Word 2003 Core Exam; Chapter W03C-1: Creating Content; W03C-1-1 Insert and Edit Text, Symbols, and Special Characters; 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; Chapter W03C-2: Organizing Content; W03C-2-1 Insert and Modify Tables; W03C-2-2 Create Bulleted Lists, Numbered Lists, and Outlines; W03C-2-3 Insert and Modify Hyperlinks; W03C-2 Review; Chapter W03C-3: Formatting Content; W03C-3-1 Format Text; W03C-3-2 Format Paragraphs; W03C-3-3 Apply and Format Columns; W03C-3-4 Insert and Modify Content in Headers and Footers; W03C-3-5 Modify Document Layout and Page Setup; W03C-3 Review; Chapter W03C-4: Collaborating; W03C-4-1 Circulate Documents for Review; W03C-4-2 Compare and Merge Document Versions; W03C-4-3 Insert, View, and Edit Comments; W03C-4-4 Track, Accept, and Reject Proposed Changes; W03C-4 Review; Chapter 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; Part II: Microsoft Office Specialist Word 2003 Expert Exam; Chapter W03E-1: Formatting Content; W03E-1-1 Create Custom Styles for Text, Tables, and Lists; W03E-1-2 Control Pagination; W03E-1-3 Format, Position, and Resize Graphics Using Advanced Layout Features; W03E-1-4 Insert and Modify Objects; W03E-1-5 Create and Modify Diagrams and Charts Using Data from Other Sources; W03E-1 Review; Chapter 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; Chapter W03E-3: Formatting Documents; W03E-3-1 Create and Modify Forms; W03E-3-2 Create and Modify Document Background; W03E-3-3 Create and Modify Document Indexes and Tables; W03E-3-4 Insert and Modify Endnotes, Footnotes, Captions, and Cross-references; W03E-3-5 Create and Manage Master Documents and Subdocuments; W03E-3 Review; Chapter W03E-4: Collaborating; W03E-4-1 Modify Track Changes Options; W03E-4-2 Publish and Edit Web Documents in Word; W03E-4-3 Manage Document Versions; W03E-4-4 Protect and Restrict Forms and Documents; W03E-4-5 Attach Digital Signatures to Documents; W03E-4-6 Customize Document Properties; W03E-4 Review; Chapter W03E-5: Customizing Word; W03E-5-1 Create, Edit, and Run Macros; W03E-5-2 Customize Menus and Toolbars; W03E-5-3 Modify Word Default Settings; W03E-5 Review; Part III: Microsoft Office Specialist Excel 2003 Core Exam; Chapter E03C-1: Creating Data and Content; E03C-1-1 Enter and Edit Cell Content; E03C-1-2 Navigate to Specific Cell Content; E03C-1-3 Locate, Select, and Insert Supporting Information; E03C-1-4 Insert, Position, and Size Graphics; E03C-1 Review; Chapter E03C-2: Analyzing Data; E03C-2-1 Filter Lists Using AutoFilter; E03C-2-2 Sort Lists; E03C-2-3 Insert and Modify Formulas; E03C-2-4 Use Statistical, Date and Time, Financial, and Logical Functions; E03C-2-5 Create, Modify, and Position Diagrams and Charts Based on Worksheet Data; E03C-2 Review; Chapter E03C-3: Formatting Data and Content; E03C-3-1 Apply and Modify Cell Formats; E03C-3-2 Apply and Modify Cell Styles; E03C-3-3 Modify Row and Column Formats; E03C-3-4 Format Worksheets; E03C-3 Review; Chapter E03C-4: Collaborating; E03C-4-1 Insert, View, and Edit Comments; E03C-4 Review; Chapter 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; Part IV: Microsoft Office Specialist Excel 2003 Expert Exam; Chapter 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; Chapter E03E-2: Formatting Data and Content; E03E-2-1 Create and Modify Custom Data Formats; E03E-2-2 Use Conditional Formatting; E03E-2-3 Format and Resize Graphics; E03E-2-4 Format Charts and Diagrams; E03E-2 Review; Chapter E03E-3: Collaborating; E03E-3-1 Protect Cells, Worksheets, and Workbooks; E03E-3-2 Apply Workbook Security Settings; E03E-3-3 Share Workbooks; E03E-3-4 Merge Workbooks; E03E-3-5 Track, Accept, and Reject Changes to Workbooks; E03E-3 Review; Chapter E03E-4: Managing Data and Workbooks; E03E-4-1 Import Data to Excel; E03E-4-2 Export Data from Excel; E03E-4-3 Publish and Edit Web Worksheets and Workbooks; E03E-4-4 Create and Edit Templates; E03E-4-5 Consolidate Data; E03E-4-6 Define and Modify Workbook Properties; E03E-4 Review; Chapter E03E-5: Customizing Excel; E03E-5-1 Customize Toolbars and Menus; E03E-5-2 Create, Edit, and Run Macros; Editing a Macro; E03E-5-3 Modify Excel Default Settings; E03E-5 Review; Part V: Microsoft Office Specialist 2003 Exam; Chapter P03C-1: Creating Content; P03C-1-1 Create New Presentations from Templates; P03C-1-2 Insert and Edit Text-Based Content; P03C-1-3 Insert Tables, Charts, and Diagrams; P03C-1-4 Insert Pictures, Shapes, and Graphics; P03C-1-5 Insert Objects; P03C-1 Review; Chapter P03C-2: Formatting Content; P03C-2-1 Format Text-based Content; P03C-2-2 Format Pictures, Shapes, and Graphics; P03C-2-3 Format Slides; P03C-2-4 Apply Animation Schemes; P03C-2-5 Apply Slide Transitions; P03C-2-6 Customize Slide Templates; P03C-2-7 Work with Masters; P03C-2 Review; Chapter P03C-3: Collaborating; P03C-3-1 Track, Accept, and Reject Changes in a Presentation; P03C-3-2 Add, Edit, and Delete Comments in a Presentation; P03C-3-3 Compare and Merge Presentations; P03C-3 Review; Chapter 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; Part VI: Microsoft Office Specialist Access 2003 Exam; Chapter 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; 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; Chapter A03C-2: Entering Data; A03C-2-1 Enter, Edit, and Delete Records; A03C-2-2 Find and Move Among Records; A03C-2-3 Import Data to Access; A03C-2 Review; Chapter A03C-3: Organizing Data; A03C-3-1 Create and Modify Calculated Fields and Aggregate Functions; A03C-3-2 Modify Form Layout; A03C-3-3 Modify Report Layout and Page Setup; A03C-3-4 Format Datasheets; A03C-3-5 Sort Records; A03C-3-6 Filter Records; A03C-3 Review; Chapter A03C-4: Managing Databases; A03C-4-1 Identify and Modify Object Dependencies; A03C-4-2 View Objects and Object Data in Other Views; A03C-4-3 Print Database Objects and Data; A03C-4-4 Export Data from Access; A03C-4-5 Back Up a Database; A03C-4-6 Compact and Repair Databases; A03C-4 Review; Part VII: Microsoft Office Specialist Outlook 2003 Exam; Chapter 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; Chapter O03C-2: Scheduling; O03C-2-1 Create and Modify Appointments, Meetings, and Events; O03C-2-2 Update, Cancel, and Respond to Meeting Requests; O03C-2-3 Customize Calendar Settings; O03C-2-4 Create, Modify, and Assign Tasks; O03C-2 Review; Chapter 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; 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; Appendix : About the Authors; Online Training Solutions, Inc. (OTSI);