Office 2007 All-in-One Desk Reference For Dummies

by Weverka, Peter

• ISBN13: 9780471782797
• ISBN10: 0471782793
• Edition: 1st
• Format: Paperback
• Copyright: 2007-01-03
• Publisher: For Dummies

Summary

Revised and updated to cover changes to all of Office's applications and productivity tools Offers beyond-the-basics coverage of Office word processing, spreadsheets, presentations, e-mail, databases, and desktop publishing Covers Word, Excel, Access, PowerPoint, Outlook, Publisher, productivity tools such as Microsoft OneNote, and SharePoint Thoroughly updated to cover the new Office interface as well as new features in each application

Author Biography

Peter Weverka is the bestselling author of several For Dummies books, including PowerPoint 2007 All-in-One Desk Reference For Dummies and Microsoft Money For Dummies, as well as 30 other computer books about various topics. Peter’s humorous articles and stories — none related to computers, thankfully — have appeared in Harper’s, SPY, The Argonaut, and other magazines for grown-ups.

Table of Contents

Introduction	1	(1)
What's in This Book, Anyway?	1	(1)
What Makes This Book Different	2	(1)
Easy-to-look-up information	2	(1)
A task-oriented approach	3	(1)
Meaningful screen shots	3	(1)
Foolish Assumptions	3	(1)
Conventions Used in This Book	4	(1)
Icons Used in This Book	4	(1)
Good Luck, Reader!	5	(2)
Book I: Common Office Tools	7	(170)
Office Nuts and Bolts	9	(26)
A Survey of Office Programs	9	(1)
Starting an Office Program	10	(2)
Finding Your Way around the New Office Interface	12	(9)
The Office button	13	(1)
The Quick Access toolbar	13	(1)
The Ribbon and its tabs	14	(1)
Context-sensitive tabs	15	(1)
The anatomy of a tab	16	(3)
Live previewing	19	(1)
Mini Toolbars	19	(2)
Office 2007 for keyboard lovers	21	(1)
Saving Your Files	21	(5)
Declaring where you like to save files	22	(1)
Saving files for use in earlier versions of an Office program	23	(1)
Saving AutoRecovery information	24	(2)
Opening and Closing Files	26	(3)
Opening a file	26	(3)
Closing a file	29	(1)
Entering the Document Properties	29	(1)
Understanding the New Office XML Format	30	(1)
Locking a File with a Password	31	(4)
Password-protecting a file	31	(2)
Opening a file that requires a password	33	(1)
Removing a password from a file	33	(2)
Wrestling with the Text	35	(26)
Manipulating the Text	35	(3)
Selecting text	35	(1)
Moving and copying text	36	(1)
Taking advantage of the Clipboard task pane	36	(2)
Deleting text	38	(1)
Changing the Look of Text	38	(8)
Choosing fonts for text	39	(3)
Changing the font size of text	42	(1)
Applying font styles to text	42	(1)
Applying text effects to text	43	(2)
Underlining text	45	(1)
Changing the color of text	45	(1)
Quick Ways to Handle Case, or Capitalization	46	(2)
Entering Symbols and Foreign Characters	48	(1)
Finding and Replacing Text	49	(7)
Finding stray words and formats	49	(6)
Conducting a find-and-replace operation	55	(1)
Creating Hyperlinks	56	(5)
Linking a hyperlink to a Web page	56	(2)
Creating a hyperlink to another place in your file	58	(1)
Creating an e-mail hyperlink	59	(1)
Repairing and removing hyperlinks	59	(2)
Speed Techniques Worth Knowing About	61	(8)
Undoing and Repeating Commands	61	(2)
Undoing a mistake	61	(1)
Repeating an action --- and quicker this time	62	(1)
Zooming In, Zooming Out	63	(1)
Viewing a File through More Than One Window	64	(1)
Correcting Typos on the Fly	64	(3)
Opening the AutoCorrect dialog box	65	(1)
Telling Office which typos and misspellings to correct	66	(1)
Preventing capitalization errors with AutoCorrect	66	(1)
Entering Text Quickly with the AutoCorrect Command	67	(2)
Taking Advantage of the Proofing Tools	69	(18)
Correcting Your Spelling Errors	69	(7)
Correcting misspellings one at a time	70	(1)
Running a spell-check	70	(2)
Fine-tuning the spell checker	72	(4)
Checking for Grammatical Errors in Word	76	(1)
Researching a Topic inside an Office Program	77	(3)
Using the Research task pane	78	(2)
Choosing your research options	80	(1)
Finding the Right Word with the Thesaurus	80	(2)
Proofing Text Written in a Foreign Language	82	(1)
Telling Office which languages you will use	82	(1)
Marking text as foreign language text	83	(1)
Translating Foreign Language Text	83	(4)
Creating a Table	87	(20)
Talking Table Jargon	87	(1)
Creating a Table	88	(2)
Entering the Text and Numbers	90	(1)
Selecting Different Parts of a Table	91	(1)
Aligning Text in Columns and Rows	91	(1)
Merging and Splitting Cells	91	(2)
Laying Out Your Table	93	(4)
Changing the size of a table, columns, and rows	93	(3)
Inserting and deleting columns and rows	96	(1)
Moving columns and rows	96	(1)
Formatting Your Table	97	(3)
Designing a table with a table style	97	(1)
Calling attention to different rows and columns	98	(1)
Decorating your table with borders and colors	98	(2)
Using Math Formulas in Word Tables	100	(1)
Neat Table Tricks	101	(6)
Changing the direction of header row text	101	(1)
Using a picture as the table background	102	(2)
Drawing diagonal lines on tables	104	(1)
Drawing on a table	105	(2)
Creating a Chart	107	(22)
A Mercifully Brief Anatomy Lesson	107	(2)
The Basics: Creating a Chart	109	(2)
Choosing the Right Chart	111	(1)
Providing the Raw Data for Your Chart	112	(1)
Positioning Your Chart in a Workbook, Page, or Slide	113	(1)
Changing a Chart's Appearance	114	(8)
Changing the chart type	114	(1)
Changing the size and shape of a chart	115	(1)
Relying on a chart style to change appearances	115	(1)
Changing the layout of a chart	116	(3)
Handling the gridlines	119	(1)
Changing a chart element's color, font, or other particular	120	(2)
Saving a Chart as a Template so You Can Use It Again	122	(1)
Saving a chart as a template	122	(1)
Creating a chart from a template	123	(1)
Chart Tricks for the Daring and Heroic	123	(4)
Decorating a chart with a picture	123	(2)
Annotating a chart	125	(1)
Displaying the raw data alongside the chart	126	(1)
Creating an overlay chart	126	(1)
Troubleshooting a Chart	127	(2)
Making a SmartArt Diagram	129	(22)
The Basics: Creating SmartArt Diagrams	129	(2)
Creating the Initial Diagram	131	(2)
Creating a diagram	132	(1)
Swapping one diagram for another	133	(1)
Changing the Size and Position of a Diagram	133	(1)
Laying Out the Diagram Shapes	134	(7)
Selecting a diagram shape	134	(1)
Removing a shape from a diagram	135	(1)
Adding shapes to diagrams apart from hierarchy diagrams	135	(1)
Adding shapes to hierarchy diagrams	136	(5)
Promoting and demoting shapes in hierarchy diagrams	141	(1)
Handling the Text on Diagram Shapes	141	(3)
Entering text on a shape	142	(1)
Entering text in a diagram shape you added	143	(1)
Entering bulleted lists on diagram shapes	144	(1)
Changing a Diagram's Direction	144	(1)
Choosing a Look for Your Diagram	145	(1)
Changing the Appearance of Diagram Shapes	146	(3)
Changing the size of a diagram shape	146	(1)
Exchanging one shape for another	146	(1)
Changing a shape's color, fill, or outline	147	(1)
Changing fonts and font sizes on shapes	148	(1)
Creating a Diagram from Scratch	149	(2)
Drawing and Manipulating Lines, Shapes, and Other Objects	151	(26)
The Basics: Drawing Lines, Arrows, and Shapes	152	(1)
Handling Lines, Arrows, and Connectors	153	(5)
Changing the length and position of a line or arrow	154	(1)
Changing the appearance of a line, arrow, or connector	154	(1)
Attaching and handling arrowheads on lines and connectors	155	(1)
Connecting shapes by using connectors	156	(2)
Handling Rectangles, Ovals, Stars, and Other Shapes	158	(3)
Drawing a shape	158	(2)
Changing a shape's symmetry	160	(1)
Using a shape as a text box	160	(1)
WordArt for Bending, Spindling, and Mutilating Text	161	(1)
Creating a WordArt image	162	(1)
Editing a WordArt image	162	(1)
Manipulating Lines, Shapes, Art, Text Boxes, and Other Objects	162	(11)
Selecting objects so that you can manipulate them	164	(1)
Hiding and displaying the rulers and grid	164	(1)
Changing an object's size and shape	165	(1)
Moving and positioning objects	166	(1)
Tricks for aligning and distributing objects	166	(3)
When objects overlap: Choosing which appears above the other	169	(2)
Rotating and flipping objects	171	(1)
Grouping objects to make working with them easier	172	(1)
Changing an Object's Color, Outline Color, and Transparency	173	(4)
Filling an object with a color, picture, or texture	174	(1)
Making a color transparent	175	(1)
Putting the outline around an object	175	(2)
Book II: Word 2007	177	(110)
Speed Techniques for Using Word	179	(16)
Introducing the Word Screen	179	(2)
Creating a New Document	181	(2)
Getting a Better Look at Your Documents	183	(3)
Viewing documents in different ways	183	(2)
Splitting the screen	185	(1)
Selecting Text in Speedy Ways	186	(1)
Moving Around Quickly in Documents	187	(4)
Keys for getting around quickly	187	(1)
Clicking thumbnail pages	188	(1)
``Browsing'' around a document	188	(1)
Going there fast with the Go To command	189	(1)
Hopping from place to place in the document map	190	(1)
Bookmarks for hopping around	190	(1)
Inserting a Whole File into a Document	191	(1)
Entering Information Quickly in a Computerized Form	192	(3)
Creating a computerized form	192	(2)
Entering data in the form	194	(1)
Laying Out Text and Pages	195	(22)
Paragraphs and Formatting	195	(1)
Inserting a Section Break for Formatting Purposes	196	(2)
Breaking a Line	198	(1)
Starting a New Page	198	(1)
Setting Up and Changing the Margins	198	(2)
Indenting Paragraphs and First Lines	200	(2)
Clicking an Indent button (for left-indents)	200	(1)
``Eye-balling it'' with the ruler	201	(1)
Going to the Paragraph dialog box	202	(1)
Numbering the Pages	202	(3)
Using ``prefabricated'' page numbers	203	(1)
Including a page number in a header or footer	204	(1)
Changing page number formats	204	(1)
Putting Headers and Footers on Pages	205	(3)
Creating, editing, and removing headers and footers	206	(1)
Fine-tuning a header or footer	207	(1)
Adjusting the Space between Lines	208	(1)
Adjusting the Space between Paragraphs	209	(1)
Creating Numbered and Bulleted Lists	210	(2)
Simple numbered and bulleted lists	210	(1)
Constructing lists of your own	210	(2)
Managing a multilevel list	212	(1)
Working with Tabs	212	(2)
Hyphenating a Document	214	(3)
Automatically and manually hyphenating a document	215	(1)
Unhyphenating and other hyphenation tasks	216	(1)
Word Styles	217	(14)
All about Styles	217	(2)
Applying a Style to Text and Paragraphs	219	(3)
Experimenting with style sets	219	(1)
Applying a style	219	(2)
Choosing which style names appear on the Style menus	221	(1)
Creating a New Style	222	(2)
Creating a style from a paragraph	222	(1)
Creating a style from the ground up	222	(2)
Modifying a Style	224	(1)
Creating and Managing Templates	225	(6)
Creating a new template	226	(1)
Deleting and renaming styles in templates	227	(1)
Copying styles from different documents and templates	227	(4)
Desktop Publishing with Word	231	(18)
Making Use of Charts, Diagrams, Shapes, Clip Art, and Photos	231	(1)
Constructing the Perfect Table	232	(3)
Repeating heading rows on subsequent pages	233	(1)
Turning a list into a table	233	(2)
Positioning and Wrapping Objects Relative to the Page and Text	235	(2)
Wrapping text around an object	235	(1)
Positioning an object on a page	236	(1)
Working with the Drawing Canvas	237	(1)
Choosing a Theme for Your Document	238	(1)
Putting Newspaper-Style Columns in a Document	239	(2)
Working with Text Boxes	241	(1)
Inserting a text box	241	(1)
Making text flow from text box to text box	242	(1)
Decorating a Page with a Border	242	(2)
Dropping In a Drop Cap	244	(1)
Watermarking for the Elegant Effect	245	(1)
Landscape Documents	246	(1)
Printing on Different Size Paper	247	(2)
Getting Word's Help with Office Chores	249	(18)
Highlighting Parts of a Document	249	(1)
Commenting on a Document	250	(2)
Entering a comment	250	(1)
Caring for and feeding comments	251	(1)
Tracking Revisions to Documents	252	(5)
Telling Word to start marking revisions	253	(1)
Telling Word how to mark revisions	253	(1)
Reading and reviewing a document with revision marks	254	(1)
Marking changes when you forgot to turn on revision marks	255	(1)
Accepting and rejecting revisions to a document	256	(1)
Printing an Address on an Envelope	257	(2)
Printing a Single Address Label (or a Page of the Same Label)	259	(1)
Churning Out Letters, Labels, and Envelopes for Mass Mailings	260	(7)
Preparing the source file	261	(1)
Merging the source file with the document	262	(4)
Printing form letters, labels, and envelopes	266	(1)
Tools for Reports and Scholarly Papers	267	(20)
Alphabetizing a List	267	(1)
Outlines for Organizing Your Work	268	(2)
Viewing your document in different ways	269	(1)
Rearranging document sections in Outline view	269	(1)
Generating a Table of Contents	270	(3)
Creating a TOC	270	(2)
Updating and removing a TOC	272	(1)
Customizing a TOC	272	(1)
Changing the structure of a TOC	272	(1)
Indexing a Document	273	(5)
Marking index items in the document	275	(1)
Generating the index	276	(2)
Editing an index	278	(1)
Putting Cross-References in a Document	278	(2)
Putting Footnotes and Endnotes in Documents	280	(3)
Entering a footnote or endnote	281	(1)
Choosing the numbering scheme and position of notes	282	(1)
Deleting, moving, and editing notes	283	(1)
Compiling a Bibliography	283	(4)
Inserting a citation for your bibliography	284	(1)
Editing a citation	285	(1)
Changing how citations appear in text	285	(1)
Generating the bibliography	286	(1)
Book III: Outlook 2007	287	(80)
Getting Acquainted with Outlook	289	(16)
What Is Outlook, Anyway?	289	(1)
Navigating the Outlook Folders	290	(2)
Wrestling with the Navigation Pane and To-Do Bar	292	(1)
Getting a Better View of Items in a Folder	292	(2)
Categorizing Items	294	(2)
Creating a category	294	(1)
Assigning items to categories	295	(1)
Arranging items by category in folders	295	(1)
Finding Stray Folder Items	296	(2)
Deleting E-Mail Messages, Contacts, Tasks, and Other Items	298	(1)
Finding and Backing Up Your Outlook File	298	(2)
Importing E-Mail and Addresses from Another Program	300	(1)
Cleaning Out Your Folders	301	(4)
Archiving the old stuff	301	(2)
Running the Mailbox Cleanup command	303	(2)
Maintaining the Contacts Folder	305	(10)
Maintaining a Happy and Healthy Contacts Folder	305	(3)
Entering a new contact in the Contacts folder	306	(2)
Changing a contact's information	308	(1)
Finding a Contact in the Contacts Folder	308	(2)
Printing the Contacts Folder	310	(5)
Different ways to print contact information	311	(1)
The basics of printing contact information	311	(1)
Changing the look of printed pages	312	(3)
Handling Your E-Mail	315	(34)
Addressing and Sending E-Mail Messages	315	(13)
The basics: Sending an e-mail message	316	(2)
Addressing an e-mail message	318	(1)
Sending copies and blind copies of messages	319	(2)
Replying to and forwarding e-mail messages	321	(1)
Distribution lists for sending messages to groups	322	(3)
Sending a file along with a message	325	(1)
Including a picture in an e-mail message	325	(1)
Choosing which account to send messages with	326	(1)
Postponing sending a message	327	(1)
Being Advised When Someone Has Read Your E-Mail	328	(1)
All about Message Formats	329	(2)
Receiving E-Mail Messages	331	(4)
Getting your e-mail	331	(1)
Being notified that e-mail has arrived	332	(1)
Reading your e-mail in the Inbox window	332	(3)
Handling Files That Were Sent to You	335	(2)
Techniques for Organizing E-Mail Messages	337	(5)
Flagging e-mail messages	338	(1)
Being reminded to take care of e-mail messages	339	(2)
Earmarking messages as they arrive	341	(1)
All about E-Mail Folders	342	(2)
Moving e-mail messages to different folders	343	(1)
Creating a new folder for storing e-mail	343	(1)
Yes, You Can Prevent Junk Mail (Sort of)	344	(5)
Getting Outlook's help to prevent junk e-mail	345	(1)
Preventative medicine for junk e-mail	346	(3)
Managing Your Time and Schedule	349	(10)
Introducing the Calendar	349	(1)
The Different Kinds of Activities	350	(1)
Going to a Different Day, Week, or Month	351	(2)
Scheduling an Activity	353	(2)
Scheduling an activity: The basics	353	(1)
Scheduling a recurring appointment or event	354	(1)
Scheduling an event	355	(1)
Canceling, Rescheduling, and Altering Activities	355	(1)
Getting a Better View of Your Schedule	356	(1)
Customizing the Outlook Calendar Window	357	(2)
Tasks, Reminders, and Notes	359	(8)
Tasks: Seeing What Needs to Get Done	359	(3)
Entering a task in the Tasks window	360	(1)
Examining tasks in the Tasks window	361	(1)
Handling and managing tasks	362	(1)
Reminders for Being Alerted to Activities and Tasks	362	(2)
Scheduling a reminder message	363	(1)
Making reminders work your way	364	(1)
Making Notes to Yourself	364	(3)
Book IV: PowerPoint 2007	367	(88)
Getting Started in PowerPoint	369	(24)
Getting Acquainted with PowerPoint	370	(1)
A Brief Geography Lesson	370	(3)
A Whirlwind Tour of PowerPoint	373	(1)
Creating a New Presentation	373	(2)
Advice for Building Persuasive Presentations	375	(3)
Creating New Slides for Your Presentation	378	(5)
Inserting a new slide	378	(3)
Speed techniques for inserting slides	381	(1)
Conjuring slides from Word document headings	381	(2)
Selecting a different layout for a slide	383	(1)
Getting a Better View of Your Work	383	(2)
Changing views	383	(1)
Looking at the different views	383	(2)
Hiding and Displaying the Slides Pane and Notes Pane	385	(1)
Selecting, Moving, and Deleting Slides	385	(1)
Selecting slides	385	(1)
Moving slides	386	(1)
Deleting slides	386	(1)
Putting Together a Photo Album	386	(4)
Creating your photo album	387	(2)
Putting on the final touches	389	(1)
Editing your photo album	390	(1)
Hidden Slides for All Contingencies	390	(3)
Hiding a slide	390	(1)
Showing a hidden slide during a presentation	390	(3)
Fashioning a Look for Your Presentation	393	(16)
Looking at Themes and Background Styles	393	(2)
Choosing a Theme for Your Presentation	395	(2)
Selecting a theme	395	(1)
Tweaking a theme	395	(2)
Creating Slide Backgrounds on Your Own	397	(6)
Using a solid (or transparent) color for the slide background	397	(1)
Selecting a gradient blend of two colors for the slide background	398	(2)
Placing a clip-art image in the slide background	400	(1)
Using a graphic for a slide background	401	(1)
Using a texture for a slide background	402	(1)
Changing the Background of a Single or Handful of Slides	403	(1)
Using Master Slides and Master Styles for a Consistent Design	404	(5)
Switching to Slide Master view	405	(1)
Understanding master slides and master styles	406	(1)
Editing a master slide	407	(1)
Changing a master slide layout	407	(2)
Entering the Text	409	(16)
Entering Text	409	(3)
Choosing fonts for text	410	(1)
Changing the font size of text	411	(1)
Changing the color of text	411	(1)
Fun with Text Boxes and Text Box Shapes	412	(2)
Controlling How Text Fits in Text Frames and Text Boxes	414	(3)
Choosing how PowerPoint ``AutoFits'' text in text frames	414	(2)
Choosing how PowerPoint ``AutoFits'' text in text boxes	416	(1)
Positioning Text in Frames and Text Boxes	417	(1)
Handling Bulleted and Numbered Lists	418	(2)
Creating a standard bulleted or numbered list	418	(1)
Choosing a different bullet character, size, and color	419	(1)
Choosing a different list-numbering style, size, and color	420	(1)
Putting Footers (and Headers) on Slides	420	(5)
Some background on footers and headers	421	(1)
Putting a standard footer on all your slides	422	(1)
Creating a nonstandard footer	422	(1)
Removing a footer from a single slide	423	(2)
Making Your Presentations Livelier	425	(12)
Suggestions for Enlivening Your Presentation	425	(2)
Transitions and Animations	427	(3)
Showing transitions between slides	427	(1)
Animating parts of a slide	428	(2)
Sounding Off on Slides	430	(4)
Playing sounds: A precautionary tale	431	(1)
Inserting a sound file on a slide	432	(1)
Telling PowerPoint when and how to play a sound file	433	(1)
Starting, pausing, and resuming a sound file	434	(1)
Playing Video on Slides	434	(3)
Inserting a video on a slide	434	(1)
Fine-tuning a video presentation	435	(2)
Delivering a Presentation	437	(18)
All about Notes	437	(1)
Rehearsing and Timing Your Presentation	438	(2)
Showing Your Presentation	440	(2)
Starting and ending a presentation	440	(1)
Going from slide to slide	440	(2)
Tricks for Making Presentations a Little Livelier	442	(3)
Wielding a pen or highlighter in a presentation	443	(1)
Erasing pen and highlighter drawings	444	(1)
Blanking the screen	444	(1)
Delivering a Presentation When You Can't Be There in Person	445	(10)
Providing handouts for your audience	445	(1)
Creating a self-running, kiosk-style presentation	446	(2)
Creating a user-run presentation	448	(2)
Packaging your presentation	450	(5)
Book V: Excel 2007	455	(80)
Up and Running with Excel	457	(18)
Creating a New Excel Workbook	457	(2)
Getting Acquainted with Excel	459	(2)
Rows, columns, and cell addresses	461	(1)
Workbooks and worksheets	461	(1)
Entering Data in a Worksheet	461	(6)
The basics of entering data	462	(1)
Entering text labels	463	(1)
Entering numeric values	463	(1)
Entering date and time values	464	(3)
Quickly Entering Lists and Serial Data with the AutoFill Command	467	(2)
Formatting Numbers, Dates, and Time Values	469	(2)
Conditional Formats for Calling Attention to Data	471	(1)
Establishing Data-Validation Rules	472	(3)
Refining Your Worksheet	475	(14)
Editing Worksheet Data	475	(1)
Moving Around in a Worksheet	476	(1)
Getting a Better Look at the Worksheet	477	(4)
Freezing and splitting columns and rows	478	(3)
Hiding columns and rows	481	(1)
Comments for Documenting Your Worksheet	481	(2)
Selecting Cells in a Worksheet	483	(1)
Deleting, Copying, and Moving Data	484	(1)
Handling the Worksheets in a Workbook	484	(2)
Keeping Others from Tampering with Worksheets	486	(3)
Hiding a worksheet	486	(1)
Protecting a worksheet	486	(3)
Formulas and Functions for Crunching Numbers	489	(20)
How Formulas Work	489	(5)
Referring to cells in formulas	489	(2)
Referring to formula results in formulas	491	(1)
Operators in formulas	492	(2)
The Basics of Entering a Formula	494	(1)
Speed Techniques for Entering Formulas	494	(5)
Clicking cells to enter cell references	494	(1)
Entering a cell range	495	(1)
Naming cell ranges so that you can use them in formulas	496	(3)
Referring to cells in different worksheets	499	(1)
Copying Formulas from Cell to Cell	499	(2)
Detecting and Correcting Errors in Formulas	501	(3)
Correcting errors one at a time	501	(1)
Running the error checker	502	(1)
Tracing cell references	502	(2)
Working with Functions	504	(5)
Using arguments in functions	505	(1)
Entering a function in a formula	505	(4)
Making a Worksheet Easier to Read and Understand	509	(16)
Laying Out a Worksheet	509	(5)
Aligning numbers and text in columns and rows	509	(2)
Inserting and deleting rows and columns	511	(1)
Changing the size of columns and rows	512	(2)
Decorating a Worksheet with Borders and Colors	514	(5)
Cell styles for quickly formatting a worksheet	514	(2)
Slapping borders on worksheet cells	516	(2)
Decorating worksheets with colors	518	(1)
Getting Ready to Print a Worksheet	519	(6)
Making a worksheet fit on a page	519	(4)
Making a worksheet more presentable	523	(1)
Repeating row and column headings on each page	524	(1)
Analyzing Data	525	(10)
Managing Information in Lists	525	(4)
Constructing a list	525	(1)
Sorting a list	526	(1)
Filtering a list	527	(2)
Forecasting with the Goal Seek Command	529	(1)
Performing What-If Analyses with Data Tables	530	(5)
Using a one-input table for analysis	531	(1)
Using a two-input table for analysis	532	(3)
Book VI: Access 2007	535	(82)
Introducing Access	537	(16)
What Is a Database, Anyway?	537	(1)
Tables, Queries, Forms, and Other Objects	538	(4)
Database tables for storing information	538	(1)
Forms for entering data	539	(2)
Queries for getting the data out	541	(1)
Reports for presenting and examining data	542	(1)
Macros and modules	542	(1)
Creating a Database File	542	(2)
Creating a blank database file	543	(1)
Getting the help of a template	543	(1)
Finding Your Way around the Navigation Pane	544	(2)
Designing a Database	546	(7)
Deciding what information you need	547	(1)
Separating information into different database tables	548	(2)
Choosing fields for database tables	550	(1)
Deciding on a primary key field for each database table	550	(1)
Mapping the relationships between tables	551	(2)
Building Your Database Tables	553	(28)
Creating a Database Table	553	(4)
Creating a database table from scratch	554	(1)
Creating a database table from a template	555	(1)
Importing a table from another database	556	(1)
Opening and Viewing Tables	557	(1)
Entering and Altering Table Fields	558	(5)
Creating a field	558	(2)
All about data types	560	(1)
Designating the primary key field	561	(1)
Moving, renaming, and deleting fields	562	(1)
Field Properties for Making Sure That Data Entries Are Accurate	563	(7)
A look at the Field Properties settings	564	(4)
Creating a lookup data-entry list	568	(2)
Indexing for Faster Sorts, Searches, and Queries	570	(3)
Indexing a field	571	(1)
Indexing based on more than one field	571	(2)
Establishing Relationships between Database Tables	573	(8)
Types of relationships	574	(1)
Finding your way around the Relationships window	575	(2)
Forging relationships between tables	577	(4)
Entering the Data	581	(10)
The Two Ways to Enter Data	581	(1)
Entering the Data in Datasheet View	582	(4)
Entering data	582	(1)
Two tricks for entering data quicker	583	(2)
Changing the appearance of the datasheet	585	(1)
Entering the Data in a Form	586	(2)
Creating a form	586	(1)
Entering the data	587	(1)
Finding a Missing Record	588	(1)
Finding and Replacing Data	589	(2)
Sorting, Querying, and Filtering for Data	591	(20)
Sorting Records in a Database Table	591	(2)
Filtering to Find Information	593	(5)
Different ways to filter a database table	593	(1)
Common filters	594	(1)
Filtering by selection	595	(1)
Filtering by form	596	(1)
Running an Advanced Filter/Sort	597	(1)
Querying: The Basics	598	(7)
Creating a new query	599	(1)
Finding your way around the Query Design window	599	(1)
Choosing which database tables to query	600	(1)
Choosing which fields to query	600	(1)
Sorting the query results	601	(1)
Choosing which fields appear in query results	602	(1)
Entering criteria for a query	603	(2)
At last --- saving and running a query	605	(1)
Six Kinds of Queries	605	(6)
Select query	605	(1)
Top-value query	606	(1)
Summary query	606	(1)
Calculation query	607	(1)
Delete query	608	(1)
Update query	609	(2)
Presenting Data in a Report	611	(6)
Creating a Report	611	(2)
Opening and Viewing Reports	613	(1)
Tweaking a Report	613	(4)
Book VII: Publisher 2007	617	(34)
Introducing Publisher	619	(12)
``A Print Shop in a Can''	619	(1)
Introducing Frames	620	(1)
Creating a Publication	621	(1)
Redesigning a Publication	622	(2)
Choosing a different publication design	622	(1)
Choosing a font scheme	623	(1)
Choosing a color scheme	623	(1)
Declaring the page size	624	(1)
Choosing other design options	624	(1)
Getting Around in Publisher	624	(2)
Zooming in and zooming out	624	(2)
Hiding and displaying toolbars	626	(1)
Going from page to page	626	(1)
Understanding and Using the Layout Guides	626	(5)
Laying out the margin, grid, and baseline guides	628	(1)
Setting down ruler guides	628	(3)
Refining a Publication	631	(10)
Entering Text on the Pages	631	(1)
Making Text Fit in Text Frames	632	(3)
Handling ``overflow'' text	632	(2)
Making text jump from frame to frame	634	(1)
Filling out a text frame	634	(1)
Making Text Wrap Around a Frame or Graphic	635	(1)
Replacing the Placeholder Graphics	636	(1)
Inserting Frames on the Pages	636	(2)
Inserting a new frame	636	(1)
Changing the size and position of frames	637	(1)
Making Frames Overlap	638	(1)
Inserting, Removing, and Moving Pages	639	(2)
Putting On the Finishing Touches	641	(10)
Decorating the Text	641	(3)
Drawing a horizontal rule	642	(1)
Dropping in a drop cap	643	(1)
Techniques for Decorating Pages	644	(2)
Putting borders and color backgrounds on frames	644	(1)
Backgrounds for pages	645	(1)
The Master Page for Handling Page Backgrounds	646	(1)
Taking Advantage of the Design Gallery	647	(1)
Running the Design Checker	647	(1)
Commercially Printing a Publication	648	(3)
Book VIII: Office 2007 --- One Step Beyond	651	(86)
Customizing an Office Program	653	(8)
Customizing the Quick Access Toolbar	653	(3)
Adding buttons to the Quick Access toolbar	654	(1)
Changing the order of buttons on the Quick Access toolbar	655	(1)
Removing buttons from the Quick Access toolbar	655	(1)
Placing the Quick Access toolbar above or below the Ribbon	656	(1)
Customizing the Status Bar	656	(1)
Changing Color Schemes	657	(1)
Customizing Keyboard Shortcuts in Word	657	(2)
Smart Tags, Smart Alecks	659	(2)
Ways of Distributing Your Work	661	(8)
Printing --- the Old Standby	661	(1)
Distributing a File in PDF Format	662	(1)
Sending Your File in an E-Mail Message	663	(1)
Saving an Office File as a Web Page	664	(2)
Choosing how to save the component parts	664	(1)
Turning a file into a Web page	665	(1)
Opening a Web page in your browser	666	(1)
Blogging from inside Word	666	(3)
Describing a blog account to Word	667	(1)
Posting an entry to your blog	668	(1)
Handling Graphics	669	(16)
All about Picture File Formats	669	(3)
Bitmap and vector graphics	670	(1)
Resolution	671	(1)
Compression	671	(1)
Choosing file formats for graphics	672	(1)
Inserting a Graphic in a File	672	(2)
Touching Up a Graphic	674	(3)
Changing a graphic's brightness and contrast	674	(1)
Recoloring a graphic	675	(1)
Cropping off part of a graphic	676	(1)
Compressing Graphics to Save Disk Space	677	(1)
Using Microsoft Office Picture Manager	678	(7)
Mapping the graphic files on your computer	679	(1)
Displaying the graphic file you want to work with	680	(1)
Editing a picture	681	(4)
Decorating Files with Clip Art	685	(12)
What Is Clip Art?	685	(1)
Inserting a Clip-Art Image	686	(1)
Tinkering with a Clip-Art Image's Appearance	687	(1)
Handling Media Files with the Clip Organizer	688	(9)
Knowing your way around the Clip Organizer	688	(1)
Locating the media file you need	689	(2)
Inserting a media file	691	(1)
Storing your own files in the My Collections folders	692	(5)
Note Taking with OneNote	697	(12)
Running OneNote	697	(1)
Introducing OneNote	698	(1)
Creating Storage Units for Notes	699	(2)
Creating a notebook	699	(1)
Creating sections, pages, and subpages for notes	700	(1)
Writing Notes	701	(2)
Typing a note	701	(1)
Drawing with a pen or highlighter	702	(1)
Getting from Place to Place in OneNote	703	(1)
Finding and Keeping Track of Notes	703	(3)
Flagging notes for follow up	704	(1)
Finding a stray note	705	(1)
Some Housekeeping Chores	706	(1)
OneNote and Other Office Programs	707	(2)
Copying a note into another Office program	707	(1)
Sending notes by e-mail	707	(1)
Transferring notes to a Word document	707	(1)
Turning a note into an Outlook task	708	(1)
Collaborating with SharePoint Services	709	(6)
Getting Equipped and Getting Started	709	(1)
Visiting a SharePoint Services Web Site	710	(1)
Getting from Place to Place in the Web Site	711	(1)
Handling and Managing Files	711	(3)
Going to the Shared Documents folder	711	(1)
Uploading files	712	(1)
Downloading a file to your computer	713	(1)
Viewing and editing a file	713	(1)
Deleting a file	714	(1)
Other Ways to Collaborate at a SharePoint Services Web Site	714	(1)
Automating Tasks with Macros	715	(12)
What Is a Macro?	715	(1)
Displaying the Developer Tab	715	(1)
Managing the Macro Security Problem	716	(2)
Recording a Macro	718	(3)
Ground rules for recording macros	718	(1)
Recording a macro	719	(2)
Running a Macro	721	(1)
Editing a Macro	722	(2)
Reading a macro in the Code window	723	(1)
Editing the text that a macro enters	724	(1)
Deleting parts of a macro	724	(1)
Running a Macro from a Button on the Quick Access Toolbar	724	(3)
Linking and Embedding in Compound Files	727	(10)
What Is OLE, Anyway?	727	(3)
Linking and embedding	728	(2)
Pitfalls of linking and embedding	730	(1)
Linking to Data in another File	730	(3)
Establishing the link	731	(1)
Updating a link	732	(1)
Editing data that is linked with a source file	732	(1)
Breaking and reestablishing links	733	(1)
Embedding Data from Other Programs	733	(4)
Embedding foreign data	733	(3)
Editing embedded data	736	(1)
Index	737