2007 Microsoft® Office System Inside Out

Larger Cover

By Microsoft Corporation

Publisher: Microsoft Press

Released: March 2007

Pages: 1312

Dive into the essential features in Microsoft Office Access® 2007, Excel® 2007, Outlook® 2007, PowerPoint® 2007, and Word 2007. This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It’s all muscle and no fluff. Discover how the experts tackle what’s new in your favorite Microsoft Office programs—and challenge yourself to new levels of mastery!

Expertly manage your inbox, contacts, and business information
Master sophisticated document-layout and formatting techniques
Build spreadsheets to help you perform complex calculations and data analysis
Design databases, build data-collection forms, and manipulate data
Learn advanced techniques for creating charts and reports
Create dynamic slides using themes, custom slide layouts, and special effects
Explore Office Groove® 2007 and Windows® SharePoint® Services for powerful collaboration
Configure security and privacy settings to help thwart worms, viruses, and malware
Write macros using Microsoft Visual Basic® for Applications and work with Office Open XML

CD includes:

Fully searchable eBook—plus bonus chapters!
30+ sample files—spreadsheets, databases, code, and XML
Resources for customizing, configuring, and troubleshooting programs
Links to demos, webcasts, training courses, and blogs
Visual references for finding commands in the Microsoft Office Fluent user interface
Online resources for InfoPath® 2007, OneNote® 2007, Project 2007, and Visio® 2007
Windows Vista® Product Guide eReference and other eBooks

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via OReilly Medias Digital Distribution services. To download this content, please visit OReillys web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.

Chapter 1 Introduction
1. Who This Book Is For
2. How This Book Is Organized
Getting Started
1. Chapter 1 Overview of the 2007 Microsoft Office System
  1. The New World of Work
  2. The New Microsoft Office User Interface
  3. The New Microsoft Office XML File Formats
  4. What Else Is New?
2. Chapter 2 The 2007 Office System User Interface: What’s Changed, What’s the Same
  1. A Quick Tour and Comparison
  2. The Ribbon and Command Tabs
  3. Customizing the Quick Access Toolbar
  4. The Microsoft Office Button and Menu
  5. Working in Context: More Tabs, Plus Some Menus and Toolbars
  6. Galleries and Live Preview
  7. Getting Help
3. Chapter 3 Managing Security and Privacy in the 2007 Office System
  1. Working in the Trust Center
  2. Setting Your Privacy Options
  3. Removing Hidden Data and Personal Information from Microsoft Office Documents
  4. Applying Information Rights Management
  5. Assigning a Password to a Document
  6. Avoiding Phishing Schemes
Collaboration Essentials
1. Chapter 4 Collaborating and Sharing with Others
  1. Understanding and Using the 2007 Office System Collaboration Environments
  2. Creating and Using Shared Workspaces with Windows SharePoint Services
  3. Creating and Using Groove Workspaces
  4. Using Office OneNote 2007 as a Collaboration Tool
2. Chapter 5 Organizing and Finding Information in Microsoft Office OneNote
  1. Organizing a OneNote Notebook
  2. Adding Notes and Information to a Notebook
  3. Finding Your Information
  4. Using a Notebook on More Than One Computer
  5. Working as a Team with Office OneNote 2007
3. Chapter 6 Working as a Team in a Microsoft Office Groove Workspace
  1. Getting Started with Groove
  2. Setting Up a Groove Account
  3. The View from the Launchbar
  4. Groove Workspace Basics
  5. Outfitting a Groove Workspace with Tools
4. Chapter 7 Sharing and Communicating Using Microsoft Office Groove
  1. Setting Up and Using a File-Sharing Workspace
  2. Managing Groove Communications
  3. Working with Groove Contacts
  4. Introducing the Groove Forms Tool
  5. Managing Workspace Archives and Templates
Word
1. Chapter 8 Mastering Page Setup and Pagination
  1. Basic Page Setup Options
  2. Changing Margins and Orientation
  3. Selecting a Paper Size and Source
  4. Controlling Page and Section Breaks
  5. Working with Varying Page Settings
  6. Including Headers and Footers
  7. Working with the Document Grid
  8. Adding and Controlling Line Numbers
