Skip to main content

Office 2007 Bible

Office 2007 Bible

John Walkenbach, Herb Tyson, Faithe Wempen, Cary N. Prague, Michael R. Groh, Peter G. Aitken, Michael R. Irwin, Gavin Powell, Lisa A. Bucki

ISBN: 978-0-470-04691-3

Jun 2007

1224 pages

Select type: Paperback

Product not available for purchase

Description

Completely revised for Office 2007, this “best of the Bible” presents Office you with the most useful content from leading experts like John Walkenbach, Cary Prague, Faithe Wempen, and Herb Tyson. The book features valuable information to help you—no matter your level of expertise—get up to speed on the new features in Excel, Access, Outlook, Word, and PowerPoint. You’ll quickly get savvy with the most widely used business application suite worldwide.

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

  • All new for Office 2007
  • Combines content from best-selling books Excel Bible and Access Bible and authors John Walkenbach and Cary Prague along with the content from the Word, Outlook, and PowerPoint Bibles to create an Office Bible that is the best of the Office suite
  • This version of Office features a massive upgrade to the user interfaces for all the applications. Even the most experienced users will be looking for a thorough book to help them through the changes
  • This Bible will feature an improved visual design, with more emphasis on readability through improved fonts and spacing.
Sample Access files
These files provide the data necessary to create the examples used in Chapters 35 and 36.
Download
Appendix A: Customizing Office
This Appendix is in .pdf format. To open it, you will need a computer with software capable of opening PDF files. If you do not already have this capability, you can download Adobe Reader at www.adobe.com.
Download
Appendix B: Optimizing Your Office Installation
This Appendix is in .pdf format. To open it, you will need a computer with software capable of opening PDF files. If you do not already have this capability, you can download Adobe Reader at www.adobe.com.
Download
Appendix C: International Support and Accessibility Features
This Appendix is in .pdf format. To open it, you will need a computer with software capable of opening PDF files. If you do not already have this capability, you can download Adobe Reader at www.adobe.com.
Download