Log In
Or create an account ->
Imperial Library
Home
About
News
Upload
Forum
Help
Login/SignUp
Index
Office 2013: The Missing Manual
Nancy Conner
Matthew MacDonald
Special Upgrade Offer
The Missing Credits
About the Authors
About the Creative Team
Acknowledgements
The Missing Manual Series
Introduction
What Is Office 2013?
Note
Flavors of Office 2013
Office 2013
Note
Office 365
Note
What’s New in Office 2013
Note
About This Book
Note
The Very Basics
Note
About→These→Arrows
About the Online Resources
Missing CD
Registration
Feedback
Errata
Safari® Books Online
Part 1. Using Office
Chapter 1. Using Office 2013’s Common Features
Opening an Office 2013 Program
Tip
The Start Screen
Note
Tip
Working with the Ribbon
Using Ribbon-Based Keyboard Shortcuts
Going Backstage
Note
Note
Saving a File
Finding and Opening a Saved File
Closing a File or Program
Note
Customizing Office Applications
Changing the Look of Office
Customizing the Quick Access Toolbar
Tip
Tip
Tip
Tip
Tip
Customizing the Ribbon
Customizing the Status Bar
Note
Part 2. Word
Chapter 2. Basic Word Processing
First Things First: Word’s Start Page
Tip
Note
The Word 2013 Window
Tip
Note
Tip
Tip
Note
Creating a New Document
Creating a New Blank Document
Creating a New Document from a Template
Tip
Creating a New Document from an Existing Document
Tip
Typing Some Text
Tip
Saving a Document
Saving a Document Using Your Mouse
Saving a Document Using Keyboard Shortcuts
Using the Save As Page
Note
Tip
Note
Closing a Document
Note
Opening an Existing Document
Tip
Note
Different Ways to View Your Work
Tip
Tip
Viewing a Document in the Navigation Pane
Tip
Zooming In and Out
The Zoom Slider
Tip
The Zoom Dialog Box
Working with Multiple Windows
Tip
Tip
Note
Chapter 3. Editing and Formatting
Selecting and Moving Text
Tip
Tip
Tip
Four Ways to Move Text
Option 1: The Ctrl Key
Option 2: Right-Click
Option 3: Use the Home Tab
Tip
Option 4: Use the Clipboard Pane
Finding and Replacing Text
Searching with the Navigation Pane
Tip
Setting Search Options
Note
Searching with the Find and Replace Dialog Box
Tip
Tip
Tip
Replacing Text
Tip
Tip
Tip
Text Formatting: Font, Size, and Style
The Home Tab’s Control Center
Tip
Copy Formatting with Format Painter
Tip
Quick Formatting with the Mini Toolbar
Tip
Styles: Formatting Power
Tip
Applying Styles Using Style Sets
Tip
Creating Your Own Style Set
Paragraph Formatting: Aligning, Indenting, Spacing
Aligning Text
Indenting Paragraphs
Indenting the First Line
Indenting an Entire Paragraph
Tip
Creating a Hanging Indent
Spacing Within a Paragraph
Spacing Between Paragraphs
Tip
Working with Lists
Creating a List
Note
Tip
Formatting Lists
Formatting a Bulleted List
Note
Tip
Formatting a Numbered List
Formatting a Multilevel List
Tip
Tip
Formatting a Document
Adjusting Page Setup
Tip
Tip
Tip
Changing Page Background Settings
Adding a Watermark
Customizing a Watermark with Text
Customizing a Watermark with an Image
Tip
Editing or Deleting a Watermark
Adding Color to Page Backgrounds
Tip
Adding Patterns to Page Backgrounds
Tip
Giving Pages a Border
Tip
Inserting Headers, Footers, and Page Numbers
Inserting a Header or Footer
Note
Tip
Editing a Header or Footer
Tip
Inserting the Date and Time into a Header or Footer
Tip
Inserting an Image into a Header or Footer
Tip
Removing a Header or Footer
Inserting Page Numbers
Formatting Page Numbers
Removing Page Numbers
Chapter 4. Tables, Graphics, and Charts
Creating a Table
Creating a Table from Scratch
Inserting a Table
Note
Inserting a Preformatted Table
Drawing a Table
Tip
Tip
Creating a Table from Text
Tip
Adding Information to a Table
Editing a Table
Selecting Part or All of a Table
Using Your Mouse
Tip
Using the Ribbon
Inserting Rows and Columns
Tip
Tip
Moving Rows and Columns
Tip
Tip
Merging and Splitting Cells
Tip
Tip
Deleting All or Part of a Table
Tip
Formatting a Table
Save Time with Ready-to-Use Table Styles
Applying Shading and Borders
Shading a Table
Working with Borders
Tip
Drawing Borders
Inserting Images
Inserting a Picture from Your Computer
Tip
Note
Inserting a Picture from the Web
Note
Tip
Inserting a Screenshot
Note
Editing an Image
Changing an Image’s Size
Cropping an Image
Tip
Removing a Picture’s Background
Note
Tip
Moving and Rotating Images
Moving an Image
Tip
Rotating an Image
Adjusting an Image’s Appearance
Using Picture Styles
Tip
Formatting Pictures
Tip
Wrapping Text Around an Image
Tip
Tip
Searching for Images
Tip
Fun with Fonts and Art That’s Smart
Creating WordArt
Tip
Editing WordArt Text
Note
Note
Tip
Formatting WordArt Using the Format Shape Pane
Shape Options
Text Options
Tip
Inserting SmartArt into Word Documents
Adding Charts and Diagrams
Tip
Tip
Chapter 5. Proofing and Research Tools
Checking Spelling and Grammar
Catching Spelling Mistakes
Tip
Flagging Frequently Confused Words
Note
Checking Spelling in an Entire Document
Note
Note
Word’s Grammar Checker
Tip
Tip
Getting Things Right with AutoCorrect
Note
Undoing an AutoCorrect Change
Setting AutoCorrect Options
Tip
Making an Exception
Tip
Adding Custom Corrections
Tip
Deleting an AutoCorrect Correction
Tip
AutoFormatting in Word
Tip
Word’s Built-in Research Tools
Installing a Dictionary
Looking Up a Word in the Dictionary
Tip
Using the Thesaurus
Tip
Translating Text
Getting a Quick Translation with the Mini Translator
Tip
Using the Research Pane for Translations
Translating an Entire Document
Chapter 6. Printing Documents
Getting Started with Printing
Previewing a Document Before You Print It
Tip
Tip
Printing a Document
Selecting Print Options and Settings
Choosing a Printer
Specifying Settings
Tip
Sending a Fax
Creating a Cover Page
Sending a Fax
Note
Printing Envelopes
Tip
Tip
Tip
Formatting Envelope Addresses
Selecting a Feed Method
Adding Electronic Postage
Printing Labels
Note
Note
Tip
Merging Names and Addresses with Documents
Tip
Step 1: Select Document Type
Tip
Step 2: Select Starting Document
Step 3: Select Recipients
Note
Step 4: Write Your Letter
Step 5: Preview Your Letters
Step 6: Complete the Merge
Do-It-Yourself Mail Merge with the Mailings Tab’s Buttons
Chapter 7. Reports and Long Documents
Inserting Page Breaks
Tip
Breaking a Document into Sections
Kinds of Section Breaks
Inserting a Section Break
Note
Changing the Orientation of a New Section
Changing the Page Numbering of a New Section
Note
Footnotes and Endnotes
Inserting a Footnote
Note
Inserting an Endnote
Tip
Editing a Note
Navigating Notes
Tip
Changing the Position of Footnotes or Endnotes
Converting Footnotes to Endnotes (or Vice Versa)
Changing Footnote or Endnote Markers
Deleting a Note
Citations and Bibliographies
Creating and Inserting a Citation
Tip
Tip
Inserting an Existing Citation
Tip
Tip
Inserting a Placeholder
Note
Editing a Citation or Its Source
Note
Tip
Deleting a Citation
Deleting a Source
Note
Building a Bibliography
Updating a Bibliography
Helping Readers Navigate Your Document
Inserting Bookmarks and Cross-References
Note
Creating a Bookmark
Jumping to a Bookmark
Tip
Deleting a Bookmark
Creating Cross-References
Creating a Table of Contents
Tip
Creating an Index
Marking Index Entries
Note
Tip
Tip
Generating an Index
Tip
Updating an Index
Editing Index Entries
Tip
Deleting an Index Entry
Deleting an index
Chapter 8. Customizing Documents with Themes, Templates, and Macros
Themes: The Way to Better Designs
Note
Choosing a Theme
Tip
Customizing a Theme
Tip
Saving a Theme
Finding a Saved Theme
Setting a Default Theme
Templates: Reusable Document Blueprints
Choosing a Template
Note
Creating Your Own Template
Creating a Template from Scratch
Tip
Creating a Template from a Document
Creating a Template from an Existing Template
Customizing a Template
Changing an Existing Style within a Template
Tip
Tip
Tip
Creating a New Style for a Template
Tip
Copying a Style from One Template to Another
Deleting a Style from a Template
Saving Time with Macros
Recording a Macro
Note
Tip
Tip
Running a Macro
Copying a Macro Between Templates
Deleting a Macro
Note
Chapter 9. Desktop and Web Publishing
Note
Newsletters and Brochures
Note
Laying Out Text in Columns
Tip
Formatting Columns
Tip
Inserting a Text Box
Images and Text Wrapping
Inserting an Image into a Document with Columns
Inserting an Image into a Document with Text Boxes
Web Page Design
Saving a Word Document as a Web Page
Creating a Web Page from Scratch
Creating Your Site’s Home Page
Step 1: Set up a table
Tip
Step 2: Create a header
Step 3: Add a navigation bar
Tip
Step 4: Add a footer
Step 5: Save the page as a template
Step 6: Adding text and images
Tip
Creating More Pages for Your Site
Note
Tip
Chapter 10. Sharing and Collaborating on Documents
Sharing a Document
Tip
Emailing a Document
Tip
Emailing a Document as an Attachment
Note
Emailing a Link to a Document
Note
Present a Document over the Internet
Tip
Note
Tip
Saving a Document to SkyDrive
Note
Tip
Note
Getting Feedback
Inserting a Comment
Tip
Tip
Viewing Comments
Note
Note
Tip
Editing a Comment
Deleting a Comment
Keeping Track of Revisions
Tip
Selecting Which Changes to View
Tip
Accepting or Rejecting Changes
Tip
Setting Track Changes Options
Comparing Documents
Tip
Tip
Combining Documents
Protecting Your Documents
Removing Hidden Data and Personal Information
Warning
Note
Restricting Formatting and Editing
Tip
Tip
Restricting Permissions
Note
Warning
Note
Coauthoring and Simultaneous Editing
Note
Tip
Part 3. Outlook
Chapter 11. Getting Started with Outlook
Setting Up Outlook
Note
Taking a Quick Look Around
Note
Mail
Note
Calendar
People
Tip
Tasks
Notes
Folders
Shortcuts
Tip
Customizing the Navigation Bar
Tip
Note
Composing and Sending Email
Tip
Note
Tip
Sending an Email to More than One Recipient
Proofreading a Message
Note
Tip
Attaching a File to an Email Message
Tip
Note
Inserting a Picture into an Email Message
Tip
Tip
Adding a Signature
Creating a Signature
Editing a Signature
Choosing a Signature to Add
Note
Deleting a Signature
Adding a Theme or Stationery
Tip
Note
Tip
Setting a Message’s Priority and Confidentiality
Making Sure They Got the Message
Setting a Delivery Time
Tip
Directing Replies to Another Address
Adding Voting Buttons
Note
Working Offline
Note
Receiving Email
Replying to or Forwarding an Email
Tip
Note
Tip
Opening an Attachment
Note
Getting Notified
Deleting a Message
Marking a Message as Unread
Flagging a Message
Flagging a Message You’ve Received
Tip
Flagging an Outgoing Message
Finding Flagged Messages
Tip
Organizing Messages
Grouping Messages into Conversations
Organizing Messages into Folders
Tip
Routing Incoming Messages
Note
Translating a Message
Printing a Message
Fighting Spam
Note
What If It’s Not Spam?
Setting Up a Safe Senders List
Tip
Managing Junk Email
Saving Time with Quick Steps
Applying a Quick Step
Tip
Note
Customizing a Quick Step
Tip
Creating Your Own Quick Step
Tip
Deleting a Quick Step
Managing Multiple Email Accounts
Adding Another Email Account
Keeping Accounts Straight
Choosing Which Account to Send From
Note
Chapter 12. Outlook’s Address Book
Adding and Editing Contacts
Adding Contacts
Creating a New Contact from Scratch
Tip
Creating a New Contact from an Email Message
Importing Email Addresses from Another Program
Tip
Exporting Contacts from Outlook
Exporting Contacts from a Different Email Program
Importing Contacts from an Outlook Data File
Importing Contacts from a CSV File
Tip
Viewing a Contact
Editing a Contact’s Information
Note
Editing All Fields
Creating a New Field
Adding Details
Note
Editing Business Cards
Deleting a Contact
Finding a Contact
Tip
Note
Viewing Contacts
Sorting and Grouping Contacts
Sorting Contacts
Grouping Contacts
Tip
Customizing a View
Tip
Note
Note
Saving a View
Note
Tip
Deleting a View
The People Pane
Communicating with a Contact
Note
Gathering Contacts into a Group
Creating a Contact Group
Note
Sending Email to a Contact Group
Managing a Contact Group
Note
Tip
Printing Your Contacts
Tip
Contacts and Social Networking
Adding a Social Network to Outlook
Chapter 13. Getting Organized with Folders
Finding Folders in the Navigation Pane
Tip
Tip
Creating a New Folder
Note
Filling Up and Managing Folders
Tip
Tip
Copying a Folder
Moving a Folder
Renaming a Folder
Deleting a Folder
Tip
Categorizing Items
Assigning a Category
Note
Note
Creating a New Category
Tip
Viewing Items by Category
Clearing Categories
Renaming a Category
Searching Folders
Searching the Current Folder
Repeating a Search
Tip
Setting the Scope of Your Search
Tip
Tip
Speeding Up Your Search with Keyboard Shortcuts
Tip
Refining Your Search
Doing an Advanced Search
Creating a Search Folder for Email
Tip
Changing Search Settings
Cleaning Out Folders
Tip
Archiving Old Data
Note
Setting Up AutoArchive
Adjusting AutoArchive Settings for a Specific Folder
Archiving Manually
Tip
Cleaning up Your Mailbox
Chapter 14. Getting Organized with Outlook’s Calendar, Tasks, and Notes
Your Schedule, Your Calendar
Creating an Appointment or Meeting
Scheduling an Appointment
Tip
Note
Setting Up a Meeting
Tip
Tip
Accepting an Invitation to a Meeting
Tip
Adding or Removing Attendees
Tip
Keeping Track of Who’s Attending
Tip
Canceling a Meeting
Editing Events
Turning an Appointment into a Meeting
Making an Event Recur
Tip
Getting Reminders
Note
Tip
Deleting an Appointment
Viewing Your Schedule
Tip
Tip
Tasks
Adding a Task
Creating a Task
Tip
Note
Creating a Recurring Task
Assigning a Task
Note
Accepting a Task
Managing Tasks
Editing a Task
Note
Flagging Tasks
Tip
Marking a Task as Completed
Viewing Tasks
Taking Notes in Outlook
Tip
Adding a Note
Working with Notes
Tip
Note
Viewing Notes
Icon View
Tip
Notes List View
Tip
Last 7 Days View
Part 4. Excel
Chapter 15. Creating Your First Spreadsheet
Starting a Workbook
Note
Adding Information to a Worksheet
Note
Adding Column Titles
Note
Note
Adding Data
Editing Data
Tip
Editing Cells with the Formula Bar
Using the Ribbon
Note
Collapsing the Ribbon
Using the Ribbon with the Keyboard
Tip
Using the Status Bar
Tip
Saving Files
Tip
Note
Tip
The Excel File Format
Tip
Sharing Your Spreadsheet with Older Versions of Excel
Note
Saving Your Spreadsheet for Excel 2003
Note
Tip
Note
Saving Your Spreadsheet As a PDF
Tip
Disaster Recovery
AutoRecover Settings
Opening Files
Note
Tip
Tip
Opening Files in Other Formats
Protected View
Tip
Working with Multiple Open Spreadsheets
Note
Adding Different Types of Data
Note
Note
How Excel Identifies Text
Tip
How Excel Identifies Numbers
How Excel Identifies Dates and Times
Tip
Note
Regional Dating
Tip
Printing
Note
How to Print an Excel File
Note
Tip
Note
Note
Page Layout View: A Better Print Preview
Note
Creating Headers and Footers
Note
Controlling Pagination
Page Breaks
Note
Scaling
Tip
Page Break Preview: A Bird’s-Eye View of Your Worksheet
Note
Chapter 16. Moving Data
Selecting Cells
Making Continuous Range Selections
Tip
Making Noncontiguous Selections
Automatically Selecting Your Data
Making Selections with the Keyboard
Tip
Tip
Moving Cells Around
A Simple Cut-and-Paste or Copy-and-Paste
Tip
A Quicker Cut-and-Paste or Copy-and-Paste
Tip
Fancy Pasting Tricks
Note
Paste Special
Copying Multiple Items with the Clipboard
Note
Adding and Moving Columns or Rows
Inserting Columns
Inserting Rows
Note
Inserting Copied or Cut Cells
Deleting Columns and Rows
Worksheets and Workbooks
Note
Adding and Removing Worksheets
Tip
Warning
Note
Moving Between Worksheets
Hiding Worksheets
Naming and Rearranging Worksheets
Note
Tip
Moving Worksheets from One Workbook to Another
Tip
Note
Chapter 17. Formatting Cells
Note
Formatting Cell Values
Changing the Cell Value Format
Note
Note
Tip
Formatting Numbers
General
Number
Currency
Accounting
Percentage
Fraction
Note
Tip
Scientific
Text
Formatting Dates and Times
Note
Special Formats for Special Numbers
Formatting Cell Appearance
Tip
Alignment and Orientation
Tip
Tip
Fonts and Color
Tip
Note
Special Characters
Tip
Note
Borders and Fills
Tip
Tip
Chapter 18. Building Basic Formulas
Creating a Basic Formula
Note
Excel’s Order of Operations
Note
Tip
Cell References
Note
How Excel Formats Cells That Contain Cell References
Functions
Tip
Using a Function in a Formula
Note
Using Cell References with a Function
Using Cell Ranges with a Function
Tip
Excel Compatibility Functions
Note
Formula Errors
Note
Tip
Logical Operators
Note
Formula Shortcuts
Point-and-Click Formula Creation
Tip
Point-and-Click Formula Editing
The Formulas Tab
Using the Insert Function Button
Note
Copying Formulas
Tip
Absolute Cell References
Partially Fixed References
Tip
Referring to Other Worksheets
Note
Chapter 19. Math and Statistical Functions
Rounding Numbers
ROUND(), ROUNDDOWN(), ROUNDUP(): Rounding Numbers
Note
Manipulating Text
CONCATENATE(): Joining Strings of Text Together
LEFT(), MID(), and RIGHT(): Copying Portions of a Text String
Note
TRIM() and CLEAN(): Removing Unwanted Spaces and Non-Printing Characters
SUBSTITUTE(): Replacing One Sequence of Characters with Another
Note
Solving Formula Errors
Step-by-Step Evaluation
Tip
Tracing Precedents and Dependents
Note
Tip
Error-Checking
Chapter 20. Creating Basic Charts
Note
Charting 101
Tip
Embedded and Standalone Charts
Note
Adding a Recommended Chart
Note
Picking from the Full Range of Charts
Note
Selecting a Chart
Note
Basic Tasks with Charts
Moving and Resizing a Chart
Tip
Tip
Creating a Standalone Chart
Note
Editing and Adding to Chart Data
Note
Filtering Chart Data
Note
Tip
Changing the Chart Type
Printing Charts
Embedded Charts
Standalone Charts
Practical Charting
Charts with Multiple Series of Numbers
Tip
Controlling the Data Excel Plots on the X-Axis
Data That Uses a Date or Time Scale
Noncontiguous Chart Ranges
Changing the Order of Your Data Series
Changing the Way Excel Plots Blank Values
Chart Types
Note
Column
Note
Bar
Tip
Line
Tip
Note
Pie
Note
Area
Chart Styles and Layouts
Tip
Chart Styles
Note
Note
Note
Chart Colors
Chart Layouts
Note
Adding Chart Elements
Adding Titles
Adding a Legend
Adding Data Labels to a Series
Tip
Note
Adding Individual Data Labels
Adding a Data Table
Part 5. PowerPoint
Chapter 21. Creating a Presentation
Creating a New Presentation
Tip
Creating a New Presentation from a Template
Tip
Choosing a Theme
Note
Varying a Theme
Tip
Adding Text to a Slide
Creating a New Slide
Note
Tip
Adding Content
Tip
Note
Deleting Content
Tip
Saving a Presentation
Tip
Note
Opening an Existing Presentation
Open a Recent Presentation from the Windows 8 Start Screen
Open a Recent Presentation from the Windows 7 Start Menu
Tip
Open a Recent Presentation in PowerPoint
Tip
Open Any Saved Presentation in PowerPoint
Adding Notes
Tip
Viewing a Presentation
Normal View
Outline View
Slide Sorter View
Notes Page View
Reading View
Slide Show View
Tip
Zooming In and Out
Printing a Presentation
Note
Note
Chapter 22. Editing Slides
Editing Text
Formatting Text
Tip
Adjusting Character Spacing
Positioning Text
Formatting a Text Box
Creating Lists
Linking Text to a Web page
Tip
Checking Your Spelling
Tip
Turning Text into WordArt
Tip
Embedding Other Files in Slides
Embedding an Existing File in a Slide
Tip
Updating Links
Creating a New Embedded File
Note
Adding Tables to Slides
Inserting a Table
Note
Inserting a Table When You Add a New Slide
Tip
Inserting a Table on an Existing Slide
Insert a Table Using an Excel-Style Spreadsheet
Tip
Drawing a Table
Tip
Adding Information to a Table
Editing a Table
Selecting All or Part of a Table
Resizing a Table
Tip
Moving a Table
Changing a Table’s Style
Adding Images to Slides
Creating a Photo Album
Note
Setting Up a Photo Album
Note
Tip
Tip
Editing a Photo Album
Working with Shapes
Inserting a Shape
Changing a Shape’s Size or Position
Tip
Adding Text to a Shape
Tip
Formatting a Shape
Note
Working with SmartArt
Inserting SmartArt
Tip
Tip
Converting Text to SmartArt
Adding a Shape
Reordering Shapes
Applying a Different Layout
Adjusting a SmartArt Graphic’s Style
Tip
Tip
Formatting Shapes within a SmartArt Graphic
Tip
Rotating a SmartArt Graphic
Note
Resizing a SmartArt Graphic
Working with Charts and Diagrams
Creating a Chart or Diagram Using Excel
Creating a Diagram Using Shapes
Arranging Objects on a Slide
Aligning Objects Using the Arrange Button
Tip
Aligning Objects Manually
Note
Tip
Ordering Objects
Tip
Grouping Objects
Chapter 23. Editing a Presentation
Copying, Rearranging, and Deleting Slides
Copying a Slide
Note
Duplicating a Slide
Note
Inserting a Slide from a Different Presentation
Tip
Rearranging Slides in a Presentation
Tip
Tip
Deleting a Slide
Hiding Slides
Tip
Headers and Footers
Time-Stamping Slides
Adding a Footer to Slides
Tip
Numbering Slides
Tip
Adding a Header and Footer to Notes and Handouts
Organizing Your Presentation with Sections
Creating a Section
Tip
Note
Naming a Section
Tip
Collapsing and Expanding Sections
Moving a Section Within a Presentation
Hiding All Slides Within a Section
Removing a Section from a Presentation
Note
Navigating with Links and Action Buttons
Inserting a Hyperlink to Another Slide
Tip
Creating a Table of Contents for Your Presentation
Tip
Linking to a Hidden Slide
Inserting an Action Button
Tip
Opening an Inserted File
Slide Masters: Powerful Slide Blueprints
Note
Changing the Look of All Slides in Your Presentation
Tip
Changing the Layout for a Particular Type of Slide
Tip
Creating a New Layout
Tip
Working with Masters for Handouts and Notes
Modifying the Handout Master
Modifying the Notes Master
Collaborating with Others
Tip
Adding and Reading Comments
Note
Inserting a Comment
Tip
Reading Comments
Editing a Comment
Hiding Comments
Deleting Comments
Tip
Comparing Versions of a Presentation
Tip
Note
Tip
Chapter 24. Adding Multimedia and Movement
Putting Media Clips in a Presentation
Adding Video That’s Stored on Your Computer
Tip
Adding a Video from SkyDrive
Adding Video from a Website
Tip
Note
Note
Finding and Adding Video via Bing or YouTube
Tip
Adding Sound That’s Stored on Your Computer
Tip
Adding Clip Art Audio
Note
Recording Audio
Note
Playing Audio Throughout a Slideshow
Tip
Formatting Video Clips
Adjust Brightness and Contrast
Tip
Add a Frame or Border
Add Effects
Tip
Crop the Player
Formatting Audio Clips
Tip
Editing Media Clips
Note
Using Bookmarks
Tip
Trimming a Media Clip
Fading in and Fading Out
Hide a Clip Until You Want it to Play
Note
Other Media Clip Settings
Tip
Tip
Animating Objects
Tip
Animating an Object
Tip
Changing an Animation
Tip
Adjusting Effect Options
Tip
Adding Sound to an Animation
Dimming Text
Note
Tip
Note
Animating Paragraphs and Words
Adding More Animation
Note
Creating a Motion Path
Note
Triggering an Animation
Tip
Timing Animations
Reordering Animations
Note
Tip
Removing an Animation
Note
Using the Animation Pane
Tip
Animating Lists
Tip
Adjusting Animation for Individual List Items
Giving Sub-Items their Own Animation
Tip
Animating a List as a Single Block of Text
Stacking Objects
Tip
Animating SmartArt Graphics
Creating Transitions Between Slides
Adding a Transition
Tip
Tweaking Transition Effects
Adding Sound to a Transition
Timing Transitions
Chapter 25. It’s Showtime! Giving a Presentation
Start, Navigate, End: Tips and Shortcuts
Starting a Slideshow
Tip
Moving From Slide to Slide
Note
Note
Ending a Slideshow
Before the Show: Prep Work
Tip
Adding Narration to Your Presentation
Tip
Recording a Narration
Tip
Tip
Tip
Playing Back a Narrated Slideshow
Turning Off Narration
Creating a Custom Slideshow
Note
Creating a Handout
Note
Setting Up Your Show
Tip
Following your Notes in Presenter View
At the Event
Settings to Check
Launching a Slideshow
Tip
During the Show
Zooming in
Hiding or Showing the Pointer
Marking Up Slides
Tip
Note
Tip
Changing Markup Color
Tip
Erasing Markup
Note
Making the Mouse Pointer a Laser Pointer
Making the Screen go Blank
Switching to Another Program (and Back)
Ending the Show
Tip
Other Presentation Options
Presenting a Slideshow Online
Note
Note
Tip
Tip
Editing an Online Presentation
Creating a Slideshow That Runs by Itself
Tip
Note
Creating an Interactive Slideshow
Tip
Tip
Turning Your Presentation into a Video
Sharing Your Presentation
Packaging Your Presentation on a CD or DVD
Part 6. Access
Chapter 26. Creating Your First Database
Understanding Access Databases
Note
Note
Starting a Database
Tip
Tip
Note
Building Your First Table
Creating a Simple Table
Note
Note
Tip
Note
Editing a Table
Edit Mode
Datasheet Shortcut Keys
Cut, Copy, and Paste
Saving Databases
Note
Making Backups
Saving a Database with a Different Name
Saving a Database in a Different Format
Tip
Shrinking a Database
Note
Opening Databases
Tip
Tip
Designating a Database as Trusted
Tip
Opening More Than One Database at Once
Opening a Database Created in an Older Version of Access
Tip
The Navigation Pane
Browsing Tables with the Navigation Pane
Tip
Managing Database Objects
Chapter 27. Building Smarter Tables
Understanding Data Types
Design View
Note
Tip
Organizing and Describing Your Fields
Note
Note
How Updates Work in Design View
Access Data Types
Note
Short Text
Note
Text Length
Tip
Long Text
Note
Formatted Text
Tip
Note
Number
Note
Number Size
Note
Note
Number Formatting
Note
Note
Currency
Tip
Note
Date/Time
Note
Custom Date Formats
Yes/No
Tip
Hyperlink
Note
Attachment
Warning
AutoNumber
Note
Using AutoNumbers Without Revealing the Size of your Table
Using Replication IDS
Note
Calculated
Note
The Primary Key
Creating Your Own Primary Key Field
Tip
Six Principles of Database Design
Note
1. Choose Good Field Names
2. Break Down Your Information
3. Include All the Details in One Place
4. Avoid Duplicating Information
Tip
5. Avoid Redundant Information
Note
6. Include an ID Field
Tip
Blocking Bad Data
Data Integrity Basics
Tip
Preventing Blank Fields
Blank Values and Empty Text
Setting Default Values
Tip
Preventing Duplicate Values with Indexes
Tip
Note
Multifield Indexes
Note
Tip
Lookups
Note
Note
Creating a Simple Lookup with Fixed Values
Warning
Adding New Values to Your Lookup List
Chapter 28. Mastering the Datasheet: Sorting, Searching, and Filtering
Tip
Datasheet Customization
Note
Formatting the Datasheet
Tip
Rearranging Columns
Note
Resizing Rows and Columns
Tip
Hiding Columns
Note
Freezing Columns
Tip
Datasheet Navigation
Sorting
Tip
Note
Sorting on Multiple Fields
Filtering
Quick Filters
Tip
Note
Filter by Selection
Filter by Condition
Searching
Tip
Printing the Datasheet
Print Preview
Moving Around the Print Preview
Changing the Page Layout
Fine-Tuning a Printout
Chapter 29. Linking Tables with Relationships
Relationship Basics
Redundant Data vs. Related Data
Tip
Matching Fields: The Relationship Link
Note
Linking with the ID Column
The Parent-Child Relationship
Note
Tip
Note
Using a Relationship
Defining a Relationship
Note
Tip
Tip
Tip
Tip
Editing Relationships
Note
Referential Integrity
Note
Note
Blank Values for Unlinked Records
Cascading Deletes
Warning
Cascading Updates
Navigating a Relationship
Tip
Tip
Lookups with Related Tables
Note
Tip
More Exotic Relationships
One-to-One Relationship
Note
Many-to-Many Relationship
Junction Tables
Tip
Multi-Value Fields
Warning
Warning
Part 7. Other Office Tools
Chapter 30. Publisher
Creating a New Publication
Tip
Creating a Publication from a Template
Tip
Creating a Publication from Scratch
Tip
Viewing the Page
Tip
Tip
Entering Text
Inserting an Image
Tip
Tip
Tip
Adding Pages
Note
Navigating Pages
Tip
Saving a Publication
Tip
Adding Text
Tip
Editing and Formatting Text
Aligning Text within a Text Box
Fitting Text to a Text Box
Note
Adjusting Hyphenation
Working with Character Spacing
Tip
Formatting Text
Adding Some Style to Your Text
Note
Inserting Your Business Information
Flowing Text from One Box to Another
Flowing Text Manually
Tip
Connecting Text Boxes to Autoflow Text
Flowing Text Around an Object
Tip
Adding Pictures, Shapes, and Other Objects
Formatting Objects
Formatting Pictures
Tip
Tip
Formatting Shapes and WordArt
Stacking and Grouping Objects
Designing and Laying Out Pages
Setting Up Pages
Choosing a Color Scheme
Choosing a Font Scheme
Using Layout Guides
Tip
Tip
Tip
Snapping an Object to a Guide
Reviewing Your Design
Printing a Publication
Preparing a Publication for a Commercial Printer
Note
Chapter 31. OneNote
What Is OneNote?
Getting Familiar with the OneNote Workspace
Note
Creating and Filling Up a Notebook
Adding Notes to a Page
Typing a Note
Pasting in a Note
Note
Drawing a Note
Tip
Inserting a Screen Clipping
Tip
Tip
Tip
Recording Audio and Video Notes
Tip
Organizing a Notebook
Working with Sections and Pages
Moving a Section
Merging Sections
Moving a Page
Changing a Page’s Level
Tip
Deleting Notebooks, Sections, and Pages
Note
Managing Individual Notes
Writing Quick Notes
Linking a Note to its Source
Tagging a Note
Tagging your to-do Items
Creating a Custom Tag
Note
Finding Tagged Notes
Removing a Tag
Finding a Note
Searching a Page
Changing the Scope of your Search
Tip
Viewing Your Notebooks
Tip
Note
Tip
Sharing Notes
Sharing a Notebook via a Link
Sharing a Notebook with an Online Meeting
Note
Finding Changes Others Have Made
Emailing a Page
Tip
Using OneNote with Other Office Programs
Linking Notes to Their Source
Note
Tip
Tip
Viewing Note Links
Removing Links from Linked Notes
Turning off Linked Notes
Getting Office Files into OneNote
Attaching a File to a Note
Inserting a Copy of a File into OneNote
Tip
Chapter 32. SkyDrive and Office Web Apps
Introducing Office on the Web
Note
Note
Setting Up Office Web Apps
Note
Signing in to SkyDrive
Note
What’s New in Office Web Apps
Note
Creating and Editing Files
Tip
Saving a Web App File in SkyDrive
Working with Folders in SkyDrive
Creating a Folder
Tip
Viewing Folders and Files
Finding Folders and Files
Note
Viewing Files in a Folder
Renaming a Folder
Note
Deleting a Folder
Managing Files in SkyDrive
Opening a File
Uploading Files to SkyDrive from Your Computer
Note
Starting Point: SkyDrive
Tip
Note
Starting Point: an Office Program
Note
Downloading Files from SkyDrive to Your Computer
Tip
Note
Move, Rename, Delete: File Management Tips
Tip
Sharing Files and Folders
Note
Sharing in Office Web Apps
Sharing in Office Web Apps
Note
Sharing on a Social Network
Note
Note
Sharing a File as a Web Page
Tip
Tip
Making a Shared Folder or File Private
Warning
Real-Time Collaborating
Note
Note
Docs.com: Office Web Apps for Facebook
Adding a Doc
Creating a Doc from Scratch
Creating a Doc from a Template
Uploading a File from your Computer
Tip
Note
Viewing Your Docs
Editing a Doc
Tip
Sharing a Doc
Tip
Viewing Friends’ Docs
Index
A note on the digital index
Symbols
A
B
C
D
E
F
I
K
L
M
O
P
Q
R
S
T
W
Y
About the Authors
Special Upgrade Offer
Office 2013: The Missing Manual
Nancy Conner
Matthew MacDonald
← Prev
Back
Next →
← Prev
Back
Next →