9780789734662

Special Edition Using Microsoft Office 2003, Student-Teacher Edition

by ;
  • ISBN13:

    9780789734662

  • ISBN10:

    0789734664

  • Edition: 1st
  • Format: Paperback
  • Copyright: 2006-02-09
  • Publisher: Que Publishing

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Purchase Benefits

  • Free Shipping Icon Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • eCampus.com Logo Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $29.99 Save up to $7.50
  • Buy Used
    $22.49

    USUALLY SHIPS IN 2-4 BUSINESS DAYS

Supplemental Materials

What is included with this book?

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

Rewards Program

Reviews for Special Edition Using Microsoft Office 2003, Student-Teacher Edition (9780789734662)