List of Sidebars

Introduction

Aha!

Chapter 1: A First Look at the Microsoft Office System

Aha!Different Needs, Different Versions

Information Rights Management in the Office System

Aha!How Will You Use the Office System?

Launch Your Favorite ApplicationsFast

Aha!Easy Opening After First Use

Aha!Easily Modify Search Settings

Aha!Ask a Question, Get an Answer

Aha!Want to learn more about InfoPath?

Wondering about the Office Assistant?

You Know You Need Detect And Repair When . . .

Chapter 2: Working with Programs and Files

Aha!Adding Quickly

Aha!Launching Your Favorite Programs Quickly

Aha!Hiding Program Windows

Hiding the Taskbar

Aha!Enlarging the Current Window

Aha!Options for Opening

Working with Stackable Documents

Aha!Viewing Clipboard Contents

Internet Fax Services in the Office System

Aha!A File by Another Name

Extending Data Use with XML

Saving Office Documents as Web Pages

Chapter 3: Creating and Viewing Documents

Aha!Word Your Way

Aha!Display the Task Pane

Aha!Dont Forget Template Possibilities

Using AutoText

Remote Word on the Pocket PC

Aha!

Other Looks for Other Tasks

Aha!Managing Shared Documents

Aha!Fast Research

Chapter 4: Using the Editing Tools in Microsoft Office Word 2003

Aha!Whats another word for ...

Aha!Reversing AutoCorrect

Browsing by Object

Aha!Get More Smart Tags

Smart Documents and Microsoft Office InfoPath Possibilities

Aha!Selecting Multiple Paragraphs

Aha!Display Clipboard Contents

Understanding Paste Special

Aha!Just Find, Please

Special Find and Replace Considerations

Spelling and Grammar Options

Controlling Editable Areas

Aha!Keep It Simple

Aha!Choosing Your Balloons

Aha!Grant Permission to Specific Users

Chapter 5: Formatting in Microsoft Word

Aha!Dont Forget Templates

More Changes in the Font Dialog Box

Aha!Adding Fonts

Aha!Changing Indents on the Ruler

Page Margins: A Different Matter

Aha!Changing Line Spacing Quickly

Aha!Setting Global Tabs

Aha!Add a Picture Bullet

Aha!Create Your Own Table Formats

Where Do You Want Columns?

Aha!Columns of Unequal Widths

Aha!Replacing Styles Globally

Chapter 6: Special Tasks in Microsoft Office Word 2003

Aha!Viewing Section Breaks

Aha!Expanding and Viewing Headers

A Quick Look at the Microsoft Clip Organizer

Aha!Getting More Clips Online

Introducing the Picture Manager

Aha!Choosing Styles for Diagrams

Aha!Hyperlink Options

Aha!Where Do You Get a Schema?

Chapter 7: Creating and Saving a Spreadsheet

Aha!Creating a Workbook from a Template

Aha!Entering Labels Automatically

Aha!Having Excel Read Back Worksheet Values

Aha!Moving to Cells Quickly

Aha!Fast Range Names

Aha!When Youre Comfortable with Formulas

Aha!Another Way to Share Workbooks

Aha!Creating a Schema from a Data File

Aha!Changing XML Properties

Chapter 8: Editing, Formatting, and Printing Spreadsheets

Aha!The Fastest Ways to Format

Aha!Commenting on Worksheets

Aha!Setting Error Checking Options

Clearing vs. Deleting Data

Aha!Resize Columns and Rows Quickly

Aha!Inserting Multiple Columns and Rows

NoteUnhiding Columns

Aha!Color-Coding Worksheet Tabs

Aha!Formatting Conditionally

Aha!Using Formatting Tools

Limiting Changes with Rights Management

Shading Worksheet Areas

Aha!Filling Quickly with Color

Aha!Adding Headers and Footers

Faxing from Excel

Chapter 9: Charting Spreadsheet Data

Creating Effective Charts

Aha!Customizing Data Series

Aha!Changing Charts After the Fact

Aha!Working with the Chart Toolbar

Aha!Fixing Crowded Chart Labels

