Microsoft Office 2016 Step by Step

Joan Lambert has worked closely with Microsoft technologies since 1986, and in the training and certification industry since 1997. As President and CEO of Online Training Solutions, Inc. (OTSI), Joan guides the translation of technical information and requirements into useful, relevant, and measurable resources for people who are seeking certification of their computer skills or who simply want to get things done efficiently. Joan is the author or coauthor of more than three dozen books about Windows and Office (for Windows, Mac, and iPad), video-based training courses about SharePoint and OneNote, and three generations of Microsoft Office Specialist certification study guides. Joan is a Microsoft Certified Professional, Microsoft Certified Trainer, Microsoft Office Specialist Master (for all Office versions since Office 2007), Microsoft Certified Technology Specialist (for Windows and Windows Server), Microsoft Certified Technology Associate (for Windows), and Microsoft Dynamics Specialist. Curtis Frye is the author of more than 30 books, including  Microsoft Excel 2013 Step by Step for Microsoft Press and  Brilliant Excel VBA Programming for Pearson, UK. He has also created and recorded more than three dozen courses for lynda.com, including  Excel for Mac 2016 Essential Training and  Excel 2013: PivotTables in Depth.

Introduction     xi
Who this book is for     xi
The Step by Step approach     xii
Download the practice files     xii
Ebook edition     xv
Get support and give feedback     xv
Errata and support     xv
We want to hear from you     xvi
Stay in touch     xvi
Part 1: Microsoft Office 2016
Chapter 1: Explore Office 2016     3
Work in the Office user interface     4
Identify app window elements     5
Sidebar: Tell me what you want to do     10
Work with the ribbon and status bar     12
Sidebar: Adapt exercise steps     16
Change Office and app options     18
Manage account information     18
Manage app options     22
Customize the Quick Access Toolbar     25
Customize the ribbon     29
Skills review     34
Practice tasks     35
Chapter 2: Create and manage files     39
Create files     40
Open and move around in files     43
Display different views of files     48
Display and edit file properties     53
Sidebar: File types and compatibility with earlier versions of Office apps     54
Save and close files     56
Sidebar: Save files to OneDrive     60
Skills review     62
Practice tasks     63
Part 2: Microsoft Word 2016
Chapter 3: Modify the structure and appearance of text     69
Apply paragraph formatting     70
Configure alignment     71
Configure vertical spacing     72
Configure indents     76
Sidebar: Configure paragraph borders and shading     79
Structure content manually     79
Apply character formatting     84
Sidebar: Character formatting and case considerations     91
Create and modify lists     91
Sidebar: Format text as you type     96
Apply built-in styles to text     97
Apply styles     97
Manage outline levels     101
Change the document theme     104
Skills review     108
Practice tasks     109
Chapter 4: Collaborate on documents     115
Mark up documents     116
Insert comments     116
Track changes     119
Display and review document markup     122
Display markup     122
Review and respond to comments     128
Review and process tracked changes     130
Sidebar: Remember to check for errors     133
Compare and merge documents     133
Compare and combine separate copies of a document     134
Compare separate versions of a document     136
Control content changes     137
Restrict actions     138
Restrict access by using a password     144
Sidebar: Restrict access by using rights management     149
Coauthor documents     149
Skills review     153
Practice tasks     154
Chapter 5: Merge data with documents and labels     159
Understand the mail merge process     160
Start the mail merge process     161
Get started with letters      162
Get started with labels     163
Get started with email messages     166
Choose and refine the data source     168
Select an existing data source     169
Create a new data source     172
Refine the data source records     173
Sidebar: Refresh data     178
Insert merge fields     178
Preview and complete the merge     181
Create individual envelopes and labels     184
Generate individual envelopes     184
Generate individual mailing labels     188
Skills review     190
Practice tasks     191
Part 3: Microsoft Excel 2016
Chapter 6: Perform calculations on data     197
Name groups of data     198
Define Excel tables     201
Create formulas to calculate values     205
Sidebar: Operators and precedence     218
Summarize data that meets specific conditions     219
Set iterative calculation options and enable or disable automatic calculation     225
Use array formulas     227
Find and correct errors in calculations     229
Skills review     235
Practice tasks     236
Chapter 7: Manage worksheet data     239
Limit data that appears on your screen     240
Manipulate worksheet data     245
Sidebar: Select list rows at random     246
Summarize data in worksheets that have hidden and filtered rows     247
Find unique values within a data set     253
Define valid sets of values for ranges of cells     255
Skills review     257
Practice tasks     258
Chapter 8: Reorder and summarize data     261
Sort worksheet data     262
Sort data by using custom lists      268
Organize data into levels     271
Look up information in a worksheet     276
Skills review     279
Practice tasks     280
Chapter 9: Analyze alternative data sets     283
Examine data by using the Quick Analysis Lens     284
Define an alternative data set     286
Define multiple alternative data sets     290
Analyze data by using data tables     292
Vary your data to get a specific result by using Goal Seek     295
Find optimal solutions by using Solver     297
Analyze data by using descriptive statistics     303
Skills review     305
Practice tasks     306
Part 4: Microsoft PowerPoint 2016
Chapter 10: Create and manage slides     313
Add and remove slides     314
Insert new slides     316
Copy and import slides and content     317
Sidebar: SharePoint slide libraries     322
Hide and delete slides     324
Divide presentations into sections     326
Rearrange slides and sections     329
Apply themes     331
Change slide backgrounds     336
Sidebar: Non-theme colors     344
Skills review     346
Practice tasks     347
Chapter 11: Insert and manage simple graphics     351
Insert, move, and resize pictures     352
Sidebar: Graphic formats     355
Edit and format pictures     356
Draw and modify shapes     361
Draw and add text to shapes     362
Sidebar: Locate additional formatting commands     364
Move and modify shapes     365
Format shapes     367
Sidebar: Connect shapes     371
Capture and insert screen clippings     372
Create a photo album     375
Skills review     380
Practice tasks     381
Chapter 12: Add sound and movement to slides     385
Animate text and pictures on slides     386
Sidebar: Animate this     392
Customize animation effects     396
Sidebar: Bookmark points of interest in media clips     402
Add audio content to slides     404
Add video content to slides     410
Compress media to decrease file size     415
Skills review     417
Sidebar: Hyperlink to additional resources     418
Practice tasks     420
Part 5: Microsoft Outlook 2016
Chapter 13: Send and receive email messages     427
Create and send messages     428
Create messages     429
Troubleshoot message addressing     434
Save and send messages     438
Sidebar: Send from a specific account     440
Attach files and Outlook items to messages     444
Sidebar: New mail notifications     451
Display messages and message attachments     452
Display message content     452
Display attachment content     454
Display message participant information     459
Respond to messages     464
Sidebar: Resending and recalling messages     468
Skills review     471
Practice tasks     472
Chapter 14: Organize your Inbox     475
Display and manage conversations     476
Arrange messages by specific attributes     482
Categorize items     486
Sidebar: Store information in Outlook notes     490
Organize messages in folders     494
Sidebar: Print messages     498
Skills review     499
Practice tasks     500
Chapter 15: Manage scheduling     503
Schedule appointments and events     504
Sidebar: Add holidays to your calendar     508
Convert calendar items     510
Configure calendar item options     512
Schedule and change meetings     518
Respond to meeting requests     526
Display different views of a calendar     528
Sidebar: Use the Date Navigator     532
Skills review     535
Practice tasks     536

Index     541
About the authors     564