Microsoft Word 2002 Core MOUS Skills | p. vi |
Microsoft Excel 2002 Core MOUS Skills | p. vi |
Microsoft Access 2002 Core MOUS Skills | p. vii |
Microsoft PowerPoint 2002 Comprehensive MOUS Skills | p. vii |
Welcome | p. viii |
Windows 2000 | |
Exploring Windows 2000 | p. 3 |
Exploring the Windows 2000 Desktop | p. 4 |
Opening and Manipulating Windows | p. 8 |
Exploring the Taskbar | p. 10 |
Maintaining Files and Customizing Windows | p. 17 |
Getting Help in Windows 2000 | p. 18 |
Creating a Folder | p. 22 |
Selecting and Copying Files | p. 24 |
Moving Files | p. 26 |
Deleting Files/Folders to the Recycle Bin | p. 28 |
Restoring Files/Folders and Emptying Files from the Recycle Bin | p. 30 |
Creating and Deleting a Shortcut | p. 32 |
Exploring the Control Panel | p. 34 |
Searching for a File or Folder | p. 36 |
Using WordPad and Paint | p. 38 |
Customizing the Desktop | p. 40 |
Index | p. 16 |
Internet Explorer 5.5 | |
Browsing the Internet Using Internet Explorer 5.5 | p. 3 |
Browsing the Internet Using Internet Explorer | p. 4 |
Navigating Using Hyperlinks | p. 6 |
Searching for Specific Sites | p. 8 |
Completing Advanced Searches for Specific Sites | p. 10 |
Downloading Images, Text, and Web Pages from the Internet | p. 12 |
Index | p. 16 |
Office | |
Introducing Microsoft Office XP | p. 1 |
Touring Office XP | p. 2 |
Preparing Documents Using Word 2002 | p. 4 |
Preparing Workbooks and Analyzing Data Using Excel 2002 | p. 6 |
Managing Data Using Access 2002 | p. 8 |
Preparing Presentations Using PowerPoint 2002 | p. 10 |
Managing E-Mail, Contacts, and Schedules Using Outlook 2002 | p. 12 |
Integrating Data in Office XP | p. 14 |
Index | p. 16 |
Word 2002 | |
Creating and Editing a Document | p. 3 |
Completing the Word Processing Cycle | p. 4 |
Moving the Insertion Point; Inserting, Replacing, and Deleting Text | p. 6 |
Scrolling and Navigating in a Document | p. 8 |
Selecting and Deleting Text; Using Undo and Redo | p. 10 |
Checking the Spelling and Grammar in a Document | p. 12 |
Using AutoCorrect and the Thesaurus | p. 16 |
Using the Help Feature; Highlighting Text | p. 18 |
Previewing and Printing a Document | p. 20 |
Inserting the Date and Time; Closing a Document | p. 22 |
Creating a Document Using a Template | p. 24 |
Managing Documents | p. 26 |
Formatting Characters and Paragraphs | p. 33 |
Applying Fonts and Font Effects Using the Formatting Toolbar | p. 34 |
Changing the Font at the Font Dialog Box; Using the Format Painter | p. 36 |
Applying Effects Using the Font Dialog Box; Repeating a Command | p. 38 |
Aligning Text in Paragraphs | p. 40 |
Indenting Text | p. 42 |
Changing Line and Paragraph Spacing | p. 44 |
Inserting Bullets and Numbering | p. 46 |
Inserting Symbols | p. 48 |
Setting Tabs | p. 50 |
Setting Tabs with Leaders | p. 52 |
Adding Borders and Shading | p. 54 |
Applying Styles and Creating an Outline-Style Numbered List | p. 56 |
Formatting and Enhancing a Document | p. 65 |
Finding and Replacing Text | p. 66 |
Cutting, Copying, and Pasting Text; Using Paste Special | p. 68 |
Using the Clipboard Task Pane | p. 70 |
Inserting a Page Break; Inserting and Modifying Page Numbers | p. 72 |
Changing Margins and Page Orientation | p. 74 |
Changing Views; Using Click and Type; Vertically Aligning Text | p. 76 |
Inserting, Sizing, and Moving Images in a Document | p. 78 |
Inserting, Sizing, and Moving WordArt in a Document | p. 82 |
Using the Drawing Toolbar | p. 84 |
Preparing an Envelope | p. 86 |
Preparing Labels | p. 88 |
Formatting with Special Features | p. 97 |
Creating a Table | p. 98 |
Modifying a Table | p. 100 |
Changing Column Widths and Row Heights; Moving a Table | p. 102 |
Formatting a Table | p. 104 |
Applying Borders and Shading to a Table; Applying AutoFormats | p. 106 |
Inserting a Section Break; Creating Newspaper Columns | p. 108 |
Revising Column Structure | p. 110 |
Inserting a Header or Footer | p. 112 |
Modifying a Header or Footer | p. 114 |
Saving a Document as a Web Page; Creating a Hyperlink; Using Web Page Preview | p. 116 |
Comparing and Merging Documents | p. 118 |
Creating Diagrams and Organizational Charts | p. 120 |
Index | p. 128 |
Excel 2002 | |
Analyzing Data Using Excel | p. 3 |
Completing the Excel Worksheet Cycle | p. 4 |
Entering Labels and Values; Using the Fill Handle | p. 8 |
Performing Calculations Using Formulas | p. 12 |
Using AutoSum | p. 14 |
Copying Relative Formulas | p. 16 |
Testing the Worksheet; Improving the Appearance of Cells | p. 18 |
Using Help | p. 22 |
Previewing, Printing, and Closing a Workbook | p. 24 |
Navigating a Worksheet | p. 26 |
Editing and Formatting Worksheets | p. 33 |
Editing and Clearing Cells; Performing a Spell Check | p. 34 |
Inserting and Deleting Cells; Using Undo and Redo | p. 36 |
Inserting, Deleting, Hiding, and Unhiding Columns and Rows | p. 38 |
Moving and Copying Cells | p. 40 |
Adjusting Column Width and Row Height | p. 42 |
Freezing and Unfreezing Panes; Changing the Zoom | p. 44 |
Changing the Font, Size, Style, and Color of Cells | p. 46 |
Formatting Numeric Cells; Adjusting Decimal Places | p. 48 |
Changing the Alignment and Indentation of Cells | p. 50 |
Adding Borders and Shading; Autoformatting | p. 52 |
Using Find and Replace | p. 56 |
Using Functions, Setting Print Options, and Adding Visual Elements | p. 65 |
Using Statistical Functions AVERAGE, MAX, and MIN | p. 66 |
Using Date Functions NOW and DATE | p. 68 |
Using Financial Function PMT | p. 70 |
Using Logical Function IF | p. 72 |
Changing Margins; Centering a Worksheet on the Page | p. 74 |
Inserting Headers and Footers | p. 76 |
Printing Headings and Gridlines; Scaling a Worksheet | p. 78 |
Creating a Chart | p. 80 |
Modifying a Chart | p. 84 |
Inserting Pictures | p. 86 |
Drawing Arrows and Text Boxes | p. 88 |
Working with Multiple Worksheets and Managing Files | p. 97 |
Inserting, Deleting, and Renaming a Worksheet | p. 98 |
Moving and Copying a Worksheet | p. 100 |
Linking Worksheets; Using 3-D References; Formatting Sheet Tabs | p. 103 |
Printing Multiple Worksheets; Setting the Print Area | p. 106 |
Creating a Workbook from a Template | p. 108 |
Using Styles | p. 110 |
Creating a Web Page from a Worksheet; Inserting and Editing Hyperlinks | p. 112 |
Filtering Lists Using AutoFilter | p. 114 |
Locating a Workbook; Creating a New Folder | p. 116 |
Inserting and Editing Comments | p. 118 |
Creating and Responding to Discussion Comments | p. 120 |
Integrating Word and Excel | p. 129 |
Copying and Pasting Word Data into an Excel Worksheet | p. 130 |
Linking an Excel Worksheet with a Word Document | p. 132 |
Updating Linked Data; Viewing a Link | p. 134 |
Linking an Excel Chart with a Word Document | p. 136 |
Embedding an Excel Worksheet into a Word Document | p. 138 |
Editing an Embedded Worksheet | p. 140 |
Index | p. 144 |
Access 2002 | |
Maintaining Data in Access Tables | p. 3 |
Exploring Database Objects | p. 4 |
Adjusting Column Width; Navigating in Datasheet View | p. 8 |
Finding and Editing Records | p. 10 |
Adding Records in Datasheet View | p. 12 |
Adding Records in Form View | p. 14 |
Deleting Records in Datasheet View | p. 16 |
Sorting Records | p. 18 |
Previewing and Printing | p. 20 |
Formatting the Datasheet | p. 22 |
Using Help | p. 24 |
Compacting and Repairing a Database | p. 26 |
Creating Tables and Relationships | p. 33 |
Creating a Table in Design View | p. 34 |
Using the Lookup Wizard | p. 38 |
Using the Input Mask Wizard | p. 40 |
Validating Field Entries | p. 44 |
Modifying Field Size and Default Value | p. 46 |
Creating a Table Using the Table Wizard | p. 48 |
Creating Relationships | p. 50 |
Creating a Form Using AutoForm | p. 52 |
Creating a New Database Using a Wizard | p. 54 |
Creating Queries, Forms, and Reports | p. 65 |
Creating a Query in Design View | p. 66 |
Using the Simple Query Wizard | p. 68 |
Extracting Records Using Criteria Statements | p. 70 |
Performing Calculations in a Query | p. 72 |
Creating a Parameter Query | p. 74 |
Creating a Form Using the Form Wizard | p. 76 |
Modifying Controls in a Form | p. 80 |
Adding Controls to a Form | p. 82 |
Creating, Previewing, and Printing a Report | p. 84 |
Resizing Controls in a Report | p. 88 |
Modifying Tables and Reports, Performing Calculations, and Viewing Data | p. 97 |
Moving Fields | p. 98 |
Inserting and Deleting Fields | p. 100 |
Modifying Field Properties | p. 102 |
Adding a Calculated Control to a Form | p. 104 |
Modifying a Report; Creating a Calculated Control | p. 106 |
Using the Label Wizard | p. 110 |
Displaying Records in a Subdatasheet | p. 112 |
Applying and Removing Filters | p. 114 |
Creating Data Access Pages | p. 116 |
Inserting Hyperlinks | p. 120 |
Integrating Word, Excel, and Access | p. 129 |
Exporting Access Data to Excel | p. 130 |
Exporting Access Data to Word | p. 132 |
Exporting an Access Report to Word | p. 134 |
Importing Data to a New Table | p. 136 |
Linking Data to a New Table and Editing Linked Data | p. 138 |
Index | p. 144 |
Powerpoint 2002 | |
Preparing a Presentation | p. 3 |
Completing the Presentation Cycle | p. 4 |
Choosing a Design Template, Creating Slides, and Closing a Presentation | p. 8 |
Opening, Navigating, and Inserting Slides in a Presentation | p. 12 |
Changing Views; Choosing a Slide Layout | p. 14 |
Changing the Slide Layout; Selecting and Moving a Placeholder | p. 16 |
Using Help; Checking Spelling | p. 18 |
Running a Presentation | p. 20 |
Using the Pen When Running a Presentation | p. 22 |
Adding Transition and Sound | p. 24 |
Printing and Previewing a Presentation | p. 26 |
Editing Slides and Slide Elements | p. 33 |
Rearranging and Deleting Slides | p. 34 |
Increasing and Decreasing Indents | p. 36 |
Selecting, Cutting, Copying, and Pasting Text | p. 38 |
Applying Font Effects Using the Formatting Toolbar | p. 40 |
Changing the Font Using Buttons on the Formatting Toolbar | p. 42 |
Changing the Font at the Font Dialog Box; Replacing Fonts | p. 44 |
Formatting with Format Painter | p. 46 |
Changing Alignment and Line and Character Spacing | p. 48 |
Changing the Slide Design and Color Scheme | p. 50 |
Inserting, Sizing, and Moving an Image | p. 52 |
Inserting and Recoloring Clip Art Images | p. 54 |
Applying an Animation Scheme | p. 56 |
Formatting and Enhancing a Presentation | p. 65 |
Using the Clipboard Task Pane | p. 66 |
Finding and Replacing Text | p. 68 |
Formatting with a Slide Master | p. 70 |
Formatting with a Title Master Slide | p. 72 |
Inserting and Formatting WordArt | p. 74 |
Drawing and Customizing an Autoshape and a Text Box | p. 76 |
Copying and Rotating Shapes | p. 78 |
Creating a Table in a Slide | p. 80 |
Adding Action Buttons | p. 82 |
Creating an Organizational Chart | p. 84 |
Inserting Headers and Footers | p. 86 |
Creating a Hyperlink; Publishing a Presentation to the Web | p. 88 |
Customizing and Managing a Presentation | |
Applying More than One Design Template; Managing Multiple Slide Masters; Inserting a Bitmap Image | p. 98 |
Customizing and Formatting a Table | p. 102 |
Adding Sound and Video | p. 104 |
Sending a Presentation for Review; Editing a Presentation Sent for Review | p. 106 |
Accepting/Rejecting Changes from Reviewers | p. 110 |
Setting and Rehearsing Timings for a Presentation | p. 112 |
Inserting and Printing Comments | p. 114 |
Creating a Folder; Saving a Presentation in Outline/RTF Format | p. 116 |
Embedding Fonts; Using the Pack and Go Wizard | p. 118 |
Publishing a Presentation to the Web; Broadcasting a Presentation Online | p. 120 |
Integrating Word, Excel, and PowerPoint | p. 129 |
Exporting a PowerPoint Presentation to Word | p. 130 |
Exporting a Word Outline to a PowerPoint Presentation | p. 132 |
Linking an Excel Chart with a Word Document and a PowerPoint Presentation | p. 134 |
Editing a Linked Object | p. 136 |
Embedding a Word Table in a PowerPoint Presentation | p. 138 |
Embedding and Editing a Word Table in a PowerPoint Slide | p. 140 |
Index | p. 144 |
Outlook 2002 | |
Using Outlook 2002 | p. 3 |
Creating and Sending an E-Mail Message | p. 4 |
Replying to, Printing, and Deleting Messages | p. 6 |
Scheduling Appointments and Events | p. 8 |
Scheduling Recurring Appointments; Changing the View | p. 10 |
Editing and Moving Appointments | p. 12 |
Creating a Contacts List | p. 14 |
Editing, Deleting, and Printing Contacts | p. 16 |
Creating and Printing a Tasks List | p. 18 |
Adding a Recurring Task; Updating Tasks | p. 20 |
Using and Customizing Outlook Today | p. 22 |
Saving a Calendar as a Web Page | p. 24 |
Integrating Contacts with the Calendar | p. 26 |
Index | p. 32 |
Table of Contents provided by Syndetics. All Rights Reserved. |