My Office® 2016 by McFedries, Paul -- Read -- Imperial Library of Trantor

Index

About This eBook Title Page Copyright Page Contents at a Glance Table of Contents About the Author Dedication Acknowledgments We Want to Hear from You! Reader Services 1. Getting Started with Office 2016

Understanding Office 365 and Office 2016

Learning How Office 365 Works

Taking Your First Steps with Office 2016

Sign In to Your Microsoft Account Create a Microsoft Account Sign Out of Your Microsoft Account Switch Between Office 2016 Applications

Creating a New Document

Create a Blank Document at Startup Create a Blank Document After an Office 2016 Application Is Running Creating a Document from a Template or Theme

Preserving Your Work

Save a New Document Create a Duplicate of a Document Convert a Document to the Latest Format

Working with Documents

Open a Document Pin a Document to the Recent Tab Print a Document

2. Formatting Documents

Selecting Text

Select Text with a Mouse

Changing the Font

Understanding Typefaces Set the Typeface Change the Type Size Apply Type Effects Set Text Colors

Formatting Paragraphs

Align Paragraphs Set the Line Spacing Build a Bulleted List Create a Numbered List Set the Indentation

Working with Formatting

Apply Styles Apply Text Effects Clear Formatting

3. Working with Office 2016 Graphics

Working with Shapes

Inserting a Line Inserting Any Other Shape

Inserting Images

Inserting a Picture Understanding SmartArt Graphics Inserting a SmartArt Graphic Inserting WordArt

Formatting and Editing Graphic Objects

Selecting Graphic Objects Lassoing Graphic Objects Sizing a Graphic Object Moving a Graphic Object Rotating a Graphic Object Formatting a Graphic Object

4. Working with Text in Word

Learning Text Basics

Enter and Edit Text Enter Text with AutoCorrect Insert Symbols Insert Symbols Using AutoCorrect Set Tabs Enter Headings

Finding and Replacing Text

Find Text Replace Text

Proofing Text

Handle Spelling and Grammar Errors

Adding Hyperlinks

Insert a Hyperlink

5. Working with Page Layout and Design in Word

Building a Table

Insert a Table Select Table Elements Format a Table Insert New Rows Insert New Columns Delete Table Elements

Working with Headers and Footers

Adding a Header Adding a Footer

Changing the Page Setup

Setting the Margins Changing the Page Orientation Changing the Paper Size Add a Page Break Understanding Sections Add a Section Break Display Text in Columns

Adding Footnotes and Endnotes

Insert a Footnote or Endnote

6. Entering Excel Data

Understanding Worksheet Cells and Data

Working with Numbers Working with Text Working with Dates and Times

Entering and Editing Data

Enter Cell Data Edit Cell Data

Working with Formulas and Functions

Build a Formula Understanding Functions Add a Function Directly to a Cell Add a Function Using the Function Wizard

Building a Table

Convert Cells to a Table Select Table Elements Format a Table Add New Rows and Columns Delete Rows and Columns Sort a Table Filter a Table

7. Getting More Out of Excel Ranges

Selecting a Range

Select a Range with a Mouse Select a Range on a Touchscreen

Working with Excel Ranges

Fill a Range with a Specific Value Fill a Range with a Series of Values Make a Copy of a Range Move a Range Insert a Range Delete a Range

Working with Range Names

Name a Range

Formatting a Range

Learning About Data Formats Apply a Numeric or Date Format Control the Number of Decimal Places Resize Columns Resize Rows Add Borders Wrap Text Within a Cell

8. Visualizing Excel Data with Charts

Creating a Chart

Create an Embedded Chart Create a Chart in a Separate Sheet

Working with Charts

Understanding Excel’s Chart Types Change the Chart Type Move a Chart Resize a Chart Change the Chart Layout and Style

Working with Chart Elements

Select Chart Elements Format Chart Elements Add Titles Add a Chart Legend Add Data Marker Labels

9. Building a PowerPoint Presentation

Adding a Slide to the Presentation

Understanding Slide Layouts Insert a New Slide Duplicate a Slide

Adding Data to a Slide

Add Text Create a Bulleted List Add a Video Add a Chart Add a Table

Working with Slides

Select Slides Rearrange Slides Change the Layout of a Slide Hide a Slide Add Notes to a Slide

Understanding the Slide Master

Work with the Slide Master

10. Working with PowerPoint Slide Shows

