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.

Microsoft Office Excel 2007 is the biggest revision this industry standard software has undergone in years. It has a brand new interface, tons of new tools and even a suite of services called Excel Services to allow you to share your valuable data on the web. For the first time in years there is a lot to learn to make the most of this powerful new update. To take advantage of all of the new features in this powerful program (and to do so quickly), users need this Vi sual QuickStart Guide. In these pages, veteran author and trusted Excel teacher Maria Langer provides step-by-step instructions for the full gamut of Excel tasks: from worksheet basics like editing, using functions, formatting cells, and adding graphics objects, to more advanced topics like creating charts, working with databases, and Web publishing. As with all Visual QuickStart Gui de books, clear, concise instructions and lots of visual aids make learning easy and painless.

Quickly teach yourself how to automate tasks and create custom spreadsheet solutions with Excel 2007 Visual Basic for Applications (VBA). With Step By Step, you set the pace—building and practicing the skills you need, just when you need them! Create macros to automate repetitive tasks Automatically format charts, shapes, and text Manipulate tables and other objects—even build PivotTable reports Write your own functions and procedures Use loops and conditions to add decision logic to macros Build custom command buttons, dialog boxes, and user forms Your all-in-one learning experience includes: Files for building skills and practicing the book’s lessons Fully searchable eBook Windows Vista Product Guide eReference—plus other resources on CD For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

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

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.

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.

PivotTables may be Excel's most powerful feature, but Microsoft has estimated that only 15% of Excel users take advantage of them. That's because PivotTables (and their companion feature, PivotCharts) have a reputation for being difficult to learn. Not any more! In this book, Excel legends Bill Jelen ("MrExcel") and Michael Alexander teach PivotTables and PivotCharts step-by-step, using realistic business scenarios that any Excel user can intuitively understand. Jelen and Alexander go far beyond merely explaining PivotTables and PivotCharts: they present practical "recipes" for solving a wide range of business problems. Drawing on more than 30 combined years of Excel experience, they provide tips and tricks you won't find anywhere else, and show exactly how to sidestep common mistakes. Coverage includes: " Creating PivotTables, customizing them, and changing the way you view them " Performing calculations within PivotTables " Using PivotCharts and other visualizations " Analyzing multiple data sources with PivotTables " Sharing PivotTables with others " Working with and analyzing OLAP data " Making the most of Excel 2010's powerful new PowerPivot feature " Using Excel 2010's Slicer to dynamically filter PivotTables " Enhancing PivotTables with macros and VBA code This book is part of the new MrExcel Library series, edited by Bill Jelen, world-renowned Excel expert and host of the enormously popular Excel help site, MrExcel.com. Teaches PivotTables, PivotCharts, and Excel 2010's new PowerPivot feature through real-world scenarios that make intuitive sense to users at all levels Includes proven PivotTable recipes for instant on-the-job results Helps Excel users avoid common pitfalls and mistakes Part of the brand-new MrExcel Library series, edited by Excel legend Bill Jelen