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. Micro$oft Word has been the world's most popular word processor for so long, it needs only one namelike Oprah or Madonna. Unlike certain celebrities, though, Word has undergone a makeover that goes well beyond cosmetic. Micro$oft has redesigned the way you interact with the program and has redefined the underlying document format (don't worry; your old Word documents will still work).

Pro Excel 2007 VBA is the complete guide to creating Excel VBA applications, including covering all the new features in Excel 2007. Covering object–oriented programming techniques, debugging, and error handling methodologies, this book quickly turns novice into expert as it explores COM and .NET components and the advantages of compiled code. The book also covers XML for Excel web development.

This book is unique insomuch that author Jim DeMarco is a true expert in the field of Excel programming, and he conveys the VBA story in the context of the real world. Not just another dry programming guide, Pro Excel 2007 VBA is a journey from novice to expert where the author is your traveling companion. Bon voyage.

What you’ll learn

• Create automated forms for data collection.
• Mmanipulate lists and create data views.
• Manipulate web–based data.
• Integrate with other Office applications.
• Master Excel’s XML tools.
• Understand and build security into your applications.

PivotTables enable you to extract meaning from large amounts of data. This description is deceptively simple because in fact PivotTables are powerful and sophisticated tools that enable you to do things that would be impossible or difficult to do any other way.

A PivotTable enables you to take what seems to be an indecipherable mass of facts and extract any trends and patterns buried in the data. You can organize and summarize your data, perform comparisons, and extract meaningful information that can be invaluable to you and your organization.

These are powerful, flexible, and complex tools, and most Excel users never tap their full potential. But you can, with Peter Aitken's step-by-step tutorials, understandable instructions, and detailed explanations. You'll learn to create and use PivotTables and charts from the simplest to the most complex.

If you like to build custom applications or customize the Office user interface, this book is for you. Written by a team of Microsoft MVPs, it shows you—step by step—how easy it is to modify the Microsoft Office® 2007 Ribbon, how the Ribbon works, and how you can customize it to add functionality. You'll learn to leverage the RibbonX API to hide, create, add, and group controls.

Along with techniques for using XML, VBA, and Access macros, you'll find clear instructions, practical examples, and real-world code you can use. This is the perfect guide for beginners, developers, and power users alike.

• Explore the Ribbon user interface and Quick Access Toolbar

• Access the CustomUI Editor and start modifying

• Learn the essentials of XML and why you need it

• Write and debug your own code with Visual Basic® for Applications (VBA)

• Master RibbonX basic controls and create custom, static, and dynamic menus

• Deploy your Ribbon customizations across files

• Gain a working knowledge of key aspects of Office security such as digital certificates and privacy settings

Inside you'll also find a handy table of RibbonX tags, a tool to quickly reveal the imageMso references and generate its XML, and much more.

Maximize the powerful BI tools available in PerformancePoint 2007 with help from this practical guide. You will learn how to collect and store data, monitor progress, analyze performance, distribute dynamic reports, and create maintainable projects and forecasts. Business Intelligence with Microsoft Office PerformancePoint Server 2007 provides full details on creating scorecards and dashboards, performing advanced analysis on data, and setting up business plans. You will also learn how to integrate PerformancePoint with ProClarity, Excel 2007, and SQL Server Reporting Services.

• Configure, deploy, and secure all the PerformancePoint components
• Create KPIs, scorecards, reports, and dashboards with the Dashboard Designer
• Create business models with the Planning Business Modeler and create budgets and forecasts with Excel 2007
• Enable advanced data analysis with PerformancePoint Server and ProClarity tools
• Take advantage of the enhanced analytic capabilities of Excel 2007
• Use SQL Server Reporting Services for analytics
• Align performance with organizational objectives

Create graphs, develop estimates, and apply probability

Get the scoop on all of Excel's statistical tools and what they can do for you

If "permutation" sounds like something you shouldn't say around your grandmother and you read "margin of error" as "margin of terror," take heart! This easy-to-follow guide explains statistics in plain English and shows you how to use Excel charts, functions, samples, and correlations to make sense of it all — even if you're numerically challenged!

Discover how to

• Understand means, medians, and standard deviations
• Use Excel to give meaning to sets of numbers
• Draw conclusions from data
• Test your hypotheses
• Apply statistical concepts to real-world situations

Dive deep into the architecture of Exchange Web Servicesand master the intricacies for accessing data with the new, unifying API. Exchange Web Services offers new functionality, replacing old, disparate APIs. This practical guide introduces developers to Exchange Web Services. It includes comprehensive, in-depth coverage of the architecture and key features, including messaging, folders, calendaring, tasks, notifications, searching, availability, and autodiscovery. Developers who are moving applications using previous APIs to Exchange Web Services will learn how to determine the correct web services constructsand the implications of those decisions. This book assumes only knowledge of how to write HTTP requests, but it provides proxy examples in Microsoft Visual C#.

Microsoft Publisher 2007 For Dummies is a 50-75% revision to Microsoft Publisher 2000 For Dummies, covering both the Publisher 2003 and Publisher 2007 editions. The book focuses on three markets: Small and medium-sized businesses using Publisher for marketing campaigns; churches using Publisher to communicate via newsletters and marketing charity events; and schools using Publisher to communicate via newsletters and projects.

The ultimate guide to Microsoft Office Project Server 2007This comprehensive guide takes you through the planning and implementation lifecycle of a Project Server installation. You will learn how to utilize this powerful software to set up and manage projects, allocate human as well as financial resources, track progress, and adjust activities quickly to accommodate project changes and updates.

Get up to speed on managing sales, marketing, and customer information

Prospect with salesforce.com, manage sales teams, and improve sales productivity

Let CRM expert Tom Wong show you how to get around salesforce.com so you spend more time with your customers and less time trying to figure out the application. From navigating salesforce.com to performing common operations that relate to your accounts and contacts, this guide will get you going on salesforce.com in no time!

Discover how to

• Set up and customize salesforce.com
• Manage your opportunities
• Update your forecasts
• Track competitors and partners
• Drive demand with campaigns
• Use dashboards and analytics