See How To

•    Create documents more efficiently using a new results-oriented interface

•    Use formatting, editing, reviewing, and publishing tools to create documents in print and online

•    Create great-looking documents faster using themes, styles, and templates

•    Organize information and add impact with clip art, SmartArt diagrams, tables, and charts

•    Create customized letters, labels, and envelopes

•    Use the Full Reading view to comfortably read documents on screen

•    Use the Outline and Draft views to develop your documents

•    Use Groove and SharePoint Team Services to collaborate and share documents and information

•    Prepare for the Microsoft Certified Applications Specialists exam

As the most popular database system in the world, Microsoft Access is used by millions of people and supported by hundreds of thousands of Access developers. The 2007 version marks the largest release of Access in five years. Written by design engineers on the Access test team at Microsoft, this book introduces you to the many new features of Access 2007 and shows you innovative ways of looking at old problems such as automation, debugging, and deployment.

The authors break down the book into four parts—programming Access applications, data manipulation, interacting with the application, and finalizing the application—in order to walk you through the important steps of creating a full-featured application. They also provide you with in-depth examples that require only minor modifications and then can be easily implemented in the real world. You'll quickly learn how the 2007 version makes it simpler to write quality Access applications with XML, C#, and other .NET languages that are actually fun to write, feature rich, and easy to use.

Because the analysis of copious amounts of data and the preparation of custom reports often take away time from true research, the automation of these processes is paramount to ensure productivity. Exploring the core areas of automation, report generation, data acquisition, and data analysis, Automated Data Analysis Using Excel illustrates how to minimize user intervention, automate parameter setup, obtain consistency in both analysis and reporting, and save time through automation.

Focusing on the built-in Visual Basic for Applications (VBA) scripting language of Excel, the book shows step-by-step how to construct useful automated data analysis applications for both industrial and academic settings. It begins by discussing fundamental elements, the methods for importing and accessing data, and the creation of reports. The author then describes how to use Excel to obtain data from non-native sources, such as databases and third-party calculation tools. After providing the means to access any required information, the book explains how to automate manipulations and calculations on the acquired data sources. Collecting all of the concepts previously discussed in the book, the final chapter demonstrates from beginning to end how to create a cohesive, robust application.

With an understanding of this book, readers should be able to construct applications that can import data from a variety of sources, apply algorithms to data that has been imported, and create meaningful reports based on the results.

This book is a single reference that’s indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere.
Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers won’t find anywhere else.
John Walkenbach, aka "Mr. Spreadsheet," is one of the world’s leading authorities on Excel.
Thoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features.

Learn to use PowerPoint in ways you never thought possible. Marcovitz shows how, providing practical instruction for using Visual Basic for Applications (VBA) to create learning environments and educational materials that support and enhance student success. With the widespread availability of PowerPoint (every copy beginning with version 1997 comes with VBA built-in) schools have all the tools they need to create powerful and interactive multimedia resources. The true power of multimedia lies in its ability to engage students' minds. Professional multimedia tools are too difficult to learn, too expensive, or both, and although many teachers and students use HyperStudio or PowerPoint to develop multimedia projects, these projects often lack true interactivity. Using VBA with PowerPoint gives teachers and students an accessible way to easily create interactive multimedia resources and projects. After introducing the basics of educational planning, the design process, and the benefits of designing and using multimedia, this book offers the practical knowledge you need to create powerful educational resources. Learn to create projects that include:

By reading this book and following the practice exercises scattered liberally throughout  the  chapters,  you  can  learn  to  develop  powerful  and  innovative  reporting  solutions  using  Microsoft  Excel  2003.  This  book’s  step-by-step approach can help you steadily gain confidence in your ability to use Excel’s reporting functions as you enhance your skills by working through the hands-on examples.

You don’t have to know Structured Query Language (SQL) to get real value from this book. However, readers who are familiar with SQL programming will probably get the most out of it. Indeed, many SQL programmers find that Excel report development is the next logical progression in their technology education. Still, even if you are only an experienced user of Excel, you will learn  a  substantial  amount  about  Excel  reporting,  especially  in  the  earlier chapters where the graphical Excel tools are used to build SQL queries that run against external data sources such as delimited files, spreadsheets, databases, and data cubes.

If you’re new to Excel reports, you should start with Part I of the book. Advanced users who are  already  familiar  with  Excel’s  reporting  features  and  with  external data sources can skip to Part II, where the core features, functions, and components of Excel reports are covered. The appendixes in Part III provide references for installing  the  NorthwindCS  database,  configuring  your  Windows  operating system to display extensions for known file types, and using basic SQL.

Devoted entirely to PivotTables and PivotCharts, this book shows you how to take full advantage of these powerful tools, which enable you to pull meaningful information from masses of seemingly meaningless data. Loaded with illustrations and real-world examples, it takes you step by step through creating a PivotTable; formatting, filtering, and grouping data; creating PivotCharts from those data; and more. You’ll learn to work with multidimensional data, how to create and manipulate PivotTables using VBA, and—most importantly—you’ll discover what these tools can do for you.

One Book…All the Answers

In just a short time you will be up and running with Microsoft Office 2007, including Word, Excel, PowerPoint, Outlook, and OneNote.

Using a straightforward, step-by-step approach, each lesson builds upon a real-world foundation, allowing you to learn the essentials of Office 2007 from the ground up.

Thorough instructions walk you through the most common tasks and show you extra features that make your Office 2007 documents stand apart from the crowd.

Notes present interesting pieces of information, extra features you can use, and warnings to protect your data.

Tips offer extra advice or teach an easier way to do something.

This Book is for programmers and would-be programmers who want to lear Word 2003 Visual Basic programming as quickly as possible. I assume that you are fluent in useing Word 2003 as a word processor and want to learn the Visual Basic programming part of Word 2003 to help you become more efficient with your word processing tasks. It is preferable that you have some programming background but the concepts are explained at the elementary level so a beginning programmer should be able to follow and learn.

I firmly believe in learning programming through examples so this book is full of programming examples to explaing the concepts and techniques of programming Visual Basic. I expect you to try all the examples in this book and make the code work for you. This is how you learn programming. Learning programming by doing is fun and I want you to have as much fun as I have writing this book.

Microsoft Office Project 2007 All-in-One Desk Reference For Dummies is a compilation of multiple short reference-style books covering Microsoft Project, enhanced by the format of a single, easy-to-use, task-oriented step-by-step package. All-in-One For Dummies books are made up of multiple minibooks that could each stand alone. Each minibook covers one topic completely.

This book features a companion Web site where readers can download Microsoft Project add-ins, templates, and author-generated materials. The book also features a gate-fold cheat sheet that contains myriad quick-reference information, tips, and shortcuts for reference when using Microsoft Project 2007.