Synopses & Reviews
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, 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 email@example.com.
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!
For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
About the Author
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.
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.
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