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 →

Chief Librarian: Las Zenow <zenow@riseup.net>
Fork the source code from gitlab
.

This is a mirror of the Tor onion service:
http://kx5thpx2olielkihfyo4jgjqfb7zx7wxr3sd4xzt26ochei4m6f7tayd.onion