Table of contents for Microsoft Office 2007 on demand / Steve Johnson.

Bibliographic record and links to related information available from the Library of Congress catalog.

Note: Contents data are machine generated based on pre-publication provided by the publisher. Contents may have variations from the printed book or be incomplete or contain other coding.


Counter
 vii
Contents
Introduction xvii
Getting Started with Office ?
Starting an Office Program ?
Viewing the Program Window ?
Using the Ribbon ?
Choosing Commands ?
Working with Toolbars ?
Choosing Dialog Box Options ?
Using the Status Bar ?
Creating a Blank Office Document ?
Creating a Document Using a Template ?
Opening an Existing Office Document ?
Converting an Existing Office Document ?
Using Task and Window Panes ?
Arranging Windows ?
Getting Help While You Work ?
Saving an Office Document ?
Saving an Office Document with Different Formats ?
Checking Compatibility ?
Documenting Properties ?
Switching Views ?
Getting Updates on the Web ?
Recovering an Office Document ?
Diagnosing and Repairing Problems ?
Closing a Document and Exiting Office ?
Using Shared Office Tools ?
Editing Text ?
Copying and Moving Text ?
Finding and Replacing Text ?
Correcting Text Automatically ?
Inserting Information the Smart Way ?
2
1
A02OF07a.qxd 10/20/2006 9:50 AM Page vii
Checking Spelling ?
Changing Proofing Options ?
Using Custom Dictionaries ?
Inserting Symbols ?
Finding the Right Words ?
Inserting Research Material ?
Translating Text to Another Language ?
Using Multiple Languages ?
Undoing and Redoing an Action ?
Zooming the View In and Out ?
Previewing a Document ?
Printing a Document ?
Creating a Template ?
Adding Art to Office Documents ?
Locating and Inserting Clip Art ?
Inserting a Picture ?
Adding a Quick Style to a Picture ?
Applying a Shape to a Picture ?
Applying a Border to a Picture ?
Applying Picture Effects ?
Modifying Picture Size ?
Compressing a Picture ?
Modifying Picture Brightness and Contrast ?
Recoloring a Picture ?
Cropping and Rotating a Picture ?
Scanning and Imaging Documents ?
Managing Pictures ?
Creating WordArt Text ?
Formatting WordArt Text ?
Applying WordArt Text Effects ?
Modifying WordArt Text Position ?
Creating SmartArt Graphics ?
Formatting a SmartArt Graphic ?
Modifying a SmartArt Graphic ?
Creating an Organization Chart ?
Modifying an Organization Chart ?
Inserting and Creating a Chart ?
Changing a Chart Type ?
Changing a Chart Layout and Style ?
Changing a Chart Titles ?
3
A02OF07a.qxd 10/20/2006 9:50 AM Page viii
Contents ix 
Changing a Chart Labels ?
Formatting Line and Bar Charts ?
Editing Chart Data ?
Saving a Chart Template ?
Adding Shapes to Office Documents ?
Drawing and Resizing Shapes ?
Adding Text to a Shape ?
Creating and Editing Freeforms ?
Copying and Moving Objects ?
Adding a Quick Style to a Shape ?
Adding a Quick Style to Shape Text ?
Applying Color Fills ?
Applying Picture Fills or Texture Fills ?
Applying Gradient Fills ?
Applying Shape Effects ?
Aligning and Distributing Objects ?
Aligning Objects to Grids or Guides ?
Changing Stacking Order ?
Rotating and Flipping a Shape ?
Grouping and Ungrouping Shapes ?
Selecting Objects Using the Selection Pane ?
Formatting Office Documents ?
Formatting Text for Emphasis ?
Revealing Formatting ?
Finding and Replacing Formatting ?
Changing Paragraph Alignment ?
Changing Line Spacing ?
Displaying Rulers ?
Setting Paragraph Tabs ?
Setting Paragraph Indents ?
Changing Character Spacing ?
Applying a Style ?
Creating and Modifying Styles ?
Creating Bulleted and Numbered Lists ?
Inserting New Pages and Sections ?
Adding Headers and Footers ?
Inserting Page Numbers and the Date and Time ?
Working with Templates ?
Hiding Text ?
5
4
A02OF07a.qxd 10/20/2006 9:50 AM Page ix
Creating a Document with Word ?
Viewing the Word Window ?
Creating a Document ?
Changing Views ?
Reading a Document ?
Moving Around in a Document ?
Setting Up the Page ?
Setting Up the Page Margins ?
Creating an Outline ?
Selecting Text ?
Checking Spelling and Grammar ?
Finding the Right Words ?
Inserting New Pages and Sections ?
Adding Headers and Footers ?
Inserting Page Numbers and the Date and Time ?
Previewing and Printing a Document ?
Formatting a Document with Word ?
Formatting Text for Emphasis ?
Revealing Formatting ?
Finding and Replacing Formatting ?
Changing Paragraph Alignment ?
Changing Line Spacing ?
Displaying Rulers ?
Setting Paragraph Tabs ?
Setting Paragraph Indents ?
Changing Character Spacing ?
Applying a Style ?
Creating and Modifying Styles ?
Creating Bulleted and Numbered Lists ?
Hiding Text ?
Enhancing a Document with Word ?
Adding Desktop Publishing Effects ?
Arranging Text in Columns ?
Creating a Table ?
Entering Text in a Table ?
Modifying a Table ?
Adjusting Table Cells ?
Formatting a Table ?
8
7
6
A02OF07a.qxd 10/20/2006 9:50 AM Page x
Contents xi 
Creating a Form Letter ?
Creating Labels ?
Addressing Envelopes and Labels ?
Inserting a Table of Contents ?
Creating Multiple Document Versions ?
Modifying the Document Summary ?
Protecting a Document ?
Creating a Worksheet with Excel ?
Viewing the Excel Window ?
Selecting Cells ?
Moving Around the Workbook ?
Entering Labels on a Worksheet ?
Entering Values on a Worksheet ?
Entering Values Quickly with AutoFill ?
Editing Cell Contents ?
Clearing Cell Contents ?
Inserting and Deleting Cell Contents ?
Selecting Rows, Columns, and Special Ranges ?
Selecting and Naming a Worksheet ?
Inserting and Deleting a Worksheet ?
Moving and Copying a Worksheet ?
Hiding and Unhiding Worksheets and Workbooks ?
Hiding and Unhiding a Column or Row ?
Inserting a Column or Row ?
Deleting a Column or Row ?
Adjusting Column Width and Row Height ?
Splitting a Worksheet into Panes ?
Freezing and Unfreezing a Column or Row ?
Showing and Hiding Workbook Elements ?
Building a Worksheet with Excel ?
Understanding Formulas ?
Understanding Cell Referencing ?
Creating a Simple Formula ?
Creating a Formula Using Formula AutoComplete ?
Editing a Formula ?
Naming Cells and Ranges ?
Entering Named Cells and Ranges ?
Managing Names ?
Simplifying a Formula with Ranges ?
10
9
A02OF07a.qxd 10/20/2006 9:50 AM Page xi
Calculating Totals with AutoSum ?
Correcting Formulas ?
Auditing a Worksheet ?
Creating Functions ?
Creating Functions Using the Library ?
Calculating Multiple Results ?
Using Nested Functions ?
Using Text Functions ?
Using Lookup and Reference Functions ?
Summarizing Data Using Subtotals ?
Summarizing Data Using Functions ?
Converting Text to Columns ?
Creating a Table ?
Formatting a Table ?
Formatting Table Elements ?
Creating Calculations in a Table ?
Removing Table Rows and Columns ?
Working with Tables ?
Sorting Data in a Table ?
Displaying Parts of a Table with AutoFilter ?
Creating Custom Searches ?
Creating Groups and Outlines ?
Adding Data Validation to a Worksheet ?
Creating a Drop-Down List ?
Designing a Worksheet with Excel ?
Applying and Creating Cell Styles ?
Applying Conditional Formatting ?
Applying Specialized Conditional Formatting ?
Creating Conditional Formatting ?
Controlling Text Flow ?
Formatting Tabs and Background ?
Adding Borders to Cells ?
Setting Up the Page ?
Adjusting Page Margins ?
Adding Headers and Footers ?
Inserting Page Breaks ?
Customizing Worksheet Printing ?
Setting the Print Area ?
Creating a Presentation with PowerPoint ? 12
11
A02OF07a.qxd 10/20/2006 9:50 AM Page xii
Contents xiii 
Viewing the PowerPoint Window ?
Browsing a Presentation ?
Understanding PowerPoint Views ?
Creating Consistent Slides ?
Entering and Deleting Text ?
Aligning and Spacing Text ?
Modifying Page Setup ?
Developing a Outline ?
Controlling Slide Appearance with Masters ?
Adding Color and Effects to an Object ?
Creating a Text Box ?
Aligning and Arranging Objects ?
Inserting Slides from Other Presentations ?
Inserting a Table ?
Inserting and Playing Movies and Sound ?
Delivering a Presentation with PowerPoint ?
Creating Slide Transitions ?
Adding Animation ?
Using Specialized Animations ?
Timing a Presentation ?
Setting Up a Slide Show ?
Creating a Custom Slide Show ?
Starting a Slide Show ?
Navigating a Slide Show ?
Annotating a Slide Show ?
Adding a Header and a Footer ?
Preparing Speaker Notes and Handouts ?
Previewing and Printing a Presentation ?
Packaging a Presentation CD ?
Creating a Database with Access ?
Understanding How Databases Store Data ?
Creating a Database ?
Stepping Through a Database Wizard ?
Viewing the Access Window ?
Viewing Database Objects ?
Working with Database Objects ?
Planning Tables ?
Creating a Table by Entering Data ?
Creating a Table Using a Wizard ?
14
13
A02OF07a.qxd 10/20/2006 9:50 AM Page xiii
Working with a Table ?
Specifying Data Types and Field Properties ?
Changing Field Properties ?
Creating Input Masks ?
Creating a Lookup Field ?
Planning Tables Relationships ?
Defining Tables Relationships ?
Ensuring Referential Integrity ?
Locating and Managing Data with Access ?
Sorting Records ?
Filtering Out Records ?
Creating Complex Filters Using Forms ?
Understanding the different Types of Queries ?
Creating a Query Using a Wizard ?
Creating a Query in Design View ?
Getting Information with a Query ?
Modifying Query in Design View ?
Performing Calculations in Queries ?
Summarizing Values with a Crosstab Query ?
Creating a Parameter Query ?
Finding Duplicate Fields ?
Identifying Object Dependencies ?
Backing Up a Database ?
Compacting and Repairing a Database ?
Presenting Data with Access ?
Creating a form ?
Working with a form in Design View ?
Entering and Editing Data in a Form ?
Modifying a Form in Design View ?
Creating a Report ?
Modifying a Report in Design View ?
Performing Calculations in Reports ?
Formatting a Form or Report ?
Aligning and Grouping controls ?
Creating a Data Access Page ?
Working with a Data Access Page in Design View ?
Formatting a Datasheet ?
Changing the Page Setup ?
Previewing and Printing Information ?
16
15
A02OF07a.qxd 10/20/2006 9:50 AM Page xiv
Contents xv 
Creating Mailing Labels ?
Communicating with Outlook ?
Preparing for Outlook ?
Using Outlook for the First Time ?
Viewing the Outlook Window ?
Using Outlook Today ?
Using the Navigation Pane ?
Viewing Items and Folders ?
Creating a Contact ?
Sorting Contacts ?
Creating a Distribution List ?
Creating and Addressing and E-Mail Message ?
Formatting Message Text ?
Attaching a File or Item to a Message ?
Using Stationery ?
Creating a Signature ?
Working with a Signature ?
Sending Messages ?
Receiving and Reading Messages ?
Flagging Messages ?
Replying to and Forwarding a Message ?
Finding and Filtering Messages ?
Organizing Messages in Folders ?
Managing Messages with Colors and Rules ?
Using Search Folders ?
Reducing Junk E-Mail and Spam ?
Archiving Messages ?
Setting Up Instant Messaging ?
Starting windows Messenger ?
Adding Contacts ?
Enabling Instant Messaging ?
Sending and receiving Instant Messages ?
Sending a File During an Instant Message ?
Managing Information with Outlook ?
Viewing the Calendar ?
Customizing the Calendar ?
Scheduling an Appointment and Event ?
Scheduling Meetings ?
Scheduling Meeting Resources ?
18
17
A02OF07a.qxd 10/20/2006 9:50 AM Page xv
Responding to Meeting Requests ?
Updating and Canceling Meeting Requests ?
Scheduling Online Meetings ?
Creating and Updating Tasks ?
Organizing Tasks ?
Assigning Tasks to Others ?
Monitoring Task Progress ?
Managing Tasks ?
Tracking Activities with Contacts ?
Recording Items in the Journal ?
Opening and Modifying Journal Entries ?
Organizing Items by Categories ?
Customizing How You View Items ?
Creating and Modifying Notes ?
Previewing Items form Outlook ?
Printing Items from Outlook ?
Creating a Publication with Publisher ?
Viewing the Publisher Window ?
Creating a Quick Publication ?
Creating a New Publication ?
Creating a Blank Publication ?
Changing Your View ?
Inserting and Deleting Pages ?
Creating a Web Site ?
Adding a Hot Spot Hyperlink ?
Applying Color ?
Adding Design Gallery Elements ?
Checking Your Design ?
Setting Up the Page ?
Using Commercial Printing Tools ?
Printing Publications ?
Designing a Publication with Publisher ?
Setting Up Layout Guides ?
Creating a Frame ?
Working with Text ?
Connecting Text Frames ?
Creating a Consistent Look ?
Creating Tables ?
Working with Pictures and Shapes ?
20
19
A02OF07a.qxd 10/20/2006 9:50 AM Page xvi
Contents xvii 
Wrapping Text Around an Object ?
Layering Objects ?
Grouping Objects Together ?
Aligning with Precision ?
Rotating and Flipping Objects ?
Publishing Office Documents on the Web ?
Opening a Web Page ?
Previewing a Web Page ?
Creating a Hyperlink ?
Adding Hyperlinks to Slide Objects ?
Formatting a Cell Hyperlink ?
Changing Web Page Options ?
Saving a Web Page ?
Publishing a Web Page ?
Saving Slides as Web Graphics ?
Creating Refreshable Web Queries ?
Getting Data from Web Queries ?
Saving Web Queries ?
Accessing Office Information on the Web ?
Getting Documents from the Web ?
Protecting and Securing a Workbook ??
Inspecting Documents ?
Protecting a Worksheet ?
Locking and Unlocking Worksheet Cells ?
Adding Security Encryption to a Document ?
Adding Password Protection to a Document ?
Restricting Document Access ?
Adding a Digital Signature ?
Adding a Signature Line ?
Avoiding Harmful Attacks ?
Using the Trust Center ?
Selecting Trusted Publishers and Locations ?
Setting Add-in Security Options ?
Setting ActiveX Security Options ?
Setting Macro Security Options ?
Changing Message Bar Security Options ?
Setting Privacy Options ?
Setting External Content Security Options ?
22
21
A02OF07a.qxd 10/20/2006 9:50 AM Page xvii
Working with Office Safe Modes ?
Marking a Document as Read-Only ?
Reviewing and Sharing Office Documents ?
Sharing Workbooks ?
Creating and Reading a Cell Comment ?
Editing and Deleting a Cell Comment ?
Adding Comments to a Presentation ?
Tracking Changes ?
Sending a Document for Review Using E-Mail ?
Sending a Document by Internet Fax ?
Working with XML ?
Creating an XML Data Map ?
Exporting and Saving Data in XML ?
Creating a PDF Document ?
Creating an XPS Document ?
Sharing Information Between Programs ?
Exporting and Importing Data ?
Linking and Embedding Files ?
Consolidating Data ?
Linking Data ?
Getting External Data ?
Managing Connections ?
Getting Query Data from a Database ?
Getting Data from Microsoft Access ?
Getting Text Data ?
Working with a Shared Workspace ?
Working with Excel Services ?
Publishing Slides to a Library ?
Saving a Document to a Document Management Server ?
Expanding Office Functionality ?
Viewing and Managing Add-ins ?
Loading and Unloading Add-ins ?
Enhancing a Workbook with VBA ?
Viewing the Visual Basic Editor ?
Setting Developer Options ?
Understanding How Macros Automate Your Work ?
Recording a Macro ?
Creating a Macro ?
Running a Macro ?
24
23
A02OF07a.qxd 10/20/2006 9:50 AM Page xviii
Contents xix 
Controlling a Macro ?
Adding a Digital Signature to a Macro Project ?
Assigning a Macro to a Toolbar ?
Saving a Workbook with Macros ?
Opening a Workbook with Macros ?
Inserting ActiveX Controls ?
Using ActiveX Controls ?
Setting ActiveX Control Properties ?
Adding VBA Code to an ActiveX Control ?
Playing a Movie Using an ActiveX Control ?
Changing the Document Information Panel ?
Microsoft Certified Applications Specialist ?
Index ?
A02OF07a.qxd 10/20/2006 9:50 AM Page xix
A02OF07a.qxd 10/20/2006 9:50 AM Page xx

Library of Congress Subject Headings for this publication:

Microsoft Office.
Business -- Computer programs.