Special Edition Using Microsoft Office 2003, Student-Teacher Edition

by Bott, Ed; Leonhard, Woody

• ISBN13: 9780789734662
• ISBN10: 0789734664
• Edition: 1st
• Format: Paperback
• Copyright: 2006-02-09
• Publisher: Que Publishing

Summary

The Student-Teacher Edition of Microsoft Office 2003 is the best-selling version of the software suite, andSpecial Edition Using Microsoft Office 2003, Student-Teacher Editionis the first book to tackle it from the perspective of this unique user. The SE Using format will help you explore advanced techniques that can save you time and help automate repetitive tasks. You will be able to increase your productivity in all areas of any one of the Microsoft Office 2003 applications. You'll also learn ways to make them work better together, further increasing your productivity. Take a look at Microsoft Office 2003 through the eyes of an expert withSpecial Edition Using Microsoft Office 2003, Student-Teacher Edition.

Author Biography

Ed Bott is an award-winning computer journalist and one of the most widely recognized voices in the computing world, with more than two decades of experience as a writer and editor at leading magazines, such as PC World, PC Computing and Smart Business. Ed had written many of Que's all-time bestsellers, including Special Edition Using Office 2000, Special Edition Using Windows 98, and Special Edition Using Windows Me. Ed also is co-author of the best-selling, category-owning Windows XP Inside-Out.

Woody Leonhard publishes Woody's Office Watch and Woody's Windows Watch eZines, which are read by more than 500,000 each week. If there is a journalist feared and respected by the geeks at Microsoft, Woody is the guy. Woody's take no prisoners approach to covering Microsoft products as both endeared him to readers worldwide and caused his name to be taken in vain at many a Microsoft product development meeting. He has won an unprecedented six Computer Press Association Awards for his books, newsletters and magazine articles. He is author of many books, including Special Edition Using Office 2000, Woody Teaches Office 97, Woody Teaches Office 2000 and the best-selling Windows XP All in Once Desk Reference for Dummies (Wiley).

Table of Contents

