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.

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!

THE ONLY WORD 2007 BOOK YOU NEED This book will help you build solid skills to create the documents you need right now, and expert-level guidance for leveraging Word’s most advanced features whenever you need them. If you buy only one book on Word 2007, Special Edition Using Microsoft Office Word 2007 is the book you need. • Come up to speed quickly with the new Word 2007 Ribbon interface • Streamline document formatting with styles, templates, and themes • Collaborate with others using comments and tracked changes • Master mail merges, master documents, and other advanced features • Manage large documents with indexes, TOCs, and automatically numbered references • Use fields and forms to collect and manage information • Illustrate key concepts with SmartArt diagrams • Create and apply custom themes that control fonts, color schemes, and effects • Manage academic research citations and generate bibliographies in any popular documentation format On the Web Includes complete instructions and a command reference you can use to customize the Ribbon with RibbonX, even if you have little or no previous XML experience. You can also download additional RibbonX examples and an easy-to-use RibbonCustomizer utility from this book’s companion web site, www.quepublishing.com/usingword2007.

Get the guide that makes learning Microsoft Excel plain and simple! This full color, no-nonsense book shows you the quickest ways to solve a problem or learn a skill, using easy-to-follow steps and concise, straightforward language. You'll analyze, manage, and share information in more ways than ever before. Here’s WHAT You’ll Learn Manage your data quickly and efficiently Filter, sort, summarize, and crunch your numbers Use formulas and functions to do the heavy lifting Bring data to life with charts and graphics Share data between Microsoft Office documents Work as a team, online and in the cloud Here’s HOW You’ll Learn It Jump in wherever you need answers Follow easy STEPS and SCREENSHOTS to see exactly what to do Get handy TIPS for new techniques and shortcuts Use TRY THIS! exercises to apply what you learn right away

Microsoft Excel 2007 is a complete rewrite of the world's most popular spreadsheet program. Microsoft will tempt people to buy the new version with amazing new features such as a larger grid (1.1 million rows x 16000 columns), improved charting, and improved business intelligence. However, Microsoft will then also leave people confused as they have completely removed the traditional File - Edit - View - Insert - Format - Tools menu and the standard and formatting toolbars. Special Edition Using Microsoft Office Excel 2007 will ease the upgrade path. The author, Mr. Excel, introduces the reader to the new interface to allow them to quickly get back up to speed in performing their job, and will then introduce the powerful new features available in Excel 2007. Among other skills, the reader will learn how to create amazing data visualizations using conditional formatting and in-cell data bars.

This book looks at the new version of Microsoft Windows Office.