Table of Contents Introduction I Common Tasks and Features 1 Getting Started with Office 2007 . 9 2 Using and Customizing the Office 2007 Interface . 27 3 Managing Office Files and Formats . 53 4 Creating, Editing, and Formatting Documents . 75 5 Creating, Editing, and Using Pictures and Graphics . 103 6 Sharing and Reviewing Office Files . 135 7 Office Security and Privacy . 159 II Using Outlook 8 Outlook Essentials .

177 9 Reading, Writing, and Organizing Email . 219 10 Keeping Your Contacts List Under Control . 259 11 Working with Calendars and Tasks . 277 12 Outlook Security and Privacy . 307 III Using Word 13 Building a Better Word Document . 329 14 Using Themes, Styles, and Templates . 387 15 Advanced Document Formatting . 415 16 Professional Document Tools and Advanced Document Sharing .

455 17 Letters, Envelopes, and Data-Driven Documents .477 IV Using Excel 18 Building a Better Workbook . 507 19 Advanced Worksheet Formatting . 553 20 Using Formulas and Functions . 593 21 Organizing Data with Tables and PivotTables . 627 22 Creating and Editing Charts . 665 V Using PowerPoint 23 Building a Perfect Presentation . 703 24 Advanced Presentation Formatting .

737 25 Adding Graphics, Multimedia, and Special Effects .759 26 Planning and Delivering a Presentation . 779 VI Other Office Applications 27 Publisher Essentials . 797 28 Access Essentials . 835 29 Using OneNote . 879 30 Using Office 2007 on a Corporate Network . 907 VII Appendixes A Advanced Setup Options . 929 B Macros and Add-Ins .

943 C Using Office on a Tablet PC . 961 Index . 969.