List of Sidebars

Conventions and Features Used in This Book

Sidebars

Chapter 1: Overview of the 2007 Microsoft Office System

Rounding Out the Office System Programs

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

Keyboard Shortcuts in the 2007 Office Release

Chapter 3: Managing Security and Privacy in the 2007 Office System

Content from the Outside

Don’t Forget Security Updates

Digitally Signing a Macro Project

Additional Privacy Options for Word

What IRM Won’t Do for You

Chapter 4: Collaborating and Sharing with Others

Small Business or Individual? Go Live.

Chapter 5: Organizing and Finding Information in Microsoft Office OneNote

OneNote Options

Sharing Audio or Video Recordings

OneNote Calculations

Entering Information with a Pen

Storing Shared Notebooks on a Windows SharePoint Services Site

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

Why You Need a Groove Account

About Groove Security

Navigating Together

Ways to List Workspaces in the Workspace List

Chapter 7: Sharing and Communicating Using Microsoft Office Groove

Using a Subfolder as a File-Sharing Workspace

Integrating Windows Messenger and Groove

Contact-Naming Conflicts

Chapter 8: Mastering Page Setup and Pagination

Binding Documents

Creating a Page or Section Border

Working with Field Codes in Headers and Footers

Making Room for Line Numbers

Chapter 9: Outlining Documents for Clarity and Structure

Forget What’s on the Clipboard?

Chapter 10: Advanced Layout and Formatting

Including Watermarks in Document Headers

Converting a Frame to a Text Box

Chapter 11: Revising Documents Using Markup Tools

Inserting Voice and Handwritten Comments

Comments, Revisions, and the Document Inspector

Chapter 12: How to Work a Worksheet and a Workbook

Navigating Multiple Selections

Go To Special Keyboard Shortcuts

Smart Tags

Dragging Worksheets Between Workbooks

Chapter 13: Building Formulas

Practical Concatenation

Rules for Naming

Troubleshooting

Selecting Cells While a Dialog Box Is Open

No More Natural-Language Formulas

Are Your References Qualified?

Multithreaded Calculation

A Single-Cell Array Formula Application

Chapter 14: Using Functions

Automatic Range Expansion

A MOD Example

Try Your Luck

Using the Flexible MROUND Function

AVERAGE vs. AVG

An ISERR Example

Chapter 16: Introduction to PowerPoint 2007

Data That Could Be Lost or Changed in PowerPoint 2007

Double Design Tabs?

Before Publishing to a Slide Library, Read This

Chapter 17: Working with Text

Add the Same Effect to Text in Multiple Places

Working with the SmartArt Text Pane

Slow Performance and Contextual Spelling

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

Sizing Photos

Add Clips to Your Clip Organizer

Chapter 19: Collaborating and Sharing

Working with Office Groove 2007

What IRM Can-and Can’t-Do

Preventing Changes Using the Mark As Final Command

Chapter 20: Working with External Data in PowerPoint 2007

Multimedia Formats

Chapter 21: Setting Up and Presenting a Slide Show

Slide Size and Orientation

Chapter 27: Creating Your Database and Tables

Choosing Field Names

Nulls and Zero-Length Strings

Chapter 28: Creating and Working with Simple Queries

Understanding Field Names and Captions

Chapter 29: Building a Form

Some Key Form Design Terms

Chapter 31: VBA Primer

Setting Up the Sample Document