Synopses & Reviews
Demonstrate your expertise with the 2007 Microsoft Office system! This comprehensive study guide covers all the Microsoft Certified Application Specialist exams for Microsoft Office, including Word 2007, Excel 2007, Outlook 2007, PowerPoint 2007, and Access 2007. For each exam, youll 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 firstname.lastname@example.org.
This study guide has been designed to prepare users and programmers to complete Microsoft's Certified Application Specialist program by providing step-by-step coverage of all of the exams pertaining to the Office 2007 platform. Cox and Preppernau (Online Training Solutions, Inc.) include all the information, practice and review needed to complete five MCAS exams (Office Word, Excel, PowerPoint, Outlook and Access). A CD-ROM has been included that contains additional practice files for the exams, access to a fully searchable eBook and further resources.
Demonstrate your expertise with the 2007 Microsoft Office system! This comprehensive study guide covers all the Microsoft Certified Application Specialist 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!
For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
Demonstrate your expertise with Microsoft Office 2010! This all-in-one guide is designed to help you practice and prepare for the four core Microsoft Office Specialist (MOS) exams.
With the MOS 2010 Study Guide, you get full, objective-by-objective coverage for:
- Exam 77-881: Microsoft Word 2010
- Exam 77-882: Microsoft Excel 2010
- Exam 77-883: Microsoft PowerPoint 2010
- Exam 77-884: Microsoft Outlook 2010
Use the books easy-to-follow procedures and illustrations to review the essential skills measured by the MOS exams. And you can apply what youve learned hands-onusing the downloadable files for all the books practice tasks.
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