How to Use This Book |
|
iv | |
Preface |
|
vi | |
What's New |
|
ix | |
Start-Up Checklist |
|
x | |
Guide for Using this Book |
|
x | |
The Microsoft Office User Specialist Program |
|
xiii | |
UNIT Introduction |
|
|
Microsoft Office XP Basics and the Internet |
|
|
1 | (1) |
UNIT Introductory Microsoft Word |
|
|
|
2 | (18) |
|
Introduction to Word Processing |
|
|
2 | (1) |
|
Creating a New Word Document |
|
|
3 | (1) |
|
Viewing the Document Screen |
|
|
4 | (1) |
|
Understanding the Normal View Screen |
|
|
4 | (1) |
|
|
5 | (1) |
|
Navigating Through a Document |
|
|
6 | (2) |
|
|
8 | (1) |
|
Locating and Opening an Existing Document |
|
|
9 | (1) |
|
|
10 | (2) |
|
|
12 | (1) |
|
Selecting a Page Orientation |
|
|
13 | (2) |
|
|
15 | (5) |
|
|
20 | (13) |
|
|
20 | (2) |
|
Using the Backspace and Delete Keys |
|
|
22 | (1) |
|
|
22 | (1) |
|
|
23 | (1) |
|
|
24 | (3) |
|
|
27 | (6) |
|
|
33 | (21) |
|
|
33 | (8) |
|
Using the Spelling and Grammar Checker |
|
|
41 | (2) |
|
Inserting the Date and Time |
|
|
43 | (1) |
|
|
44 | (2) |
|
|
46 | (4) |
|
|
50 | (4) |
|
|
54 | (13) |
|
|
54 | (1) |
|
|
55 | (7) |
|
|
62 | (1) |
|
|
63 | (4) |
|
Formatting Paragraphs and Documents |
|
|
67 | (23) |
|
|
67 | (1) |
|
|
67 | (2) |
|
|
69 | (1) |
|
Changing Indents and Spacing |
|
|
70 | (3) |
|
Changing Vertical Alignment |
|
|
73 | (1) |
|
|
74 | (1) |
|
|
75 | (2) |
|
Bulleted and Numbered Lists |
|
|
77 | (2) |
|
|
79 | (4) |
|
Sorting Text in a Document |
|
|
83 | (2) |
|
|
85 | (5) |
|
Desktop Publishing with Word |
|
|
90 | (22) |
|
What Is Desktop Publishing? |
|
|
90 | (1) |
|
|
90 | (2) |
|
Using Borders and Shading |
|
|
92 | (3) |
|
|
95 | (9) |
|
Creating Diagrams and Charts |
|
|
104 | (3) |
|
|
107 | (5) |
|
|
112 | (27) |
|
Switching Between Documents |
|
|
112 | (1) |
|
Copying and Pasting Text Between Documents |
|
|
113 | (1) |
|
|
114 | (1) |
|
Working with Multipage Documents |
|
|
115 | (4) |
|
Inserting Headers and Footers |
|
|
119 | (2) |
|
Creating Footnotes and Endnotes |
|
|
121 | (2) |
|
Creating a Section with Formatting That Differs from Other Sections |
|
|
123 | (1) |
|
|
124 | (1) |
|
Inserting and Formatting Tables |
|
|
125 | (5) |
|
Organizing a Document in Outline View |
|
|
130 | (3) |
|
Assigning Outline Levels to Paragraphs |
|
|
133 | (1) |
|
|
134 | (5) |
|
Increasing Efficiency Using Word |
|
|
139 | |
|
Using Templates and Wizards |
|
|
139 | (6) |
|
|
145 | (5) |
|
Creating and Printing Envelopes |
|
|
150 | (2) |
|
Creating and Printing Labels |
|
|
152 | (1) |
|
|
153 | (2) |
|
|
155 | (5) |
|
Sending a Word Document via E-mail |
|
|
160 | (1) |
|
|
160 | (3) |
|
|
163 | (4) |
|
|
167 | |
Unit Introductory Microsoft Excel |
|
|
|
2 | (19) |
|
|
2 | (1) |
|
|
3 | (2) |
|
Opening an Existing Worksheet |
|
|
5 | (1) |
|
Moving the Highlight in a Worksheet |
|
|
6 | (2) |
|
Selecting a Group of Cells |
|
|
8 | (1) |
|
|
9 | (2) |
|
|
11 | (1) |
|
|
12 | (2) |
|
|
14 | (1) |
|
|
14 | (1) |
|
|
15 | (1) |
|
|
16 | (5) |
|
Changing the Appearance of a Worksheet |
|
|
21 | (20) |
|
Changing the Size of a Cell |
|
|
21 | (2) |
|
Positioning Text Within a Cell |
|
|
23 | (4) |
|
|
27 | (3) |
|
|
30 | (5) |
|
|
35 | (6) |
|
|
41 | (22) |
|
|
41 | (5) |
|
|
46 | (1) |
|
Inserting and Deleting Rows and Columns |
|
|
47 | (1) |
|
|
48 | (2) |
|
|
50 | (4) |
|
Checking Spelling on a Worksheet |
|
|
54 | (2) |
|
|
56 | (7) |
|
|
63 | (19) |
|
|
63 | (1) |
|
|
64 | (2) |
|
|
66 | (1) |
|
Relative, Absolute, and Mixed Cell References |
|
|
67 | (2) |
|
Creating Formulas Quickly |
|
|
69 | (2) |
|
|
71 | (1) |
|
|
72 | (3) |
|
|
75 | (7) |
|
|
82 | (20) |
|
|
82 | (1) |
|
Parts of Function Formulas |
|
|
82 | (2) |
|
|
84 | (10) |
|
|
94 | (8) |
|
Making the Worksheet Useful |
|
|
102 | (27) |
|
|
102 | (1) |
|
|
103 | (2) |
|
|
105 | (1) |
|
Using Draw in the Worksheet |
|
|
106 | (3) |
|
Adding a Picture to a Worksheet |
|
|
109 | (5) |
|
|
114 | (3) |
|
Inserting Hyperlinks in Files |
|
|
117 | (1) |
|
Saving Workbooks in Different Formats |
|
|
118 | (2) |
|
Viewing and Editing Comments |
|
|
120 | (3) |
|
|
123 | (6) |
|
Working with Multiple Worksheets |
|
|
129 | (13) |
|
|
129 | (1) |
|
|
129 | (2) |
|
Positioning Worksheets in a Workbook |
|
|
131 | (1) |
|
Consolidating Workbook Data |
|
|
132 | (2) |
|
|
134 | (3) |
|
|
137 | (5) |
|
|
142 | |
|
What Is a Worksheet Chart? |
|
|
142 | (2) |
|
Types of Worksheet Charts |
|
|
144 | (2) |
|
Creating a Chart from a Worksheet |
|
|
146 | (1) |
|
|
146 | (5) |
|
Creating an Embedded Chart |
|
|
151 | (2) |
|
Creating Other Types of Charts |
|
|
153 | (8) |
|
|
161 | (7) |
|
|
168 | (9) |
|
|
177 | |
UNIT Introductory Microsoft Access |
|
|
|
2 | (23) |
|
|
2 | (1) |
|
|
3 | (1) |
|
|
4 | (3) |
|
|
7 | (12) |
|
|
19 | (6) |
|
|
25 | (16) |
|
|
25 | (5) |
|
Changing Datasheet Layout |
|
|
30 | (6) |
|
|
36 | (5) |
|
Creating and Modifying Forms |
|
|
41 | (19) |
|
|
41 | (8) |
|
|
49 | (6) |
|
Compacting and Repairing a Database |
|
|
55 | (1) |
|
|
56 | (4) |
|
Finding and Ordering Data |
|
|
60 | (24) |
|
|
60 | (2) |
|
|
62 | (8) |
|
|
70 | (3) |
|
|
73 | (1) |
|
|
73 | (1) |
|
|
74 | (3) |
|
Creating a Multitable Query |
|
|
77 | (3) |
|
|
80 | (4) |
|
|
84 | (20) |
|
|
84 | (12) |
|
|
96 | (4) |
|
|
100 | (4) |
|
|
104 | |
|
Importing and Exporting Data |
|
|
104 | (3) |
|
|
107 | (6) |
|
|
113 | (4) |
|
|
117 | (4) |
|
|
121 | |
UNIT Introductory Microsoft PowerPoint |
|
|
|
2 | (14) |
|
Introduction to PowerPoint |
|
|
2 | (1) |
|
|
2 | (1) |
|
Opening and Viewing an Existing Presentation |
|
|
3 | (2) |
|
|
5 | (1) |
|
|
6 | (3) |
|
|
9 | (1) |
|
|
10 | (1) |
|
|
11 | (1) |
|
Closing a Presentation and Exiting PowerPoint |
|
|
12 | (1) |
|
|
13 | (3) |
|
Enhancing a PowerPoint Presentation |
|
|
16 | (30) |
|
|
16 | (2) |
|
Applying a Design Template |
|
|
18 | (2) |
|
|
20 | (1) |
|
|
21 | (2) |
|
|
23 | (6) |
|
|
29 | (1) |
|
|
30 | (1) |
|
|
31 | (1) |
|
|
32 | (6) |
|
Adding a Header or Footer |
|
|
38 | (2) |
|
|
40 | (1) |
|
Saving a Presentation as Rich Text Format |
|
|
41 | (1) |
|
|
42 | (4) |
|
Working with Visual Elements |
|
|
46 | (23) |
|
Working with Organization Charts |
|
|
46 | (3) |
|
|
49 | (3) |
|
|
52 | (3) |
|
Creating Shapes and Objects |
|
|
55 | (2) |
|
|
57 | (6) |
|
|
63 | (3) |
|
|
66 | (3) |
|
Expanding on PowerPoint Basics |
|
|
69 | |
|
Integrating PowerPoint with Other Office Programs |
|
|
69 | (8) |
|
Working with Multiple Presentations |
|
|
77 | (2) |
|
Formatting Text and Objects |
|
|
79 | (1) |
|
Aligning Text and Pictures |
|
|
80 | (1) |
|
Delivering a Presentation |
|
|
81 | (6) |
|
Publishing Presentations to the Web |
|
|
87 | (3) |
|
Sending a Presentation via E-mail |
|
|
90 | (4) |
|
|
94 | (3) |
|
|
97 | |
UNIT Introductory Microsoft Outlook |
|
|
Outlook Basics and E-mail |
|
|
2 | (23) |
|
|
2 | (2) |
|
|
4 | (5) |
|
|
9 | (3) |
|
|
12 | (9) |
|
|
21 | (4) |
|
|
25 | (17) |
|
|
25 | (13) |
|
|
38 | (4) |
|
Working with Other Outlook Tools |
|
|
42 | |
|
|
42 | (2) |
|
|
44 | (8) |
|
|
52 | (2) |
|
|
54 | (2) |
|
|
56 | (1) |
|
|
57 | (3) |
|
|
60 | |
UNIT Introductory Microsoft Publisher & Microsoft FrontPage |
|
|
|
2 | (14) |
|
Introduction to Publisher |
|
|
2 | (1) |
|
|
2 | (1) |
|
|
3 | (1) |
|
Personal Information Sets |
|
|
4 | (2) |
|
|
6 | (2) |
|
|
8 | (3) |
|
Other Types of Publications |
|
|
11 | (2) |
|
|
13 | (3) |
|
|
16 | |
|
Introduction to FrontPage |
|
|
16 | (3) |
|
|
19 | (20) |
|
|
39 | (1) |
|
|
40 | (4) |
|
|
44 | |
Capstone Simulation |
|
1 | (1) |
Appendix A: The Microsoft Office User Specialist Program |
|
1 | (1) |
Appendix B: Windows Basics |
|
1 | (1) |
Appendix C: Computer Concepts |
|
1 | (1) |
Appendix D: Using Microsoft Office XP Speech Recognition |
|
1 | (1) |
Glossary |
|
1 | (1) |
Index |
|
1 | |