Index
Symbols
+ (addition) operator 218
& (concatenation) operator 218
#DIV/0! error code 230
/ (division) operator 218
##### error code 230
^ (exponentiation) operator 218
* (multiplication) operator 218
#NAME? error code 230
- (negation) operator 218
% (percentage) operator 218
#REF! error code 230
– (subtraction) operator 218
#VALUE! error code 230
A
absolute references
changing from relative 214
creating 217
accepting tracked changes in documents 131–132
accessing documents
restricting with passwords 144–149
restricting with rights management 149
accounts
displaying Office settings 20
Active view 528
Address Block merge field 179–181
address books, searching 437–438
address lists
searching 438
troubleshooting 435
AGGREGATE function 245, 247, 250–252
aliases 430
Align Left 71
Align Right 71
aligning
decimal points 81
lines of text 80
tabs 83
text, using tab stops 80
All Items list, filtering 463
All Markup view 122
animating
pie charts 392
animation effects
adding sound 402
configuring 390
copying between objects 395
live preview 394
Motion Path 389
removing 396
reordering 400
Animation Painter 396
animations 386
adding sound effects 402
fine-tuning 399
indicators 398
as individual events 398
on click 398
opening effect-specific dialog box 400
ordering 391
positioning objects on slides 391
reordering 391
setting duration 401
timing 401
turning off live preview 394
types 386
app windows
changing backgrounds 20
changing color schemes 20
maximizing 13
personalizing 19
Quick Access Toolbar 6
appointment window 504
converting into events 510–511
converting into meetings 512
creating from messages 510–511
creating recurrences 517
default availability 513
displaying on calendars 505
editing 507
indicating availability 516
InfoBar 505
modifying 516
opening new appointment windows 506
resizing 507
arguments
array 253
col_index_num 277
definition 207
fv 207
k 253
lookup_value 277
nper 207
pv 207
range_lookup 277
rate 207
table_array 277
type 207
VLOOKUP function 276
arrays 253
artistic effects
applying to pictures 361
applying to text 88
ascending order, sorting bulleted lists 94
attachments
arranging messages by 482
copies of online files 449
forwarding messages 465
modifying 445
opening in default app 457
Outlook items 450
saving to storage drives 457–458
scanning for viruses 456
sending from File Explorer 449
attendees 519
adding to meetings 521
optional 523
removing 524
required 523
tracking meeting responses 521
attributes
files 53
automatically starting 410
downloading 404
fading into/out of 408
inserting onto slides 406
preventing from stopping 409
supported formats 404
audio content
adding narration 404
customizing 406
starting 405
trimming 408
audio playback
automatically starting 409
controls 405
manually starting 409
auditing formulas for errors 229
AutoCalculate
summarizing filtered data lists 247
summarizing values 252
AutoFormat As You Type 96, 202
AutoFormatting options 96
automatic calculations 226
AVERAGE function 207, 247–248, 250
AVERAGEIFS function 220
B
Background Removal tool tab 360
backgrounds (PowerPoint) 336–346
Format Background pane 337, 340
removing from pictures 359–360
managing account information 18
balloons
comments 116
displaying markup 125
Bar Tab 81
bitmap (BMP) file format 355
bits per pixel (bpp) 355
blind courtesy copies 430
BMP (bitmap) file format 355
Border Lines 96
borders (Word)
adding lines 96
paragraphs 79
bpp (bits per pixel) 355
branches, conversations 477
build slides 392
built-in styles, applying to text 97–103
built-in themes, applying to documents 106
bulleted lists 91
See also lists
converting from paragraphs 93
formatting on the fly 92
sorting into ascending/descending order 94
starting new 92
bullets 94
C
Cached Exchange Mode, enabling 463
See also formulas; iterative calculations
automatic 226
dependents 231
error codes 230
finding errors 229
linear 299
manual 226
assiging importance 515
indicating availability 513, 516
modifying 516
privacy 514
calendars
Active view 528
Calendar view 528
changing displayed time period 531
connecting to 503
date areas 505
Day arrangement 529
displaying seven-day week 534
displaying specific day 534
displaying task lists 534
displaying today’s schedule 534
displaying week numbers 531
displaying work week schedule 534
List view 528
Month arrangement 529
navigating in Month view 531
Preview view 528
privacy indicator 514
reminder icon 513
removing holidays 509
resetting views 530
returning to default settings 535
Schedule view arrangement 529
ScreenTips 505
time slots 505
Week arrangement 529
Work Week arrangement 529
Call or Call All message responses 466
capturing screen clippings 372–374
See also messages
appointments 515
arranging messages by 483
assigning colors 488
assigning shortcut keys 488
assigning to notes 490
Categorize menu 489
conversations 488
deleting 494
elements 488
events 515
filtering by 489
grouping items by 489
holidays 509
meetings 515
naming 488
removing 493
searching 486
sorting by 489
viewing in Reading Pane 488
Categorize menu 489
cell colors, sorting data by 267
cell formats and VLOOKUP 278
cell ranges
converting tables to 205
creating tables from 202
named 198
watching values in 234
with numbers, counting 222
cell references
absolute 217
circular 225
relative 217
error codes 230
error indicators 233
excluding from tables 202
expanding selection 210
meeting conditions 223
named ranges 198
selecting in formulas 209
setting watches 232
Center Shadow Rectangle picture frame style 376
Center Tab 81
changes, tracking See tracked changes
applying 85
best practices 91
definition 84
removing 90
types 84
character spacing, changing 85, 90–91
characters, subscript/superscript 88
Check Spelling As You Type option 133
chiclet 459
circular references 225
cleaning up conversations 480
closing files 60
coauthoring 115
inserting comments into documents 116–118
col_index_num argument 277
Color Categories dialog box, opening 492
color schemes, changing for all apps 20
color sets in themes 104
colors
applying to presentations 334
fonts 88
non-theme 344
notes 490
tracking changes using 119–120
column input cell 294
columns, in worksheets
adding to Excel tables 202, 204
commands
formatting 364
repeating formatting 90
comments
adding to data set scenarios 287
balloons 116
deleting 130
displaying 126
editing 130
hidden 116
inserting into documents 116–118
marking as done 130
moving between 129
Compatibility mode 55
Compound Frame, Black picture frame style 376
conditional formulas
averages that meet conditions 224
creating 219
summarizing data 222
sums that meet conditions 223
conditional functions 220
contact cards
displaying for message participants 459–462
initiating contact from 462–463
pinning 460
conversation bubble icons, hidden comments 116
conversations 476
See also messages
benefits of using 477
branches 477
deleting 478
deleting messages from folders 478–481
displaying all messages 476, 478
displaying color category blocks 488
displaying message lists 480
displaying messages 480
displaying messages in any folder 478
displaying most recent messages 476
history 462
indenting older messages 478
moving from folders 497
multiple responses 477
participants 461
selecting all messages 477, 480
stop ignoring 482
unique messages 476
unread messages 477
copying
formatting from one shape to another 369
values 270
copyrighted pictures 352
COUNT function 207, 220, 248, 250
COUNTBLANK function 220
COUNTIF function 220
COUNTIFS function 220
courtesy copies 430
cropping pictures 357
cursor movement and keyboard 45
custom color model 345
custom groups in subtotals 275
custom lists, sorting data using 268–270
D
Daily Task List 534
data
analyzing using data tables 292–295
analyzing using descriptive statistics 303–304
analyzing using Quick Analysis Lens 284–286
circling invalid data 257
filtering in worksheets 262–268
organizing into levels 271–275
sorting using custom lists 268–270
summarizing in tables 202
summarizing with AutoCalculate 252
validation rules 255
Data Analysis add-ins, adding to ribbon 304
data lists
creating custom groups in 275
hiding/showing details in 274
removing custom groups 275
removing subtotals from 275
data, mail merge
merging to new documents 182–183
refreshing 178
data ranges
adding total columns/rows 285
See also scenarios
adding tables 286
adding totals 286
defining alternative values 287, 289
defining multiple alternative values 290–291
deleting 290
displaying 289
formatting summaries 285
using descriptive statistics 304
varying for specific results 295–297
data sources, mail merge
linking to merge fields 178
mail merge 160
mail merge requirements 168–169
refining records 173
data tables
changing variables 293
column input cell 294
location in cell ranges 292
row input cell 294
date and time, displaying current 215
date areas on calendars 505
Day calendar arrangement 529
decimal points, aligning 81
Decimal Tab 81
See also removing
comments 130
descending order, sorting bulleted lists 94
details, hiding/showing in subtotal summary lists 274
digital signatures See signatures
Display For Review options 122–123
displaying
author of tracked change 131
coauthor changes 152
comments 126
time of tracked change 131
distribution lists 461
docking panes 99
Document Formatting gallery 98
Document Themes folder location 106–107
documents
adding envelopes 186
applying built-in themes 106
browsing objects 48
changing theme elements 106
closing 60
collaborating 115
creating based on templates 42
default theme 106
editing 152
expanding/collapsing sections 103
formatting marks 52
formatting restrictions 138–144
hiding/unhiding gridlines 52
hiding/unhiding guides 52
hiding/unhiding rulers 52
highlighting merge fields 180
identifying locked areas 152
nonprinting characters 52
opening protected documents 146–147
previewing merged 182
saving 59
spelling checks 133
dots (pixels) 355
Draft view 49
drafts
automatic saving increments 441
saving messages as 438–439, 441–442
E
comments 130
inviting others to edit 152
photo album settings 380
removing restrictions 144
Effect Options 399
effect style, applying to presentations 335–336
effects
fonts 85
WordArt 86
electronic postage 186
email addresses
comma separators 437
removing from Auto-Complete List 436
email messages See messages
embed code 410
embedded videos, selecting 414
Emphasis animation effects 388, 391
Encrypted option 144
Entrance animation effects 387, 391
envelopes
adding to documents 186
creating individual 184
editing addresses 184
electronic postage 186
manually entering addresses 186–187
positioning addresses 185
saving 188
setting up from addresses 187
storing return addresses 185–186
Error Checking tool 232
error codes in calculations 229, 230
errors
changing display options 234
circular references 225
Error Checking tool 232
finding/fixing in calculations 229–232
tracing precedents 230
events 504
converting to appointments 512
converting to invited events 512
creating recurrences 517
displaying on calendars 505
indicating availability 516
invited 510
modifying 516
reminders, changing default 516
Evolutionary solver method 299
Excel 2016
file extensions 54
file formats 54
views 49
Exit animation effects 389–391
F
Facebook accounts, connecting to 19
faxing messages 448
fields, mail merge 160
files
accessing from OneDrive 61
attributes 53
automatically saving 58
creating based on installed templates 42
creating based on online templates 42
displaying different views 48–50
displaying multiple 52
displaying properties 56
editing properties 56
extensions 54
Office version compatibility 54–55
opening in web browsers 47
previewing design templates 41
properties 53
saving copies 59
saving in previous Office versions 55
saving to SharePoint 57
sending from File Explorer 444, 449
sending from Office apps 444, 447–448
settings 53
starting new 41
switching among views 51
switching between 50
templates 40
viewing in multiple windows 50
filtered data lists, summarizing visible cells 247
filtering
All Items list 463
by categories 489
defining criteria 241
summarizing worksheet data 247–253
filters
clearing from worksheets 245
creating rules 244
selection 244
Final view (Word 2010) See No Markup view
first line indent, creating 78
First Line Indent marker 76–77
flags, arranging messages by 483
Flickr accounts, connecting to 19
flipping shapes 366
Font dialog box 90
font sets
applying to presentations 334–335
built-in 104
fonts
changing colors 88
changing for selected text 87
changing sizes 87
default 84
effects 85
size 84
style 85
Format Background pane 337, 340
formatting
alignment 71
AutoCorrect Options 92
commands 364
copying to other text 89
lists 92
paragraph borders 79
paragraph shading 79
previewing 9
removing 90
removing restrictions 144
repeating previous commands 90
text as you type 96
text on a shape 369
tracked changes 119
formatting marks, displaying 52
See also calculations
absolute references 214
averages that meet conditions 224
calculating payments 215
calculating values 206
creating 215
creating AGGREGATE 253
creating subtotals 252
displaying date and time 215
displaying errors 224, 231, 233, 234
duplicate results 228
Error Checking tool 232
error codes 229
generating specific results 295, 297
identifying dependents 233
identifying precedents 233
incomplete results 228
inserting functions 222
interative calculations 225
moving 217
NOW(), updating 215
operator precedence 218
operators 218
predefined 206
recalculating workbooks 226
referring to named ranges 216
referring to table columns 216
summarizing data 222
sums that meet conditions 223
tracer arrows 231
values from named ranges 208
VLOOKUP 278
Forward As Attachment message responses 465
Forward message responses 465
forwarding messages 464–465, 470
frame styles, pictures 376
function_num argument 248, 252–253
functions
AVERAGEIFS 220
COUNTBLANK 220
COUNTIF 220
COUNTIFS 220
HLOOKUP 278
IF 222
IFERROR 220
MEDIAN 251
MODE.SNGL 251
NOW 207
PERCENTILE.EXC 251
PERCENTILE.INC 251
PMT 207
PRODUCT 249
SMALL 251
SUMIF 220
SUMIFS 220
fv argument 207
G
GIF (Graphics Interchange Format) 355
gradients, slide backgrounds 337–338, 342–343
grammar errors, hiding 23
formatting commands 364
types 351
Graphics Interchange Format (GIF) 355
Greeting Line merge field 179, 181
GRG Nonlinear solver method 299
gridlines, hiding 52
grouping shapes 369
guides, hiding 52
H
Hanging Indent marker 94
hanging indents
in lists 91
hidden characters 80
hidden comments 116
hiding
Animation Pane 395
document markup 126
grammar errors 23
gridlines 52
guides 52
paragraph marks 82
rulers 52
spelling errors 23
tracked changes 120
highlighting text in documents 89
HLOOKUP function 278
I
IF function 222
IFERROR function 220
ignoring conversations 478, 482
importing
custom data lists 269
indenting
lists 93
paragraphs 78
InfoBar 505
information rights management (IRM) 149
Insert New Pictures dialog box 377
Insert Picture dialog box 353
inserting
comments into documents 116–118
on-screen window images onto slides 372–373
integer programming 299
IR (information rights management) 149
italic, applying to text 87
iterative calculations 225–227
See also calculations
J
jelly bean 459
JPEG (Joint Photographic Experts Group) 355
K
k argument 253
keyboard and cursor movement 45
keyboard shortcuts 45
creating tables 202
expanding cell selections 210
L
labels See mail merge labels; mailing labels
LARGE function 251
layouts, photo albums 375
Left Tab 81
letters
merge field placeholders 162
merge fields 179
templates 162
level buttons in worksheet outlines 273
line break characters 80
line breaks, inserting 82
linear calculations 299
LinkedIn accounts, connecting to 19
List view 528
See also bulleted lists; numbered lists
automatic formatting 92
creating multiple levels 93
customizing 92
definition 91
ending 92
modifying indentation 93
locking documents 152
lookup_value argument 277
lowercase 91
M
magnifying screen display 13
mail merge
creating new data sources 172–173
data source requirements 168–169
data sources 159, 160, 162, 169–170
definition 159
displaying Mail Merge Recipients list 174
editing custom greetings 167
fields 160
filtering recipients list 174–175
importing contacts 170
importing data from Exchange 170
manually excluding records 177
merge fields 161
records 160
refining data source records 173–177
refreshing data 178
removing data source records 173–174
removing duplicate records 176
selecting existing data sources 169–172
sorting records in data sources 177–178
tools 160
types of output 161
using the Mail Merge wizard 161
validating addresses 174
manufacturers and products 164
uses for 163
mailing addresses
editing on envelopes 184
validating 174
managing simple graphics 351–382
manual calculations 226
markup 116
hiding 126
responding to comments 128–130
mathematical operators
controlling order of 218
list of 218
media, compressing/uncompressing 415–417
MEDIAN function 251
meeting invitations, creating from messages 464
accepting 526
creating 522
declining 526
editing 524
tenatively accepting 526
meetings
attendee availability 519–520, 523
changing times 521
conference rooms 519
creating recurrences 517
default availability 513
indicating availability 516
inviting groups of people 519
inviting managed resources 519
modifying 516
opening new meeting window 521
optional attendees 523
removing attendees 524
requirements 519
Room Finder 519
Skype for Business 504
tracking attendee responses 521
menus, resizing 393
merge fields 161
highlighting in documents 180
linking to data sources 178
placeholders 162
merged documents, previewing 182
merging
message folders, creating 496–497
drafts 439
icons 452
message lists 475
changing default settings 480
default order 475
message participants
communication history 462
online status 459
message responses
address boxes 464
etiquette 465
forwarding 465
meeting requests 466
modifying recipients 465
task assignments 466
voting buttons 466
See also categories; conversations
address boxes 464
arranging by account 482
arranging by attachments 482
arranging by attributes 482–486
arranging by categories 483
arranging by flags 483
arranging by importance 483
arranging by item type 483
arranging by primary recipients 483
arranging by senders 483
arranging by size 483
arranging by subject 483
assigning categories 492
attaching online file copies 449
attaching Outlook items 444–445, 450
body 429
closing after responding 470–471
creating appointments from 510–511
displaying as conversations 477
downloading external content 453
editing custom greetings 167
entering content 432
entering email addresses 432
entering subjects 432
expanding groups 486
faxing 448
grouping/ungrouping 485
HTML format 428
icons in headers 452
multiple categories 487
opening 452
personalizing 428
Plain Text format 428
previewing 499
Reading Pane 452
recipients 430
removing attachments 449
Reply 464
Reply All 464
Reply with Meeting 464
resetting arrangements 486
Rich Text format 428
security settings 453
selecting groups 485
sending 443
sending from specific accounts 440
sending to aliases 430
signatures 428
sorting by column 485
verifying sent items 444
MODE.SNGL function 251
Month calendar arrangement 529
Motion Path animation effects 389
moving
between comments 129
formulas 217
groups of shapes 370
shapes 366
between tracked changes 128
multiple data set scenarios 290
N
creating 200
creating from data with headings 200
defining cells as 198
deleting 201
managing 199
referring to in formulas 216
supplying formula values 208
names, removing from Auto-Complete List 436
naming Excel tables 203
narration 402
new mail notifications 451
No Markup view 123
nonprinting characters, displaying 52
Normal template styles 97
Normal view 49
Notes Page view 49
notes, storing information in 490–491
notifications 451
NOW() formulas, updating 215
NOW function 207
nper argument 207
Number Filters 240
numbered lists 91
See also lists
converting from paragraphs 93
formatting on the fly 92
predefined numbering 95
restarting 95
starting 95
starting new 92
numbers
changing styles 94
defining custom styles 95
O
objects
animating on slides 386, 392–394
applying multiple animation effects 391
applying multiple effects 395
browsing in documents 48
copying effects 395
positioning on slides 391
removing animations 396
Office 365 subscriptions 18, 21
Office 2016 3
managing updates 21
Quick Access Toolbar 6
starting 4
Office themes 19
on click animations 398
OneDrive 60
accessing files 61
connecting to 19
OneDrive for Business 61
one-variable data tables 293–294
opening protected documents 146–147
organization levels in worksheets 273
organizing
items in folders 495
Original view 123
outline area, worksheets 273
Outline Level settings 102
Outline view 49
outlines
displaying in Navigation pane 103
expanding/collapsing 103
levels 102
subheadings 103
Outlook items, attaching to messages 444–445, 450
Outlook Options dialog box, opening 436
P
Page Break Preview view 49
paragraph indent 76
paragraph marks, displaying/hiding 82
Paragraph Spacing options 73
paragraphs
adjusting spacing between lines 75
breaking lines 80
configuring borders 79
converting to lists 93
first line indents 78
formatting 70
formatting as lists 92
hidden characters 80
indenting beyond margins 78
indenting right edge 78
inserting line breaks 82
line break characters 80
line spacing 72
manually positioning text 79
outdenting right edge 78
setting alignment 72
shading 79
soft returns 80
spacing 72
tab characters 80
wrapping lines 80
parentheses, controlling operator order 218
patterns, slide backgrounds 339–340, 346
PERCENTILE.EXC function 251
PERCENTILE.INC function 251
personalizing messages 428
Photo Album dialog box 375
photo albums, creating 375–380
Picture Tools tab group 353
See also graphics
artistic effects 361
copyrights 352
editing and formatting 356–361
inserting, moving, and resizing 352–355
pie charts, animating 392
pinning contact cards 460
pixels 355
placeholders, merge fields 162
Plain Text format 428
PMT function 207
PNG (Portable Network Graphic) 355
Portable Network Graphic (PNG) 355
PowerPoint 2016
file extensions 55
file formats 55
precedence of operators 218
precedents
identifying 233
tracing 230
presence information 459
presentations
closing 60
color schemes 334
creating based on templates 42
dividing into sections 326–328
hiding/unhiding gridlines 52
hiding/unhiding guides 52
hiding/unhiding rulers 52
saving 59
standard themes 333
Preview view 528
previewing
animation effects 394
animations 396
formatting 9
merged documents 182
messages 499
primary key 276
primary key column 276
primary slide master, attaching hyperlinks 418
Print Layout view 48
envelopes 188
properties
editing 56
pv argument 207
Q
QUARTILE.EXC function 251
QUARTILE.INC function 251
Quick Access Toolbar 6
customizing 26
defining for specific files 28
moving 28
moving buttons 29
resetting to default 29
Quick Analysis Lens
adding tables 286
adding totals 286
formatting cells 285
Quick Click category 488
assigning 492
changing 494
removing 492
setting 494
R
range_lookup argument 277
ranges See named ranges
rate argument 207
Read Mode view 48
Reading Pane
displaying 452
displaying attachments 454
magnifying 453
meeting requests 526
scrolling messages 454
viewing categories 488
Reading view 50
rearranging slides and sections 329–331
records
filtering recipients list 174–176
mail merge 160
manually excluding from recipients list 177
removing duplicates 176
sorting in data sources 177–178
Rectangle picture frame style 376
recurring appointments 513–514, 517
references
absolute 217
circular 225
relative 217
regrouping shapes 370
relative references
changing to absolute 214
creating 217
reminders 513
See also deleting
backgrounds from pictures 359–360
password protection 147
tracked changes 132
Reply All message response 464
Reply message response 464
Reply with IM or Reply All with IM message response 466
Reply with Meeting message response 464
resize handles 202
resizing
Excel tables 202
shapes 366
responding to comments 128–130
responding to messages 464–467
Restrict Editing pane 139
revising content See editing
displaying tabs 15
renaming custom tabs 32
resetting to default 34
ScreenTips 8
scrolling 12
Rich Text format 428
Right Tab 81
Room Finder pane 519
rotating shapes 366
Rounded Rectangle picture frame style 376
row input cell 294
rows, worksheets
grouping 275
hiding/unhiding 273
random, selecting from lists 246
restoring 273
sorting in worksheets 264
rulers
changing measurements 77
displaying 77
hiding 52
indent markers 76
tab stops 80
S
saving
attachments to storage drives 457–458
automatically 58
documents 59
files in previous Office versions 55
files to SharePoint 57
message drafts 441
presentations 59
workbooks 59
See also data sets
adding comments 287
creating from Solver 299
creating summary worksheets 292
defining values 288
displaying 289
Normal 291
removing 288
size limitations 291
summarizing 291
Schedule view calendar arrangement 529
scheduling
screen clippings, capturing and inserting 372–374
Screenshot menu 372
ScreenTips, calendars 505
scrolling files 44
address lists 438
categories 486
folders 494
for holidays 509
security
restricting access using passwords 144–149
scanning for viruses 456
security settings, messages 453
selecting
multiple shapes 366
pictures for editing 354
shapes for editing 366
sending messages 443
settings, files 53
shading paragraphs 79
See also graphics
Text Box margins 364
SharePoint
saving files to 57
slide libraries 322
shortcut keys, categories 488
signatures 428
Simple Frame, Black picture frame style 376
Simple Frame, White picture frame style 376
simple graphics 351
creating a photo album 375–380
drawing and modifying shapes 361–371
editing and formatting pictures 356–361
inserting, moving, and resizing pictures 352–355
Simplex LP solver method 299
Skype for Business 504
slide libraries 322
Slide Show view 50
slide shows 412
Slide Sorter view 50
slides
animating objects 392
animation/transition indicator 394
audio playback controls 405
building with animations 391–392
fitting to window 52
inserting audio clips 406
inserting video clips 413
moving video images 414
reordering animation effects 400
SMALL function 251
social media service, connecting to 20
Soft Edge Rectangle picture frame style 376
soft return 80
Solver
adding to ribbon 300
creating scenarios 299
deleting constraints 303
Evolutionary method 299
GRG Nonlinear method 299
identifying objective cell 300
identifying values to change 300
installing 298
integer programming 299
limiting values 299
opening 300
requiring binary number values 302
requiring integer values 302
requiring non-negative values 303
resetting model 303
saving results 299
selecting methods 303
Simplex LP method 299
solving methods 299
specifying result types 300
sorting
categories 489
cell colors 264
data using custom lists 268–270
default settings, Excel 268
worksheet rows 264
spelling checks 133
spelling errors, hiding 23
splitting windows into panes 52
standard colors 344
standard themes, presentations 333
Start screens, enabling/disabling 23
sticky notes 490
strikethrough 87
styles
adding to Styles gallery 101
built-in, applying to text 97–103
defining custom numbers 95
fonts 85
live preview 98
modifying definitions 98
numbers 94
predefined 97
removing from Styles gallery 101
Styles gallery 97
adding styles 101
removing styles 101
Styles pane
changing displayed styles 99–100
displaying/hiding style previews 101
opening 99
options 100
subscript 88
SUBTOTAL function 245, 247–248, 250
subtotal summaries 275
subtotals
defining 271
hiding/showing details 274
removing 274
removing from data lists 275
Suggested Times list 521
SUM function 207, 247, 249, 251
SUMIF function 220
SUMIFS function 220
summary function, changing 203
superscript 88
T
tab leader 81
table_array argument 277
tables (Excel)
adding with Quick Analysis Lens 286
converting to cell ranges 205
creating using keyboard shortcut 202
creating with default formatting 204
entering values 202
excluding cells 202
expanding automatically 202
naming 203
overwriting format 202
renaming 205
summarizing data 202
summary function 203
Tabs dialog box, opening 82
task assignments 466
task lists, displaying on calendars 534
templates
creating files from 41
finding 43
letters 162
previewing design 41
styles stored in 98
testing passwords 146
text
applying artistic effects 88
applying bold 87
applying built-in styles 97–103
changing case 88
changing font color 88
changing fonts 87
changing font size 87
copying formatting 89
crossing out 87
effects 86
formatting 87
formatting as you type 96
highlighting 89
strikethrough 87
underlining 87
WordArt 86
Text Box margins, shapes 364
textures, slide backgrounds 338–339, 343
themes 104
applying custom 107
applying from non-standard locations 107
applying to presentations 331–336
built-in, applying to documents 106
changing default 107
changing in documents 104
color schemes 334
color sets 104
Office 19
saving 105
saving custom 107
standard 333
Themes gallery 104
thumbnails 9
time slots on calendars 505, 507
time zones on calendars
appointments 515
hiding controls 515
meetings 515
specifying 512
toolbars, displaying 285
totals, adding with Quick Analysis Lens 286
default formatting 119
displaying author of 131
displaying revision types 127
displaying time of 131
hiding 120
Microsoft accounts 126
moving sequentially among 128
preventing from turning off 121
rejecting all 132
removing selected changes 132
turning on/off 120
unlocking 122
user identification 24
trigger icons 404
triggering animations 398, 401
troubleshooting
address lists 435
message addressing 434
multiple recipients 435
Twitter accounts, connecting to 19
two-variable data tables 293–295
type argument 207
U
Unencrypted option 144
ungrouping shapes 370
unhiding
Animation Pane 395
gridlines 52
guides 52
paragraph marks 82
rulers 52
unique messages 476
unique values 276
unlocking change tracking 122
updates 21
uppercase 91
user interface 3
V
values
defining for cell ranges 255–257
watching in ranges 234
variables, changing 293
versions (documents)
vertical spacing, paragraphs 72, 74
video clips
embedded, full screen playback 414
embedding 411
formatting 411
inserting 410
inserting onto slides 413
inserting trigger bookmarks 411
linking to online video 410
managing 412
selecting embedded 414
sources 410
video images 414
video playback 411
video soundtracks, setting relative volume 415
viruses, scanning attachments 456
VLOOKUP formula 278
voting buttons 466
W
Web Layout view 48
websites, linking to 418
Week calendar arrangement 529
windows
splitting into two panes 52
switching 52
Word 2016
file extensions 54
file formats 54
views 48
WordArt 86
Work Week calendar arrangement 529, 534
workbooks
closing 60
creating based on templates 42
recalculating 226
saving 59
adding validation rules 255
finding information in 276–279
recalculating 226
selecting random rows 246
setting calculation options 226
using VLOOKUP 279
Y
YouTube accounts, connecting to 19