Notes
Slide Show
Outline
1
 
2
 
3
 
4
 
5
 
6
 
7
 
8
 
9
Lesson 1
  • The Basics of Excel
10
 
11
 
12
 
13
 
14
End of Lesson
  • Return to
  • Table of Contents


15
Lesson 2
  • Becoming Familiar with the Toolbars
16
 
17
 
18
 
19
 
20
 
21
 
22
 
23
 
24
 
25
End of Lesson
  • Return to
  • Table of Contents


26
Lesson 3
  • Locating and Using the Major Features
27
 
28
A.  File Menu
29
 
30
 
31
 
32
B.  Edit Menu
33
 
34
 
35
 
36
C.  View Menu
37
 
38
 
39
D.  Insert Menu
40
 
41
 
42
E.  Format Menu
43
 
44
F.  Tools Menu
45
 
46
 
47
G.  Data Menu
48
 
49
 
50
H.  Window Menu
51
 
52
End of Lesson
  • Return to
  • Table of Contents


53
Lesson 1
  • Functions and Formulas
54
 
55
 
56
 
57
 
58
 
59
 
60
 
61
 
62
 
63
 
64
 
65
 
66
 
67
 
68
 
69
 
70
 
71
 
72
 
73
 
74
 
75
 
76
End of Lesson
  • Return to the Table of Contents
77
Lesson 2
  • Page Setup and Printing
78
 
79
 
80
 
81
 
82
 
83
 
84
 
85
End of Lesson
  • Return to the Table of Contents
86
Lesson 3
  • Formatting
  • Part A.  Cells
87
 
88
 
89
 
90
 
91
 
92
 
93
 
94
 
95
 
96
3.  Formatting
  • B.  Rows, Columns, and Sheets
97
 
98
 
99
 
100
 
101
 
102
 
103
End of Lesson
  • Return to the Table of Contents
104
Lesson 4
  • The Fill Feature and
    Other Shortcuts
105
 
106
 
107
 
108
 
109
 
110
 
111
 
112
 
113
 
114
 
115
End of Lesson
  • Return to the Table of Contents
116
Lesson 5
  • Working with Multiple Windows
117
 
118
 
119
 
120
 
121
 
122
 
123
 
124
 
125
 
126
End of Lesson
  • Return to the Table of Contents
127
Lesson 6
  • Inserting/Deleting Rows, Columns, and Individual Cells
128
 
129
 
130
 
131
End of Lesson
  • Return to the Table of Contents
132
Lesson 7
  • Merging Cells
133
 
134
 
135
 
136
End of Lesson
  • Return to the Table of Contents
137
Lesson 8
  • Creating Borders Using the Standard Toolbar
138
 
139
 
140
 
141
End of Lesson
  • Return to the Table of Contents
142
Lesson 9
  • Cell Protection – How and Why
143
 
144
 
145
 
146
 
147
 
148
End of Lesson
  • Return to the Table of Contents
149
Lesson 10
  • Cell Validation
150
 
151
 
152
 
153
 
154
 
155
 
156
 
157
 
158
 
159
End of Lesson
  • Return to the Table of Contents
160
Lesson 11
  • Headers and Footers
161
 
162
 
163
 
164
End of Lesson
  • Return to the Table of Contents
165
Lesson 12
  • Macros
166
 
167
 
168
 
169
 
170
 
171
End of Lesson
  • Return to the Table of Contents
172
Lesson 13
  • Auto-Formatting
173
 
174
 
175
 
176
End of Lesson
  • Return to the Table of Contents
177
Lesson 14
  • Bookmarks
178
 
179
 
180
 
181
 
182
 
183
 
184
End of Lesson
  • Return to the Table of Contents
185
Lesson 15
  • Hyperlinking
186
 
187
 
188
 
189
 
190
 
191
End of Lesson
  • Return to the Table of Contents
192
Lesson 16
  • Creating and Manipulating Comments
193
 
194
 
195
 
196
 
197
 
198
 
199
 
200
End of Lesson
  • Return to the Table of Contents
201
Lesson 17
  • Conditional Formatting
202
 
203
 
204
 
205
 
206
 
207
 
208
 
209
 
210
 
211
End of Lesson
  • Return to the Table of Contents
212
Lesson 18
  • Format Painter – Standard Toolbar Button
213
 
214
 
215
 
216
End of Lesson
  • Return to the Table of Contents
217
Lesson 19
  • Creating and Working with Charts and Graphs
218
 
219
 
220
 
221
 
222
 
223
 
224
 
225
 
226
 
227
 
228
 
229
End of Lesson
  • Return to the Table of Contents
230
Lesson 20
  • Creating Emails Using the Email Button – Standard Toolbar Button
231
 
232
 
233
 
234
 
235
End of Tutorial
  • Return to the Table of Contents