Home Page Icon
Home Page
Table of Contents for
Office 2016 For Dummies®
Close
Office 2016 For Dummies®
by Wallace Wang
Office 2016 For Dummies
Cover
Cover
Introduction
Who Should Buy This Book
Icons Used in This Book
Beyond the Book
Getting Started
Part 1: Getting Started with Office 2016
Chapter 1: Introducing Microsoft Office 2016
Starting an Office 2016 Program
Introducing the Microsoft Office Ribbon
Using the Ribbon
Using the Quick Access Toolbar
Customizing an Office 2016 Program
Exiting Office 2016
Chapter 2: Selecting and Editing Data
Adding Data by Pointing
Selecting Data
Editing Text with the Pop-up Toolbar
Deleting Data
Cutting and Pasting (Moving) Data
Copying and Pasting Data
Using Paste Options
Dragging with the Mouse to Cut, Copy, and Paste
Undo and Redo
Sharing Data with Other Office 2016 Programs
Chapter 3: Modifying Pictures
Adding (and Deleting) Pictures
Manipulating Pictures
Enhancing Pictures
Chapter 4: Getting Help from Office 2016
Searching in the Help Window
Making the Help Window Easier to Read
Finding the Right Commands to Use
Part 2: Working with Word
Chapter 5: Typing Text in Word
Moving the Cursor with the Mouse
Moving the Cursor with the Keyboard
Navigating through a Document
Finding and Replacing Text
Checking Your Spelling
Checking Your Grammar
Viewing a Document
Chapter 6: Formatting Text
Changing the Font
Changing the Font Size
Changing the Text Style
Changing Colors
Justifying Text Alignment
Adjusting Line Spacing
Making Lists
Using the Ruler
Using Format Painter
Using Styles
Using Templates
Removing Formatting from Text
Chapter 7: Designing Your Pages
Inserting New Pages
Adding (and Deleting) a Cover Page
Inserting Page Breaks
Inserting Headers and Footers
Organizing Text in Tables
Formatting and Coloring a Table
Sorting a Table
Deleting Tables
Making Text Look Artistic
Dividing Text into Columns
Previewing a Document before Printing
Part 3: Playing the Numbers with Excel
Chapter 8: The Basics of Spreadsheets: Numbers, Labels, and Formulas
Understanding Spreadsheets
Storing Stuff in a Spreadsheet
Formatting Numbers and Labels
Navigating a Spreadsheet
Searching a Spreadsheet
Editing a Spreadsheet
Clearing Data
Printing Workbooks
Chapter 9: Playing with Formulas
Creating a Formula
Using Functions
Editing a Formula
Conditional Formatting
Data Validation
Goal Seeking
Creating Multiple Scenarios
Auditing Your Formulas
Checking for Errors
Chapter 10: Charting and Analyzing Data
Understanding the Parts of a Chart
Creating a Chart
Editing a Chart
Using the Chart Tools
Using Sparklines
Organizing Lists in Pivot Tables
Part 4: Making Presentations with PowerPoint
Chapter 11: Creating a PowerPoint Presentation
Defining the Purpose of Your Presentation
Creating a PowerPoint Presentation
Working with Text
Chapter 12: Adding Color and Pictures to a Presentation
Applying a Theme
Changing the Background
Adding Graphics to a Slide
Adding Movies to a Slide
Adding Sound to a Slide
Chapter 13: Showing Off a Presentation
Spell-Checking Your Presentation
Organizing Slides in Sections
Adding Visual Transitions
Adding Hyperlinks
Viewing a Presentation
Creating Handouts
Part 5: Getting Organized with Outlook
Chapter 14: Managing Email with Outlook
Configuring Email Settings
Creating Email
Attaching Files to Messages
Reading and Organizing Email
Deleting Email Messages
Creating Quick Steps
Chapter 15: Calendars, Contacts, and Tasks
Setting Appointments
Storing Names and Addresses
Managing Tasks
Part 6: Storing Stuff in Access
Chapter 16: Using a Database
Understanding the Basics of a Database
Designing a Database
Editing and Modifying a Database
Typing Data into a Database
Closing and Saving a Database
Chapter 17: Searching, Sorting, and Querying a Database
Searching a Database
Sorting a Database
Querying a Database
Chapter 18: Creating a Database Report
Using the Report Wizard
Manipulating the Data in a Report
Editing a Report
Making Reports Look Pretty
Deleting a Report
Part 7: The Part of Tens
Chapter 19: Ten Tips for Using Office 2016
Saving Office 2016 Files
Password-Protecting Your Files
Guarding Against Macro Viruses
Customize the Ribbon
Send Feedback to Microsoft
When in Doubt, Right-Click the Mouse
Freezing Row and Column Headings in Excel
Displaying Slides Out of Order in PowerPoint
Reduce Spam in Outlook
Using Office 365 and Office on Android and iOS
Chapter 20: Almost Ten Ways to Make Office 2016 Easier to Use
Build (and Use) Your Own Office Add-Ins
Collaborating with the Review Tab
Using Word’s References Tab
Using Excel’s Data Tab
Saving and Sending Files
Encrypting a File
Saving to the Cloud
Ignoring the Silly Office Ribbon
About the Author
Advertisement Page
Connect with Dummies
End User License Agreement
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Office 2016
Next
Next Chapter
Introduction
Office 2016 For Dummies®
To view this book's Cheat Sheet, simply go to
www.dummies.com
and search for “Office 2016 For Dummies Cheat sheet” in the Search box.
Table of Contents
Cover
Introduction
Who Should Buy This Book
Icons Used in This Book
Beyond the Book
Getting Started
Part 1: Getting Started with Office 2016
Chapter 1: Introducing Microsoft Office 2016
Starting an Office 2016 Program
Introducing the Microsoft Office Ribbon
Using the Ribbon
Using the Quick Access Toolbar
Customizing an Office 2016 Program
Exiting Office 2016
Chapter 2: Selecting and Editing Data
Adding Data by Pointing
Selecting Data
Editing Text with the Pop-up Toolbar
Deleting Data
Cutting and Pasting (Moving) Data
Copying and Pasting Data
Using Paste Options
Dragging with the Mouse to Cut, Copy, and Paste
Undo and Redo
Sharing Data with Other Office 2016 Programs
Chapter 3: Modifying Pictures
Adding (and Deleting) Pictures
Manipulating Pictures
Enhancing Pictures
Chapter 4: Getting Help from Office 2016
Searching in the Help Window
Making the Help Window Easier to Read
Finding the Right Commands to Use
Part 2: Working with Word
Chapter 5: Typing Text in Word
Moving the Cursor with the Mouse
Moving the Cursor with the Keyboard
Navigating through a Document
Finding and Replacing Text
Checking Your Spelling
Checking Your Grammar
Viewing a Document
Chapter 6: Formatting Text
Changing the Font
Changing the Font Size
Changing the Text Style
Changing Colors
Justifying Text Alignment
Adjusting Line Spacing
Making Lists
Using the Ruler
Using Format Painter
Using Styles
Using Templates
Removing Formatting from Text
Chapter 7: Designing Your Pages
Inserting New Pages
Adding (and Deleting) a Cover Page
Inserting Page Breaks
Inserting Headers and Footers
Organizing Text in Tables
Formatting and Coloring a Table
Sorting a Table
Deleting Tables
Making Text Look Artistic
Dividing Text into Columns
Previewing a Document before Printing
Part 3: Playing the Numbers with Excel
Chapter 8: The Basics of Spreadsheets: Numbers, Labels, and Formulas
Understanding Spreadsheets
Storing Stuff in a Spreadsheet
Formatting Numbers and Labels
Navigating a Spreadsheet
Searching a Spreadsheet
Editing a Spreadsheet
Clearing Data
Printing Workbooks
Chapter 9: Playing with Formulas
Creating a Formula
Using Functions
Editing a Formula
Conditional Formatting
Data Validation
Goal Seeking
Creating Multiple Scenarios
Auditing Your Formulas
Checking for Errors
Chapter 10: Charting and Analyzing Data
Understanding the Parts of a Chart
Creating a Chart
Editing a Chart
Using the Chart Tools
Using Sparklines
Organizing Lists in Pivot Tables
Part 4: Making Presentations with PowerPoint
Chapter 11: Creating a PowerPoint Presentation
Defining the Purpose of Your Presentation
Creating a PowerPoint Presentation
Working with Text
Chapter 12: Adding Color and Pictures to a Presentation
Applying a Theme
Changing the Background
Adding Graphics to a Slide
Adding Movies to a Slide
Adding Sound to a Slide
Chapter 13: Showing Off a Presentation
Spell-Checking Your Presentation
Organizing Slides in Sections
Adding Visual Transitions
Adding Hyperlinks
Viewing a Presentation
Creating Handouts
Part 5: Getting Organized with Outlook
Chapter 14: Managing Email with Outlook
Configuring Email Settings
Creating Email
Attaching Files to Messages
Reading and Organizing Email
Deleting Email Messages
Creating Quick Steps
Chapter 15: Calendars, Contacts, and Tasks
Setting Appointments
Storing Names and Addresses
Managing Tasks
Part 6: Storing Stuff in Access
Chapter 16: Using a Database
Understanding the Basics of a Database
Designing a Database
Editing and Modifying a Database
Typing Data into a Database
Closing and Saving a Database
Chapter 17: Searching, Sorting, and Querying a Database
Searching a Database
Sorting a Database
Querying a Database
Chapter 18: Creating a Database Report
Using the Report Wizard
Manipulating the Data in a Report
Editing a Report
Making Reports Look Pretty
Deleting a Report
Part 7: The Part of Tens
Chapter 19: Ten Tips for Using Office 2016
Saving Office 2016 Files
Password-Protecting Your Files
Guarding Against Macro Viruses
Customize the Ribbon
Send Feedback to Microsoft
When in Doubt, Right-Click the Mouse
Freezing Row and Column Headings in Excel
Displaying Slides Out of Order in PowerPoint
Reduce Spam in Outlook
Using Office 365 and Office on Android and iOS
Chapter 20: Almost Ten Ways to Make Office 2016 Easier to Use
Build (and Use) Your Own Office Add-Ins
Collaborating with the Review Tab
Using Word’s References Tab
Using Excel’s Data Tab
Saving and Sending Files
Encrypting a File
Saving to the Cloud
Ignoring the Silly Office Ribbon
About the Author
Advertisement Page
Connect with Dummies
End User License Agreement
Guide
Cover
Table of Contents
Begin Reading
Pages
iii
iv
vii
viii
ix
x
xi
xii
xiii
xiv
xv
xvi
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
51
52
53
54
55
56
57
58
59
60
61
62
63
65
66
67
68
69
70
71
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
455
456
457
458
459
460
461
462
463
464
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset