Microsoft Office Specialist Study Guide: Office 2003 Edition

Overview

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 ...
See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (74) from $1.99   
  • New (8) from $6.25   
  • Used (66) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$6.25
Seller since 2010

Feedback rating:

(2265)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
New We ship daily Monday-Friday!

Ships from: Powder Springs, GA

Usually ships in 1-2 business days

  • Canadian
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$6.83
Seller since 2010

Feedback rating:

(972)

Condition: New
PAPERBACK New 0735621101 Friendly Return Policy. A+++ Customer Service!

Ships from: Philadelphia, PA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$6.83
Seller since 2010

Feedback rating:

(726)

Condition: New
PAPERBACK New 0735621101! ! ! ! BEST PRICES WITH A SERVICE YOU CAN RELY! ! !

Ships from: Philadelphia, PA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$6.83
Seller since 2014

Feedback rating:

(445)

Condition: New
PAPERBACK New 0735621101! ! KNOWLEDGE IS POWER! ! ENJOY OUR BEST PRICES! ! ! Ships Fast. All standard orders delivered within 5 to 12 business days.

Ships from: Southampton, PA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$6.83
Seller since 2011

Feedback rating:

(782)

Condition: New
PAPERBACK New 0735621101 SERVING OUR CUSTOMERS WITH BEST PRICES. FROM A COMPANY YOU TRUST, HUGE SELECTION. RELIABLE CUSTOMER SERVICE! ! HASSLE FREE RETURN POLICY, SATISFACTION ... GURANTEED**** Read more Show Less

Ships from: Philadelphia, PA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$6.97
Seller since 2014

Feedback rating:

(297)

Condition: New
PAPERBACK New 0735621101 XCITING PRICES JUST FOR YOU. Ships within 24 hours. Best customer service. 100% money back return policy.

Ships from: Bensalem, PA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$6.97
Seller since 2009

Feedback rating:

(2463)

Condition: New
2004-07-26 Paperback 2003 ed. New 0735621101 Ships Within 24 Hours. Tracking Number available for all USA orders. Excellent Customer Service. Upto 15 Days 100% Money Back ... Gurantee. Try Our Fast! ! ! ! Shipping With Tracking Number. Read more Show Less

Ships from: Bensalem, PA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$50.00
Seller since 2014

Feedback rating:

(181)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

Overview

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.

Read More Show Less

Product Details

  • ISBN-13: 9780735621107
  • Publisher: Microsoft Press
  • Publication date: 6/23/2004
  • Series: Epg-Other Series
  • Edition description: 2003 ed.
  • Pages: 760
  • Product dimensions: 7.34 (w) x 9.20 (h) x 2.08 (d)

Meet the Author

Joan Lambert is the author or coauthor of more than a dozen books about Windows® and Microsoft Office, including the popular
Microsoft Windows XP Step by Step and 2007 Microsoft Office
System Step by Step. Having learned about computers literally at her father's knee, Joan's wide-ranging experiences in various facets of the computer industry contribute to her enthusiasm for producing interesting, useful, and understandable training materials. Joan is the President of Online Training Solutions, Inc. (OTSI) and an avid telecommuter. The power of the Internet and an obsession with technology have made it possible for Joan to live and work in New
Zealand, Sweden, Denmark, and various locations in the US during the past 15 years. Having finally discovered the delights of a daily dose of sunshine, Joan has settled in San Diego.

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

Read More Show Less

Table of Contents

Introduction;
About Microsoft Office Specialist Certification;
About This Book;
About the Book’s 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);

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 2 Customer Reviews
  • Anonymous

    Posted March 2, 2006

    Not what I expected

    This book was a a huge disappointment. It is hard to follow and does not provide clear explanations. I'm currently looking for a book by another publisher that will cover the same subject matter.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted November 7, 2009

    No text was provided for this review.

Sort by: Showing all of 2 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)