How to Use •        Office: Organize information and add impact with clip art, SmartArt diagrams, tables, and charts with a new results-oriented interface •        Word: Create great-looking documents faster using themes, styles, and templates •        Excel: Use organizing, processing, and presenting tools to create data in Excel •        PowerPoint: Create powerful presentations faster using ready-made design templates and themes •        Outlook: Use tools for creating and managing your e-mail, calendar, contacts, and tasks •        Publisher: Use task panes to quickly create a brochure or a newsletter without being a designer •        SharePoint: Collaborate and share documents and information •        Prepare for the Microsoft Certified Application Specialist exam •        Practice your new skills with the useful workshops inside   On the Web This book uses real-world examples to give you a context in which to use a task. This book also includes  workshops to help you put together individual tasks into projects. The Office example files that you need for project tasks are available at www.perspection.com   Perspection has written and produced books on a variety of computer software—including Microsoft Office 2003 and XP, Microsoft Windows XP, Apple Mac OS X Panther, Adobe Photoshop CS2, Macromedia Flash 8, Macromedia Director MX, and Macromedia Fireworks—and Web publishing. In 1991, after working for Apple Computer and Microsoft, Steve Johnson founded Perspection, Inc. Perspection is committed to providing information and training to help people use software more effectively. Perspection has written more than 80 computer books, and sold more than 5 million copies.   Includes MCAS Exam Objectives! This courseware meets the objectives for the Microsoft Certified Application Specialist (MCAS). Upon completion of this courseware, you may be prepared to take the exam for MCAS qualification. To learn more about becoming a Microsoft Certified Application Specialist, visit www.microsoft.com.   Chapter 1    Getting Started with Office         1 Chapter 2    Using Shared Office Tools 33 Chapter 3    Adding Art to Office Documents 57 Chapter 4    Adding Shapes to Office Documents    93 Chapter 5    Formatting Office Documents    115 Chapter 6    Creating a Document with Word          131 Chapter 7    Formatting a Document with Word      153 Chapter 8    Enhancing a Document with Word       173 Chapter 9    Creating a Worksheet with Excel         211 Chapter 10  Building a Worksheet with Excel 239 Chapter 11  Designing a Worksheet with Excel        281 Chapter 12  Creating a Presentation with PowerPoint       305 Chapter 13  Delivering a Presentation with PowerPoint      343 Chapter 14  Creating a Database with Access         375 Chapter 15  Locating and Managing Data with Access       405 Chapter 16  Presenting Data with Access      423 Chapter 17  Communication with Outlook     447 Chapter 18  Managing Information with Outlook     489 Chapter 19  Creating a Publication with Publisher     519 Chapter 20  Designing a Publication with Publisher   537 Chapter 21  Publishing Office Documents on the Web       557 Chapter 22  Protecting and Securing Office Documents     575 Chapter 23  Reviewing and Sharing Office Documents       605 Chapter 24  Expanding Office Functionality    647 New Features        673 Microsoft Certified Applications Specialist       683

The Microsoft Official Academic Course program is the official instruction package for Microsoft Programs in higher education. These learning products are created specifically for the academic market and combine the software expertise, business world focus, and market research of Microsoft with 200 years of market leading higher education publishing from Wiley. The program is based upon the same curriculum as are Microsoft IT Certifications, building the skills students need to succeed at work and preparing them to validate those skills through professional certification, giving them their best chance to land the jobs they seek. All the support instructors need to deliver great courses on Microsoft software is in the program. Wiley Faculty Network seminars will bring you the latest information on new products and curriculums and are a part of the program. The Microsoft Official Academic Course program is a great way for instructors to get ready to teach.

Microsoft Office is the industry standard in business software. Learn how to make Office 2007 work for you! As part of the In Business System, Microsoft Office 2007 In Business Core is the only Office 2007 book that prepares students expressly for core business courses such as Accounting, Economics, Marketing, Finance, and Business Statistics by providing exposure to real business files that meet professional standards, useful references that can be used in later courses, an understanding of how to use the software as a tool to accomplish business goals, and coverage of the core Office skills needed in business. The second edition includes several new features that reinforce the primary mission of the series, which is to illustrate how Microsoft Office is used to accomplish both personal and professional business objectives.  Microsoft Office skills are essential for anyone working in a business environment. Whether you need Word skills for Marketing or Excel skills f