2. Chapter 9 Outlining Documents for Clarity and Structure
  1. Outlining Enhancements in Word 2007
  2. Creative Outlining with Word 2007
  3. Eleven Reasons to Outline Your Next Complex Document
  4. Viewing a Document in Outline View
  5. Creating a New Outline
  6. Choosing Outline Display
  7. Working with Headings in Outline View
  8. Displaying Outline and Print Layout View at the Same Time
  9. Changing Your Outline
  10. Printing Your Outline
  11. Using the Document Map vs. Using Outline View
3. Chapter 10 Advanced Layout and Formatting
  1. Layout and Design Fundamentals
  2. Using Backgrounds and Watermarks
  3. Controlling Text Placement and Formatting with Text Boxes, Shapes, and Frames
  4. Configuring Word 2007 Layout Options
  5. Commanding Attention with Borders and Shading
  6. Adding a Simple Border
  7. Creating Enhanced Borders
  8. Creating Partial Borders
  9. Using a Page Border
  10. Adding Borders to Document Sections and Paragraphs
  11. Adjusting Border Spacing
  12. Inserting Graphical Horizontal Lines
  13. Adding Borders to Pictures
  14. Adding Table Borders
  15. Applying Shading Behind Content
4. Chapter 11 Revising Documents Using Markup Tools
  1. Benefits of an Organized Revision Process
  2. Familiarizing Yourself with Markup Tools
  3. Using the Highlight Tool
  4. Adding and Managing Comments Effectively
  5. Tracking Changes
  6. Comparing and Combining Documents
Excel
1. Chapter 12 How to Work a Worksheet and a Workbook
  1. Moving Around Regions
  2. Understanding Selection
  3. Techniques for Entering Data
  4. Managing Worksheets
  5. Viewing Worksheets
  6. Protecting Worksheets
  7. Managing Multiple Workbooks
  8. Opening Multiple Windows for the Same Workbook
  9. Hiding and Protecting Workbooks
2. Chapter 13 Building Formulas
  1. Formula Fundamentals
  2. Using Functions: A Preview
  3. Working with Formulas
  4. Worksheet Calculation
  5. Using Arrays
  6. Linking Workbooks
  7. Creating Conditional Tests
3. Chapter 14 Using Functions
  1. Using the Built-In Function Reference in Excel
  2. Exploring the Syntax of Functions
  3. Inserting Functions
  4. Understanding Mathematical Functions
  5. Understanding Text Functions
  6. Understanding Logical Functions
  7. Understanding Information Functions
  8. Understanding Lookup and Reference Functions
4. Chapter 15 Analyzing Data with PivotTable Reports
  1. Introducing PivotTables
  2. Creating a PivotTable
  3. Rearranging PivotTable Fields
  4. Refreshing a PivotTable
  5. Changing the Numeric Format of PivotTable Data
  6. Choosing Report Layout Options
  7. Formatting a PivotTable
  8. Displaying Totals and Subtotals
  9. Sorting PivotTable Fields
  10. Filtering PivotTable Fields
  11. Changing PivotTable Calculations
  12. Grouping and Ungrouping Data
  13. Displaying the Details Behind a Data Value
  14. Creating PivotCharts
PowerPoint
1. Chapter 16 Introduction to PowerPoint 2007
  1. Command Locations
  2. Customizing Office PowerPoint 2007
  3. File Formats
  4. Formatting
  5. PowerPoint 2007 Views
  6. Themes
  7. Tables
  8. Custom Slide Layouts
  9. PowerPoint 2007 Slide Libraries
  10. Program Recovery
2. Chapter 17 Working with Text
  1. Adding a Text Box to a Slide
  2. Finding and Replacing Words or Phrases
  3. Creating and Saving Customized Theme Fonts
  4. Formatting with WordArt
  5. Adding Punch to Your Bulleted Lists
  6. Writing on Slides During a Presentation
  7. Using Headers and Footers
  8. Working with Proofing Tools