Introduction	1	(1)
Who Should Buy This Book	2	(1)
How This Book Is Organized	3	(1)
Conventions Used in This Book	4	(5)
Text Conventions	4	(1)
Special Elements	5	(4)
I. Common Tasks and Feature
Getting Started with Office 2003	9	(20)
What Is Office Student and Teacher Edition 2003?	10	(1)
Office 2003 Student and Teacher Edition, Piece by Piece	11	(3)
Outlook 2003	11	(1)
Word 2003	12	(1)
Excel 2003	12	(1)
PowerPoint 2003	13	(1)
Other Office Programs	14	(1)
Setup Essentials	14	(3)
Activating Your Copy of Office	15	(1)
Installing Updates and Service Packs	16	(1)
Customizing Your Office Installation	17	(3)
Fixing Setup Problems	20	(1)
Using Setup in Maintenance Mode	20	(2)
Adding and Removing Office Features	21	(1)
Repairing an Office Installation	21	(1)
Uninstaling Office 2003	22	(1)
Getting Help	22	(7)
Viewing a Help Topic	25	(2)
Using the Office Assistant	27	(2)
Making Office 2003 Work Your Way	29	(32)
Point, Click, Customize	30	(1)
Making Menus and Toolbars Consistent	30	(3)
How Personalized Toolbars and Menus Work	31	(1)
Disabling On-the-Fly Interface Changes	32	(1)
Restoring Default Menus and Toolbars	33	(1)
Customizing Toolbars	33	(6)
Showing, Hiding, and Arranging Toolbars	34	(2)
Adding and Removing Buttons	36	(3)
Creating a New Toolbar	39	(4)
Customizing the Appearance of Toolbar Buttons	40	(1)
Editing a Toolbar Button's Icon and Label	41	(1)
Assigning a Hyperlink to a Toolbar Button	42	(1)
Customizing Built-In Menus	43	(3)
Rearranging Pull-Down Menus	43	(1)
Creating New Menus	44	(1)
Modifying Shortcut Menus	44	(2)
Bypassing Menus with Keyboard Shortcuts	46	(1)
Configuring Common Office Features	47	(7)
Customizing Task Panes	48	(1)
Customizing Smart Tags	48	(2)
Setting Up Spell-Checking Options	50	(3)
Configuring the Research Task Pane	53	(1)
Setting Security Options	54	(2)
Saving and Restoring Personal Settings	56	(1)
Troubleshooting	57	(1)
Extra Credit: Custom Toolbars for Quick Highlighting	58	(3)
Keeping Track of Your Files and Settings	61	(26)
Getting Organized (and Staying That Way)	62	(1)
Where Should You Keep Your Files?	62	(4)
Opening and Saving Files over a Network	65	(1)
Storing Files on the Web or an Intranet	65	(1)
Creating New Files	66	(2)
Naming Documents	68	(1)
Using and Customizing Common Dialog Boxes	69	(5)
Customizing Common Dialog Boxes	72	(1)
Using Alternative File Formats	73	(1)
Storing Extra Details About Your Documents	74	(5)
Default Document Properties	77	(1)
Using Custom Properties to Organize Files	77	(1)
Using Windows Explorer to View File Properties	78	(1)
Searching for Office Files	79	(4)
Finding Files or Messages by Content	82	(1)
Using Document Properties to Locate Files	82	(1)
Working with Multiple Files	83	(1)
Setting Up Automatic Backup and Recovery Options	84	(1)
Troubleshooting	85	(1)
Extra Credit: Find Files Faster with Desktop Search Tools	86	(1)
Entering, Editing, and Formatting Text	87	(26)
Entering Text: More Than Just Typing	88	(4)
Inserting Symbols and Special Characters	88	(2)
Entering Accented and International Characters	90	(1)
Entering Text in Another Language	90	(2)
Selecting Text	92	(1)
Finding and Replacing Text	93	(2)
Converting Scanned Documents to Text	95	(3)
Using AutoCorrect to Type Faster	98	(7)
How AutoCorrect Works	99	(1)
Setting AutoCorrect Options	100	(1)
Customizing the AutoCorrect Lists	101	(3)
Advanced AutoCorrect Techniques	104	(1)
AutoCorrect Do's and Don'ts	104	(1)
Using and Managing Fonts	105	(1)
Common Formatting Options	106	(3)
Changing Character Attributes	106	(2)
Using Bullets and Numbers to Set Off Lists	108	(1)
Undoing and Redoing Changes	109	(1)
Can You Really Enter Text by Speaking?	110	(1)
Troubleshooting	111	(1)
Extra Credit: Using AutoCorrect to Add a Scanned Signature to Word Documents	112	(1)
Using Pictures and Drawings	113	(32)
Going Beyond Plain Text	114	(1)
Using Office Drawing Tools	114	(12)
Working with the Drawing Layer	114	(2)
Working with a Drawing Canvas	116	(1)
Drawing Simple Shapes	117	(1)
Working with AutoShapes	118	(1)
Using Lines and Arrows	119	(2)
Changing Background Colors and Line Formats	121	(1)
Adding Shadows and 3D Effects	122	(1)
Adding Text to a Drawing	123	(1)
Aligning and Grouping Graphic Elements	124	(1)
Wrapping, Layout, and Stacking	125	(1)
Adding Pictures to Office Documents	126	(2)
Choosing Embedding or Linking	127	(1)
Working with Scanned Images	128	(1)
Viewing, Editing, and Managing Pictures	129	(6)
Resizing and Cropping Pictures	131	(1)
Editing Image Files	132	(2)
Compressing Graphics for Web Pages and Presentations	134	(1)
Using Advanced Picture Effects	135	(1)
Creating Graphics from Text	135	(3)
Using Text Boxes to Create Pull Quotes	136	(1)
Using WordArt for Logos	137	(1)
Using Clip Art	138	(4)
Creating and Editing Charts and Diagrams	142	(1)
Simple Charts	142	(1)
Organization Charts	142	(1)
Diagrams	143	(1)
Troubleshooting	143	(1)
Extra Credit: A Professional Flowchart	144	(1)
Using Office Programs Together	145	(20)
Sharing Data Between Office Programs	146	(1)
Using the Office Clipboard	146	(3)
Customizing the Office Clipboard	149	(1)
Converting Clipboard Data into Alternative Formats	149	(2)
Dragging and Dropping Data	151	(2)
Converting and Importing Files Between Office Programs	153	(1)
Combining Two or More Data Types in One Document	154	(6)
Embedding Versus Linking	154	(2)
Creating and Editing Embedded Objects	156	(2)
Creating and Editing Linked Objects	158	(1)
Managing Links Between Documents and Objects	159	(1)
Troubleshooting	160	(1)
Extra Credit: Side by Side with Office	160	(5)
II. Using Outlook
Getting Started with Outlook	165	(44)
The Five Faces of Outlook	166	(1)
Using and Customizing the Outlook Interface	166	(4)
Customizing the Navigation Pane	167	(2)
Adding Custom Shortcuts to the Navigation Pane	169	(1)
Customizing the Outlook Today Page	170	(1)
Using Custom Views to Display Information	170	(12)
Using Views to Display, Sort, and Filter Items	171	(1)
Arranging Items in a View	172	(1)
Customizing an Existing View	173	(6)
Creating a New Custom View	179	(2)
Managing Custom Views	181	(1)
Opening a Folder in a Separate Window	181	(1)
Creating, Editing, and Managing Outlook Items	182	(4)
Moving, Copying, and Deleting Items	182	(2)
Entering Dates and Times Automatically	184	(1)
Assigning Items to Categories	185	(1)
How Outlook Stores Data	186	(4)
Mailbox Folders on an Exchange Server Only	189	(1)
Managing Outlook Data Files	190	(4)
Cleaning Up and Archiving Outlook Information	190	(2)
Recovering Free Space in Outlook Data Files	192	(1)
Repairing a Damaged Personal Folders File	193	(1)
Using Reminders and Follow-Up Flags	194	(3)
Flagging Messages for Follow-Up	194	(2)
Managing Flagged Items	196	(1)
Finding Outlook Items	197	(5)
Finding Contact Information Fast	197	(1)
Using the Find Pane for Simple Searches	198	(1)
Advanced Search Techniques	199	(3)
Importing and Exporting Outlook Information	202	(4)
Importing Data from External Programs	202	(3)
Exporting Outlook Data	205	(1)
Synchronizing Outlook Data with a Handheld Device	205	(1)
Troubleshooting	206	(1)
Extra Credit: Building a Library of Saved Searches	207	(2)
Keeping Your E-mail Under Control	209	(48)
Making the Most of E-mail	210	(1)
Switching from Outlook Express or Another E-mail Program	210	(1)
Setting Up E-mail Accounts	210	(7)
Configuring Internet Standard E-mail Accounts	212	(3)
Configuring Your SMTP Server to Send Mail	215	(1)
Hotmail and Other HTTP Accounts	216	(1)
Managing Multiple E-mail Accounts	217	(1)
Managing Connections to E-mail Servers	217	(4)
Advanced Options	219	(1)
Setting Up Alternative E-mail Profiles	220	(1)
Checking Your Mail and Reading New Messages	221	(5)
Setting Up Send/Receive Groups	221	(1)
Choosing Which Messages to Download	222	(1)
Checking for New Messages	223	(1)
Setting Notifications	224	(1)
Speed-Reading New Messages with the Reading Pane	225	(1)
Creating, Managing, and Using E-mail Addresses	226	(8)
Configuring the Outlook Address Book	227	(2)
Integrating Outlook with the Windows Address Book	229	(1)
Those Other Address Books	230	(1)
Addressing an E-mail Message	231	(1)
Sending E-mail to Groups of People	232	(2)
Using Word as an E-mail Editor	234	(1)
Creating and Sending Messages	234	(9)
Choosing a Message Format	235	(2)
Using a Specific Account to Send a Message	237	(1)
Creating, Editing, and Managing Signatures	237	(3)
Using Stationery and Fonts in Formatted Messages	240	(1)
Setting Message Options	241	(1)
Setting Reply and Forward Options	242	(1)
Organizing Your E-mail	243	(9)
Using E-mail Rules to Sort and Process Mail	244	(1)
Creating a New E-mail Rule	245	(5)
Managing E-mail Rules and Alerts	250	(1)
Creating and Using Search Folders	251	(1)
Troubleshooting	252	(3)
Extra Credit: Expert Strategies for Outlook Rules	255	(2)
Stopping Viruses, Spam, and Other Security Threats	257	(18)
Why Should You Care About E-mail Security?	258	(1)
Blocking E-mail Viruses	259	(4)
Configuring Attachment Options	259	(2)
Controlling Execution of Scripts	261	(2)
Restricting Access to the Outlook Address Book	263	(1)
Stopping Spam and Other Unwanted E-mail	263	(6)
Fine-Tuning Outlook's Junk Mail Filter	264	(4)
Using E-mail Rules to Block Junk E-mail	268	(1)
Using Third-Party Spam-Fighting Software	269	(1)
Protecting Your Privacy	269	(2)
Disabling HTML-Based E-mail	271	(1)
Troubleshooting	272	(1)
Extra Credit: How to Avoid Being Victimized by a Phishing Attack	273	(2)
Organizing Your Contacts List	275	(20)
Managing Your List of Contacts	276	(1)
Entering and Editing Contact Information	277	(5)
Entering and Editing Names	278	(1)
Working with Addresses	279	(1)
Entering Job and Company Details	280	(1)
Managing Phone, Fax, and Other Numbers	280	(1)
Entering and Editing E-mail and Web Addresses	281	(1)
Entering Personal Information and Other Details	282	(1)
Working Smarter with Contact Items	282	(5)
Changing the Way a Contact Item Is Filed	282	(1)
Entering Several New Contact Items at Once	283	(1)
Exchanging Contact Information	284	(1)
Expert Editing Techniques	284	(1)
Merging Duplicate Contact Items	285	(2)
Using Windows/MSN Messenger to Communicate with Contacts	287	(1)
Addressing Letters and Envelopes Using Your Contacts List	287	(2)
Printing Phone Lists from Your Contacts List	289	(3)
Troubleshooting	292	(1)
Extra Credit: Putting a Face with Each Name	293	(2)
Managing Appointments, Meetings, and Tasks	295	(30)
Managing Your Personal Calendar	296	(1)
Creating a New Appointment or Event	297	(4)
Entering a Recurring Appointment	300	(1)
Rescheduling an Appointment or Event	301	(1)
Viewing a Dairy, Weekly, or Monthly Calendar	301	(9)
Switching Between Day, Week, and Month Views	301	(3)
Color-Coding Important Appointments	304	(1)
Customizing the Calendar Display	305	(1)
Customizing Other Calendar Options	306	(2)
Juggling Multiple Time Zones	308	(2)
Maintaining a Personal Task List	310	(3)
Entering Tasks	310	(1)
Entering Recurring Tasks	311	(1)
Sorting and Filtering the Task List	312	(1)
Printing a List of Appointments and Tasks	313	(2)
Planning a Meeting with Outlook	315	(3)
Responding to Meeting Requests	318	(1)
Checking the Status of a Meeting You've Arranged	319	(1)
Rescheduling or Canceling a Meeting	320	(1)
Troubleshooting	320	(1)
Extra Credit: Publishing a Calendar As a Web Page	321	(4)
III. Using Word
Getting Started with Word	325	(42)
Word Essentials	326	(1)
Choosing the Right Document View	326	(7)
Normal View	326	(1)
Web Layout View	327	(1)
Print Layout View	328	(1)
Outline View	328	(1)
Reading Layout View	329	(1)
Navigating with Thumbnails and the Document Map	330	(1)
Zoom Options	331	(1)
Full Screen View	332	(1)
Splitting a Document Window	332	(1)
Navigating Through a Word Document	333	(8)
Using the Keyboard to Move Through a Document	333	(1)
Using the Mouse to Move Through a Document	334	(1)
Navigating with the Document Map	335	(1)
Using the Keyboard and Mouse to Select Text	336	(1)
Bookmarks	337	(1)
Navigating Through Documents with the Select Browse Object Menu	338	(3)
Entering Text and Graphics Automatically with AutoText and AutoCorrect	341	(2)
Using Hyphens and Dashes	343	(2)
Finding and Replacing Text and Other Parts of a Document	345	(6)
Finding Text	346	(2)
Replacing Text	348	(1)
Finding and Replacing Formatting	349	(1)
Inserting Footnotes	350	(1)
Checking Spelling and Grammar	351	(1)
Printing Word Documents	352	(3)
Previewing Printed Pages	352	(1)
Choosing What to Print	353	(1)
Printing Thumbnails	354	(1)
Collating	355	(1)
Sharing Documents	355	(4)
Tracking Changes to a Document	355	(2)
Adding Comments to Documents	357	(1)
Saving Document Versions	357	(1)
Restricting Changes to a Shared Document	358	(1)
Strategies for Non-Word Environments	358	(1)
Customizing the Word Interface	359	(5)
Controlling How Word Documents Appear on the Taskbar	360	(1)
Options Settings	360	(3)
Disabling AutoFormat Settings	363	(1)
Word Startup Switches	364	(1)
Extra Credit: Protect Your Privacy When Saving and Sharing Documents	365	(2)
Creating Great-Looking Documents	367	(36)
Understanding Your Formatting Options	368	(4)
Character Formats	368	(3)
Paragraph Formats	371	(1)
Direct Formatting Versus Styles	371	(1)
Applying and Modifying Formats	372	(8)
Revealing Formatting Within a Document	372	(1)
Copying Formats	373	(1)
Removing Text Formatting	374	(1)
Page/Section Setup Options	374	(2)
Floating Versus Inline Objects	376	(1)
Automatic Formatting	376	(2)
Locking a Document's Formatting	378	(2)
Changing Paper Size and Orientation	380	(1)
Adjusting Margins	381	(3)
Changing Text Formatting	384	(3)
Changing Paragraph Formatting	387	(8)
Adjusting Paragraph Alignment and Outline Level	388	(1)
Indenting Paragraphs for Emphasis	389	(1)
Adjusting Line and Paragraph Spacing	390	(1)
Controlling Page Breaks	391	(1)
Using Drop Caps for Emphasis	392	(1)
Positioning Text with Tabs	393	(2)
Using the Ruler to Set Tab Stops	395	(1)
Using Tabs to Create a User-Input Form	395	(1)
Formatting Simple Lists with Bullets and Numbers	396	(2)
Formatting All or Part of a Document Automatically	398	(2)
Troubleshooting	400	(1)
Extra Credit: Straight Quotes or Curly Quotes?	400	(3)
Tables, Sections, and Other Advanced Formatting Options	403	(44)
Going Beyond Basic Formatting	404	(1)
Using Tables to Organize Information	404	(1)
Adding a Table to a Document	405	(4)
Creating Quick Tables	406	(1)
Drawing a Complex Table	407	(1)
Converting Text to a Table	407	(2)
Nesting Tables Within Tables	409	(1)
Working with Tables	409	(8)
Selecting Cells, Rows, and Columns	409	(1)
Entering and Editing Data	410	(1)
Moving and Copying Parts of a Table	411	(1)
Changing Column Widths and Row Heights	411	(2)
Adding and Deleting Rows and Columns	413	(1)
Rotating Text	414	(1)
Merging and Splitting Cells and Tables	414	(2)
Sorting Data Within Tables	416	(1)
Positioning Tables on the Page	417	(1)
Advanced Table Formatting Options	418	(4)
Letting Word Do the Work with AutoFormat	418	(2)
Using Borders and Shading	420	(1)
Aligning Text in Cells	420	(1)
Working with Big Tables	421	(1)
Taking Control of Page Breaks	422	(1)
Formatting Documents by Section	423	(3)
Types of Sections	423	(1)
Inserting and Deleting Section Breaks	424	(1)
Copying Formatting Between Sections	425	(1)
Adding Lines, Borders, Shading, and Backgrounds	426	(4)
Quick Ways to Create Lines	426	(1)
Borders and Boxes	427	(1)
Shading Characters, Paragraphs, and Pages	428	(2)
Formatting a Document with Columns	430	(1)
Creating and Editing Headers and Footers	431	(5)
Creating Headers and Footers	432	(1)
Numbering Pages	433	(1)
Adding Dates and Document Details	434	(1)
How Section Breaks Affect Headers and Footers	435	(1)
Keeping Long Documents Under Control	436	(8)
One File or Many?	436	(1)
Using Bookmarks	437	(1)
Inserting Cross-References	438	(2)
Creating Indexes	440	(2)
Creating a Table of Contents	442	(2)
Wrapping Text Around Graphics	444	(1)
Troubleshooting	444	(2)
Extra Credit: Nested Tables for Superior Layout	446	(1)
Mastering Styles and Templates	447	(24)
Moving Beyond Manual Formatting	448	(1)
Using Styles and Templates to Manage Formats	448	(3)
Formatting Documents with Styles	451	(6)
Paragraph Versus Character Styles	451	(2)
List and Table Styles	453	(1)
Applying Styles Manually	454	(1)
Using the Styles and Formatting Task Pane	455	(2)
Saving Formats as Named Styles	457	(2)
Customizing the Normal Document Template	459	(2)
Using Word's Built-in Templates	461	(1)
Changing Document Formats Globally	462	(3)
Managing Styles and Templates	465	(3)
Creating a New Template from Scratch	465	(1)
Where Does Word Store Templates?	465	(2)
Customizing Word Templates	467	(1)
Copying Styles and Settings Between Templates	467	(1)
Troubleshooting	468	(1)
Extra Credit: Styles and Manually Applied Formatting	469	(2)
Letters, Mail Merge, and ``Smart'' Documents	471	(44)
Putting Word to Work	472	(1)
Creating and Editing Letters	472	(6)
Using the Letter Wizard	472	(2)
Customizing Letter Templates	474	(3)
Addressing Letters with the Outlook Contacts List	477	(1)
Creating Envelopes and Labels	478	(3)
Printing Envelopes	478	(2)
Printing Labels	480	(1)
Customizing Labels	480	(1)
Merging Data to Create Custom Reports and Letters	481	(2)
Using Mail Merge to Personalize Form Letters	483	(6)
Creating the Form Letter	484	(1)
Specifying a Source for Names and Addresses	485	(2)
Placing Data Fields Within Your Document	487	(1)
Previewing Mail Merge Results	488	(1)
Mass E-mailing and Faxing with Outlook and Mail Merge	489	(1)
Creating Directories	490	(1)
Advanced Mail Merge Techniques	491	(3)
Merge Envelopes	491	(2)
Merge Labels	493	(1)
Using Fields Intelligently	494	(3)
Inserting a Field into a Document	495	(1)
Showing and Hiding Field Codes	496	(1)
Field Code Syntax	497	(1)
Formatting Field Results	497	(3)
General \* Format Switches	497	(1)
Numeric \# Picture Switches	498	(1)
Date-Time \@ Format Switches	499	(1)
Displaying Field Results Correctly	500	(1)
Some Useful Custom Fields	501	(10)
Showing Dates and Times	502	(2)
Page Numbering	504	(1)
Displaying Document Properties	504	(2)
Prompting for Input	506	(1)
Customizing Form Letters with Fields	507	(1)
Managing Custom Numeric Sequences	508	(3)
Table of Contents and Index Fields	511	(1)
Troubleshooting	511	(1)
Extra Credit: Professional Labels, Big Time	512	(3)
IV. Using Excel
Getting Started with Excel	515	(44)
Working with Worksheets and Workbooks	516	(6)
Moving, Copying, Inserting, and Deleting Worksheets	516	(2)
Renaming a Worksheet	518	(1)
Navigating in a Workbook with Keyboard Shortcuts	519	(1)
Working with Multiple Worksheets	520	(1)
Using Cell References and Range Names to Navigate in a Workbook	521	(1)
Using Ranges to Work with Multiple Cells	522	(4)
Selecting Ranges	522	(1)
Moving from Cell to Cell Within a Range	523	(1)
Entering the Same Data in Multiple Cells	523	(1)
Selecting Ranges of Data with the Go To Dialog Box	523	(3)
Hiding Rows and Columns	526	(1)
Finding, Replacing, and Transforming Data	526	(5)
Finding and Replacing the Contents of a Cell or Range	526	(1)
Dragging and Dropping to Convert Data	527	(1)
Transforming Data with Paste Options	528	(3)
Customizing the Worksheet Window	531	(2)
Using the Zoom Controls	531	(1)
Locking Row and Column Labels for Onscreen Viewing	532	(1)
Splitting the Worksheet Window	533	(1)
Using Links to Automatically Update or Consolidate Worksheet Data	533	(1)
Restricting and Validating Data Entry for a Cell or Range	534	(5)
Defining Data-Validation Rules	535	(1)
Displaying Helpful Input Messages	536	(1)
Alerting the User to Errors	536	(2)
Deleting, Moving, or Copying Data-Validation Rules	538	(1)
Troubleshooting Data Errors	538	(1)
Printing Worksheets	539	(6)
Using Ranges to Define the Default Print Area	540	(1)
Inserting Your Own Page Breaks	541	(1)
Extra Items You Can Print	542	(1)
Labeling Printed Pages with Headers and Footers	543	(1)
Using Repeating Titles for Multiple Page Printouts	544	(1)
Forcing a Worksheet to Fit on a Specified Number of Pages	544	(1)
Protecting a Worksheet	545	(5)
Using Passwords to Restrict Access to a Workbook	546	(1)
Preventing Changes to a Worksheet	547	(2)
Protecting the Structure of a Workbook	549	(1)
Publishing Excel Data in Web Pages	550	(2)
Customizing Excel	552	(4)
Changing Default Formatting for New Workbooks and Worksheets	555	(1)
Installing Excel Add-Ins	555	(1)
Excel Startup Switches	556	(1)
Troubleshooting	556	(2)
Extra Credit: Beware of Undo	558	(1)
Making Great-Looking Worksheets	559	(34)
How Cell Formatting Works	560	(6)
Using the General Number Format	560	(1)
Controlling Automatic Number Formats	560	(2)
Avoiding Rounding Errors	562	(2)
The Limits of Precision	564	(1)
Working with Numbers in Scientific Notation	565	(1)
Entering Numbers as Text	565	(1)
Changing Formatting for a Cell or Range	566	(11)
Setting Number Formats	566	(2)
Setting Date and Time Formats	568	(2)
Excel and Year 2000 Issues	570	(1)
Creating Custom Cell Formats	571	(6)
Designing and Formatting a Worksheet for Maximum Readability	577	(7)
Changing Fonts and Character Attributes	577	(2)
Aligning, Wrapping, and Rotating Text and Numbers	579	(2)
Using Borders, Boxes, and Colors	581	(2)
Merging Cells	583	(1)
Changing Row Height and Column Width	583	(1)
Using Conditional Formatting to Identify Key Values	584	(2)
Copying Formats with the Format Painter	586	(1)
Saving Formats as Named Styles	587	(1)
Using AutoFormat	588	(2)
Troubleshooting	590	(1)
Extra Credit: Redesigning a Worksheet Clarifies the Information	590	(3)
Using Formulas and Functions	593	(36)
Entering and Editing Formulas	594	(8)
Using Cell References in Formulas	595	(1)
Using 3D References to Cells on Other Worksheets	595	(1)
Controlling the Order and Timing of Calculations in Formulas	595	(2)
Absolute Versus Relative Cell References	597	(2)
Preventing Formulas from Displaying in the Formula Bar	599	(1)
Using Array Formulas	599	(2)
Using the Watch Window to Monitor Calculations	601	(1)
Using Range Names and Labels in Formulas	602	(5)
Using Natural-Language Formulas	602	(2)
Limitations of Natural-Language Formulas	604	(1)
Using Named Ranges in Formulas	604	(2)
Managing Range Names	606	(1)
Manipulating Data with Worksheet Functions	607	(4)
Entering Error-Free Formulas	608	(2)
Totaling Rows and Columns Automatically	610	(1)
Putting Worksheet Functions to Use	611	(7)
Calculating Financial Formulas	611	(1)
Working with Date and Time Functions	612	(1)
Performing Statistical Analyses	613	(1)
Using Database Functions	614	(1)
Performing Mathematical Operations	614	(1)
Combining and Separating Text Values	615	(2)
Using Logical and Information Functions	617	(1)
Troubleshooting Formulas	618	(4)
How Formula AutoCorrect Work	618	(1)
Resolving Common Error Messages	618	(2)
Checking for Errors in a Worksheet	620	(2)
Using the Range Finder to Locate Parts of a Formula	622	(1)
Using Coal Seek to Find Values	622	(2)
Troubleshooting	624	(1)
Extra Credit: Nesting Functions Within Functions	625	(4)
Working with Lists and PivotTables	629	(40)
Slicing and Dicing Data with Lists	630	(1)
Creating a List on a Worksheet	630	(3)
Speeding Up Repetitive Data Entry with AutoComplete	633	(1)
Automatically Filling In a Series of Data	634	(4)
Creating Custom AutoFill Lists to Fit Your Projects	637	(1)
Sorting Lists	638	(3)
Sorting by Multiple Columns	639	(1)
Sorting by Dates or Custom Series	639	(2)
Finding and Filtering Data in a List	641	(8)
Using AutoFilter to Find Sets of Data	641	(2)
Using Comparison Criteria to Create Custom Filters	643	(1)
Filtering with Advanced Criteria	644	(5)
Using Forms to Add and Edit List Data	649	(2)
Importing and Exporting Data	651	(1)
How PivotTable and PivotChart Reports Work	652	(4)
When Should You Use a PivotTable?	656	(1)
Creating a PivotTable	656	(2)
Editing and Updating a PivotTable	658	(6)
Changing Sort Order and Other Display Options	660	(1)
Adding and Removing Column and Row Subtotals	660	(1)
Switching Between Table and Outline Layouts	661	(1)
Removing Blank Cells and Error Messages	662	(1)
Refreshing Data in a PivotTable	663	(1)
Creating and Editing PivotCharts	664	(2)
Formatting and Printing PivotTables	666	(1)
Extra Credit: Grouping Items in a PivotTable	667	(2)
Turning Data into Charts	669	(30)
Every Picture Tells a Story	670	(1)
Anatomy of an Excel Chart	670	(5)
Data Series	672	(1)
Data Markers	672	(1)
Axes and Gridlines	673	(1)
Data Labels, Legends, and Titles	673	(1)
Plot Area	674	(1)
Chart Area	674	(1)
Working with Embedded Charts	674	(1)
Using the Chart Wizard for Quick Results	675	(2)
Selecting Data to Plot	677	(2)
Selecting and Customizing a Chart Type	679	(8)
Choosing a Standard Chart Type	679	(4)
Using Combination Charts	683	(1)
Creating and Saving Custom Chart Types	684	(2)
Creating a Default Chart	686	(1)
Editing and Formatting Chart Elements	687	(7)
Adjusting Chart Options	687	(3)
Changing Number Formats	690	(1)
Changing Text Formats	691	(1)
Adding Background Colors, Textures, and Pictures	692	(1)
Changing the Scale and Spacing of Axes	692	(1)
Changing the Data Source for an Existing Chart	692	(2)
Advanced Chart Options	694	(1)
Extra Credit: Creating a Custom Chart Library	694	(5)
V. Using PowerPoint
Getting Started with PowerPoint	699	(24)
What Is PowerPoint Good For?	700	(1)
Anatomy of a PowerPoint Presentation	700	(2)
PowerPoint File Types	702	(2)
File Compatibility Issues	704	(1)
Creating a Presentation	704	(6)
Creating a Blank Presentation	704	(3)
Starting PowerPoint with a Design Template	707	(1)
Building a Presentation from ``Canned'' Content	708	(1)
Copying the Design of an Existing Presentation	708	(1)
Importing from a Word Outline	709	(1)
Viewing a Presentation	710	(5)
Organizing Ideas in the Outline Pane	711	(1)
Using Slide Sorter View to Rearrange a Presentation	712	(1)
Previewing Your Presentation in Slide Show View	713	(1)
Adding Notes	713	(1)
Viewing Presentations in a Web Browser	714	(1)
Managing Slide Shows	715	(3)
Navigating Through a Presentation	718	(3)
Mouse and Keyboard Shortcuts	718	(1)
Using Hyperlinks	719	(1)
Advanced Navigation with Action Settings	720	(1)
Navigation Shorthand with Action Buttons	720	(1)
Extra Credit: Supercharging PowerPoint with a Free Add-in	721	(2)
Building Your Presentation	723	(36)
Editing the Presentation Outline	724	(2)
Editing Slides in Outline View	724	(1)
Reordering Slides	725	(1)
Expanding and Collapsing	725	(1)
Picking the Best Slide Layout	726	(3)
Choosing a Slide Layout	726	(1)
Using Placeholders	727	(1)
Going Outside the Placeholders	728	(1)
Editing Slides	729	(7)
Adding and Editing Text	729	(1)
Working with Bulleted and Numbered Lists	730	(3)
Working with Tables	733	(1)
Adding Pictures, Diagrams, and Clip Art	734	(2)
Organizing Formats with Master Slides	736	(11)
Using the Title Master	736	(2)
Using the Slide Master	738	(3)
Changing the Background of Every Slide	741	(1)
Working with Headers and Footers	741	(2)
Removing Slide Master Elements from a Single Slide	743	(1)
Creating Speaker Notes and Audience Handouts	744	(2)
Creating Multiple Master Slides	746	(1)
Applying and Modifying Designs	747	(5)
Choosing the Best Design for Your Presentation	748	(1)
Modifying an Existing Design for Your Presentation	748	(2)
Choosing the Best Background	750	(2)
Changing the Background on Selected Slides	752	(1)
Using Color Schemes	752	(3)
Choosing a New Color Scheme	753	(1)
Changing Colors on Selected Slides	754	(1)
Copying a Color Scheme	754	(1)
Changing Paragraph and Text Formatting	755	(2)
Using Paragraph Formatting	756	(1)
Using Fonts	756	(1)
Replacing Fonts Throughout a Presentation	756	(1)
Troubleshooting	757	(1)
Extra Credit: Creating Top-Notch Notes and Handouts	757	(2)
Adding Sizzle to a Presentation	759	(24)
Banishing Boring Slide Shows	760	(1)
Using Transitions to Control Pacing	760	(3)
Applying a Transition to One Slide	761	(1)
Applying a Transition to a Group of Slides	762	(1)
Controlling Slide Transition Speed	762	(1)
Animating Text and Objects on a Slide	763	(11)
Animating Bullet Points	764	(2)
Animating Titles	766	(1)
Advanced Animation	766	(5)
Animating the Drawing Layer	771	(1)
Hiding and Uncovering Slide Contents	772	(1)
Animating Chart Components	773	(1)
Adding Multimedia to Your Presentation	774	(6)
Adding Music, Sounds, and Video Clips	775	(1)
Controlling a Video or Sound Clip	776	(2)
Using CD Audio and Recorded Audio	778	(2)
Using Action Links to Combine Effects	780	(1)
Troubleshooting	780	(1)
Extra Credit: Using PowerPoint to Show Off Digital Photos	781	(2)
Delivering a Presentation with Style	783	(18)
Planning Your Presentation	784	(3)
The Importance of Preparation	784	(1)
Organizing Your Remarks with Speaker Notes	784	(1)
Using PowerPoint's Timer to Rehearse a Presentation	785	(2)
Delivering a Perfect Presentation	787	(1)
Running a Slide Show	787	(1)
Creating Presentations for the Web	788	(1)
Setting Up a Slide Show	789	(2)
Tuning Your Presentation for Your Hardware	789	(1)
Using Two Monitors	790	(1)
Using Hidden Slides to Anticipate Questions	791	(1)
Writing or Drawing on Slides	792	(1)
Taking Notes During a Slide Show	793	(1)
Packaging a Presentation for Use on Other Computers	793	(2)
Saving a Presentation on a CD	794	(1)
Using the PowerPoint Viewer	795	(1)
Printing Your Presentation	795	(2)
Choosing Which Elements to Print	795	(1)
Preparing a Color Presentation for a Black-and-White Printer	796	(1)
Troubleshooting	797	(1)
Extra Credit: Anticipating Questions with Hidden Slides	797	(4)
VI. Advanced Tasks and Features
Using Macros to Automate Office Tasks	801	(32)
Getting Started with Macros	802	(1)
What Can You Do with a Macro?	802	(2)
What Shouldn't You Do with Macros?	803	(1)
VBA Basics	803	(1)
Using the Visual Basic Editor	804	(2)
How Office Applications Store Macros	805	(1)
Using Object Models	806	(1)
Recording Simple Macros	806	(4)
How the Macro Recorder Captures Actions	807	(1)
Recording a Macro	808	(1)
Testing the Macro	809	(1)
Troubleshooting Recorded Macros	810	(4)
Stepping Through and Editing Recorded Macros	810	(2)
Common Recorded Macro Mistakes	812	(1)
Testing and Bullet-Proofing Macros	812	(2)
Running Macros	814	(1)
Managing Macros	814	(2)
Macro Security	816	(5)
Using Digital Signatures to Verify a Macro's Source	817	(1)
Configuring Office Security Levels	818	(1)
Blocking Access to the Visual Basic Project	819	(1)
Protecting Your PC and Network from Viruses	820	(1)
Building Interactive VBA Programs	821	(3)
Code Snippets You Can Use	824	(6)
Using VBA to Navigate Office Documents	824	(1)
Using VBA to Augment Find and Replace	825	(2)
Using VBA to Apply Formatting	827	(1)
Using VBA to Loop Through Collections	828	(2)
Troubleshooting	830	(1)
Extra Credit: Getting Ready to Tackle VBA	831	(2)
Using Office to Create Web Pages	833	(20)
Office and the Web	834	(4)
Using HTML, XML, and XHTML	834	(2)
How Office Programs Handle Web Pages	836	(1)
Removing Office-Generated HTML Tags	837	(1)
Viewing Office Documents in a Browser Window	837	(1)
What You Can (and Can't) Do with Office	838	(4)
Word	839	(1)
Excel	839	(2)
PowerPoint	841	(1)
Outlook	841	(1)
Moving Between HTML and Office Formats	842	(2)
Web-Page Design Essentials	844	(3)
Browser-Compatibility Issues	845	(1)
Viewing HTML Source Code	845	(1)
Previewing and Testing Web Pages	846	(1)
Working with Hyperlinks	847	(2)
Troubleshooting	849	(1)
Extra Credit: Viewing and Editing Office Documents in a Web Browser	849	(4)
Using Office on a Tablet PC	853	(12)
Office 2003 and the Tablet PC	854	(2)
Entering and Editing Text on a Tablet PC	856	(4)
Using Ink to Add Annotations and Comments	860	(2)
Using OneNote with Office	862	(1)
Troubleshooting	863	(2)
Index	865

Excerpts

= 0) {slash = '\\';} else {slash = '/';}openLoc = figLoc.substring(0, figLoc.lastIndexOf(slash) + 1);while (pPage.substring(0,3) == '../') {openLoc = openLoc.substring(0, openLoc.lastIndexOf(slash, openLoc.length - 2)+ 1);pPage = pPage.substring(3, pPage.length + 1);}popUpWin =window.open('','popWin','resizable=1,scrollbars=1,location=0,toolbar=0,width=525,height=394');figDoc = popUpWin.document;zhtm= ' ' + pPage + ' ';zhtm += ' ';zhtm += ' ';zhtm += ' ';zhtm += '' + pPage.substring(pPage.lastIndexOf('/') + 1, pPage.length) + '';zhtm += ' ';figDoc.write(zhtm);figDoc.close();}// modified 3.1.99 RWE v4.1 --> INTRODUCTION INTRODUCTIONIn this introduction Who Should Buy This Book How This Book Is Organized Conventions Used in This BookOnce upon a time, Microsoft Office was strictly for the office. Today, its general-purpose tools have been softened and refined, and the capabilities of the programs in the Office family have expanded. Despite the name, Office isn't just for the office anymore.Microsoft Office Home and Student 2007 is packaged and sold for people who plan to use it at home. Although its individual parts are identical to those found in the Office version used in corporate settings, the day-to-day tasks you're likely to tackle are a little different. That's why, in this book, we've shifted the focus to explain how you can use Word, Excel, PowerPoint, and OneNote to produce school reports, family newsletters, and projects for civic and social organizations. Of course, if you want to use the same technique to sneak in a little work on the weekend, we won't tell.The audience may be different, but the depth of our coverage hasn't changed. We still assume you're smart, curious, and able to figure out the truly basic stuff on your own. We show you how to use and customize the common parts of Office 2007--the Quick Access toolbar, task panes, and other interface elements--and how to get along with the new, potentially confusing Ribbon interface.Like its predecessors, Office 2007 still has odd inconsistencies, as well as bugs, features that don't work as expected, and basic interface elements guaranteed to drive expert users crazy. But as we worked with this latest member of the Office family we grew to like it, a lot. Office 2007 still isn't perfect--not by a long shot--but it is more usable than any Office version ever.Some of what you see inSpecial Edition Using Microsoft Office Home and Student 2007will be familiar to you if you've worked with an earlier edition of this book. We've gone through every chapter, sentence by sentence, test