How to Use

*nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; Office: Organize information and add impact with clip art, SmartArt diagrams, tables, and charts with a new results-oriented interface

*nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; Word: Create great-looking documents faster using themes, styles, and templates

*nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; Excel: Use organizing, processing, and presenting tools to create data in Excel

*nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; PowerPoint: Create powerful presentations faster using ready-made design templates and themes

*nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; Outlook: Use tools for creating and managing your e-mail, calendar, contacts, and tasks

*nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; Publisher: Use task panes to quickly create a brochure or a newsletter without being a designer

*nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; SharePoint: Collaborate and share documents and information

*nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; Prepare for the Microsoft Certified Application Specialist exam

*nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; Practice your new skills with the useful workshops inside

nbsp;

On the Web

This book uses real-world examples to give you a context in which to use a task. This book also includesnbsp; 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

nbsp;

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.

nbsp;

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, visitwww.microsoft.com.

nbsp;

Chapter 1nbsp;nbsp;nbsp; Getting Started with Officenbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 1

Chapter 2nbsp;nbsp;nbsp; Using Shared Office Tools 33

Chapter 3nbsp;nbsp;nbsp; Adding Art to Office Documents 57

Chapter 4nbsp;nbsp;nbsp; Adding Shapes to Office Documentsnbsp;nbsp;nbsp; 93

Chapter 5nbsp;nbsp;nbsp; Formatting Office Documentsnbsp;nbsp;nbsp; 115

Chapter 6nbsp;nbsp;nbsp; Creating a Document with Wordnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 131

Chapter 7nbsp;nbsp;nbsp; Formatting a Document with Wordnbsp;nbsp;nbsp;nbsp;nbsp; 153

Chapter 8nbsp;nbsp;nbsp; Enhancing a Document with Wordnbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 173

Chapter 9nbsp;nbsp;nbsp; Creating a Worksheet with Excel nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 211

Chapter 10nbsp; Building a Worksheet with Excel 239

Chapter 11nbsp; Designing a Worksheet with Excelnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 281

Chapter 12nbsp; Creating a Presentation with PowerPointnbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 305

Chapter 13nbsp; Delivering a Presentation with PowerPointnbsp;nbsp;nbsp;nbsp;nbsp; 343

Chapter 14nbsp; Creating a Database with Accessnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 375

Chapter 15nbsp; Locating and Managing Data with Accessnbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 405

Chapter 16nbsp; Presenting Data with Accessnbsp;nbsp;nbsp;nbsp;nbsp; 423

Chapter 17nbsp; Communication with Outlooknbsp;nbsp;nbsp;nbsp; 447

Chapter 18nbsp; Managing Information with Outlooknbsp;nbsp;nbsp;nbsp; 489

Chapter 19nbsp; Creating a Publication with Publishernbsp;nbsp;nbsp;nbsp; 519

Chapter 20nbsp; Designing a Publication with Publishernbsp;nbsp; 537

Chapter 21nbsp; Publishing Office Documents on the Webnbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 557

Chapter 22nbsp; Protecting and Securing Office Documentsnbsp;nbsp;nbsp;nbsp; 575

Chapter 23nbsp; Reviewing and Sharing Office Documentsnbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 605

Chapter 24nbsp; Expanding Office Functionalitynbsp;nbsp;nbsp; 647

New Featuresnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 673

Microsoft Certified Applications Specialistnbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 683