|
PART I Microsoft 365 Features |
|
|
|
Chapter 1 Microsoft 365 Basics |
|
|
|
Start and Exit Microsoft 365 Apps |
|
|
4 | (2) |
|
|
6 | (1) |
|
|
7 | (1) |
|
|
8 | (2) |
|
Search for a Ribbon Command |
|
|
10 | (2) |
|
|
12 | (2) |
|
Customize the Quick Access Toolbar |
|
|
14 | (351) |
|
|
365 | |
|
|
16 | (2) |
|
Chapter 2 Working with Files |
|
|
|
|
18 | (2) |
|
|
20 | (2) |
|
|
22 | (2) |
|
|
24 | (2) |
|
|
26 | (339) |
|
|
365 | |
|
|
|
Insert a Picture from Your PC |
|
|
28 | (2) |
|
|
30 | (2) |
|
Resize and Move Graphic Objects |
|
|
32 | (2) |
|
Understanding Graphics Modification Techniques |
|
|
34 | (2) |
|
Chapter 4 Working with Microsoft 365 Files Online |
|
|
|
Microsoft 365 and the Cloud |
|
|
36 | (2) |
|
|
38 | (2) |
|
Share a Document from Microsoft 365 |
|
|
40 | (2) |
|
|
42 | (2) |
|
Using an Online App in OneDrive |
|
|
44 | (2) |
|
Open a Document in a Desktop App from OneDrive |
|
|
46 | (2) |
|
Upload a Document to OneDrive |
|
|
48 | (2) |
|
Share a Document Using OneDrive |
|
|
50 | (4) |
|
|
|
|
|
|
54 | (2) |
|
|
56 | (2) |
|
|
58 | (2) |
|
|
60 | (2) |
|
Chapter 6 Formatting Text |
|
|
|
Change the Font, Size, and Color |
|
|
62 | (4) |
|
|
66 | (1) |
|
|
67 | (1) |
|
|
68 | (2) |
|
|
70 | (2) |
|
|
72 | (2) |
|
|
74 | (2) |
|
|
76 | (1) |
|
|
77 | (1) |
|
|
78 | (2) |
|
|
80 | (2) |
|
Chapter 7 Adding Extra Touches |
|
|
|
|
82 | (2) |
|
|
84 | (2) |
|
|
86 | (2) |
|
|
88 | (2) |
|
|
90 | (2) |
|
|
92 | (1) |
|
Insert Table Rows or Columns |
|
|
93 | (1) |
|
|
94 | (2) |
|
Insert Footnotes and Endnotes |
|
|
96 | (2) |
|
Chapter 8 Reviewing Documents |
|
|
|
|
98 | (4) |
|
|
102 | (2) |
|
Navigate Document Content |
|
|
104 | (2) |
|
Check Spelling and Grammar |
|
|
106 | (2) |
|
|
108 | (2) |
|
Using Word's Thesaurus and Dictionary |
|
|
110 | (2) |
|
|
112 | (2) |
|
Track and Review Document Changes |
|
|
114 | (2) |
|
|
116 | (2) |
|
Combine Reviewers' Changes |
|
|
118 | (2) |
|
|
120 | (4) |
|
|
|
Chapter 9 Building Spreadsheets |
|
|
|
|
124 | (2) |
|
|
126 | (2) |
|
Using AutoFill for Faster Data Entry |
|
|
128 | (2) |
|
|
130 | (1) |
|
Center Data Across Columns |
|
|
131 | (1) |
|
|
132 | (2) |
|
|
134 | (2) |
|
|
136 | (1) |
|
Increase or Decrease Decimals |
|
|
137 | (1) |
|
Add Cell Borders and Shading |
|
|
138 | (2) |
|
|
140 | (2) |
|
Apply Conditional Formatting |
|
|
142 | (2) |
|
|
144 | (2) |
|
|
146 | (1) |
|
Freeze Column and Row Titles On-Screen |
|
|
147 | (1) |
|
|
148 | (2) |
|
|
150 | (2) |
|
Chapter 10 Worksheet Basics |
|
|
|
|
152 | (1) |
|
|
153 | (1) |
|
Change Page Setup Options |
|
|
154 | (2) |
|
|
156 | (1) |
|
|
157 | (1) |
|
|
158 | (2) |
|
|
160 | (2) |
|
Filter or Sort Table Information |
|
|
162 | (2) |
|
|
164 | (1) |
|
Understanding Data Analysis Choices |
|
|
165 | (1) |
|
|
166 | (2) |
|
Chapter 11 Workina with Formulas and Functions |
|
|
|
|
168 | (2) |
|
|
170 | (2) |
|
Apply Absolute and Relative Cell References |
|
|
172 | (2) |
|
|
174 | (2) |
|
|
176 | (2) |
|
|
178 | (2) |
|
Chapter 12 Working with Charts |
|
|
|
|
180 | (2) |
|
|
182 | (2) |
|
|
184 | (1) |
|
|
185 | (1) |
|
|
186 | (1) |
|
|
187 | (1) |
|
|
188 | (1) |
|
|
189 | (1) |
|
Using Sparklines to View Data Trends |
|
|
190 | (2) |
|
Understanding PivotTables |
|
|
192 | (2) |
|
|
194 | (2) |
|
|
196 | (2) |
|
Insert a PivotTable Slicer |
|
|
198 | (4) |
|
|
|
Chapter 13 Creating a Presentation |
|
|
|
Create a New Presentation |
|
|
202 | (2) |
|
Create a Photo Album Presentation |
|
|
204 | (2) |
|
|
206 | (2) |
|
|
208 | (2) |
|
|
210 | (2) |
|
|
212 | (2) |
|
Chapter 14 Populating Presentation Slides |
|
|
|
|
214 | (2) |
|
Change the Font, Size, and Color |
|
|
216 | (4) |
|
|
220 | (1) |
|
|
221 | (1) |
|
|
222 | (1) |
|
Add a Text Box to a Slide |
|
|
223 | (1) |
|
|
224 | (2) |
|
|
226 | (2) |
|
Add a Video Clip to a Slide |
|
|
228 | (2) |
|
|
230 | (1) |
|
|
231 | (1) |
|
Chapter 15 Assembling and Presenting a Slideshow |
|
|
|
|
232 | (2) |
|
|
234 | (2) |
|
Organize Slides into Sections |
|
|
236 | (2) |
|
|
238 | (2) |
|
|
240 | (2) |
|
Create a Custom Animation |
|
|
242 | (2) |
|
|
244 | (1) |
|
|
245 | (1) |
|
|
246 | (2) |
|
|
248 | (2) |
|
|
250 | (6) |
|
|
|
Chapter 16 Database Basics |
|
|
|
Understanding Database Basics |
|
|
256 | (2) |
|
Create a Database Based on a Template |
|
|
258 | (2) |
|
|
260 | (2) |
|
|
262 | (2) |
|
|
264 | (2) |
|
|
266 | (1) |
|
Delete a Field from a Table |
|
|
267 | (1) |
|
|
268 | (1) |
|
|
269 | (1) |
|
|
270 | (2) |
|
|
272 | (1) |
|
|
273 | (1) |
|
|
274 | (1) |
|
|
275 | (1) |
|
Chapter 17 Adding, Finding, and Querying Data |
|
|
|
|
276 | (2) |
|
Add a Record Using a Form |
|
|
278 | (2) |
|
Navigate Records Using a Form |
|
|
280 | (1) |
|
Search for a Record Using a Form |
|
|
281 | (1) |
|
Delete a Record from a Table |
|
|
282 | (1) |
|
Delete a Record Using a Form |
|
|
283 | (1) |
|
|
284 | (2) |
|
|
286 | (2) |
|
|
288 | (4) |
|
|
292 | (6) |
|
|
|
Chapter 18 Organizing with Outlook |
|
|
|
|
298 | (2) |
|
|
300 | (2) |
|
|
302 | (2) |
|
|
304 | (2) |
|
|
306 | (2) |
|
Customize the Navigation Bar |
|
|
308 | (2) |
|
Peek at Appointments and Tasks |
|
|
310 | (2) |
|
Chapter 19 E-mailing with Outlook |
|
|
|
Compose and Send a Message |
|
|
312 | (2) |
|
|
314 | (1) |
|
|
315 | (1) |
|
Reply to or Forward a Message |
|
|
316 | (2) |
|
Add a Sender to Your Outlook Contacts |
|
|
318 | (1) |
|
|
319 | (1) |
|
|
320 | (2) |
Create a Message Rule |
|
322 | (2) |
Index |
|
324 | |