My Office 2016 (includes Content Update Program)

Paul McFedries is a Microsoft Office expert and full-time technical writer. Paul has been authoring computer books since 1991 and has more than 85 books to his credit, which combined have sold more than four million copies worldwide. His titles include the Que Publishing books Formulas and Functions with Microsoft Excel 2016, PCs for Grownups, and Windows 10 In Depth (with coauthor Brian Knittel), as well as the Sams Publishing book Windows 7 Unleashed. Paul is also the proprietor of Word Spy (www.wordspy.com), a website devoted to lexpionage, the sleuthing of new words and phrases that have entered the English language. Please drop by Paul’s personal website at www.mcfedries.com or follow Paul on Twitter at twitter.com/wordspy.

Chapter 1  Getting Started with Office 2016   3
Understanding Office 365 and Office 2016   4
Learning How Office 365 Works   4
Taking Your First Steps with Office 2016   .5
Sign In to Your Microsoft Account   5
Create a Microsoft Account   7
Sign Out of Your Microsoft Account   9
Switch Between Office 2016 Applications   10
Creating a New Document   11
Create a Blank Document at Startup   12
Create a Blank Document After an Office 2016 Application Is Running   12
Creating a Document from a Template or Theme   13
Preserving Your Work   14
Save a New Document   14
Create a Duplicate of a Document   16
Convert a Document to the Latest Format   17
Working with Documents   18
Open a Document   18
Pin a Document to the Recent Tab   20
Print a Document.   21
Chapter 2  Formatting Documents   23
Selecting Text   24
Select Text with a Mouse   25
Changing the Font   26
Understanding Typefaces   27
Set the Typeface   28
Change the Type Size   29
Apply Type Effects   30
Set Text Colors   31
Formatting Paragraphs   32
Align Paragraphs   32
Set the Line Spacing   33
Build a Bulleted List   34
Create a Numbered List   35
Set the Indentation   37
Working with Formatting   37
Apply Styles   38
Apply Text Effects   39
Clear Formatting   40
Chapter 3  Working with Office 2016 Graphics   43
Working with Shapes   44
Inserting a Line   44
Inserting Any Other Shape   45
Inserting Images   46
Inserting a Picture   47
Understanding SmartArt Graphics   49
Inserting a SmartArt Graphic   50
Inserting WordArt   51
Formatting and Editing Graphic Objects   52
Selecting Graphic Objects   53
Lassoing Graphic Objects   53
Sizing a Graphic Object   54
Moving a Graphic Object   55
Rotating a Graphic Object   56
Formatting a Graphic Object   57
Chapter 4  Working with Text in Word   61
Learning Text Basics   62
Enter and Edit Text    62
Enter Text with AutoCorrect   63
Insert Symbols   65
Insert Symbols Using AutoCorrect   66
Set Tabs   67
Enter Headings   69
Finding and Replacing Text   70
Find Text   71
Replace Text    73
Proofing Text   75
Handle Spelling and Grammar Errors   76
Adding Hyperlinks   77
Insert a Hyperlink   78
Chapter 5  Working with Page Layout and Design in Word   81
Building a Table   82
Insert a Table   82
Select Table Elements   84
Format a Table   85
Insert New Rows    86
Insert New Columns   87
Delete Table Elements   88
Working with Headers and Footers   89
Adding a Header   90
Adding a Footer   93
Changing the Page Setup   94
Setting the Margins   95
Changing the Page Orientation   97
Changing the Paper Size   98
Add a Page Break   99
Understanding Sections   99
Add a Section Break   100
Display Text in Columns   101
Adding Footnotes and Endnotes   103
Insert a Footnote or Endnote   104
Chapter 6  Entering Excel Data   107
Understanding Worksheet Cells and Data   108
Working with Numbers   109
Working with Text   109
Working with Dates and Times   110
Entering and Editing Data   112
Enter Cell Data   112
Edit Cell Data   113
Working with Formulas and Functions   114
Build a Formula   115
Understanding Functions   117
Add a Function Directly to a Cell   118
Add a Function Using the Function Wizard   119
Building a Table   121
Convert Cells to a Table    122
Select Table Elements   123
Format a Table   123
Add New Rows and Columns   125
Delete Rows and Columns   126
Sort a Table   126
Filter a Table   128
Chapter 7  Getting More Out of Excel Ranges   131
Selecting a Range   132
Select a Range with a Mouse   132
Select a Range on a Touchscreen   133
Working with Excel Ranges   133
Fill a Range with a Specific Value   134
Fill a Range with a Series of Values   135
Make a Copy of a Range   137
Move a Range   138
Insert a Range   139
Delete a Range   140
Working with Range Names   141
Name a Range   142
Formatting a Range    142
Learning About Data Formats   143
Apply a Numeric or Date Format   146
Control the Number of Decimal Places   147
Resize Columns   148
Resize Rows   149
Add Borders   150
Wrap Text Within a Cell   151
Chapter 8  Visualizing Excel Data with Charts   153
Creating a Chart   154
Create an Embedded Chart   155
Create a Chart in a Separate Sheet   156
Working with Charts   157
Understanding Excel’s Chart Types   157
Change the Chart Type   159
Move a Chart   161
Resize a Chart   162
Change the Chart Layout and Style   162
Working with Chart Elements   163
Select Chart Elements   163
Format Chart Elements   164
Add Titles   165
Add a Chart Legend   166
Add Data Marker Labels   167
Chapter 9  Building a PowerPoint Presentation   169
Adding a Slide to the Presentation   170
Understanding Slide Layouts   170
Insert a New Slide   172
Duplicate a Slide   173
Adding Data to a Slide   174
Add Text   175
Create a Bulleted List   175
Add a Video   177
Add a Chart    178
Add a Table    180
Working with Slides    181
Select Slides   181
Rearrange Slides    181
Change the Layout of a Slide   182
Hide a Slide   182
Add Notes to a Slide   184
Understanding the Slide Master   186
Work with the Slide Master   186
Chapter 10  Working with PowerPoint Slide Shows   191
Defining Slide Animations    192
Animation Guidelines   192
Set Up a Slide Transition   193
Animate Slide Objects    195
Add an Animation   196
Preparing a Slide Show   198
Rehearse Slide Timings   199
Recording Narration   200
Record Narration for a Slide   201
Record Narration for an Entire Presentation   202
Setting Up Multiple Versions of a Slide Show   204
Create a Custom Slide Show   205
Running a Slide Show   206
Start the Slide Show   206
Navigate Slides   207
Set Up an Automatic Slide Show   210
Chapter 11  Sending and Receiving Outlook Email   213
Setting Up Your Email Account   214
Add an Account Automatically   214
Add an Account Manually   216
Composing and Sending a New Message   218
Compose a Message   218
Use the Contacts List to Specify Recipients   220
Attach a File to a Message    221
Reading and Working with Incoming Mail   222
Retrieve and Read Messages   222
Reply to a Message   224
Forward a Message   225
Save an Attachment   226
Move a Message    227
Delete a Message   228
Chapter 12  Scheduling with the Outlook Calendar   231
Using the Calendar Folder   232
Switch to the Calendar Folder   232
Navigate to a Date   233
Switch the Calendar’s View   234
Setting Up Appointments   235
Create a New Appointment   236
Taking Advantage of AutoDate   237
Create a Recurring Appointment   239
Appointments Versus All-Day Events   241
Schedule an All-Day Event   242
Understanding Meeting Requests   242
Request a Meeting   243
Chapter 13  Keeping in Touch with Outlook Contacts   247
Exploring the Contacts Folder   248
Switch to the Contacts Folder   248
Understanding the Contacts Folder Views   249
Adding a New Contact   250
Create a New Contact from Scratch   250
Understanding Outlook’s Contact Data Fields   252
Create a Contact from the Same Company   253
Create a Contact from an Email Message   254
Importing Contact Data   255
Import Contact Data   255
Working with Your Contacts   259
Edit Contact Data   259
Add a Picture for a Contact   260
Send an Email to a Contact   261
Request a Meeting with a Contact   262
View a Map of a Contact’s Address   263
Print a Contact Address on an Envelope or Label   264
Chapter 14  Building a OneNote Notebook   267
Working with Sections   268
Insert a New Section   269
Rename a Section   269
Color-Code a Section   270
Working with Pages   271
Insert a New Page   271
Insert a New Page from a Template   272
Enter Text on a Page   273
Work with Page Containers   274
Building a OneNote Table   274
Insert a Table   275
Working with Tags   277
Tag an Item   277
Build Lists   279
Create a To-Do List   280
Chapter 15  Getting More Out of OneNote   283
Working with Notebooks   284
Create a New Notebook   284
Switch Between Notebooks   285
Set Notebook Properties   286
Adding Data to a Page   287
Insert the Date and Time   288
Add a Link to a Website   289
Add a Link to a OneNote Location   290
Insert a Spreadsheet File   291
Insert a New Spreadsheet   293
Attach a File   294
Adding Ink   295
Handwrite Text   295
Highlight Text   .296
Convert Ink to Text   297
Erase Ink   298
Chapter 16  Learning Access Basics   301
Understanding Access Databases   302
Creating a Database   303
Create a Database    303
Building and Working with Tables   304
Designing a Table   304
Learning About Access Data Types   307
Create a Table    308
Enter Data   309
Sort Table Data    311
Filter Table Data   312
Querying Access Data   313
Design a Simple Query   313
Understanding Query Criteria   315
Enter Query Criteria    317
Creating Forms   319
Create a Basic Form   319
Navigating Form Fields and Records   320
Run the Form Wizard    321
Creating Reports   323
Create a Basic Report   323
Run the Report Wizard   324
Chapter 17  Customizing the Office 2016 Applications   329
Working with Application Options   330
Working with the Options Dialog Box   330
Changing Your User Name and Initials   331
Bypassing the Start Screen at Launch   332
Customizing the Interface   333
Pinning the Ribbon   333
Hiding the Ribbon   334
Customizing the Ribbon   334
Changing the Position of the Quick Access Toolbar   338
Customizing the Quick Access Toolbar   339
Setting the Office Background   341
Chapter 18  Collaborating with Others   343
Collaborating in Word with Comments and Changes   344
Insert Comments in a Word Document   344
Edit a Comment   345
Delete a Comment   345
Track Changes in a Word Document   346
Control the Display of Comments and Changes   .346
Control the Markup Display   348
Navigate Comments and Changes   349
Accept or Reject Comments and Changes   350
Collaborating in Excel with Comments and Changes   351
Insert Comments in Cells   352
View Workbook Comments   353
Track Worksheet Changes   354
Accept or Reject Workbook Changes   356
Share an Excel Workbook with Other Users   358
Display and Removing Reviewers   360
Handle Sharing Conflicts   361
Sharing a Document Online   362
Save a Document to OneDrive   362
Send an Invitation to Share a OneDrive Document   363
Copy a Link to Share a OneDrive Document   365
Appendix A  Excel Worksheet Function Reference   367
Financial Functions   370
Date and Time Functions   374
Math and Trigonometry Functions   375
Statistical Functions   378
Lookup and Reference Functions   383
Database Functions   384
Text Functions   385
Logical Functions    387
Information Functions    387
Engineering Functions   388
Cube Functions   391
Compatibility Functions   391
Web Functions   393
Index   395