My Office 2016 for Mac (includes Content Update Program)

Paul McFedries is an Excel 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 4 million copies worldwide. His titles include the Que Publishing books My Office 2016, Windows 10 In Depth (with coauthor Brian Knittel), and PCs for Grownups, 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 for Mac   3
Understanding Office 365 and Office 2016 for Mac   3
Learning How Office 365 Works   4
Taking Your First Steps with Office 2016 for Mac   5
Sign In to Your Microsoft Account   5
Create a Microsoft Account   6
Sign Out of Your Microsoft Account   8
Switch Between Office 2016 for Mac Applications   9
Creating a New Document   9
Create a Blank Document at Startup   10
Create a Blank Document After an Office 2016 for Mac Application Is Running   11
Creating a Document from a Template   12
Preserving Your Work   12
Save a New Document   13
Create a Duplicate of a Document   14
Working with Documents   15
Open a Document   15
Pin a Document to the Recent Tab   16
Print a Document   16
Chapter 2  Formatting Documents   19
Selecting Text   20
Select Text with a Mouse or Trackpad   21
Changing the Font   22
Understanding Typefaces   23
Set the Typeface   23
Change the Type Size   24
Apply Type Effects   25
Set Text Colors   26
Formatting Paragraphs   27
Align Paragraphs   27
Set the Line Spacing 28
Build a Bulleted List 29
Create a Numbered List 30
Set the Indentation   32
Working with Formatting   32
Apply Styles   33
Apply Text Effects   33
Clear Formatting   34
Chapter 3  Working with Office 2016 for Mac Graphics   37
Working with Shapes   38
Inserting a Line   38
Inserting Any Other Shape   40
Inserting Images   40
Inserting a Picture   41
Understanding SmartArt Graphics   43
Inserting a SmartArt Graphic   44
Inserting WordArt   45
Formatting and Editing Graphic Objects   46
Selecting Graphic Objects   46
Lassoing Graphic Objects   47
Sizing a Graphic Object   48
Moving a Graphic Object   49
Rotating a Graphic Object   50
Formatting a Graphic Object   51
Chapter 4  Working with Text in Word   55
Learning Text Basics   56
Enter and Edit Text   56
Enter Text with AutoCorrect   57
Insert Symbols   59
Insert Symbols Using AutoCorrect   60
Set Tabs   61
Enter Headings   63
Finding and Replacing Text   64
Find Text   64
Replace Text   66
Proofing Text   68
Handle Spelling and Grammar Errors   69
Adding Hyperlinks   70
Insert a Hyperlink   71
Chapter 5  Working with Page Layout and Design in Word   75
Building a Table   75
Insert a Table   76
Select Table Elements   78
Format a Table 79
Insert New Rows   80
Insert New Columns   81
Delete Table Elements   82
Working with Headers and Footers   83
Adding a Header   84
Adding a Footer   87
Changing the Page Setup 88
Setting the Margins   88
Changing the Page Orientation   90
Changing the Paper Size   91
Add a Page Break   92
Understanding Sections   92
Add a Section Break   93
Display Text in Columns   94
Adding Footnotes and Endnotes   96
Insert a Footnote or Endnote   96
Chapter 6  Entering Excel Data   99
Understanding Worksheet Cells and Data   100
Working with Numbers   100
Working with Text   101
Working with Dates and Times   101
Entering and Editing Data   103
Enter Cell Data   104
Edit Cell Data   105
Working with Formulas and Functions   106
Build a Formula   107
Understanding Functions   108
Add a Function Directly to a Cell   109
Add a Function Using the Function Wizard   111
Building a Table   112
Convert Cells to a Table   113
Select Table Elements   113
Format a Table 114
Add New Rows and Columns 115
Delete Rows and Columns 116
Sort a Table   117
Filter a Table   118
Chapter 7  Getting More Out of Excel Ranges   121
Selecting a Range   122
Select a Range with a Mouse   122
Select a Range with a Keyboard   123
Working with Excel Ranges   123
Fill a Range with a Specific Value 124
Fill a Range with a Series of Values   125
Make a Copy of a Range   127
Move a Range   128
Insert a Range   129
Delete a Range   130
Working with Range Names   131
Name a Range   132
Formatting a Range   132
Learning About Data Formats   133
Apply a Numeric or Date Format   136
Control the Number of Decimal Places 137
Resize Columns   138
Resize Rows   139
Add Borders   140
Wrap Text Within a Cell   141
Chapter 8  Visualizing Excel Data with Charts   143
Creating a Chart 143
Create an Embedded Chart   145
Create a Chart in a Separate Sheet   145
Working with Charts   146
Understanding Excel’s Chart Types   146
Change the Chart Type   148
Move a Chart   149
Resize a Chart   150
Change the Chart Layout and Style   151
Working with Chart Elements   151
Select Chart Elements   152
Format Chart Elements   153
Add Titles   154
Add a Chart Legend   155
Add Data Marker Labels   156
Chapter 9  Building a PowerPoint Presentation   159
Adding a Slide to the Presentation   160
Understanding Slide Layouts   160
Insert a New Slide   162
Duplicate a Slide   163
Adding Data to a Slide   164
Add Text   164
Create a Bulleted List   165
Add a Video   166
Add a Chart 168
Add a Table   169
Working with Slides   170
Select Slides   170
Rearrange Slides   170
Change the Layout of a Slide   171
Hide a Slide   171
Add Notes to a Slide   173
Understanding the Slide Master   174
Work with the Slide Master   175
Chapter 10  Working with PowerPoint Slide Shows   179
Defining Slide Animations   180
Animation Guidelines   180
Set Up a Slide Transition   181
Animate Slide Objects   183
Add an Animation   183
Preparing a Slide Show   186
Rehearse Slide Timings   187
Recording Narration   188
Record Narration for a Slide   188
Setting Up Multiple Versions of a Slide Show   190
Create a Custom Slide Show   190
Running a Slide Show   192
Start the Slide Show   192
Navigate Slides   193
Set Up an Automatic Slide Show   195
Chapter 11  Sending and Receiving Outlook Email   199
Setting Up Your Email Account 199
Add an Account Automatically 200
Add an Account Manually    201
Composing and Sending a New Message   202
Compose a Message   203
Use the Contacts List to Specify Recipients   204
Attach a File to a Message   205
Reading and Working with Incoming Mail   206
Retrieve and Read Messages   206
Reply to a Message   208
Forward a Message   209
Save an Attachment   210
Move a Message   211
Delete a Message   212
Chapter 12  Scheduling with the Outlook Calendar   215
Using the Calendar Folder 216
Switch to the Calendar Folder   216
Navigate to a Date   217
Switch the Calendar’s View   218
Setting Up Appointments   219
Create a New Appointment   219
Create a Recurring Appointment   221
Appointments Versus All-Day Events 222
Schedule an All-Day Event 223
Understanding Meeting Requests   224
Request a Meeting   224
Chapter 13  Keeping in Touch with Outlook People   227
Exploring the People Folder   228
Switch to the People Folder   228
Adding a New Contact   228
Create a New Contact from Scratch   229
Understanding Outlook’s Contact Data Fields   229
Create a Contact from an Email Message   230
Importing Contact Data   231
Import Contact Data from Outlook for Windows   231
Import Contact Data from Outlook 2011 for Mac   233
Working with Your Contacts   234
Edit Contact Data   235
Add a Picture for a Contact   235
Send an Email to a Contact   237
Request a Meeting with a Contact   237
View a Map of a Contact’s Address   238
Chapter 14  Building a OneNote Notebook   241
Working with Sections 242
Insert a New Section   243
Rename a Section   243
Color-Code a Section   244
Working with Pages   245
Insert a New Page   245
Enter Text on a Page   246
Work with Page Containers 246
Building a OneNote Table   247
Insert a Table   248
Working with Tags   249
Tag an Item   249
Build Lists   251
Create a To-Do List   251
Chapter 15  Getting More Out of OneNote   255
Working with Notebooks   255
Create a New Notebook   256
Switch Between Notebooks   257
Sync a Notebook 257
Adding Data to a Page 258
Insert the Date   258
Add a Link to a Website   259
Add a Link to a OneNote Location   260
Attach a File   261
Chapter 16  Customizing the Office 2016 for Mac Applications   265
Working with Application Preferences   266
Working with the Preferences Dialog   266
Changing Your User Name and Initials   267
Bypassing the Start Screen at Launch 268
Customizing the Interface   269
Collapsing the Ribbon   269
Expanding the Ribbon   270
Adding Group Titles to the Ribbon   270
Setting the Office Theme   271
Adding the Developer Tab 272
Chapter 17  Collaborating with Others   275
Collaborating in Word with Comments and Changes   275
Insert Comments in a Word Document   276
Edit a Comment   277
Delete a Comment   277
Track Changes in a Word Document   278
Control the Display of Comments and Changes   278
Control the Markup Display   280
Navigate Comments and Changes   280
Accept or Reject Comments and Changes   281
Collaborating in Excel with Comments and Changes   282
Insert Comments in Cells   282
View Workbook Comments   283
Track Worksheet Changes   284
Accept or Reject Workbook Changes   287
Share an Excel Workbook with Other Users   288
Display and Removing Reviewers   290
Handle Sharing Conflicts 291
Sharing a Document Online   291
Save a Document to OneDrive   292
Send an Invitation to Share a OneDrive Document   293
Copy a Link to Share a OneDrive Document   294
Appendix A  Excel Worksheet Function Reference   295
Financial Functions   298
Date and Time Functions   302
Math and Trig Functions   303
Statistical Functions   306
Lookup and Reference Functions   311
Database Functions   312
Text Functions   313
Logical Functions 315
Information Functions   315
Engineering Functions   316
Cube Functions   319
Compatibility Functions   319
Web Functions   321
Index   323