Special Edition Using Microsoft Office Home and Student 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 2007 proficiency and use of more advanced features. If you buy only one book on Office Home and Student 2007, Special Edition Using Microsoft Office Home and Student 2007 is the book you need. Office Home and Student 2007 is available to ANYONE, regardless of whether you are a student, a teacher, or neither. The only condition Microsoft attaches is the requirement that the software not be used for commercial purposes. For use in the home or classroom, Office Home and Student 2007 is an exceptional deal at a fraction of the cost of the business versions! * No other authoring team in the business is as well recognized and respected as the Office Dream Team; when they speak, even the Office development team at Microsoft listens! * This book is a category killer-one that sets the pace for others to follow! * Tired of Office books that read as though Microsoft employees wrote them? Tired of learning the Microsoft way? Tired of books containing little more than you can pull from the Help system? If you answered yes to any of these questions, then you owe it to yourself to get a copy of this book! * If you own a copy of Office Home and Student 2007, you deserve a copy of this book! Here, you'll find a bevy of previously undocumented tips and tricks that will show you how to harness the power of Office 2007! * 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 "Another Special Edition Winner! Clear, concise and right on-target. Everything a student or a home user will need to know in order to master Office 2007." -Alan & Sandra Ashendorf, Hosts of Let's Talk Computers Radio Talk Show Ed Bott is a best-selling author of more than 25 computer books and an award-winning computer journalist with two decades of experience in the personal computer industry. He is a three-time winner of the Computer Press Award, and he and Woody Leonhard won the prestigious Jesse H. Neal Award, sometimes referred to as "the Pulitzer Prize of the business press," in back-to-back years for their work on PC Computing's "Windows SuperGuide." You can read more of Ed's writing at http://www.edbott.com/weblog. Curmudgeon, critic, and perennial "Office Victim," Woody Leonhard runs a fiercely independent website with up-to-the-nanosecond news, observations, tips, and help for both Office and Windows. AskWoody.com has become the premier source of unbiased information for people who need to really use Windows and Office, and for people concerned about juggling the neverending stream of Microsoft patches. 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. Category: Integrated Suites Covers: Microsoft Office Home and Student 2007 User Level: Beginner-Intermediate

Table of Contents

Introduction 1 Part I Common Tasks and Features 1 Getting Started with Office 2007 9 2 Making Office 2007 Work Your Way 27 3 Keeping Track of Your Files and Settings 55 4 Entering, Editing, and Formatting Text 81 5 Using Pictures and Drawings in Office 107 6 Using Office Programs Together 139 Part II Using Word 7 Getting Started with Word 161 8 Creating Great-Looking Documents 203 9 Organizing Complex Documents with Advanced Formatting Options 241 10 Mastering Styles, Templates, and Themes 287 11 Letters, Mail Merge, and "Smart" Documents 311 Part III Using Excel 12 Getting Started with Excel 353 13 Making Great-Looking Worksheets 401 14 Using Formulas and Functions 439 15 Working with Tables and PivotTables 473 16 Turning Data into Charts 513 Part IV Using PowerPoint 17 Getting Started with PowerPoint 541 18 Building Your Presentation 563 19 Adding Sizzle to a Presentation 595 20 Delivering a Presentation with Style 615 Part V Using OneNote 21 OneNote Essentials 633 22 Organizing and Arranging Information in OneNote 653 23 OneNote for Experts 669 Part VI Advanced Tasks and Features 24 Extending Office with Templates, Macros, and Add-ins 687 25 Using Office on a Tablet PC 711 26 Using Macros to Automate Routine Tasks 721 Index 739

Author Biography

Ed Bott is a best-selling author and award-winning technology journalist who has been covering the personal computer industry since the days when an 8MHz 80286 was a smokin' machine. Ed's feature stories and columns about Microsoft and its products have appeared regularly in print and on the web for more than 15 years, and he has written books on nearly every version of Microsoft Windows and Microsoft Office--so many, in fact, that he's lost count of the exact number. He is a three-time winner of the Computer Press Award and earned the Award of Merit from the Society for Technical Communication in 2003. Ed and Woody Leonhard won the prestigious Jesse H. Neal Award, sometimes referred to as "the Pulitzer Prize of the business press," in back-to-back years for their work on PC Computing's "Windows SuperGuide." He lives in an extremely civilized corner of the American Southwest with his wife, Judy, and a growing menagerie of affectionate pets who are sometimes smarter than he is. You can read Ed's latest writings at Ed Bott's Windows Expertise (http://www.edbott.com/weblog) and Ed Bott's Microsoft Report (http://blogs.zdnet.com/bott). Woody Leonhard describes himself as a "Certified Office Victim." With more than 40 computer books under his belt, he's seen parts of Office that would curl your hair. Woody's best known for his fiercely independent website, AskWoody.com, which mercilessly holds Microsoft's feet to the fire, and specializes in keeping consumers informed about problems with Microsoft patches. He's also a Contributing Editor with Windows Secrets Newsletter, windowssecrets.com. Woody has won eight Computer Press Awards and, with Ed, two American Business Press Association awards. He moved to Phuket, Thailand, seven years ago, where he now basks in the sun with his wife, Duangkhae, 82-year-old father, George, and all-American beagle, Chronos.