Defining Slide Animations

Animation Guidelines Set Up a Slide Transition Animate Slide Objects Add an Animation

Preparing a Slide Show

Rehearse Slide Timings Recording Narration Record Narration for a Slide Record Narration for an Entire Presentation

Setting Up Multiple Versions of a Slide Show

Create a Custom Slide Show

Running a Slide Show

Start the Slide Show Navigate Slides Set Up an Automatic Slide Show

11. Sending and Receiving Outlook Email

Setting Up Your Email Account

Add an Account Automatically Add an Account Manually

Composing and Sending a New Message

Compose a Message Use the Contacts List to Specify Recipients Attach a File to a Message

Reading and Working with Incoming Mail

Retrieve and Read Messages Reply to a Message Forward a Message Save an Attachment Move a Message Delete a Message

12. Scheduling with the Outlook Calendar

Using the Calendar Folder

Switch to the Calendar Folder Navigate to a Date Switch the Calendar’s View

Setting Up Appointments

Create a New Appointment Taking Advantage of AutoDate Create a Recurring Appointment Appointments Versus All-Day Events Schedule an All-Day Event Understanding Meeting Requests Request a Meeting

13. Keeping in Touch with Outlook Contacts

Exploring the Contacts Folder

Switch to the Contacts Folder Understanding the Contacts Folder Views

Adding a New Contact

Create a New Contact from Scratch Understanding Outlook’s Contact Data Fields Create a Contact from the Same Company Create a Contact from an Email Message

Importing Contact Data

Import Contact Data

Working with Your Contacts

Edit Contact Data Add a Picture for a Contact Send an Email to a Contact Request a Meeting with a Contact View a Map of a Contact’s Address Print a Contact Address on an Envelope or Label

14. Building a OneNote Notebook

Working with Sections

Insert a New Section Rename a Section Color-Code a Section

Working with Pages

Insert a New Page Insert a New Page from a Template Enter Text on a Page Work with Page Containers

Building a OneNote Table

Insert a Table

Working with Tags

Tag an Item Build Lists Create a To-Do List

15. Getting More Out of OneNote

Working with Notebooks

Create a New Notebook Switch Between Notebooks Set Notebook Properties

Adding Data to a Page

Insert the Date and Time Add a Link to a Website Add a Link to a OneNote Location Insert a Spreadsheet File Insert a New Spreadsheet Attach a File

Adding Ink

Handwrite Text Highlight Text Convert Ink to Text Erase Ink

16. Learning Access Basics

Understanding Access Databases Creating a Database

Create a Database

Building and Working with Tables

Designing a Table Learning About Access Data Types Create a Table Enter Data Sort Table Data Filter Table Data

Querying Access Data

Design a Simple Query Understanding Query Criteria Enter Query Criteria

Creating Forms

Create a Basic Form Navigating Form Fields and Records Run the Form Wizard

Creating Reports

Create a Basic Report Run the Report Wizard

17. Customizing the Office 2016 Applications

Working with Application Options

Working with the Options Dialog Box Changing Your User Name and Initials Bypassing the Start Screen at Launch

Customizing the Interface

Pinning the Ribbon Hiding the Ribbon Customizing the Ribbon Changing the Position of the Quick Access Toolbar Customizing the Quick Access Toolbar Setting the Office Background

18. Collaborating with Others

Collaborating in Word with Comments and Changes

Insert Comments in a Word Document Edit a Comment Delete a Comment Track Changes in a Word Document Control the Display of Comments and Changes Control the Markup Display Navigate Comments and Changes Accept or Reject Comments and Changes

Collaborating in Excel with Comments and Changes

Insert Comments in Cells View Workbook Comments Track Worksheet Changes Accept or Reject Workbook Changes Share an Excel Workbook with Other Users Display and Removing Reviewers Handle Sharing Conflicts

Sharing a Document Online

Save a Document to OneDrive Send an Invitation to Share a OneDrive Document Copy a Link to Share a OneDrive Document

A. Excel Worksheet Function Reference

Financial Functions Date and Time Functions Math and Trigonometry Functions Statistical Functions Lookup and Reference Functions Database Functions Text Functions Logical Functions Information Functions Engineering Functions Cube Functions Compatibility Functions Web Functions

Index Inside Front Cover Inside Back Cover Code Snippets

← Prev
Back
Next →

← Prev
Back
Next →