My Office 2016

About

Features

• Students quickly master the Microsoft Office suite using easy-to-follow tasks
• Master core skills in every Office application
• Learn how to use OneDrive to collaborate with others, including people using other versions of Office
• Written by Paul McFedries, a highly visible and widely known technology author
• Updates will be delivered via a FREE Web Edition of this book, which can be accessed with any Internet connection

Description

Book + Content Update Program

My Office 2016 introduces readers to this new version of the suite and shows them how to get the most out of the apps. The book clearly explains what to expect from the new version of Office, what the program limitations are, and discusses best practices for using the apps. My Office 2016 teaches readers how to use Word, Excel, PowerPoint, Outlook, Access, and OneDrive in an easy-to-follow, task-based format. Topics covered include how to use the main features that come with each Office application, how to synchronize documents between devices, and how to collaborate with others.

• Master core skills you can use in every Office 2016 program
• Quickly create visual documents with advanced formatting and graphics
• Build complex documents with columns, footnotes, headers, and tables
• Enter and organize Excel data more accurately and efficiently
• Quickly move, copy, delete, and format large amounts of data with Excel ranges
• Use charts to make data more visual, intuitively understandable, and actionable
• Add pizzazz to PowerPoint slide shows with animations and transitions
• Use Outlook 2016 to efficiently manage your email, contacts, and calendar
• Bring all your ideas and notes together in a OneNote notebook
• Start building useful Access 2016 databases
• Customize your Office applications to work the way you do
• Store and share your Office files in the cloud with Microsoft OneDrive
• Collaborate with others, including people using other versions of Office

In addition, this book is part of Que’s exciting new Content Update Program. As Microsoft updates features of Office 2016, sections of this book will be updated or new sections will be added to match the updates to the software. The updates will be delivered to you via a FREE Web Edition of this book, which can be accessed with any Internet connection. To learn more, visit www.quepublishing.com/CUP.

How to access the free web edition:  Follow the instructions within the book to learn how to register your book to access the FREE Web Edition.

Sample Content

Online Sample Chapter

Customizing the Office 2016 Applications

Sample Pages

Download the sample pages (includes Chapter 17 and Index)

Table of Contents

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

Updates

Updates & Corrections

This book is part of Que's Content Update Program. As Microsoft updates features of Office 2016, sections of this book will be updated or new sections will be added to match the updates to the software. The updates will be delivered to you via a free Web Edition of this book, which can be accessed with any Internet connection from your account on quepublishing.com. For more information, visit quepublishing.com/CUP.

Submit Errata