By Steve Johnson
How to Use
• place of work: manage info and upload effect with clip artwork, SmartArt diagrams, tables, and charts with a brand new results-oriented interface
• observe: Create great-looking files speedier utilizing topics, types, and templates
• Excel: Use organizing, processing, and featuring instruments to create info in Excel
• PowerPoint: Create robust shows swifter utilizing ready-made layout templates and themes
• Outlook: Use instruments for growing and coping with your e mail, calendar, contacts, and tasks
• writer: Use activity panes to speedy create a brochure or a e-newsletter with no being a designer
• SharePoint: Collaborate and percentage files and information
• arrange for the Microsoft qualified software professional exam
• perform your new talents with the worthwhile workshops inside
On the Web
This publication makes use of real-world examples to provide you a context within which to take advantage of a role. This publication additionally contains workshops that will help you prepare person initiatives into initiatives. The place of work instance documents that you simply desire for undertaking projects can be found at www.perspection.com
Perspection has written and produced books on various computing device software—including Microsoft place of work 2003 and XP, Microsoft home windows XP, Apple Mac OS X Panther, Adobe Photoshop CS2, Macromedia Flash eight, Macromedia Director MX, and Macromedia Fireworks—and net publishing. In 1991, after operating for Apple laptop and Microsoft, Steve Johnson based Perspection, Inc. Perspection is devoted to supplying info and coaching to aid humans use software program extra successfully. Perspection has written greater than eighty machine books, and bought greater than five million copies.
Includes MCAS examination Objectives!
This courseware meets the pursuits for the Microsoft qualified software expert (MCAS). Upon of completion of this courseware, you will be ready to take the examination for MCAS qualification. to profit extra approximately changing into a Microsoft qualified software professional, stopover at www.microsoft.com.
Chapter 1 Getting began with Office 1
Chapter 2 utilizing Shared workplace instruments 33
Chapter 3 including artwork to workplace records 57
Chapter 4 including Shapes to place of work Documents 93
Chapter 5 Formatting place of work Documents 115
Chapter 6 making a rfile with Word 131
Chapter 7 Formatting a rfile with Word 153
Chapter 8 bettering a record with Word 173
Chapter 9 making a Worksheet with Excel 211
Chapter 10 construction a Worksheet with Excel 239
Chapter eleven Designing a Worksheet with Excel 281
Chapter 12 making a Presentation with PowerPoint 305
Chapter thirteen supplying a Presentation with PowerPoint 343
Chapter 14 making a Database with Access 375
Chapter 15 finding and coping with information with Access 405
Chapter sixteen offering information with Access 423
Chapter 17 conversation with Outlook 447
Chapter 18 handling details with Outlook 489
Chapter 19 making a e-book with Publisher 519
Chapter 20 Designing a booklet with Publisher 537
Chapter 21 Publishing workplace files at the Web 557
Chapter 22 keeping and Securing workplace Documents 575
Chapter 23 Reviewing and Sharing workplace Documents 605
Chapter 24 increasing workplace Functionality 647
New Features 673
Microsoft qualified purposes Specialist 683