3. Chapter 18 Working with Objects, Diagrams, and Charts in PowerPoint 2007
  1. Working with Pictures
  2. Adding Clip Art
  3. Using SmartArt
  4. Adding Sounds
  5. Including Movies
  6. Playing with Animations
  7. Animating SmartArt Graphics
  8. Creating Charts and Diagrams
4. Chapter 19 Collaborating and Sharing
  1. Using Templates
  2. Working with Windows SharePoint Services
  3. Reviewing, Approving, and Tracking Changes
  4. Protecting Your Document
  5. Securing Your Presentation
  6. Using the Document Inspector
5. Chapter 20 Working with External Data in PowerPoint 2007
  1. Working with Earlier Versions of PowerPoint
  2. Working with Excel 2007
  3. Working with Access 2007
  4. Blocking and Unblocking External Content
  5. Using Trusted Locations
  6. Setting Up Security Alerts and Trusted Publishers
6. Chapter 21 Setting Up and Presenting a Slide Show
  1. Learning the Basics
  2. Creating Custom Slide Shows
  3. Adding Transitions
  4. Using Presenter View
  5. Working with Photo Albums
  6. Exploring Printing Options
Outlook
1. Chapter 22 Introducing Outlook 2007
  1. A New Interface
  2. Instant Search
  3. Calendar Changes
  4. E-Mail Changes
  5. Color Categories
  6. Collaboration and Sharing Improvements
  7. Overview of Outlook 2007 Capabilities
  8. How Outlook Stores Data
  9. Understanding Messaging Protocols
  10. Security Provisions in Outlook
  11. Options for Starting Outlook
2. Chapter 23 Finding and Organizing Messages
  1. Finding and Organizing Messages with Search Folders
  2. Flagging and Monitoring Messages and Contacts
  3. Grouping Messages by Customizing the Folder View
  4. Filtering a View Using Categories
  5. Managing E-Mail Effectively
3. Chapter 24 Securing Your System, Messages, and Identity
  1. Configuring HTML Message Handling
  2. Protecting Messages with Digital Signatures
  3. Signing Messages
  4. Encrypting Messages
  5. Protecting Data with Information Rights Management
4. Chapter 25 Collaboration with Outlook and Windows SharePoint Services
  1. Understanding Windows SharePoint Services Collaboration
  2. Setting Up Alerts
  3. Working with Shared Documents
  4. Working with Shared Contacts
  5. Linking a Team Calendar to Outlook
  6. Configuring Alerts in Outlook
  7. Using Outlook to Work with SharePoint Libraries and Files
Access
1. Chapter 26 Exploring the New Look of Access 2007
  1. Opening Access for the First Time
  2. Getting Started—A New Look for Access
  3. Understanding Content Security
  4. Understanding the New Ribbon Feature
  5. Understanding the New Navigation Pane
  6. Using the Single-Document vs. Multiple-Document Interface
  7. Modifying Global Settings via the Access Options Dialog Box
2. Chapter 27 Creating Your Database and Tables
  1. Creating a New Database
  2. Creating Your First Simple Table by Entering Data
  3. Creating a Table Using a Table Template
  4. Creating a Table in Design View
  5. Defining Fields
  6. Defining a Primary Key
  7. Defining a Table Validation Rule
  8. Understanding Other Table Properties
  9. Defining Relationships
  10. Adding Indexes
  11. Setting Table Design Options
  12. Creating a Default Template for New Databases
  13. Printing a Table Definition
  14. Database Limitations
3. Chapter 28 Creating and Working with Simple Queries
  1. Selecting Data from a Single Table
  2. Testing Validation Rule Changes
  3. Working in Query Datasheet View
4. Chapter 29 Building a Form
  1. Forms and Object-Oriented Programming
  2. Starting from Scratch—A Simple Input Form
  3. Working with Quick Create Commands and the Form Wizard
  4. Simplifying Data Input with a Form
5. Chapter 30 Constructing a Report
  1. Starting from Scratch—A Simple Report
  2. Using the Report Command
  3. Using the Report Wizard
  4. Building a Report in Layout View
