* Edit standard XML files with all the tools of Word and Excel (like formulas and the spell checker) * Take existing Word or Excel documents, transform all or part of them into XML, and "plug" them into business processes. * Mine the data in an Office document, using custom macros or applications—on any platform. * Create rich Word or Excel documents programmatically, without even needing to have Office installed. * Create smart documents that have built-in user guidance and validation rules to prevent errors.

An exploration of the relationship between XML and Office 2003, examining how the various products in the Office suite both produce and consume XML. Beginning with an overview of the XML features included in the various Office 2003 components, it provides guidance on how to import or export information from Office documents into other systems.

This extensive reference manual covers the whole of Microsoft Office Word 2007 in exquisite detail: every dialog box is illustrated and every command (whether or not it it available through the Ribbon) is described and fully cross-referenced. This is not a "how to" guide, but a serious reference for power users for whom the online help is not detailed enough. Buy this book if you need quick answers to tricky questions about Word 2007.

*Practical step-by-step tutorials and business examples guide the reader through everything they need to know about Pivot Tables. *This book focuses specifically on Pivot Tables where most books only include a section on them. Since many users find Pivot Tables very challenging, the single focus of this book offers an accessible but full tutorial on this important part of Excel. *Paul Cornell works at Microsoft and has a long career writing about Office and Excel for Power Users, who are the audience he is now writing for in this new book.

* Builds real applications that can be customized and used commercially. * Provides real-world examples, each of which offers a fundamental lesson in approaching data structure and code. * Friendly, open and targeted chapters that can be absorbed one lesson at a time.

PCMag.com is a leading authority on technology, delivering Labs-based, independent reviews of the latest products and services. Our expert industry analysis and practical solutions help you make better buying decisions and get more from technology.

PCMag.com is a leading authority on technology, delivering Labs-based, independent reviews of the latest products and services. Our expert industry analysis and practical solutions help you make better buying decisions and get more from technology.

Learn quickly and efficiently from a true Excel master using the tried and true Special Edition Using formula for success. Here, readers will find information that's undocumented elsewhere--even in Microsoft's own Help systems.

bull; Written by Goldfarb, the inventor of markup language technology, and Walmsley, a leading expert on XML Schema, on which Office 2003's XML features are based. bull; Ideal for both Office power users and IT developers. bull; Foreword and cover endorsement by Jean Paoli, Microsoft's Chief XML Architect.

PCMag.com is a leading authority on technology, delivering Labs-based, independent reviews of the latest products and services. Our expert industry analysis and practical solutions help you make better buying decisions and get more from technology.