Special Edition Using Microsoft Office 2007 ONLY OFFICE BOOK YOU NEED We created this book to grow with you, providing the reference material you need as you move toward Office proficiency and use of the features are more advanced. If you buy only one book on Office 2007, Special Edition Using Microsoft Office 2007 is the only book you need. If you have a copy of Office 2007, you are entitled to a copy of this book! Although this book is aimed at the Office veteran, Ed and Woody's attractive style will appeal to beginners as well?. Written in clear English, the reader will feel as though they are learning from real humans and not Microsoft clones. Sprinkled with a wry sense of humor and amazing depth of field, this book is almost certainly isn? T you go for regular computer books. You should expect a lot of hands-on guidance and in-depth reference materials, but can be accessed. This is not it? T dad? Office! For the first time in a decade, Microsoft has launched an all-new user interface. Menu? Gone. Toolbar? Gone. For the core program within the Office family, you now interact with the program using the Ribbon an oversized strip of icons and commands, which are arranged in multiple tabs, which took over the top of each program? Interface. If your muscles have memorized Office menus, you? Will have to forget a lot of old habits for this version. Ed Bott is an award-winning computer journalist and one of the voices of the most widely recognized in the computing world, with nearly two decades of experience as a writer and editor at leading magazines, like PC World, PC Computing, and Smart Business. Ed has written many of Que? S-selling book of all time, including Special Edition Using Office 2000, Special Edition Using Windows 98, and Special Edition Using Windows Me. Scrooge, critics, and the eternal victim? Office, run? Woody Leonhard is an independent site AskWoody.com hard-to-the-nanosecond news up, observations, tips and help for both Office and Windows. In the last 15 years, Woody has written more than three dozen books, drawing an unprecedented six awards Computer Press Association 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 General Duties 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 Word document better. . . . . . . . . . . . . . . . 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 Prese Sempurnantation. 703 24 Advanced Presentation Formatting. 737 25 Adding Graphics, Multimedia, and Special Effects. .759 26 Planning and Delivering Presentations. . 779 VI Other Office Applications 27 Publisher Essentials. . 797 28 Access Essentials. 835 29 Using OneNote. 879 30 Using Office 2007 on the Company Network. 907 Annex VII A Advanced Setup Options. . 929 B Macros and Add-Ins. 943 C Using Office on a Tablet PC. 961 Index. . 969