Microsoft Office Programming Primer
1. Chapter 31 VBA Primer
  1. When and Why to Use VBA
  2. Introduction to the VBA Language and Code Structure
  3. Understanding and Using the Visual Basic Editor
  4. Writing, Editing, and Sharing Simple Macros
  5. Using VBA to Save Time on Document Production and Troubleshooting
  6. Introduction to Using Events
  7. Creating UserForms (Dialog Boxes)
  8. Next Steps for Working with Automation in Microsoft Office
2. Chapter 32 Office Open XML Essentials
  1. Chapter Assumptions
  2. XML Basics for Reading Your Documents
  3. Getting to Know the Office Open XML Formats
  4. Editing and Managing Documents Through XML
  5. Customizing the Ribbon
  6. Binding Data to Content Controls
  7. Next Steps for Working with the Office Open XML Formats

Appendix Appendix: Installing and Configuring the 2007 Office System
1. Installing the Microsoft Office System from the CD
2. Changing Your 2007 Office System Setup
Appendix Index to Troubleshooting Topics
Appendix About the Authors
Appendix Choose the Right Book for You

Title:

2007 Microsoft® Office System Inside Out

By:

Microsoft Corporation

Publisher:

Microsoft Press

Formats:

Print
Ebook
Safari Books Online

Print:

March 2007

Ebook:

November 2009

Pages:

1312

Print ISBN:

978-0-7356-2324-8

| ISBN 10:

0-7356-2324-4

Ebook ISBN:

978-0-7356-9016-5

| ISBN 10:

0-7356-9016-2

Description

Table of Contents

Product Details

About the Author

Recommended for You

Chapter 1 Introduction

Who This Book Is For

How This Book Is Organized

Getting Started

Chapter 1 Overview of the 2007 Microsoft Office System

Chapter 2 The 2007 Office System User Interface: What’s Changed, What’s the Same

Chapter 3 Managing Security and Privacy in the 2007 Office System

Collaboration Essentials

Chapter 4 Collaborating and Sharing with Others

Chapter 5 Organizing and Finding Information in Microsoft Office OneNote

Chapter 6 Working as a Team in a Microsoft Office Groove Workspace

Chapter 7 Sharing and Communicating Using Microsoft Office Groove

Word

Chapter 8 Mastering Page Setup and Pagination

Chapter 9 Outlining Documents for Clarity and Structure

Chapter 10 Advanced Layout and Formatting

Chapter 11 Revising Documents Using Markup Tools

Excel

Chapter 12 How to Work a Worksheet and a Workbook

Chapter 13 Building Formulas

Chapter 14 Using Functions

Chapter 15 Analyzing Data with PivotTable Reports

PowerPoint

Chapter 16 Introduction to PowerPoint 2007

Chapter 17 Working with Text

Chapter 18 Working with Objects, Diagrams, and Charts in PowerPoint 2007

Chapter 19 Collaborating and Sharing

Chapter 20 Working with External Data in PowerPoint 2007

Chapter 21 Setting Up and Presenting a Slide Show

Outlook

Chapter 22 Introducing Outlook 2007

Chapter 23 Finding and Organizing Messages

Chapter 24 Securing Your System, Messages, and Identity

Chapter 25 Collaboration with Outlook and Windows SharePoint Services

Access

Chapter 26 Exploring the New Look of Access 2007

Chapter 27 Creating Your Database and Tables

Chapter 28 Creating and Working with Simple Queries

Chapter 29 Building a Form

Chapter 30 Constructing a Report

Microsoft Office Programming Primer

Chapter 31 VBA Primer

Chapter 32 Office Open XML Essentials

Appendix Appendix: Installing and Configuring the 2007 Office System

Installing the Microsoft Office System from the CD

Changing Your 2007 Office System Setup

Appendix Index to Troubleshooting Topics

Appendix About the Authors

Appendix Choose the Right Book for You

Microsoft Corporation

About O'Reilly

Community

More O'Reilly Sites

Partner Sites

Shop O'Reilly