Table of Contents

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

About the Author

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.