Special Edition Using Microsoft® Office 2007 THE ONLY OFFICE BOOK YOU NEED   We crafted this book to grow with you, providing the reference material you need as you move toward Office proficiency and use of more advanced features. If you buy only one book on Office 2007, Special Edition Using Microsoft® Office 2007 is the only book you need.   If you own a copy of Office 2007, you deserve a copy of this book! Although this book is aimed at the Office veteran, Ed and Woody’s engaging style will appeal to beginners, too. Written in clear, plain English, readers will feel as though they are learning from real humans and not Microsoft clones. Sprinkled with a wry sense of humor and an amazing depth of field, this book most certainly isn’t your run-of-the-mill computer book. You should expect plenty of hands-on guidance and deep but accessible reference material.   This isn’t your Dad’s Office! For the first time in a decade, Microsoft has rolled out an all-new user interface. Menus? Gone. Toolbars? Gone. For the core programs in the Office family, you now interact with the program using the Ribbon–an oversize strip of icons and commands, organized into multiple tabs, that takes over the top of each program’s interface. If your muscles have memorized Office menus, you’ll have to unlearn a lot of old habits for this version.   Ed Bott is an award-winning computer journalist and one of the most widely recognized voices in the computing world, with nearly two decades of experience as a writer and editor at leading magazines, such as PC World, PC Computing, and Smart Business. Ed has written many of Que’s all-time bestsellers, including Special Edition Using Office 2000, Special Edition Using Windows 98, and Special Edition Using Windows Me.   Curmudgeon, critic, and perennial “Office Victim,” Woody Leonhard runs the fiercely independent AskWoody.com website with up-to-the-nanosecond news, observations, tips and help for both Office and Windows. In the past 15 years, Woody has written more than three dozen books, drawing an unprecedented six Computer Press Association awards and two American Business Press awards. Woody was one of the first Microsoft Consulting Partners and is a charter member of the Microsoft Solutions Provider organization.     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

Special Edition Using Microsoft® Office 2007 THE ONLY OFFICE BOOK YOU NEED   We crafted this book to grow with you, providing the reference material you need as you move toward Office proficiency and use of more advanced features. If you buy only one book on Office 2007, Special Edition Using Microsoft® Office 2007 is the only book you need.   If you own a copy of Office 2007, you deserve a copy of this book! Although this book is aimed at the Office veteran, Ed and Woody’s engaging style will appeal to beginners, too. Written in clear, plain English, readers will feel as though they are learning from real humans and not Microsoft clones. Sprinkled with a wry sense of humor and an amazing depth of field, this book most certainly isn’t your run-of-the-mill computer book. You should expect plenty of hands-on guidance and deep but accessible reference material.   This isn’t your Dad’s Office! For the first time in a decade, Microsoft has rolled out an all-new user interface. Menus? Gone. Toolbars? Gone. For the core programs in the Office family, you now interact with the program using the Ribbon–an oversize strip of icons and commands, organized into multiple tabs, that takes over the top of each program’s interface. If your muscles have memorized Office menus, you’ll have to unlearn a lot of old habits for this version.   Ed Bott is an award-winning computer journalist and one of the most widely recognized voices in the computing world, with nearly two decades of experience as a writer and editor at leading magazines, such as PC World, PC Computing, and Smart Business. Ed has written many of Que’s all-time bestsellers, including Special Edition Using Office 2000, Special Edition Using Windows 98, and Special Edition Using Windows Me.   Curmudgeon, critic, and perennial “Office Victim,” Woody Leonhard runs the fiercely independent AskWoody.com website with up-to-the-nanosecond news, observations, tips and help for both Office and Windows. In the past 15 years, Woody has written more than three dozen books, drawing an unprecedented six Computer Press Association awards and two American Business Press awards. Woody was one of the first Microsoft Consulting Partners and is a charter member of the Microsoft Solutions Provider organization.     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