Home Page Icon
Home Page
Table of Contents for
Code Snippets
Close
Code Snippets
by Paul McFedries
My Office® 2016
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
Code Snippets
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
My Office® 2016
Next
Next Chapter
Images
Code Snippets
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset