Moving to Excel 2007 is not a routine upgrade. Microsoft's radical redesign of the application's user interface has led to confusion among many who people who have relied on Excel for years. Our new edition of the Excel 2007 Pocket Guide has been written from the ground up to help newcomers and longtime users alike find their way around without getting lost. With this book in hand, you'll be able to find your favorite Excel tools quickly. It's packed with information to guide beginners through the basics of creating spreadsheets and entering data, while providing advanced users with information on formulas, pivot tables, and more. Inside, you'll find: A visual guide to the new "Ribbon" interface that helps users find familiar tools A section designed to give beginners enough information to dive right in and start creating rich Excel workbooks immediately Quick answers about how to perform specific tasks in Excel, such as working with files, editing data, formatting, summarizing and displaying data Convenient techniques for connecting data across worksheets and projects Help for moving from the basics of spreadsheet construction to more advanced features This edition also includes an extensive reference on commonly used formulas, which reveal at a glance the many possibilities Excel 2007 provides for easy calculation. Tasks in the book are presented as answers to "How do I..." questions -- such as "How do I change the formatting of part of a cell's contents?" -- followed by concise instructions for performing the task. You'll learn ways to customize Excel to fit your needs, and how to share workbooks and collaborate with others. And much more. Don't let Excel 2007 baffle you. Pick up this convenient pocket guide and learn to navigate this redesigned application with ease.

Packed with information, the "Excel Pocket Guide" is a compact reference that covers such basics as creating workbooks, entering data, printing, cell formatting, and spell checking.

The latest book from Cengage Learning on Data Analysis with Microsoft« ExcelÖ

Provides detailed instruction in the fundamental features and functions of Access, Excel, FrontPage, Outlook, PowerPoint, Publisher, and Word, as well as InfoPath, SharePoint, LiveMeeting, and Groove--and the new integration features of the new version of the Office suite.

Are you new to computers? Does new technology make you nervous? Relax! You're holding in your hands the easiest guide ever to Office 2007 -- a book that skips the long-winded explanations and shows you how things work. All you have to do is open the book, follow Chip, your friendly guide -- and discover just how easy it is to get up to speed. "The Simplified series is very accessible to beginners and provides useful information for more experienced users. For visual learners (like myself), the illustrations are a great help. It's challenging to take a complex subject and express it simply, clearly, concisely, and comprehensively. This book meets the challenge." --John Kelly (Anchorage, AK) "Simplify It" sidebars offer real-world advice A friendly character called Chip introduces each task Full-color screen shots walk you through step by step Self-contained, two-page lessons make learning a snap

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

Excel Annoyances addresses the quirks, bugs, and hidden features found in the various versions of the Excel spreadsheet program. Broken down into several easy-to-follow categories such as Entering Data, Formatting, Charting, and Printing, it uncovers a goldmine of helpful nuggets that you can use to maximize Excel's seemingly limitless potential.

"Microsoft Office InfoPath represents a revolutionary leap in XML technologies and a new paradigm for gathering business-critical information. I am delighted that Scott Roberts and Hagen Green, two distinguished members of the InfoPath product team, decided to share their experience in this book." --From the Foreword by Jean Paoli, cocreator of XML 1.0 and Microsoft Office InfoPath Microsoft Office InfoPath 2007 offers breakthrough tools for gathering, managing, and integrating business-critical information, and creating efficient forms-driven processes. Two longtime members of Microsoft's InfoPath product team have written the first comprehensive, hands-on guide to building successful XML-based solutions with InfoPath 2007. The book opens with a practical primer on the fundamentals of InfoPath form template design for information workers and application developers at all levels of experience. It then moves into advanced techniques for customizing, integrating, and extending form templates--with all the code examples and detail needed by professional developers. Learn how to: Design form templates: create blank form templates, insert and customize controls, use advanced formatting, and construct and lay out views Work with data: start with XML data or schema, manually edit data sources, and understand design-time visuals Add custom business logic to forms, and integrate them with other applications Retrieve and query data from external data sources, including XML files, databases, SharePoint lists, Web services, and ADO.NET DataSets Submit and receive form data using ADO.NET Save, preview, and publish to e-mail, SharePoint, and more Build reusable components with template parts Create workflows with SharePoint and InfoPath E-Mail Forms Administer Forms Services and Web-enabled form templates Build advanced form templates using C# form code, custom controls, add-ins, and the new InfoPath 2007 managed object model Design form templates using Visual Studio Tools for Office (VSTO) Update, secure, and optimize your form templates List of Figures List of Tables Foreword Preface About the Authors PART I: Designing Forms Chapter 1: Introduction to InfoPath 2007 Chapter 2: Basics of InfoPath Form Design Chapter 3: Working with Data Chapter 4: Advanced Controls and Customization Chapter 5: Adding Logic without Code Chapter 6: Retrieving Data from External Sources Chapter 7: Extended Features of Data Connections Chapter 8: Submitting Form Data Chapter 9: Saving and Publishing Chapter 10: Building Reusable Components Chapter 11: Security and Deployment Chapter 12: Creating Reports Chapter 13: Workflow Chapter 14: Introduction to Forms Services Part II: Advanced Form Design Chapter 15: Writing Code in InfoPath Chapter 16: Visual Studio Tools for Microsoft Office InfoPath 2007 Chapter 17: Advanced Forms Services Chapter 18: Hosting InfoPath Chapter 19: Building Custom Controls Using ActiveX Technologies Chapter 20: Add-ins Chapter 21: Importers and Exporters Appendix: Further Reading Index

Written by one of the most popular and knowledgeable Microsoft Outlook MVPs, this book fills a void in the market for a professional-level Outlook programming book Explains how to use the many new features of Outlook 2007's object model and offers honest advice from the author on how to deal with common shortcomings and pitfalls of Outlook Addresses common workarounds for Outlook programming bugs and how to interface with Word, Excel, SharePoint, and Access Discusses the new Object Model, Outlook forms, COM add-ins, security, and more

This is your most concise, practical reference to deploying, configuring, and running SharePoint 2013. Perfect for admins at all levels, it covers both technical topics and business solutions. SharePoint MVP Ben Curry focuses on the crucial step-by-step information for performing day-to-day tasks quickly, reliably, and well. No obscure settings, abstract theory, or hype...just help you can really trust--and really use! Install SharePoint Server 2013 Configure farms and databases Create and extend web applications Set up and scale service applications Deploy and manage sites/collections Implement BI solutions Integrate Excel Services and PowerPivot Configure enterprise content types and metadata Deploy Enterprise Search Manage documents and web content Brand your site Deliver social tools, including microblogging Back up and restore