The Microsoft Office Specialist Study Guide

by Joyce Cox, Joan Preppernau

Overview

Demonstrate your expertise with the 2007 Microsoft Office system! This comprehensive study guide covers all the Microsoft® Office Specialist Study Guide exams for Microsoft Office, including Word 2007, Excel® 2007, Outlook® 2007, PowerPoint® 2007, and Access® 2007. For each exam, you’ll build the skills and knowledge measured by its objectives through a series of step-by-step exercises, practice questions, and real-world scenarios. Easy-to-follow screen shots and explanations bring key concepts to life and expertly guide you through the material. The CD includes the practice files for all the book's lessons. Earn the premier credential and showcase your expertise in the popular Microsoft Office programs!

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 [e-mail].

Product Details

ISBN-13:	9780735649712
Publisher:	Microsoft Press
Publication date:	09/14/2010
Pages:	816
Product dimensions:	7.30(w) x 8.90(h) x 2.00(d)

About the Author

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.

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).

Table of Contents

Taking a Microsoft Certified Application Specialist ExamUsing This Book to Study for a Certification ExamWorking in the Microsoft Office Fluent User InterfaceUsing the Companion CDGetting HelpPart 77-601: Using Microsoft Office Word 2007Chapter 1: Creating and Customizing DocumentsChapter 2: Formatting ContentChapter 3: Working with Visual ContentChapter 4: Organizing ContentChapter 5: Reviewing DocumentsChapter 6: Sharing and Securing ContentPart 77-602: Using Microsoft Office Excel 2007Chapter 1: Creating and Manipulating DataChapter 2: Formatting Data and ContentChapter 3: Creating and Modifying FormulasChapter 4: Presenting Data VisuallyChapter 5: Collaborating and Securing DataPart 77-603: Using Microsoft Office PowerPoint 2007Chapter 1: Creating and Formatting PresentationsChapter 2: Creating and Formatting Slide ContentChapter 3: Working with Visual ContentChapter 4: Collaborating On and Delivering PresentationsPart 77-604: Using Microsoft Office Outlook 2007Chapter 1: Managing MessagesChapter 2: Managing SchedulingChapter 3: Managing TasksChapter 4: Managing Contacts and Personal Contact InformationChapter 5: Organizing InformationPart 77-605: Using Microsoft Office Access 2007Chapter 1: Structuring a DatabaseChapter 2: Creating and Formatting Database ElementsChapter 3: Entering and Modifying DataChapter 4: Creating and Modifying QueriesChapter 5: Presenting and Sharing DataChapter 6: Managing and Maintaining DatabasesAppendix : About the AuthorsAppendix : Choose the Right Book for You