Index
Symbols
##### error code, Excel, 223
+ (addition) operator, 210–211
* (asterisk), starting paragraphs with, 98
& (concatenation) operator, 210–211
/ (division) operator, 210–211
^ (exponentiation) operator, 210–211
- (hyphens), using to draw lines, 101
* (multiplication) operator, 210–211
- (negation) operator, 210–211
% (percentage) operator, 210–211
- (subtraction) operator, 210–211
~ (tildes), using to draw lines, 101
_ (underscores), using to draw lines, 101
A
A to Z sorting
bulleted list items, 100
Excel, 250
worksheet data, 252
absolute references, 207
accessibility features, alt text, 339–340
Account attribute, messages, 459
account information, managing, 19–23
AccreditPictures presentation, 363
Active, Calendar module, 482
active tab, 7
AddAudio presentation, 403
addition (+) operator, 210–211
AddRemoveSlides presentation, 323
Address Block merge field, 178–180
address boxes, messages, 412
address lists, messages, 415
AddVideo presentation, 403–404
ADTS audio format, 386
AGGREGATE function and formula, 238, 240–242
aligning text, 86–87. See also text
All Items tab, messages, 438–439
Alt key. See keyboard shortcuts
alt text, accessibility feature, 339–340
alternative data sets, 269–274, 289–290
angle handle, shapes, 354
AnimateSlides presentation, 401
animation effects, 369–371, 378–383
Animation Pane, 376
animations. See also PowerPoint 2019
“build slides,” 373
effects in PowerPoint, 374
selecting, 376
app settings, managing, 10, 24–27
app window. See also backgrounds and themes; Office apps
displaying, 5
maximizing, 17
resizing, 42
ApplyThemes presentation, presentations, 324
appointments
converting to meetings, 496
creating from email messages, 496
modifying, 500
arguments. See also Function Arguments dialog box
col_index_num, 262
lookup_value, 262
range_lookup, 262
table_array, 262
array formulas, 220–221, 230. See also formulas
artistic effects, 94, 337. See also effects
ascending and descending order
bulleted list items, 100
Excel, 250
worksheet data, 252
asterisk (*), starting paragraphs with, 98
attaching files to messages, 424–428, 448. See also files
attachments, displaying, 432–435, 449
Attachments attribute, messages, 459
attribution, pictures, 337–340, 363
AU audio format, 386
audio clips
AuditFormulas workbook, 230
AutoCalculate, Excel, 237–238, 241–242. See also calculating values
Auto-Complete list, messages, 415
AutoCorrect Options button, 98
AutoFormat As You Type, 101
AutoFormat option, 141
availability
meetings, 507
AVERAGE function, 202, 237, 240
AVERAGEIF and AVERAGEIFS functions, 202, 213–214, 216–217, 237, 240
B
backgrounds, removing from pictures, 335–336
backgrounds and themes, 21–22, 110. See also app window; slide backgrounds
balloons, displaying markup, 128
Bar tab, 87
Bcc box, messages, 410
Bids and Quotes category, template, 51
Black theme, 21
blank documents, creating, 49
BMP (bitmap) format, 330
bold text, 93
bookmarks, PowerPoint, 384–385
Border Lines, 101
borders and shading, 85
Browse feature, 65
Budgets category, template, 51
“build slides,” 373. See also slides
BuildFormulas workbook, 228
BuildSolverModel workbook, 291–292
bulleted lists, 98, 100, 373. See also lists
Business category, template, 51
buttons
moving on Quick Access Toolbar, 31
C
Cached Exchange Mode, messages, 438, 440
calculating values, 228. See also AutoCalculate
Calculation Options, Excel, 218
Calculations category, template, 51
calendar items
configuring, 515
Calendar module
arrangements, 483
default settings, 488
ScreenTips, 490
task list, 488
time periods, 484
weeks, 484
Call or Call All, messages, 441
capturing screens, 345–348, 364
categories
Categories attribute, messages, 460
category filters, 51
Cc box, messages, 410
cell color, sorting by, 254. See also colors
cell ranges, value sets, 244–246
cell references, absolute, 207
cells
blank values, 215
counting nonblank, 215
dependents, 223
ChangeBackgrounds presentation, 324–325
changes. See also content changes; Track Changes feature
preventing, 146
recommending against, 145
ChangeTheme document, 118
character formatting, 90–97, 115–116
character spacing, 96
characters. See also nonprinting characters
navigating, 53
superscript and subscript, 94
Charts category, template, 51
Chat button and pane, 151, 153
Check Document tool, 134
Clipboard group, 95
Close button, 6
cloud storage, connecting to, 22–23, 66. See also OneDrive; storage locations
Cloud storage menu button, 6
coauthoring documents, 149–153, 158
col_index_num argument, 262
collaboration commands, displaying, 121. See also commands; Track Changes feature
collapsing groups of messages, 9, 461, 463
Color Categories dialog box, 467
Color category, Outlook, 465
color palette, slide backgrounds, 313, 316
Colorful theme, 21
colors. See also cell color
specifying for comments, 122
specifying for tracked changes, 124
columns, sorting in Excel, 252
command groups, removing from tabs, 34
commands. See also collaboration commands; keyboard shortcuts
adding to custom groups, 35
adding to Quick Access Toolbar, 27–30, 41
listing, 28
comments
activating for editing, 131
deleting, 132
inserting in documents, 120–122
Resolved, 132
Scenario Manager, 270
Simple Markup view, 129
user name and initials, 25, 27
Comments command, 10
Compact spacing, 79
comparing documents, 135–139, 156–157. See also reviewing documents
composition window, messages, 412
concatenation (&) operator, 210–211
conditional formulas, 212–217. See also formulas
connecting
connectors, shapes, 360
constraints
adding with Solver, 284
editing with Solver, 285
Contact Cards, messages, 436–437
content changes. See also changes; Track Changes feature
controlling, 157
content templates, 48. See also design templates; templates
ControlChanges document, 157
conversations, displaying and managing, 453–459. See also messages
copies of files, saving, 66
copying
formatting to text, 95
formulas, 209
copyrighted pictures, 328
COUNT function, 202, 213, 215, 238, 240
COUNTBLANK function, 213
COUNTIFS function, 213–214, 216
CreateArrayFormulas workbook, 230
CreateConditionalFormulas workbook, 229
CreateEnvelopes document, 193
CreateNames workbook, 228
CreateScenarios workbook, 289
CreateSections presentation, 325
Creative Commons licensing, pictures, 338
Ctrl key. See keyboard shortcuts
cursor movement, 53
custom lists, sorting, 255–257, 265. See also lists
CustomizeAnimation presentation, 402–403
D
Dark Gray theme, 21
data
summarizing, 214
data analysis, descriptive statistics, 286–287
data lists, removing subtotals, 261
data sources. See also Recipients list
contents, 168
creating, 172
duplicate records, 175
refreshing data, 177
sorting records, 176
data tables, Excel, 274–278, 290
Database category, template, 51
data-validation rules, Excel, 244–246
date and time, displaying in Excel, 208
Day arrangement, Calendar module, 482, 485
DefineDataTables workbook, 290
deleting
alternative data sets, 273
categories (Outlook), 471
comments, 132
constraints with Solver, 286
custom themes, 113
sections of slides, 321
sorting rules in Excel, 255
tracked changes, 133
deletions, tracking changes, 123
descending and ascending order
bulleted list items, 100
Excel, 250
worksheet data, 252
descriptive statistics, Excel, 286–287, 292
Design Ideas pane, PowerPoint, 345
design templates, previewing, 49–50. See also content templates; design templates
dialog box launcher, 7
Display for Review options, 126. See also Review tab
displaying
collaboration commands, 121
file properties, 61
open files, 60
DisplayViews presentation, 71
distribution lists, messages, 437
#DIV/0! error code, Excel, 223
division (/) operator, 210–211
.docm files, 62
Document Formatting gallery, 104
document markup, displaying and reviewing, 126–130, 155–156
document themes, changing, 109–113, 118. See also themes
documents. See also files; Word documents
ChangeTheme, 118
comparing and merging, 134–139, 156–157
ControlChanges, 157
creating, 49
going to beginning and end, 53
InsertFields, 192
RefineData, 192
saving, 66
splitting into panes, 60
StartMerge, 191
.docx files, 62
.dotm files, 62
.dotx files, 62
double lines, drawing, 101
Double spacing, 79
Draft view, Draft, 56
drafts, messages, 421
drawing shapes, 351–352, 365–366
DrawShapes presentation, 365–366
duplicate records, removing from recipients list, 175
E
EditPictures presentation, 363
Education category, template, 51
effects, applying to fonts, 92–93. See also artistic effects
email messages. See also conversations; Inbox; new messages; Outlook 2019
adding people to conversations, 412
address boxes, 412
address lists, 415
arranging by attributes, 459–463, 479
Auto-Complete list, 415
Bcc box, 410
Cached Exchange Mode, 438, 440
Call or Call All, 441
categories, 467
categorizing items, 479
Cc box, 410
closing after responding, 443
collapsing groups, 461
composition window, 412
creating appointments from, 496
displaying and managing, 478
displaying participant information, 436–440, 449
distribution lists, 437
drafts, 421
entering content, 413
From list, 420
grouping and ungrouping, 462–463
IM (instant messaging), 442
@mentioning feature, 413
Message body box, 411
Organization section, 437, 439
People Pane, 438
presence icon, 436
Preview view, 462
Recipient, 410
removing from conversations, 457–458
resolution process, 411
Sent Items folder, 419, 423, 444–445
Single view, 462
To box, 410
troubleshooting addressing, 414–418
verifying sending, 423
VoIP (Voice over Internet Protocol) calls, 441
Emphasis animations, PowerPoint, 370, 374
Encrypted protection, 145, 149
entering content, messages, 413
Entrance animations, PowerPoint, 369, 374, 379
envelopes, generating, 183–187
Error Checking dialog box, 224
errors
checking in Word, 134
display options, 226
finding and correcting, 230
formulas, 225
events
converting appointments, 496
converting to appointments, 497
modifying, 500
Events category, template, 51
Evolutionary solving method, 282
Excel 2019. See also formulas; workbooks; worksheets
absolute references, 207
adding formulas to columns, 207
alternative data sets, 269–274
app options, 43
arguments, 202
AutoCalculate, 237–238, 241–242
Calculation Options, 218
data-validation rules, 244–246
date and time, 208
descriptive statistics, 286–287, 292
errors in calculations, 222–226
file properties, 72
file types, 62
formulas, 208
functions, 202
hiding groups of rows, 259
iterative calculation options, 219, 229
LimitData workbook, 247
operators and precedence, 210–211
organizing data into levels, 257–261, 266
Quick Analysis Lens, 268–269, 289
removing tracer arrows, 225
Scenario Manager, 270–274, 289–290
Subtotal dialog box, 258
SummarizeValues workbook, 247–248
summarizing data, 229
table columns, 209
unique values in data sets, 243
ValidateData workbook, 248
value sets for cell ranges, 244–246
views, 57
Exit animations, PowerPoint, 370–371, 374, 379
exponentiation (^) operator, 210–211
F
Facebook, connecting to, 23
fading in and out, audio clips, 390
fax messages, sending via email, 426
Feedback page, displaying, 38–41, 46
File Explorer, 423
file name and location, 6
file properties, displaying and editing, 60–61, 64, 67, 72
file size, decreasing, 395–397
file storage folder, accessing, 55. See also storage locations
File tab, 7
file types, compatibility, 62–63
files. See also attaching files to messages; documents; open files; recent files
accessing, 21
basing on templates, 50
managing, 10
filters, applying to categories, 51
Financial Management category, template, 51
FLAC audio format, 386
Flag: Start Date or Due Date attribute, messages, 460
folders
creating, 65
font color, 94
Font dialog box, 96
fonts
presentations, 308
Food and Nutrition category, template, 51
form letters, mail merge, 162–163
Format Background pane, PowerPoint, 313
Format Painter, 95
Format Shape pane, 353
FormatCharacters document, 115–116
FormatParagraphs document, 114
formatting
copying to text, 95
repeating, 96
text while typing, 101
tracking changes, 123
using Quick Analysis Lens, 269
formulas. See also array formulas; conditional formulas; Excel 2019; functions
adding to columns in Excel, 207
calculating values, 228
creating, 208
errors, 225
evaluating, 226
pictures, 363
Forward options, messages, 441, 443
From attribute, messages, 460
From list, messages, 420
Function Arguments dialog box, 212. See also arguments
functions. See also formulas
AVERAGEIF and AVERAGEIFS, 213–214, 216–217
COUNT, 202, 213, 215, 238, 240
COUNTBLANK, 213
HLOOKUP, 264
inserting, 215
LARGE, 240
MEDIAN, 240
MODE.SNGL, 240
NOW, 202
PERCENTILE.EXC, 241
PERCENTILE.INC, 241
QUARTILE.EXC, 241
QUARTILE.INC, 241
SMALL, 241
SUMIFS, 213
G
gallery content
Document Formatting, 104
effects, 92
scrolling and expanding, 9
GIF (Graphics Interchange Format), 330
Goal Seek, Excel, 278–280, 290. See also Solver
gradients, slide backgrounds, 311, 314–315
graphics
defined, 327
Greeting Line merge field, 178, 180
GRG Nonlinear solving method, 282
group buttons, 13
grouping and ungrouping messages, 462–463
customizing, 35
renaming, 35
guides, displaying and hiding, 60
H
handles, shapes, 354
hanging indents, 84
hiding
groups of rows in Excel, 259
highlighting text, 95
HLOOKUP function, 264
holidays, adding to calendars, 494–495
Home pages, enabling and disabling, 25, 27
HSL (Hue, Saturation, Luminescence) values, 316
HTML message format, 408
hyperlinks, presentations, 398–399
hyphens (-), using to draw lines, 101
I
IFERROR function, 213–214, 217
IM (instant messaging), 442
images
artistic effects, 337
copyrights, 328
Creative Commons licensing, 338
editing and formatting, 332–337, 363
online storage locations, 329
selecting for editing, 331
Importance attribute, messages, 460
inactive tabs, 7
Inbox. See also messages; Outlook 2019
Junk Mail filter, 452
overview, 451
subfolders, 472
indents, configuring, 76, 82–84
Industry category, template, 51
Insert Function dialog box, 215
Insert Picture dialog box, 329
InsertFields document, 192
InsertIcons presentation, 365
inserting
pictures, 362
insertions, tracking changes, 123
InsertPictures presentation, 362
InsertScreens presentation, 364
integer programming, 282
invited events, 497
italic text, 93
iterative calculation options, 229
J
JPEG (Joint Photographic Experts Group) format, 331
Junk Mail filter, Inbox, 452
K
keyboard shortcuts. See also commands; Shortcut key category
appointments, 491
array formulas, 220
bold text, 93
case options for text, 94
cells in Excel, 205
copying and pasting, 209
cursor movement, 53
folders, 473
Help pane, 38
italic text, 93
line breaks, 88
meeting windows, 506
months in Calendar module, 485
paragraph marks, 88
pasting, 209
redisplaying ribbon, 19
repeating formatting, 96
ribbon tabs, 18
Save, 14
Track Changes feature, 124
underlined text, 93
work week schedule, 485
keys and buttons, 15
L
LARGE function, 240
levels, organizing Excel data, 257–261, 266
LimitData workbook, 247
lines
drawing, 101
scrolling, 53
List, Calendar module, 482
lists. See also bulleted lists; custom lists; numbered lists
creating and modifying, 97–102, 116–117
modifying indentation, 99
multiple levels, 99
starting at predefined numbers, 102
Live Preview feature, 9
enabling and disabling, 25
locations, displaying, 52
Lock Tracking option, 125
Logs category, template, 51
lookup_value argument, 262
LookupData workbook, 266
looping audio clips, 391
lowercase and uppercase text, 94, 97
M
magnification, changing, 17, 58–59
mail merge. See also merging documents; Word documents
data sources, 160, 168–176, 192
envelopes and labels, 182–189, 193–194
placeholders, 162
previewing and completing, 180–182, 193
records, 160
refreshing data, 177
starting, 161
Mail module, 472
mailing address, saving, 185–186
ManageMultipleScenarios workbook, 289–290
marking up documents, 154–155. See also Track Changes feature; Word documents
MEDIAN function, 240
meeting requests, responding, 509–511, 516
meetings. See also Outlook 2019
availability, 507
converting appointments, 496
modifying, 500
Propose New Time, 511
scheduling and changing, 502–509, 515–516
@mentioning feature, Outlook 2019, 412–413
merging documents, 135–139, 156–157. See also mail merge
Message body box, messages, 411
message formats, 408
messages. See also conversations; Inbox; new messages; Outlook 2019
adding people to conversations, 412
address boxes, 412
address lists, 415
arranging by attributes, 459–463, 479
Auto-Complete list, 415
Bcc box, 410
Cached Exchange Mode, 438, 440
Call or Call All, 441
categories, 467
categorizing items, 479
Cc box, 410
closing after responding, 443
collapsing groups, 461
composition window, 412
creating appointments from, 496
displaying and managing, 478
displaying participant information, 436–440, 449
distribution lists, 437
drafts, 421
entering content, 413
From list, 420
grouping and ungrouping, 462–463
IM (instant messaging), 442
@mentioning feature, 413
Message body box, 411
Organization section, 437, 439
People Pane, 438
presence icon, 436
Preview view, 462
Recipient, 410
removing from conversations, 457–458
resolution process, 411
Sent Items folder, 419, 423, 444–445
Single view, 462
To box, 410
troubleshooting addressing, 414–418
verifying sending, 423
VoIP (Voice over Internet Protocol) calls, 441
Microsoft Download Center, 63
MIDI format, 386
Mini Toolbar
character formatting, 91
Minimize button, 6
MKA audio format, 386
MODE.SNGL function, 240
Month arrangement, Calendar module, 483, 485
Monthly category, template, 51
morphing slide content, 378
Motion Path animations, PowerPoint, 370–371
Mouse mode, 16
moved content, tracking changes, 123
moving
buttons on Quick Access Toolbar, 31
MP3 and MP4 audio formats, 386
multiplication (*) operator, 210–211
N
Name category, Outlook, 465
#NAME? error code, Excel, 223
negation (-) operator, 210–211
new messages, notifications. See also messages
next page, 53
nonprinting characters, 58, 60. See also characters
Normal view
Excel, 57
PowerPoint, 57
Notes Page view, PowerPoint, 57
notifications, new messages, 426
NOW function, 202
number style, changing, 100
numbered lists, 98, 102. See also lists
O
Office 2019
app options, 43
Backstage view, 10
overview, 407
procedural instructions, 14–15
Quick Access Toolbar, 27–31, 44–45
ribbon, 7–9, 12–13, 16–19, 31–36, 45
Office apps, suggesting changes, 40. See also app window
Office updates, managing, 23
OneDrive. See also cloud storage
online storage locations, 329
open files, displaying, 60. See also files
Open spacing, 79
opening files, 54–56, 67, 70–71
operators and precedence, 210–211
Organization section, messages, 437
OrganizeData workbook, 266
Outline view, PowerPoint, 57
Outline view, Word, 56
Outlook 2019. See also Inbox; meetings; messages
data sources, 170
default email app, 423
From File Explorer option, 423
From an Office app option, 423
From Outlook option, 423
Mail module, 472
@mentioning feature, 412
options, 25
Outlook notes, storing information, 468–469
P
Page Break Preview view, Excel, 57
Page Layout view, Excel, 57
Page Up and Page Down, 53
paragraph alignment, 78
paragraph formatting
borders, 85
paragraph indents, 82
paragraph marks, 88
paragraph styles, outline levels, 107
paragraphs
borders and shading, 85
converting to lists, 98
indenting and outdenting, 83–84
participant information, displaying in messages, 436–440, 449
People Pane, messages, 438–439
percentage (%) operator, 210–211
PERCENTILE.EXC function, 241
PERCENTILE.INC function, 241
PerformGoalSeekAnalysis workbook, 290
PerformQuickAnalysis, workbook, 289
Personal category, template, 51
photos. See pictures
pictures
artistic effects, 337
copyrights, 328
Creative Commons licensing, 338
editing and formatting, 332–337, 363
online storage locations, 329
selecting for editing, 331
pie charts, 373
Pin The Ribbon button, 18
pixels, defined, 330
Plain Text message format, 408
PNG (Portable Network Graphic) format, 331
PowerPoint 2019. See also animations; presentations; slides
file types, 63
Format Background pane, 313
help and feedback, 46
options, 25
screen clippings, 345
text boxes, 296
views, 57
and Word style conversion, 300, 303
precedence and operators, 210–211
presence icon, messages, 436
presentations. See also PowerPoint 2019; slides
AccreditPictures, 363
AddAudio, 403
AddRemoveSlides, 323
AnimateSlides, 401
ApplyThemes, 324
CreateSections, 325
Design Ideas pane, 345
DisplayViews, 71
dividing into sections, 317–319, 325
EditPictures, 363
effect styles, 309
font sets, 308
InsertIcons, 365
InsertPictures, 362
InsertScreens, 364
non-theme colors, 316
RearrangeSlides, 326
rearranging slides and sections, 319–321
saving, 66
setting formatting, 358
Presenter view, PowerPoint, 57
Preview
Calendar module, 482
messages, 462
previous page, 53
Print Layout view, Word, 56
printing
mailing labels, 189
and saving envelopes, 187
privacy, calendars, 498
Profit and Loss, template, 51
Projects, template, 51
properties. See file properties
Propose New Time, meetings, 511
Q
QUARTILE.EXC function, 241
QUARTILE.INC function, 241
Quick Access Toolbar. See also ribbon
adding commands, 29
locating, 6
moving buttons, 31
resetting to default, 31
separator, 31
Quick Analysis Lens, Excel, 268–269, 289
Quick Click category, 465, 467, 471
R
range_lookup argument, 262
Read Mode view, Word, 56
Reading pane, meeting request, 509
Reading view, PowerPoint, 57
RearrangeSlides presentation, presentations, 326
recent files, opening, 54. See also files
Recent list, 64
Recipients list. See also data sources
excluding records, 176
records in data sources, excluding from recipients list, 176
recurrence, calendars, 498, 501
#REF! error code, Excel, 223
RefineData document, 192
Relaxed spacing, 79
reminders, calendars, 498, 501
renaming
groups, 35
tabs, 34
Reply options, messages, 440, 442–443
resetting, Quick Access Toolbar, 31
resizing
shapes, 355
Resolved comments, 132
restricting
access using passwords, 144–149
restrictions, removing, 143–144
Review tab, Lock Tracking, 125. See also Display for Review options
ReviewComments document, 155–156
reviewers, displaying markup, 129
reviewing comments, 130–132. See also comparing documents
RGB (Red, Green, Blue) values, 316
ribbon. See also Quick Access Toolbar
hiding and displaying, 13, 17–19
redisplaying, 19
resetting, 36
Ribbon Display Options button, 6
Rich Text message format, 408
Right indent, 82
Room Finder, meetings, 503–504
rotate handle, shapes, 354
rows
hiding in Excel, 259
sorting in worksheets, 251
rulers
displaying, 83
displaying and hiding, 60
indent markers, 82
S
Save As dialog box, 65
saving
copies of files, 66
documents, 14
drafts of messages, 421
envelopes, 187
files to OneDrive, 68
mailing labels, 189
Scenario Manager, Excel, 270–274, 289–290
Schedule view, Calendar module, 483
schedules, displaying daily, 485
scheduling
appointments, 488–493, 513–514
and changing meetings, 502–509, 515–516
overview, 481
Scheduling Assistant page, 504–505
screen
scrolling, 53
screen clippings, capturing and inserting, 345–348, 364
ScreenTips
Calendar module, 490
shapes, 351
scroll arrows, 13
scroll bar, displaying, 70
scrolling, 53
sections
dividing presentations, 317–319
presentations, 325
sending messages, 419–423, 447–448
Sent Items folder, messages, 419, 423, 444–445
SetIterativeOptions, workbooks, 229
settings, managing, 10
shading and borders, 85
shapes
changing, 356
connecting, 360
copying formatting, 358
drawing and modifying, 351–352, 365–366
formatting commands, 353
grouping and ungrouping, 359
moving on slides, 355
regrouping, 359
resizing, 355
rotating and flipping, 355–356
SharePoint sites, accessing, 21–22
Shift key. See keyboard shortcuts
Shortcut key category, Outlook, 465. See also keyboard shortcuts
shortcuts, viewing, 12
Simple Markup view, comments, 129
Simplex LP solving method, 282
Single view, messages, 462
Size attribute, messages, 460
size handles, shapes, 354
slide backgrounds, 310–315, 317, 324–325. See also backgrounds
slide content, morphing, 378
Slide Sorter view, PowerPoint, 57
slides. See also “build slides”; PowerPoint 2019; presentations
adding and removing, 323
copying and importing, 298–303
creating shapes, 352
hiding, unhiding, and deleting, 304–305
moving shapes, 355
patterned backgrounds, 317
textured backgrounds, 315
themes, 299
Tile And Content layout, 297
SMALL function, 241
social media, connecting to, 22–23
soft returns, 86
Solver, Excel, 280–286, 291–292. See also Goal Seek
SortCustomData workbook, 265
SortData workbook, 265
sorting
bulleted lists, 100
records in data sources, 176
rows in worksheets, 251
spacing. See character spacing; vertical spacing
spelling, checking, 134
splitting documents and workbooks, 60
StartMerge document, 191
status bar, 5, 11–13, 16–19, 42
storage locations, 21–22. See also cloud storage; file storage folder
Strikethrough button, 93
StructureContent document, 114–115
styles
applying to text, 102–108, 117–118
Word and PowerPoint, 300
Subject attribute, messages, 460
Subject box, messages, 411, 413
subscription, managing, 23
Subtotal dialog box, Excel, 258
SUBTOTAL function and formula, 238–239, 242
subtotals, removing from data lists, 261
subtraction (-) operator, 210–211
SUM function, 202, 204, 237, 239–240
SUMIFS function, 213
SummarizeValues workbook, 247–248
summarizing data, Excel, 214, 229, 241–242
superscript and subscript characters, 94
SVG (Scalable Vector Graphic) format, 331, 350
T
table columns, referring to, 209
Table Tools, 7
table_array argument, 262
tables, using Quick Analysis Lens, 269
tabs
active and inactive, 7
hiding and displaying, 33
removing command groups, 34
renaming, 34
setting, 87
using, 42
target value, finding, 280. See also values
task list, Calendar module, 488
Tell Me feature, 36, 38–39, 46
templates. See also content templates; design templates
basing files on, 50
storing styles, 103
text. See also aligning text
bold, italic, and underlined, 93
case, 97
copying formatting to, 95
formatting on shapes, 358
formatting while typing, 101
highlighting, 95
Strikethrough button, 93
uppercase and lowercase, 94
text boxes, PowerPoint, 296
textured backgrounds, slides, 315
themes. See also document themes
non-theme colors, 316
presentations, 324
using with slides, 299
thumbnails, 9
Tight spacing, 79
tildes (~), using to draw lines, 101
Tile And Content layout, slides, 297
time and date, displaying in Excel, 208
time zones, calendars, 497, 499–500
To attribute, messages, 460
To box, messages, 410
tool tabs, 7
Top 10 filter, Excel, 233, 235
totals, using Quick Analysis Lens, 269
Touch mode, 16
touchscreen devices, 16
Track Changes feature, 123–125, 130. See also changes; collaboration commands; content changes; marking up documents; Word documents
TrackChanges document, 154–155
tracked changes, reviewing and processing, 132–134
Trim Audio dialog box, 389
trimming audio and video, 395
Type attribute, messages, 460
U
underlined text, 93
underscores (_), using to draw lines, 101
Unencrypted protection, 145
unique values, finding in data sets, 243. See also values
Unlock Tracking option, 125
updates, managing, 23
uppercase and lowercase text, 94, 97
URLs of websites, presentations, 398–399
UseDescriptiveStatistics workbook, 292
user badge, checking, 151
user identification, changing, 27, 41
V
ValidateData workbook, 248
validation rules, Excel, 244–246
#VALUE! error code, Excel, 223
value sets for cell ranges, Excel, 244–246
values, summarizing, 241–242. See also target value; unique values
variables, data tables, 275–276
versions of documents, comparing, 138–139
video clips
View Shortcuts toolbar, 12, 58
views
options, 58
switching, 58
VoIP (Voice over Internet Protocol) calls, messages, 441
W
WAV audio format, 386
Web Layout views, Word, 56
websites
Microsoft Download Center, 63
OneDrive, 69
Week arrangement, Calendar module, 483, 485
weeks, Calendar module, 484
White theme, 21
window management options, 6
WMA audio format, 386
Word 2019
options, 25
overview, 119
and PowerPoint style conversion, 300, 303
Word documents. See also documents; mail merge; marking up documents; Track Changes feature
browsing by object, 56
file types, 62
mail merge, 191
Navigation pane, 56
ribbon, 45
user interface, 42
Work Week arrangement, Calendar module, 482, 485
workbooks. See also Excel 2019
AuditFormulas, 230
BuildFormulas, 228
CreateArrayFormulas, 230
CreateConditionalFormulas, 229
CreateNames, 228
CreateScenarios, 289
DefineDataTables, 290
LimitData, 247
LookupData, 266
ManageMultipleScenarios, 289–290
OrganizeData, 266
PerformGoalSeekAnalysis, 290
PerformQuickAnalysis, 289
recalculating, 219
saving, 66
SetIterativeOptions, 229
SortCustomData, 265
SortData, 265
splitting into panes, 60
UseDescriptiveStatistics, 292
ValidateData, 248
worksheet data, sorting, 250–255, 265
worksheets. See also Excel 2019
hidden and filtered rows, 237–244
listing rows at random, 236–237
looking up information, 261–264, 266
recalculating, 219
X
.xlam files, 62
.xlsb files, 62
.xlsm files, 62
.xlsx files, 62
.xltm files, 62
.xltx files, 62
.xml files, 62
Y
YouTube, connecting to, 21, 23
Z
Z to A sorting
bulleted list items, 100
Excel, 250
worksheet data, 252
zigzag line, drawing, 101
Zoom slider and button, 12