Description
Book SynopsisStart learning the latest in Office Office Simplified is the quick, easy, full-color guide to the new features and tools of the latest version of Office.
Table of ContentsOFFICE FEATURES
Chapter 1 Office Basics
Start and Exit Office Applications 4
Navigate the Program Windows 6
Work with Backstage View 7
Change the Color Scheme 8
Find a Ribbon Command 10
Work with the Ribbon 12
Customize the Quick Access Toolbar 14
Using an Office Program on a Tablet PC 16
Chapter 2 Working with Files
Create a New File 18
Save a File 20
Open a File 22
Print a File 24
Email a File 26
Select Data 28
Cut, Copy, and Paste Data 30
Arrange Windows 32
Chapter 3 Office Graphics Tools
Insert a Picture 34
Insert an Online Picture 36
Resize and Move Objects 38
Understanding Graphics Modification Techniques 40
Chapter 4 Working with Office Files Online
Office and the Cloud 42
Sign In to Office 365 44
Share a Document from Office 46
Download Apps from the Office Store 48
Sign In to OneDrive 50
Using an Online App in OneDrive 52
Using an Office Program from OneDrive 54
Upload a Document to OneDrive 56
Share a Document Using OneDrive 58
WORD
Chapter 5 Adding Text
Change Word’s Views 62
Type and Edit Text 64
Insert Quick Parts 66
Insert Symbols 68
Create a Blog Post 70
Chapter 6 Formatting Text
Change the Font, Size, and Color 72
Align Text 76
Set Line Spacing 77
Indent Text 78
Set Tabs 80
Set Margins 82
Create Lists 84
Copy Formatting 86
Clear Formatting 87
Format with Styles 88
Using a Template 90
EXCEL
Chapter 7 Adding Extra Touches
Insert an Online Video 92
Assign a Theme 94
Add Borders 96
Create Columns 98
Insert a Table 100
Apply Table Styles 102
Insert Table Rows or Columns 103
Add Headers and Footers 104
Insert Footnotes and Endnotes 106
Insert Page Numbers and Page Breaks 108
Generate a Table of Contents 110
Create a Bibliography 112
Chapter 8 Reviewing Documents
Work in Read Mode View 114
Find and Replace Text 116
Scan Document Content 118
Check Spelling and Grammar 120
Work with AutoCorrect 122
Using Word’s Thesaurus and Dictionary 124
Translate Text 126
Track and Review Document Changes 128
Lock and Unlock Tracking 130
Work with Comments 132
EXCEL
Chapter 9 Building Spreadsheets
Enter Cell Data 136
Select Cells 137
Faster Data Entry with AutoFill 138
Turn On Text Wrapping 140
Center Data Across Columns 141
Adjust Cell Alignment 142
Change the Font and Size 144
Change Number Formats 146
Increase or Decrease Decimals 147
Add Cell Borders and Shading 148
Format Data with Styles 150
Apply Conditional Formatting 152
Add Columns and Rows 154
Resize Columns and Rows 156
Freeze Column and Row Titles On‐Screen 157
Name a Range 158
Clear or Delete Cells 160
Split and Format a Column of Data 162
Chapter 10 Worksheet Basics
Add a Worksheet 164
Name a Worksheet 165
Change Page Setup Options 166
Move and Copy Worksheets 168
Delete a Worksheet 169
Find and Replace Data 170
Create a Table 172
Filter or Sort Table Information 174
Analyze Data Quickly 176
Understanding Data Analysis Choices 177
Track and Review Worksheet Changes 178
Insert a Comment 180
Chapter 11 Working with Formulas and Functions
Understanding Formulas 182
Create a Formula 184
Apply Absolute and Relative Cell References 186
Understanding Functions 188
Apply a Function 190
Total Cells with AutoSum 192
Audit a Worksheet for Errors 194
Chapter 12 Working with Charts
Create a Chart 196
Move and Resize Charts 198
Change the Chart Type 200
Change the Chart Style 201
Change the Chart Layout 202
Add Chart Elements 203
Format Chart Objects 204
Change the Chart Data 205
Using Sparklines to View Data Trends . . . . . . . . . . . . . .206
POWERPOINT
Chapter 13 Creating a Presentation
Create a New Presentation 210
Create a Photo Album Presentation 212
Change PowerPoint Views 214
Insert Slides 216
Change the Slide Layout 217
Change the Slide Size 218
Chapter 14 Populating Presentation Slides
Add and Edit Slide Text 220
Change the Font, Size, and Color 222
Apply a Theme 226
Set Line Spacing 227
Align Text 228
Add a Text Box to a Slide 229
Add a Table to a Slide 230
Add a Chart to a Slide 232
Add a Video Clip to a Slide 234
Move a Slide Object 236
Resize a Slide Object 237
Chapter 15 Assembling and Presenting a Slide Show
Reorganize Slides 238
Reuse a Slide 240
Define Slide Transitions 242
Add Animation Effects 244
Record Narration 246
Insert a Background Song 247
Create Speaker Notes 248
Rehearse a Slide Show 250
Run a Slide Show 252
Review a Presentation 256
Package Your Presentation on a CD 258
Present Online 260
ACCESS
Chapter 16 Database Basics
Understanding Database Basics 264
Create a Database Based on a Template 266
Create a Blank Database 268
Create a New Table 270
Change Table Views 272
Add a Field to a Table 274
Delete a Field from a Table 275
Hide a Field in a Table 276
Move a Field in a Table 277
Create a Form 278
Change Form Views 280
Move a Field in a Form 281
Delete a Field in a Form 282
Apply a Database Theme 283
Chapter 17 Adding, Finding, and Querying Data
Add a Record to a Table 284
Add a Record to a Form 286
Navigate Records in a Form 288
Search for a Record Using a Form 289
Delete a Record from a Table 290
Delete a Record Using a Form 291
Sort Records 292
Filter Records 294
Apply Conditional Formatting 296
Perform a Simple Query 298
Create a Report 302
OUTLOOK
Chapter 18 Organizing with Outlook
Navigate in Outlook 306
Schedule an Appointment 308
Create a New Contact 310
Create a New Task . . . . . . . . . . . . . . . . . . . . .312
Add a Note 314
Customize the Navigation Bar 316
Peek at Appointments and Tasks 318
Search for Outlook Items 320
Work with the To‐Do Bar 322
Link Contacts 323
Chapter 19 Emailing with Outlook
Compose and Send a Message 324
Send a File Attachment 326
Read an Incoming Message 327
Reply To or Forward a Message 328
Add a Sender to Your Outlook Contacts 330
Delete a Message 331
Work with Conversations 332
Screen Junk Email 334
PUBLISHER
Chapter 20 Publisher Basics
Create a Publication 338
Zoom In and Out 340
Add Text 342
Add a New Text Box 343
Swap Pictures 344
Save a Publication for Photo Center Printing 346
Chapter 21 Fine‐Tuning a Publication
Change the Font, Size, and Color 348
Apply a Text Effect 352
Change Text Alignment 353
Add a Border 354
Control Text Wrap 355
Link Text Boxes 356
Edit the Background 358
Taking Notes with OneNote
Navigate OneNote 362
Type and Draw Notes 364
Insert and Format a Table 366
Attach Files to Notes 368
Create a Quick Note 369
Insert a Screen Clipping 370
Record an Audio Note 372
ONENOTE
Chapter 22 Organizing and Sharing Notes
Create a New Notebook 374
Create a New Section 375
Create a New Page 376
Rename a Section or Page 377
Group Sections 378
Search Notes 380
Search for Recent Edits 382
Set Synchronization Options 383
Share Notes with People Who Do Not Have OneNote 384
