Home > Store

My Office 2016

Register your product to gain access to bonus material or receive a coupon.

My Office 2016


  • Sorry, this book is no longer in print.
Not for Sale



• 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


  • Copyright 2016
  • Dimensions: 6" x 9"
  • Pages: 432
  • Edition: 1st
  • Book
  • ISBN-10: 0-7897-5498-3
  • ISBN-13: 978-0-7897-5498-1

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 & 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

More Information

InformIT Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.


Pearson Education, Inc., 221 River Street, Hoboken, New Jersey 07030, (Pearson) presents this site to provide information about products and services that can be purchased through this site.

This privacy notice provides an overview of our commitment to privacy and describes how we collect, protect, use and share personal information collected through this site. Please note that other Pearson websites and online products and services have their own separate privacy policies.

Collection and Use of Information

To conduct business and deliver products and services, Pearson collects and uses personal information in several ways in connection with this site, including:

Questions and Inquiries

For inquiries and questions, we collect the inquiry or question, together with name, contact details (email address, phone number and mailing address) and any other additional information voluntarily submitted to us through a Contact Us form or an email. We use this information to address the inquiry and respond to the question.

Online Store

For orders and purchases placed through our online store on this site, we collect order details, name, institution name and address (if applicable), email address, phone number, shipping and billing addresses, credit/debit card information, shipping options and any instructions. We use this information to complete transactions, fulfill orders, communicate with individuals placing orders or visiting the online store, and for related purposes.


Pearson may offer opportunities to provide feedback or participate in surveys, including surveys evaluating Pearson products, services or sites. Participation is voluntary. Pearson collects information requested in the survey questions and uses the information to evaluate, support, maintain and improve products, services or sites, develop new products and services, conduct educational research and for other purposes specified in the survey.

Contests and Drawings

Occasionally, we may sponsor a contest or drawing. Participation is optional. Pearson collects name, contact information and other information specified on the entry form for the contest or drawing to conduct the contest or drawing. Pearson may collect additional personal information from the winners of a contest or drawing in order to award the prize and for tax reporting purposes, as required by law.


If you have elected to receive email newsletters or promotional mailings and special offers but want to unsubscribe, simply email information@informit.com.

Service Announcements

On rare occasions it is necessary to send out a strictly service related announcement. For instance, if our service is temporarily suspended for maintenance we might send users an email. Generally, users may not opt-out of these communications, though they can deactivate their account information. However, these communications are not promotional in nature.

Customer Service

We communicate with users on a regular basis to provide requested services and in regard to issues relating to their account we reply via email or phone in accordance with the users' wishes when a user submits their information through our Contact Us form.

Other Collection and Use of Information

Application and System Logs

Pearson automatically collects log data to help ensure the delivery, availability and security of this site. Log data may include technical information about how a user or visitor connected to this site, such as browser type, type of computer/device, operating system, internet service provider and IP address. We use this information for support purposes and to monitor the health of the site, identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents and appropriately scale computing resources.

Web Analytics

Pearson may use third party web trend analytical services, including Google Analytics, to collect visitor information, such as IP addresses, browser types, referring pages, pages visited and time spent on a particular site. While these analytical services collect and report information on an anonymous basis, they may use cookies to gather web trend information. The information gathered may enable Pearson (but not the third party web trend services) to link information with application and system log data. Pearson uses this information for system administration and to identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents, appropriately scale computing resources and otherwise support and deliver this site and its services.

Cookies and Related Technologies

This site uses cookies and similar technologies to personalize content, measure traffic patterns, control security, track use and access of information on this site, and provide interest-based messages and advertising. Users can manage and block the use of cookies through their browser. Disabling or blocking certain cookies may limit the functionality of this site.

Do Not Track

This site currently does not respond to Do Not Track signals.


Pearson uses appropriate physical, administrative and technical security measures to protect personal information from unauthorized access, use and disclosure.


This site is not directed to children under the age of 13.


Pearson may send or direct marketing communications to users, provided that

  • Pearson will not use personal information collected or processed as a K-12 school service provider for the purpose of directed or targeted advertising.
  • Such marketing is consistent with applicable law and Pearson's legal obligations.
  • Pearson will not knowingly direct or send marketing communications to an individual who has expressed a preference not to receive marketing.
  • Where required by applicable law, express or implied consent to marketing exists and has not been withdrawn.

Pearson may provide personal information to a third party service provider on a restricted basis to provide marketing solely on behalf of Pearson or an affiliate or customer for whom Pearson is a service provider. Marketing preferences may be changed at any time.

Correcting/Updating Personal Information

If a user's personally identifiable information changes (such as your postal address or email address), we provide a way to correct or update that user's personal data provided to us. This can be done on the Account page. If a user no longer desires our service and desires to delete his or her account, please contact us at customer-service@informit.com and we will process the deletion of a user's account.


Users can always make an informed choice as to whether they should proceed with certain services offered by InformIT. If you choose to remove yourself from our mailing list(s) simply visit the following page and uncheck any communication you no longer want to receive: www.informit.com/u.aspx.

Sale of Personal Information

Pearson does not rent or sell personal information in exchange for any payment of money.

While Pearson does not sell personal information, as defined in Nevada law, Nevada residents may email a request for no sale of their personal information to NevadaDesignatedRequest@pearson.com.

Supplemental Privacy Statement for California Residents

California residents should read our Supplemental privacy statement for California residents in conjunction with this Privacy Notice. The Supplemental privacy statement for California residents explains Pearson's commitment to comply with California law and applies to personal information of California residents collected in connection with this site and the Services.

Sharing and Disclosure

Pearson may disclose personal information, as follows:

  • As required by law.
  • With the consent of the individual (or their parent, if the individual is a minor)
  • In response to a subpoena, court order or legal process, to the extent permitted or required by law
  • To protect the security and safety of individuals, data, assets and systems, consistent with applicable law
  • In connection the sale, joint venture or other transfer of some or all of its company or assets, subject to the provisions of this Privacy Notice
  • To investigate or address actual or suspected fraud or other illegal activities
  • To exercise its legal rights, including enforcement of the Terms of Use for this site or another contract
  • To affiliated Pearson companies and other companies and organizations who perform work for Pearson and are obligated to protect the privacy of personal information consistent with this Privacy Notice
  • To a school, organization, company or government agency, where Pearson collects or processes the personal information in a school setting or on behalf of such organization, company or government agency.


This web site contains links to other sites. Please be aware that we are not responsible for the privacy practices of such other sites. We encourage our users to be aware when they leave our site and to read the privacy statements of each and every web site that collects Personal Information. This privacy statement applies solely to information collected by this web site.

Requests and Contact

Please contact us about this Privacy Notice or if you have any requests or questions relating to the privacy of your personal information.

Changes to this Privacy Notice

We may revise this Privacy Notice through an updated posting. We will identify the effective date of the revision in the posting. Often, updates are made to provide greater clarity or to comply with changes in regulatory requirements. If the updates involve material changes to the collection, protection, use or disclosure of Personal Information, Pearson will provide notice of the change through a conspicuous notice on this site or other appropriate way. Continued use of the site after the effective date of a posted revision evidences acceptance. Please contact us if you have questions or concerns about the Privacy Notice or any objection to any revisions.

Last Update: November 17, 2020