Chapter 10: Creating a PresentationFrom Start to Finish

NoteFeeling Creative?

Aha!For Notetakers

To Master or Not to Master

Aha!More Room, Please

Aha!The New Presentation Task Pane

Aha!Seeing Them All

Aha!OopsI Wanted That

Changing Page Layout

Aha!Changing Chart Type

Importing Chart Data

Aha!Searching for Art

Aha!Changing Fonts

Change the Slide Background

Aha!Making Global Text Changes

From Color to Grayscale

Aha!Annotating Slides

Aha!Switching Among Programs

Package to CD

Things to Watch for in Web Preview

Chapter 11: Animating and Timing Your Presentation

Aha!Adding Animation Effects to Multiple Slides

Aha!Using Both Manual and Automatic Advance

Aha!Using Apply To All Slides

Aha!A Final Run-Through

Chapter 12: Enhancing Your Presentations

Aha!Using Your Resources

Aha!Adding Movies by Clicking

Aha!Adding a Custom Clip

Capturing Your Own Movies

Display Movies Full-Screen

Aha!Checking Out Sound Properties

Managing Recordings

Collaborating Online

Chapter 13: E-Mailing with Microsoft Office Outlook 2003

Outlook 2003 with Business Contact Manager

Aha!Changing the Look of Message Text

Aha!Using Your Contacts

Aha!Checking Your Spelling Quickly

Aha!Attaching a File Fast

Aha!Printing Multiple Messages at the Same Time

Chapter 14: Organizing with Microsoft Office Outlook 2003

Aha!Viewing Multiple Accounts

Aha!Advanced Rules

Aha!More Alerts

Aha!Faster Flagging

Blocking HTML Content

Aha!Clearing Deleted Items Automatically

Aha!Cleaning Up Your Mailbox

Where Does the Address Book Fit In?

More Data! More Data!

Aha!Find Names Fast

Aha!Printing Selected Entries

Outlook with Business Contact Manager

Aha!Fast Task Entry

Introducing Microsoft Office OneNote

Chapter 15: Scheduling with Microsoft Office Outlook 2003

Aha!Quickly Changing an Appointment

Canceling a Repeating Appointment

Aha!Record Your Own

Setting Your Schedule

Aha!The Big Event

Chapter 16: Getting Started with Databases

Aha!More Than Words

Aha!Picture Data

Aha!Using the Switchboard

Aha!Adding Fields Quickly

Aha!Inserting a Field After the Fact

More Than One Way to Create a Table

Navigating Forms

Aha!Entering Data in Datasheet View

Aha!Transforming Your XML Data

Aha!Customized Forms

Aha!Last Minute Changes

Chapter 17: Working with Your Data

Aha!Search Everywhere

Aha!If Appearances Are Deceiving ...

And Dont Forget Replace

Aha!Getting Rid of Unwanted Filters

Aha!Use Queries for Repeat Procedures

Aha!Delete Unnecessary Queries

More Fun with Queries

Chapter 18: Preparing and Printing Reports in Microsoft Office Access 2003

Aha!Everything, Please

Aha!Data Remains Intact

Chapter 19: FrontPage 2003 Basics

Where Will Your Web Site Go?

Aha!A Quick Look at Pages

FrontPage and SharePoint Team Services

Web Lingo

Aha!Copy and Paste into FrontPage

Aha!Limiting Graphics

Aha!Test in Different Browsers

Aha!Add a Photo Gallery

Aha!Showcase Your Services

Aha!Adding Browsers

Aha!From Web to Print

Chapter 20: Microsoft Office FrontPage 2003 Special Tasks

Aha!Add an Invisible Table

Aha!Preview in Multiple Browsers

Aha!Add Custom Lines Quickly

Aha!Choose a Border Alternative

Aha!Bone Up on HTML

Chapter 21: Publishing Your Pages

Aha!Check Your Links

Aha!Update Your Site

Appendix D: The Microsoft Office System: The Big Picture

The Office System: Top 12 Things You Need to Know

IRM: Quick Facts

Aha!Correcting Images Fast with Auto Correct