Office 2007 Bible

About the Authors v

Acknowledgments xxxvii

Introduction xxxix

Part I: Common Office Features

Chapter 1: Welcome to Microsoft Office 2007 3

Chapter 2: Navigating in the New Office 23

Chapter 3: Mastering Fundamental Operations 47

Part II: Creating Documents with Word

Chapter 4: Making a Document 81

Chapter 5: Formatting 101: Font/Character Formatting 109

Chapter 6: Paragraph Formatting 125

Chapter 7: Styles 143

Chapter 8: Page Setup and Sections 159

Chapter 9: Tables and Graphics 181

Chapter 10: Mail Merge 227

Chapter 11: Document Security 251

Part III: Making the Numbers Work with Excel

Chapter 12: Using Excel Worksheets and Workbooks 269

Chapter 13: Entering and Editing Worksheet Data 287

Chapter 14: Essential Worksheet and Cell Range Operations 303

Chapter 15: Introducing Formulas and Functions 337

Chapter 16: Working with Dates and Times 361

Chapter 17: Creating Formulas That Count and Sum 387

Chapter 18: Getting Started Making Charts 411

Chapter 19: Working with Database Tables in Excel 425

Part IV: Persuading and Informing with PowerPoint

Chapter 20: A First Look at PowerPoint 2007 449

Chapter 21: Creating a Presentation, Slides, and Text 469

Chapter 22: Working with Layouts, Themes, and Masters 515

Chapter 23: Working with Tables and Charts 551

Chapter 24: Using SmartArt Diagrams, Clip Art, and Pictures 607

Chapter 25: Building Animation Effects, Transitions, and Support Materials 659

Chapter 26: Delivering a Live Presentation 685

Part V: Organizing Messages, Contacts, and Time with Outlook

Chapter 27: Fundamentals of E-Mail 707

Chapter 28: Processing and Securing E-Mail 767

Chapter 29: Working with Contacts 797

Chapter 30: Working with Appointments and Tasks 825

Part VI: Designing Publications with Publisher

Chapter 31: Introducing Publisher 865

Chapter 32: Design Dazzling Publications with Publisher 887

Part VII: Tracking Detailed Data with Access

Chapter 33: An Introduction to Database Development 909

Chapter 34: Creating Access Tables 925

Chapter 35: Creating and Entering Data with Basic Access Forms 963

Chapter 36: Selecting Data with Queries 1001

Chapter 37: Presenting Data with Access Reports 1027

Part VIII: Gathering Information

Chapter 38: Keeping Information at Hand with OneNote 1043

Chapter 39: Making Data Forms with InfoPath 1063

Part IX: Sharing and Collaboration

Chapter 40: SharePoint 1081

Chapter 41: Groove 1095

Chapter 42: Integration with Other Office Applications 1103

Appendix A: Customizing Office online

Appendix B: Optimizing Your Office Installation online

Appendix C: International Support and Accessibility Features online

Index 1119