2007 MicrosoftВ® Office System Inside Out (Bpg-Inside Out)

2007 Microsoft Office System Inside Out is organized in eight parts. Here’s a rundown of what you’ll find in each section of the book.

• In Part 1, “Getting Started,” you’ll be introduced to the 2007 Microsoft Office system, including a full chapter about the Microsoft Office Fluent interface. You’ll learn about the security features in the 2007 Office release, including the Trust Center, where you set options for managing your privacy as well as for which macros you will allow to run.

• In Part 2, “Collaboration Essentials,” you’ll explore several of the 2007 Office release tools and programs that are designed for collaboration and sharing, including Microsoft Office OneNote 2007 and Microsoft Office Groove 2007. You’ll also find an overview of how to use Microsoft Office with Windows SharePoint Services.

• Part 3 covers Microsoft Office Word 2007, including formatting and layout techniques, outlining, marking up and revising documents, and page setup. On the book’s CD, you’ll find additional information about working with new features such as document Themes.

• Part 4 is about Microsoft Office Excel 2007. This part describes techniques for working with worksheets and workbooks, building formulas, using functions, and analyzing data. On the book’s CD, you’ll find additional information (from the Bonus Chapters tab) about working with charts in Excel and about connecting Excel worksheets to external data.

• Part 5 covers Microsoft Office PowerPoint 2007, including the basics of creating and formatting a presentation; how to work with text; and how to work with objects, diagrams, and charts in a presentation. This section also provides information about collaborating and sharing PowerPoint presentations and explains how to import or export data to and from your PowerPoint slides. In the last chapter in this section, you’ll learn how to set up and present a slide show.

• Part 6 brings us to Microsoft Office Outlook, an application in which many information workers spend the better parts of their days-reading e-mail, scheduling meetings, and setting up tasks. To start this section you’ll read an overview of Office Outlook 2007, it’s new features, and its new user interface. In the chapters that follow you’ll read about how to manage e-mail, about security features in Outlook 2007, and how to integrate your use of Outlook with Windows SharePoint Services. The Bonus Chapters area of the book’s CD will lead you to chapters in which you can learn about managing tasks, meetings, appointments, and contacts in Outlook 2007.

• In Part 7 of the book, you’ll learn about the latest release of Microsoft Office Access. You’ll learn in detail about the new Access 2007 user interface, how to create a database and its tables, and how to work with database objects such as queries, forms, and reports. The book’s CD includes an additional chapter that teaches you about how to work with Access together with a SharePoint site and an article that covers the fundamentals of database design.

• The final part of the book, “Office Programming Primer,” presents an introduction to Visual Basic for Applications, the programming language you use to automate and extend the functionality of Microsoft Office programs, and a primer on working with the Office Open XML Formats, the framework at the heart of the 2007 Office release file formats.