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