This is the eBook version of the printed book. Learn the ins and outs of Mail Merge in Word 2007, including how to select and prepare a data file and a main document, how to manually or automatically set up field codes, and how to print, save, and manage merged letters, envelopes, labels, and catalogs. Contents: What Is a Mail Merge? Performing a Letter Merge with the Mail Merge Wizard Selecting a Main Document Type Selecting a Data Source Preparing the Main Document Inserting Merge Fields Filtering and Sorting the Data Previewing and Printing the Merge Creating Custom Merges with Word Fields Faithe Wempen, M.A., is a Microsoft Office Master Instructor and an adjunct instructor of computer information technology at Indiana University/Purdue University at Indianapolis, specializing in Microsoft Office and PC hardware. She is the author of more than 90 books on PC hardware and software and teaches online courses in Office applications for corporate clients including Hewlett-Packard, Gateway, and Sony. She also owns and operates Sycamore Knoll Bed and Breakfast (www.sycamoreknoll.com).

The inside scoop... for when you want more than the official line! Microsoft Office Word 2007 may be the top word processor, but to use it with confidence, you'll need to know its quirks and shortcuts. Find out what the manual doesn't always tell you in this insider's guide to using Word in the real world. How do you use the new Ribbon? What's the best way to add pictures? From deciphering fonts to doing mass mailings, first get the official way, then the best way from an expert. Unbiased coverage on how to get the most out of Word 2007, from applying templates and styles to using new collaboration tools Savvy, real-world advice on creating document for the Web, saving time with macros, and punching up docs with SmartArt. Time-saving techniques and practical guidance on working around Word quirks, avoiding pitfalls, and increasing your productivity. Tips and hacks on how to customize keyboard shortcuts, how to embed fonts, and quick ways to get to Help. Sidebars and tables on TrueType versus Printer fonts, World 2007 View modes, and tabs in Word 2007. Watch for these graphic icons in every chapter to guide you to specific practical information. Bright Ideas are smart innovations that will save you time or hassle. Hacks are insider tips and shortcuts that increase productivity. When you see Watch Out! heed the cautions or warnings to help you avoid common pitfalls. And finally, check out the Inside Scoops for practical insights from the author. It's like having your own expert at your side!

Microsoft Word has grown considerably in power, sophistication and capability over the past decade, but one thing that hasn't changed since the early '90s is its user interface. The simple toolbar in version 2.0 has been packed with so many features since then that few users know where to find them all. Consequently, more and more people are looking for "insider" tips that will allow them to use these advanced and often hidden features. Microsoft has addressed this problem in Word 2007 by radically redesigning the user interface with a tabbed toolbar that makes every feature easy to locate and use. Unfortunately, Microsoft's documentation is as scant as ever, so even though you will be able to find advanced features, you might not know what to do with them. Word 2007: The Missing Manual, written specifically for this version of the software, explains basics like how to create documents, enter and edit text, format, print, and fax. You will will also learn how to create sophisticated page layouts, insert forms and tables, use graphics, and create book-length documents with outlines and Master Documents. Coverage also includes how to share documents with other people and programs, create web pages, automate documents with fields, and automate tasks with macros and the Visual Basic scripting language. This book shows you how to do it all.

Word basics for simple documents -- Creating longer and more complex documents -- Sharing documents and collaborating with other people -- Customizing Word with macros and other tools -- Word help and beyond.

Word 2007: Beyond the Manual is written for the experienced Word user who would find an introductory manual boring, condescending, and a waste of time. Basic features of word-processing in general or of Word in particular are not discussed. Features new to Word 2007 are emphasized, as are complex features that, though available in earlier versions of Word, were not readily accessible. The narrative is fast-paced, concise, and respectful of the reader’s familiarity with earlier versions of the program.

THE ONLY EXCEL BOOK YOU NEED We crafted this book to grow with you, providing the reference material you need as you move toward Excel proficiency and use of more advanced features. If you buy only one book on Excel, Special Edition Using Microsoft® Office Excel® 2007 is the book you need. Does your life play out in a spreadsheet? Do numbers in columns and rows make or break you in the work world? Tired of having numbers kicked in your face by other Excel power users who make your modest spreadsheets look paltry compared to their fancy charts and pivot tables? If you answered yes to any of these questions, Special Edition Using Microsoft® Office Excel® 2007 is the bookthat will make it all better. Learn quickly and efficientlyfrom a true Excel master using the tried and true SpecialEdition Using formula for success. Here, you’ll findinformation that’s undocumented elsewhere—even inMicrosoft’s own Help systems. You’ll learn from finelycrafted, real-life examples built by an author who livesand dies by the integrity of his spreadsheets. Excel’s backbone is its formulas and functions. Master those and you will master your spreadsheets. Special Edition Using Microsoft Office® Excel® 2007 provides more down and dirty help with your formulas and functions than you’ll find in any other book! See how it’s done in real life! Don’t settle for lame pivot table and chart examples found in other books… This book provides beautifully detailed examples that not only show you how it should be done, but how to be the local worksheet hero!

Score Higher on the MCAS Exams! We provide you with the proven study tools and expert insight that will help you score higher on your exams. Clear and simple explanations, lists, and screen shots walk you through the Microsoft Office processes you need to know to score well on the MCAS exams. Study strategies, challenges, and key terms focus your study so you can maximize your preparation time. Comprehensive discussion of all subject areas covered on the MCAS exams. Practice Questions that include detailed explanations of correct and incorrect answers–so you can learn the material from your success and mistakes. This book covers all the skills measured by the MCAS Exams for Microsoft Office 2007, including Creating, customizing, formatting, and organizing Word documents Working with visual content, references, and document review processes Creating, manipulating, and formatting data and other content in Microsoft Excel Presenting Excel data visually with charts and illustrations Sharing and securing Microsoft Office content Creating, formatting, and delivering PowerPoint presentations Managing messaging, scheduling, and tasks with Microsoft Outlook Working with Outlook contacts and personal contact information Structuring, presenting, managing, and maintaining Access databases Building and modifying Access queries This is the eBook version of the print title. Note that the eBook does not provide access to the practice test software that accompanies the print book.