: (colon), 201
, (comma), 201
= (equal) sign, 196
absolute references in formulas, 200
accents, adding to publications, 359
Accept All Changes to the Presentation option (PowerPoint), 264
accepting changes
in PowerPoint, 264
in Word, 157
Account Settings dialog box, 279, 309
Accounting Number Format button (Excel), 182
accounts
email accounts
removing from Outlook, 279
Microsoft accounts
creating, 14
switching, 14
Add Account command (Outlook), 278
Add a Drop Cap button (Word), 128
Add a service button, 15
add-ins, managing, 35
addresses, cell, 167
Advanced Options, 34
advancing slides, 267
Align Left button, 43
Align Right button, 43
aligning text, 43
Animation Pane button (PowerPoint), 258
animation (PowerPoint)
animating slide objects, 256-257
customizing animations, 258-259
Animations tab (PowerPoint), 256-258
applying
picture borders, 59
styles
Excel, 183
picture styles, 58
templates to notebooks, 324
appointments, scheduling, 299
Arrange All button (PowerPoint), 234
Artistic Effects (pictures), 57
Attach File option (Outlook), 287
attachments
email attachments, 287
notebook attachments, 328
audio
adding to PowerPoint presentations, 252-253, 269
recording to notebooks, 330
Audio button (PowerPoint), 252
Audio & Video Settings button (OneNote), 331
AutoSum button (Excel), 202
AVERAGE function, 203
backgrounds
publications, 351
Bcc (blind courtesy/carbon copy), 282
bitmap pictures, 53
Blank document button (Word), 96-98
blank documents (Word), creating, 96-98
Blank Page command (Word), 119
blank pages (Word), 119
blank publications, creating, 342-343
blank workbooks, creating, 166
blind courtesy/carbon copy (Bcc), 282
Block Sender feature (Outlook), 290
blocking email messages, 290
Bookmark command (Word), 133
Bookmark dialog box (Word), 133
bookmarks, inserting into Word documents, 133
borders
picture borders, 59
publication borders, 359
Borders & Accents option (Publisher), 359
Borders and Shading dialog box (Word), 140-141
Browse for Themes option (Word), 148
Browse the Web button (OneNote), 323
building blocks (Word)
custom building blocks, 107
deleting, 107
inserting, 106
Quick Parts library, 106
bulleted lists
adding to PowerPoint presentations, 221
creating, 102
business information, adding to publications, 361
Business Information option (Publisher), 361
calculation precedence in Excel formulas, 199
Calendar
navigating, 293
notes, 307
publishing, 303
reserving conference rooms, 300
scheduling appointments, 299
tasks
color coding, 306
managing, 306
marking as completed, 306
removing, 306
views, 304
viewing, 298
case sensitivity of Excel formulas, 196
Cc (courtesy copy), 282
cell addresses, 167
cell formulas (Excel)
absolute references in, 200
AutoSum button, 202
AVERAGE function, 203
copying, 197
COUNT function, 203
MAX function, 203
MIN function, 203
overview, 194
simple formulas, 196
SUM function, 201
Cell Styles button (Excel), 183
cells
in Excel worksheets, 183
in Word tables
deleting, 112
merging, 114
splitting, 115
Center button, 43
centering text in Excel worksheets, 181
Change Picture command (Publisher), 347
Change View button (Outlook), 304
changes
accepting/rejecting
in Word, 157
undoing in OneNote, 335
changing
notebook views, 325
page layout (Word)
character spacing, 144
columns, 139
leader characters, 147
line spacing, 144
page margins, 136
page orientation, 137
page size, 138
paragraph spacing, 145
text color in Word, 104
character spacing (Word), 144
charts
inserting into Excel worksheets, 206-207
modifying, 209
previewing, 206
styles, 208
Choose a SmartArt Graphic dialog box, 68
circles, creating, 65
Clear All Formatting button, 105
clearing styles in Word, 105
Clipboard, 19
Close button, 30
Close command (File menu), 7, 30
closing
Revisions Pane (PowerPoint), 264
cloud-based storage. See OneDrive
Collapse All command (PowerPoint), 222-224
collapsing
PowerPoint sections, 222
presentation outlines, 224
colon (:), 201
Color button, 57
colors
color coding
tasks, 306
worksheet tabs, 173
customizing
notebook section tabs, 316
publication color schemes, 350
Publisher templates, 343
Word text, 104
columns
in Excel worksheets
column headers, 190
column width, 186
deleting, 171
inserting, 170
in Word pages, 139
in Word tables
deleting, 112
inserting, 111
selecting, 108
Columns dialog box (Word), 139
Columns option (Word), 139
Combine command (Word), 157
combining Word documents, 157
comma (,), 201
comments
presentation comments
adding, 262
managing, 263
Word documents
deleting, 155
commercial printing, saving publications for, 366-367
Compare command
PowerPoint, 264
Word, 157
comparing
PowerPoint presentations, 264-265
Word documents, 157
composite proof, 367
conference rooms, reserving, 300
connected services, viewing, 15
deleting, 295
editing, 296
emailing, 297
searching, 294
viewing, 294
content palette (PowerPoint), 220
contextual tabs, 10
Copy command, 18
formulas, 197
Corrections button, 56
COUNT function, 203
courtesy copy (Cc), 282
Cover Page command (Word), 118
cover pages (Word), 118
Create a New Section command (OneNote), 316
Create command (Publisher), 341
Create Handouts button (PowerPoint), 242
Create New Color Scheme command (Publisher), 350
Create New Style from Formatting dialog box, 110
Create Notebook command (OneNote), 314
Create PDF/XPS button, 22
Create Rule option (Outlook), 290
Create Rules dialog box (Outlook), 290
Create Sparklines dialog box (Excel), 212
Create Video button (PowerPoint), 275
creating. See also inserting
bullet/number formats, 103
circles, 65
Excel charts
Insert Chart dialog box, 206-207
styles, 208
Excel workbooks
blank workbooks, 166
saving, 165
formulas
absolute references, 200
copying, 197
simple formulas, 196
Microsoft accounts, 14
notebooks, 314
links, 323
notes, 318
page titles, 315
pages, 319
pictures, 321
subpages, 320
tags, 322
templates, 324
text formatting, 318
OneDrive folders, 75
Outlook notes, 307
PowerPoint
publications
new blank publications, 342-343
standard page size, 342
Publisher templates
pictures, 347
text, 346
Quick Parts, 107
spreadsheets in Office Mobile, 91
squares, 65
tags, 322
Word documents
blank pages, 119
bulleted lists, 102
cover pages, 118
date/time fields, 129
drop caps, 128
hyperlinks, 132
margins, 136
numbered lists, 103
page borders, 140
page breaks, 120
page numbers, 121
ScreenTips, 132
styles, 105
text color, 104
Word tables, 108
deleting cells, 112
deleting rows/columns, 112
formatting, 110
inserting rows/columns, 111
Quick Tables, 109
selecting rows/columns, 108
styles, 110
undoing changes, 112
Creative Commons license, 55
Crop button, 61
Crop to Shape command, 61
cropping pictures, 61
Custom Margins option (Word), 136
Custom Sort command (Excel), 190
Customize Tags command (OneNote), 322
Customize Tags dialog box (OneNote), 322
Cut command, 18
data entry (Excel), 168
Date and Time dialog box, 129
dates, inserting into Word documents, 129
Decrease Indent option (Word), 142
Define New Bullet command (Word), 103
Define New Number Format command (Word), 103
Delete All Comments and Ink in This Presentation option (PowerPoint), 263
Delete button
Excel, 171
OneDrive, 85
Delete Cells command, 112
Delete command (Excel), 174
Delete Comment command (Word), 155
Delete Outlook Task command (OneNote), 336
Delete Table command (Word), 113
Delete Text option (Publisher), 346
backgrounds from publications, 351
cells in Word tables, 112
columns from Excel worksheets, 171
comments from Word documents, 155
contacts, 295
cover pages (Word), 118
email accounts from Outlook, 279
email signatures, 288
Excel filters, 193
hyperlinks from PowerPoint presentations, 239
notebook pages, 319
notebook sections, 316
OneDrive files, 85
picture placeholders, 355
PowerPoint animations, 259
PowerPoint comments, 263
PowerPoint sections, 223
Quick Parts, 107
rows/columns
from Excel worksheets, 171
from Word tables, 112
slide timings, 268
slides, 236
styles in Word, 105
video clips, 249
Word pages, 119
Word tables, 113
worksheets, 174
Design Checker, 348
Design Checker Options dialog box, 364
Design Checker (Publisher), 364-365
Display Options, 33
.doc format, 96
docking notebooks, 325
document markup, viewing in Word documents, 156
documents (Word). See also text
bookmarks, 133
combining, 157
comparing, 157
creating
headers/footers
mini toolbars, 99
opening, 98
page layout
character spacing, 144
columns, 139
leader characters, 147
line spacing, 144
overview, 134
page margins, 136
page orientation, 137
page size, 138
paragraph spacing, 145
pages
blank pages, 119
cover pages, 118
page breaks, 120
page numbers, 121
Quick Parts
custom Quick Parts, 107
deleting, 107
inserting, 106
Quick Parts library, 106
reviewing, 150
accepting/rejecting changes, 157
document markup, 156
saving, 97
tables
creating, 108
deleting, 113
deleting cells, 112
deleting rows/columns, 112
formatting, 110
inserting from other sources, 115
inserting rows/columns, 111
merging cells, 114
navigating, 108
Quick Tables, 109
resizing, 114
selecting rows/columns, 108
splitting, 115
splitting cells, 115
styles, 110
undoing changes, 112
text
bulleted lists, 102
color, 104
date/time fields, 129
drop caps, 128
hyperlinks, 132
numbered lists, 103
ScreenTips, 132
selecting, 99
styles, 105
.docx format, 96
Download button (OneDrive), 85
downloading
OneDrive app, 86
OneDrive files, 85
Draft mode (Word), 159
Draw Text Box option (Publisher), 353
drawing
lines, 65
drop caps, 128
duplicate pages, inserting into publications, 352
Edit Document command (OneDrive), 82
editing
contacts, 296
Excel charts, 209
headers/footers (Word), 124-125
notebook page titles, 315
picture placeholders, 355
Quick Tables, 109
Effect Options (PowerPoint), 259
accounts
removing, 279
email messages
attaching files to, 287
blocking, 290
forwarding, 286
moving, 291
reading, 283
receiving, 283
sending, 282
sharing files with, 26
email messages
attaching files to, 287
blocking, 290
forwarding, 286
moving, 291
reading, 283
receiving, 283
sending, 282
signatures
choosing, 289
deleting, 288
Email Page command (OneNote), 333
E-mail Calendar button (Outlook), 302
emailing
contacts, 297
notebooks pages, 333
Encrypt Document dialog box, 177
entering data into Excel worksheets, 168
equal (=) sign, 196
Excel workbooks
charts
modifying, 209
previewing, 206
styles, 208
columns
deleting, 171
inserting, 170
creating
blank workbooks, 166
in Office Mobile, 91
data formatting, 178
cell styles, 183
column headers, 190
column width, 186
freezing panes, 189
merging and centering text, 181
numbers, 182
row height, 187
wrapping text, 180
defined, 162
absolute references in, 200
AutoSum button, 202
calculation precedence, 199
copying, 197
overview, 194
simple formulas, 196
functions
AVERAGE, 203
COUNT, 203
MAX, 203
MIN, 203
SUM, 201
read-only workbooks, 176
rows
deleting, 171
inserting, 169
saving, 165
worksheets
cell addresses, 167
creating in Office Mobile, 91
defined, 162
deleting, 174
entering data into, 168
hiding, 175
inserting, 172
navigating, 167
protecting data, 177
renaming, 173
replacing data, 188
searching, 188
tab color, 173
unhiding, 175
Exchange, sharing calendar with, 302
Expand All command (PowerPoint), 222-224
expanding
PowerPoint sections, 222
presentation outlines, 224
Export command, 7
File menu, 22
PowerPoint, 275
exporting PowerPoint presentations as video, 275
fields, 122
File Attachment command (OneNote), 328
File menu commands
Account, 14
Close, 30
Export, 22
New, 342
Open, 98
Print, 29
files
attaching
to email, 287
to notebooks, 328
.doc format, 96
.docx format, 96
OneDrive files
deleting, 85
downloading, 85
printing, 82
version history, 85
picture file formats, 53
renaming, 17
saving
to OneDrive, 21
Filter command (Excel), 192
filtering worksheet data, 192-193
Find and Replace dialog box, 44
Find & Select button (Excel), 188
finding
RSS feeds, 309
text, 45
first line indents, 143
Folder Pane (Outlook), 280
OneDrive folders
creating, 75
organizing, 75
properties, 77
Outlook folders, creating, 291
fonts
customizing in Publisher templates, 343
formatting, 42
Footer command (Word), 122
Footer option (Publisher), 356
footers
in publications, 356
in Word
Format as Table button (Excel), 184
Format as Table dialog box (Excel), 185
Format Background button (PowerPoint), 230
Format Cells dialog box, 42, 180
Format Page Number command (Word), 121
Format Painter, 19
Format Shape command, 67
formatting
notebook tables, 329
page numbers in Word documents, 121
pictures. See pictures
publications, 349
backgrounds, 351
borders and accents, 359
business information, 361
color schemes, 350
headers/footers, 356
inserting pages into, 352
page numbers, 357
page parts, 358
tables, 360
text boxes, 353
slides. See slides
video clips for PowerPoint presentations, 251
Word tables, 110
WordArt, 47
worksheet data, 178
cell styles, 183
column headers, 190
column width, 186
freezing panes, 189
merging and centering data, 181
numbers, 182
row height, 187
wrapping text, 180
formulas (Excel)
absolute references in, 200
AutoSum button, 202
AVERAGE function, 203
calculation precedence, 199
copying, 197
COUNT function, 203
MAX function, 203
MIN function, 203
overview, 194
simple formulas, 196
SUM function, 201
Forward button (Outlook), 283, 286
forwarding email messages, 286
Freeze Panes button (Excel), 189
freezing panes in Excel worksheets, 189
From Beginning button (PowerPoint), 270
functions
AVERAGE, 203
COUNT, 203
MAX, 203
MIN, 203
SUM, 201
galleries
Quick Tables Gallery, 110
WordArt, 46
General Options, 33
Get OneDrive apps option (OneDrive), 86
graphics. See images
hanging indents, 143
Header command (Word), 122
Header & Footer button (PowerPoint), 240
Header option (Publisher), 356
publications, 356
Word
worksheet columns, 190
headings (PivotTable), 210
height of worksheet rows, 187
help
Help window, 37
Tell Me box, 36
Help window, 37
Hide command (Excel), 175
hiding worksheets, 175
highlighting in OneNote notebooks, 335
Hyperlink command
Word, 132
hyperlinks
in notebooks, 323
in PowerPoint presentations, 238-239
in Word documents, 132
sharing files with, 25
pictures. See pictures
shapes
defined, 62
SmartArt
defined, 62
importing presentation outlines, 225
improving Insights results, 39
Increase Indent option (Word), 142
indents (Word), adding
on Home tab, 142
on Layout tab, 143
Info window, 6
Insert button (Excel), 169-170
Insert Chart dialog box (Excel), 206-207
Insert Date and Time button (Word), 129
Insert Duplicate Page command (Publisher), 352
Insert File dialog box, 328
Insert Hyperlink dialog box (Word), 132
Insert Picture dialog box, 52-54
inserting. See also creating
bookmarks into Word documents, 133
comments in Word documents, 154
pictures
publication pages, 352
Quick Parts into Word documents, 106-107
rows/columns
into Excel worksheets, 169-170
into Word tables, 111
slides, 69
tables into notebooks, 329
timestamps in OneNote notebooks, 332
Word tables, 115
WordArt, 46
worksheets, 172
installing Office Mobile, 88-89
Justify button, 43
justifying text, 43
Language Options, 34
layout
Word page layout
character spacing, 144
columns, 139
leader characters, 147
line spacing, 144
overview, 134
page margins, 136
page orientation, 137
page size, 138
paragraph spacing, 145
Layout button (PowerPoint), 220, 228
leader characters, 147
left indents (Word), 143
licenses, Creative Commons license, 55
drawing, 65
line spacing (Word), 144
Link dialog box, 323
links
in notebooks, 323
in PowerPoint presentations, 238-239
in Word documents, 132
sharing files with, 25
lists
bulleted lists
adding to PowerPoint presentations, 221
creating, 102
numbered lists, 103
Make Subpage command (OneNote), 320
managing
add-ins, 35
PowerPoint comments, 263
tasks, 306
margins, changing in Word documents, 136
Margins option (Word), 136
Mark as Final command (Excel), 176
marking tasks as completed, 306
Markup command (Word), 156
MAX function, 203
Merge Cells command (Word), 114
Merge & Center button (Excel), 181
Merge into Another Section command (OneNote), 317
Merge Section dialog box (OneNote), 317
merging
cells in Word tables, 114
notebook sections, 317
text in Excel worksheets, 181
Message Preview (Outlook), 281
messages (email)
attaching files to, 287
blocking, 290
forwarding, 286
moving, 291
reading, 283
receiving, 283
sending, 282
signatures
choosing, 289
deleting, 288
Microsoft accounts
creating, 14
switching, 14
Microsoft Exchange, sharing calendar with, 302
MIN function, 203
mobile devices, Office Mobile. See also OneDrive
limitations, 90
Mouse Mode, 8
moving
email messages, 291
notebook sections, 317
PowerPoint presentations, 222
multiple columns, entering into worksheets, 170
multiple pictures, selecting, 53-55
multiple rows, entering into worksheets, 169
naming worksheets, 173
narrations, adding to PowerPoint presentations, 269
navigating
bookmarks, 133
Outlook, 277
Outlook Calendar, 293
Word tables, 108
worksheets, 167
New Appointment command (Outlook), 299
New command (File menu), 6, 342
New Comment command
PowerPoint, 262
New Contact command (Outlook), 295
New Email command (Outlook), 282
New Folder command (Outlook), 291
New Meeting command (Outlook), 300
New Note (Outlook), 307
New Slide button (PowerPoint), 69, 219
New Table Style command (Word), 110
New Task option (Outlook), 304
Normal view (PowerPoint), 218
attaching files to, 328
audio recording, 330
creating, 314
links, 323
notes, 318
page titles, 315
pages, 319
pictures, 321
subpages, 320
tags, 322
templates, 324
text formatting, 318
docking, 325
emailing pages from, 333
highlighting in, 335
notes, turning into tasks, 336
OneNote apps, 337
overview, 312
saving, 314
switching between, 314
tables
formatting, 329
inserting, 329
timestamps, 332
undoing changes, 335
views, 325
notes
adding to notebooks, 318
creating, 307
turning into tasks, 336
views, 307
Notes pane (PowerPoint), 218
numbered lists, 103
numbers
Excel formulas, 196
Excel worksheets, 182
adding to publications, 357
inserting into Word documents, 121
objects
defined, 18
Office Lens, 337
Office Mobile
limitations, 90
Office themes, 15
additional storage, 74
downloading, 86
files
deleting, 85
downloading, 85
printing, 82
version history, 85
folders
creating, 75
organizing, 75
properties, 77
saving files to, 21
signing in to, 74
signing up with, 74
OneNote Clipper, 337
OneNote notebooks
attaching files to, 328
audio recording, 330
creating, 314
links, 323
notes, 318
page titles, 315
pages, 319
pictures, 321
subpages, 320
tags, 322
templates, 324
text formatting, 318
docking, 325
emailing pages from, 333
highlighting in, 335
notes, turning into Outlook tasks, 336
OneNote apps, 337
overview, 312
saving, 314
switching between, 314
tables
formatting, 329
inserting, 329
timestamps, 332
undoing changes, 335
views, 325
online pictures, inserting, 54-55
Online Pictures button, 54
online presentations, 27
Online Video option (PowerPoint), 248
Open command (File menu), 6, 16, 98
Open Task in Outlook command (OneNote), 337
opening
attachments in OneNote, 328
recent documents, 16
Word documents, 98
Options command, 7
organizing
email messages, 291
folders on OneDrive, 75
orientation of Word pages, 137
Orientation option (Word), 137
Outline mode (Word), 159
Outline view (PowerPoint), 224-225
outlines of PowerPoint presentations
collapsing/expanding, 224
importing, 225
Outlook
Calendar
navigating, 293
publishing, 303
reserving conference rooms, 300
scheduling appointments, 299
viewing, 298
contacts
deleting, 295
editing, 296
emailing, 297
searching, 294
viewing, 294
email accounts
removing, 279
email messages
attaching files to, 287
blocking, 290
forwarding, 286
moving, 291
reading, 283
receiving, 283
sending, 282
navigating, 277
notes
creating, 307
views, 307
RSS feeds
finding, 309
unsubscribing from, 311
tasks
color coding, 306
deleting, 336
managing, 306
marking as completed, 306
removing, 306
turning notes into, 336
viewing, 337
views, 304
Outlook Tasks command (OneNote), 336
Outlook.com, 87
Page Borders option (Word), 140
Page Break command (Word), 120
page breaks, inserting into Word documents, 120
Page Design (Publisher), 362-363
page layout (Word)
overview, 134
page margins, 136
Page Number command
Word, 121
page numbers
adding to publications, 357
inserting into Word documents, 121
page orientation (Word)
character spacing, 144
columns, 139
leader characters, 147
line spacing, 144
page orientation, 137
page size, 138
paragraph spacing, 145
page parts, adding to publications, 358
Page Parts option (Publisher), 358
Page Setup dialog box, 137-138
Page Setup option (Word), 137
pages
notebook pages
adding, 319
deleting, 319
emailing, 333
promoting, 320
rearranging, 319
subpages, 320
titles, 315
publication pages, inserting, 352
Word page
blank pages, 119
cover pages, 118
page breaks, 120
page numbers, 121
Paragraph dialog box (Word), 146
paragraph spacing (Word), 145
password protection (workbooks), 176-177
Paste command, 18
Paste Options dialog box, 18
PDF (Portable Document Format), saving files as, 22-23
People (Outlook). See contacts
photos. See pictures
Picture Border button, 59
Picture Placeholder option (Publisher), 354
pictures, 50
bitmap pictures, 53
borders, 59
Creative Commons license, 55
cropping, 61
file formats, 53
inserting
into notebooks, 321
multiple pictures, selecting, 53-55
publication pictures, replacing, 347
styles, 58
vector pictures, 53
Pictures button, 52
Playback tab (PowerPoint), 251
Pop Out button (Outlook), 283
Portable Document Format (PDF), saving files as, 22-23
Poster Frame button (PowerPoint), 251
PowerPoint presentations
animation
animating slide objects, 256-257
customizing animations, 258-259
audio
voice narrations, 269
comments
adding, 262
managing, 263
design options, 227
exporting as video, 275
headers/footers
previewing, 241
hyperlinks
removing, 239
testing, 239
online presentations, 27
outlines
collapsing/expanding, 224
importing, 225
overview, 214
sections
collapsing/expanding, 222
moving, 222
removing, 223
renaming, 223
slide shows
rehearsing timings, 268
slides
advancing, 267
bulleted lists, 221
deleting, 236
publishing, 27
size, 228
slide masters, 237
video
formatting, 251
inserting online video, 248-249
inserting video clips from computer, 250
views
Normal, 218
Presenter View, 274
Present Online button (PowerPoint), 272
presentations (PowerPoint)
animation
animating slide objects, 256-257
customizing animations, 258-259
audio
voice narrations, 269
comments
adding, 262
managing, 263
design options, 227
exporting as video, 275
headers/footers
previewing, 241
hyperlinks
removing, 239
testing, 239
online presentations, 27
outlines
collapsing/expanding, 224
importing, 225
overview, 214
sections
collapsing/expanding, 222
moving, 222
removing, 223
renaming, 223
slide shows
rehearsing timings, 268
slides
advancing, 267
bulleted lists, 221
deleting, 236
publishing, 27
size, 228
slide masters, 237
video
formatting, 251
inserting online video, 248-249
inserting video clips from computer, 250
views
Normal, 218
Presenter, 274
Presenter View (PowerPoint), 274
previewing
Excel charts, 206
picture styles, 58
Print Layout view (Word), 158
printing
OneDrive files, 82
PowerPoint presentations, 244-245
privacy, Insights, 38
Promote Subpage command (OneNote), 320
promoting notebook pages, 320
Protect Sheet command (Excel), 177
Protect Workbook button (Excel), 176
publications (Publisher), 348
creating from templates, 340-341
creating new blank publications, 342-343
formatting
backgrounds, 351
borders and accents, 359
business information, 361
color schemes, 350
headers/footers, 356
page numbers, 357
page parts, 358
tables, 360
text boxes, 353
inserting pages into, 352
replacing pictures, 347
replacing text, 346
saving for commercial printing, 366-367
standard page size, 342
Publish Online button (Outlook), 303
Publish to WebDAV Server option (Outlook), 303
Publisher publications
creating from templates, 340-341
creating new blank publications, 342-343
formatting
backgrounds, 351
borders and accents, 359
business information, 361
color schemes, 350
headers/footers, 356
page numbers, 357
page parts, 358
tables, 360
text boxes, 353
inserting pages into, 352
replacing pictures, 347
replacing text, 346
saving for commercial printing, 366-367
standard page size, 342
publishing
Calendar, 303
slides, 27
Quick Access Toolbar
customizing, 35
overview, 8
Quick Parts (Word)
custom Quick Parts, 107
deleting, 107
inserting, 106
Quick Parts library, 106
Quick Tables, 109
Quick Tables Gallery, 110
Read Mode (Word), 158
read-only workbooks, 176
reading email messages, 283
Reading Pane (Outlook), 281-283
rearranging notebook pages, 319
receiving email messages, 283
recent documents, opening, 16
Recommended PivotTables button (Excel), 210
Recommended PivotTables dialog box (Excel), 210
Record Audio command (OneNote), 330
Record Slide Show button (PowerPoint), 269
Record Video command (OneNote), 331
recording
audio in OneNote notebooks, 330
video in OneNote notebooks, 327, 331
Rehearse Timings button (PowerPoint), 268
rehearsing timings (PowerPoint), 268
rejecting changes
in PowerPoint, 265
in Word documents, 157
Remove All Sections command, 223
Remove Current Cover Page command (Word), 118
Remove from List (Outlook), 306
Remove Hyperlink button (PowerPoint), 239
Remove Section and Slides command, 223
Remove Section command, 223
removing. See deleting
renaming
files, 17
presentation sections, 223
worksheets, 173
Replace All button, 44
Replace button, 44
replacing
pictures in publications, 347
worksheet data, 188
Reply All button (Outlook), 283-284
Reply button (Outlook), 283-284
replying to email messages, 284-285
reserving conference rooms, 300
Reset Background button (PowerPoint), 231
resizing
pictures, 60
in OneNote, 321
picture placeholders, 355
video clips, 249
Word tables, 114
resolution (screen), 118
Review tab (Word)
Delete Comment, 155
Markup, 156
Reviewing Pane (Word), 156
reviewing Word documents, 150
accepting/rejecting changes, 157
document markup, 156
Revisions Pane (PowerPoint), closing, 264
Ribbon
customizing, 34
display options, 5
Ribbon Display Options button, 5
right indents (Word), 143
rows
in Excel worksheets
deleting, 171
inserting, 169
row height, 187
in Word tables
deleting, 112
inserting, 111
selecting, 108
RSS feeds
finding, 309
unsubscribing from, 311
Ruler (Word), 136
Run Design Checker button (Publisher), 364
Save As command (File menu), 6, 20, 101
Save As dialog box, 101
Save button, 97
Save command, 6
Save for a Commercial Printer option (Publisher), 366
Save for Photo Printing option (Publisher), 367
Save to Cloud button, 25
saving
files
to OneDrive, 21
notebooks, 314
publications for commercial printing, 366-367
shortcuts, 20
Word documents, 97
workbooks, 165
scheduling
appointments, 299
Screen Recording button (PowerPoint), 250
screen resolution, 118
Screenshot button, 70
ScreenTips, inserting into Word documents, 132
searching
contacts, 294
text, 45
worksheet data, 188
notebook
creating, 316
deleting, 316
merging, 317
moving, 317
PowerPoint, 223
presentation, 222
security, Excel workbooks
Protect Sheet command, 177
read-only workbooks, 176
selecting
rows/columns in Word tables, 108
text in Word documents, 99
Send a Calendar via E-mail dialog box, 302
Send/Receive All Folders command (Outlook), 282-283
sending
email messages, 282
tasks to Outlook, 336
sequential data, entering into worksheets, 168
services, connected, 15
Set Up Slide Show button (PowerPoint), 266
setting up
Shape Effects button, 67
Shape Fill button, 67
Shape Outline button, 67
Shape Style button, 66
shapes
defined, 62
Shapes button, 64
Share Calendar button (Outlook), 302
sharing
shortcuts, saving, 20
Show Comments button (PowerPoint), 263
Sign In button (OneDrive), 74
Sign Up button (OneDrive), 74
signatures (email)
choosing, 289
deleting, 288
signing in to OneDrive, 74
signing up with OneDrive, 74
simple formulas, 196
Single Page option (Publisher), 344
Size option (Word), 138
sizing
pictures in OneNote, 321
slides, 228
video clips, 249
Word pages, 138
worksheet columns, 186
worksheet rows, 187
Slide Master button (PowerPoint), 237
slide masters, 237
slide shows
rehearsing timings, 268
Slide Size button (PowerPoint), 228
Slide Sorter button (PowerPoint), 232
Slide Sorter view (PowerPoint), 232-233
adding, 69
adding to presentations, 219-220
advancing, 267
bulleted lists, 221
deleting, 236
publishing, 27
size, 228
slide masters, 237
slide shows
rehearsing timings, 268
Smart Lookup button, 38
SmartArt
defined, 62
Sort & Filter button (Excel), 190-192
sorting worksheet data, 190-191
Spelling & Grammar button, 48
Split Cells command (Word), 115
Split Table command (Word), 115
splitting
cells in Word tables, 115
Word tables, 115
spreadsheets. See worksheets
squares, creating, 65
standard page size (Publisher), 342
Start Presentation button (PowerPoint), 272
Start screen, 3
storage. See OneDrive
styles
chart styles, 208
Excel styles, 183
picture styles
applying, 58
previewing, 58
PivotTable styles, 211
video styles, 251
Word styles
applying, 105
clearing, 105
creating, 105
table styles, 110
subpages (notebook), creating, 320
subscribing to RSS feeds, 308-311
SUM function, 201
switching
Microsoft accounts, 14
notebook views, 325
notebooks, 314
symbols, inserting into Word documents, 130-131
Symbols command (Word), 130
tab color (worksheets), 173
Tab Color command (Excel), 173
Table option (Publisher), 360
tables
adding to publications, 360
notebook tables
formatting, 329
inserting, 329
Word tables
creating, 108
deleting cells, 112
deleting tables, 113
formatting, 110
inserting from other sources, 115
inserting rows/columns, 111
merging cells, 114
navigating, 108
Quick Tables, 109
resizing, 114
rows/columns, 112
selecting rows/columns, 108
splitting cells, 115
splitting tables, 115
styles, 110
undoing changes, 112
Tabs dialog box (Word), 146
tags
adding to notebooks, 322
customizing, 322
task panes, 11
tasks
color coding, 306
deleting, 336
managing, 306
marking as completed, 306
removing, 306
turning notes into, 336
viewing in Outlook, 337
views, 304
Tell Me box, 36
templates
applying to notebooks, 324
colors/fonts, 343
creating publications from, 340-341
customizing, 347
replacing pictures, 347
replacing text, 346
testing hyperlinks in PowerPoint presentations, 239
text, 40
aligning, 43
finding, 45
merging and centering, 181
wrapping, 180
justifying, 43
notebook text, 318
publication text, 349
backgrounds, 351
business information, 361
color schemes, 350
headers/footers, 356
page numbers, 357
replacing, 346
tables, 360
text boxes, 353
Word text
bulleted lists, 102
color, 104
date/time fields, 129
drop caps, 128
hyperlinks, 132
numbered lists, 103
ScreenTips, 132
selecting, 99
styles, 105
WordArt
formatting, 47
inserting, 46
Text Box command (Word), 126
text boxes, inserting
into publications, 353
Text Effects button, 47
Text Fill button, 47
Text Outline button, 47
themes
defined, 104
Office themes, 15
PowerPoint presentations, 216-217, 229
Themes option (Word), 148
time fields, inserting into Word documents, 129
timestamps, adding to notebooks, 332
Timings (PowerPoint), 259, 268
titles
notebooks, 315
Word documents, 119
toolbars
mini toolbar, 9
Quick Access Toolbar, 8
Touch Mode, 8
tracking changes in Word documents, 144, 152-153
Transitions tab (PowerPoint), 254
Trust Center, 35
Two-Page Spread option (Publisher), 344
Undo button, 112
undoing changes
OneNote notebooks, 335
Word documents, 112
Unfreeze Panes command (Excel), 189
Unhide Sheet command (Excel), 175
unhiding worksheets, 175
Universal Office apps, 87
unsubscribing from RSS feeds, 311
Upload command (OneDrive), 78
vector pictures, 53
version history, 85
video
adding to PowerPoint presentations
formatting, 251
video clips from computer, 250
exporting PowerPoint presentations as, 275
recording to notebooks, 327, 331
video styles, 251
Video Border button (PowerPoint), 251
Video button (PowerPoint), 248-250
Video on My PC option (PowerPoint), 250
Video Style button (PowerPoint), 251
View button (OneDrive), 84
viewing
Calendar, 298
connected services, 15
contacts, 294
document markup, 156
tasks in Outlook, 337
Word documents, 150
document markup, 156
views
Calendar, 298
Contacts (Outlook), 294
notebooks, 325
Outlook notes, 307
PowerPoint presentations
Normal view, 218
Presenter View, 274
tasks, 304
voice narrations, adding to PowerPoint presentations, 269
weather bar (Calendar), 298
Web Layout (Word), 159
Web searches with Insights, 38-39
Whole Page option (Publisher), 345
width of worksheet columns, 186
wizards, Pack and Go Wizard, 366-367
Word documents, 94. See also text
bookmarks, 133
combining, 157
comparing, 157
creating
creating in Office Mobile, 90-93
headers/footers
mini toolbars, 99
opening, 98
page layout
character spacing, 144
columns, 139
leader characters, 147
line spacing, 144
overview, 134
page margins, 136
page orientation, 137
page size, 138
paragraph spacing, 145
pages
blank pages, 119
cover pages, 118
page breaks, 120
page numbers, 121
Quick Parts
custom Quick Parts, 107
deleting, 107
inserting, 106
Quick Parts library, 106
reviewing, 150
accepting/rejecting changes, 157
document markup, 156
saving, 97
tables
creating, 108
deleting, 113
deleting cells, 112
deleting rows/columns, 112
formatting, 110
inserting from other sources, 115
inserting rows/columns, 111
merging cells, 114
navigating, 108
Quick Tables, 109
resizing, 114
selecting rows/columns, 108
splitting, 115
splitting cells, 115
styles, 110
undoing changes, 112
text
bulleted lists, 102
color, 104
date/time fields, 129
drop caps, 128
hyperlinks, 132
numbered lists, 103
ScreenTips, 132
selecting, 99
styles, 105
formatting, 47
inserting, 46
WordArt gallery, 46
charts
modifying, 209
previewing, 206
styles, 208
columns
deleting, 171
inserting, 170
creating
blank workbooks, 166
data formatting, 178
cell styles, 183
column headers, 190
column width, 186
freezing panes, 189
merging and centering text, 181
numbers, 182
row height, 187
wrapping text, 180
defined, 162
formulas
absolute references in, 200
AutoSum button, 202
calculation precedence, 199
compound formulas, creating, 198-199
copying, 197
overview, 194
simple formulas, creating, 196
functions
AVERAGE, 203
COUNT, 203
MAX, 203
MIN, 203
SUM, 201
read-only workbooks, 176
rows
deleting, 171
inserting, 169
saving, 165
worksheets
cell addresses, 167
defined, 162
deleting, 174
entering data into, 168
hiding, 175
inserting, 172
navigating, 167
protecting data, 177
renaming, 173
replacing data, 188
searching, 188
tab color, 173
unhiding, 175
worksheets (Excel). See also workbooks
cell addresses, 167
defined, 162
deleting, 174
entering data into, 168
hiding, 175
inserting, 172
navigating, 167
protecting data, 177
renaming, 173
replacing data, 188
searching, 188
tab color, 173
unhiding, 175
Wrap Text button (Excel), 180
wrapping text in Excel worksheets, 180
XPS (XML Paper Specification), saving files as, 22-23
Zoom slider
Publisher, 345
Word, 160
zooming in/out
in Publisher, 345