You are previewing Office 2013 On Demand.
O'Reilly logo
Office 2013 On Demand

Book Description

Need answers quickly? Office 2013 on Demand provides those answers in a visual step-by-step format. We will show you exactly what to do through lots of full color illustrations and easy-to-follow instructions.

Inside the Book

• Office: Organize information and add impact with online pictures and video, SmartArt diagrams, tables, and charts

• Word: Create great-looking documents using themes, templates, and video

• Excel: Use organizing, processing, and presenting tools to quickly create data tables and charts

• PowerPoint: Create powerful presentations faster using ready-made design templates and themes

• Access: Use full-featured templates and application parts to create desktop and web app databases.

• Outlook: Use tools for creating and managing your e-mail, calendar, contacts, and tasks

• Publisher: Use ready-made design templates to quickly create a brochure or a newsletter

• Office Web Apps: View and edit your Office documents in a browser

• Online Sharing: Save, open, and share Office documents on Skydrive and Office 365 SharePoint from all your devices

• Prepare for the Microsoft Office Specialist exam

Bonus Online Content

Register your book at queondemand.com to gain access to:

• Workshops and related files

• Keyboard shortcuts

Visit the author site: perspection.com

Includes

• Online Workshops that focus on real-world techniques

• MOS Exam Prep

• More than 700 of the most essential Office 2013 tasks

Table of Contents

  1. Title Page
  2. Copyright Page
  3. Acknowledgments
    1. Perspection, Inc.
    2. Acknowledgments
    3. About the Author
    4. We Want to Hear from You!
  4. Contents
  5. Introduction
    1. How This Book Works
    2. What’s New
    3. Keyboard Shortcuts
    4. Step-by-Step Instructions
    5. Real World Examples
    6. Workshops
    7. Microsoft Office Specialist
    8. Get More on the Web
  6. 1. Getting Started with Office
    1. Introduction
    2. Starting an Office Program
    3. Viewing an Office Program Window
    4. Using the Ribbon
    5. Choosing Commands
    6. Working with the Ribbon and Toolbars
    7. Choosing Dialog Box Options
    8. Using the Status Bar
    9. Creating a Blank Office Document
    10. Creating a Document Using a Template
    11. Opening an Existing Office Document
    12. Converting an Existing Office Document
    13. Using Task and Window Panes
    14. Arranging Windows
    15. Switching Views
    16. Documenting Properties
    17. Getting Help While You Work
    18. Saving an Office Document
    19. Saving an Office Document with Different Formats
    20. Saving an Office Document to Online Services
    21. Working with Accounts
    22. Checking Compatibility
    23. Checking Accessibility
    24. Recovering an Office Document
    25. Closing a Document and Exiting Office
  7. 2. Using Shared Office Tools
    1. Introduction
    2. Editing Text
    3. Copying and Moving Text
    4. Finding and Replacing Text
    5. Correcting Text Automatically
    6. Inserting Information the Smart Way
    7. Checking Spelling
    8. Changing Proofing Options
    9. Using Custom Dictionaries
    10. Inserting Symbols
    11. Finding the Right Words
    12. Inserting Research Material
    13. Translating Text to Another Language
    14. Using Multiple Languages
    15. Undoing and Redoing an Action
    16. Zooming the View In and Out
    17. Previewing a Document
    18. Printing a Document
    19. Working with Touch Screens
  8. 3. Adding Art to Office Documents
    1. Introduction
    2. Locating and Inserting an Online Picture
    3. Inserting a Picture
    4. Inserting a Picture Screen Shot
    5. Adding an Artistic Style to a Picture
    6. Adding a Quick Style to a Picture
    7. Applying a Shape to a Picture
    8. Applying a Border to a Picture
    9. Applying Picture Effects
    10. Modifying Picture Size
    11. Compressing a Picture
    12. Correcting a Picture
    13. Recoloring a Picture
    14. Cropping and Rotating a Picture
    15. Removing a Picture Background
    16. Creating WordArt Text
    17. Formatting WordArt Text
    18. Applying WordArt Text Effects
    19. Modifying WordArt Text Position
    20. Creating SmartArt Graphics
    21. Formatting a SmartArt Graphic
    22. Modifying a SmartArt Graphic
    23. Adding Pictures to a SmartArt Graphic
    24. Creating an Organization Chart
    25. Inserting and Creating a Chart
    26. Changing a Chart Layout and Style
    27. Changing Chart Elements
    28. Formatting Line and Bar Charts
    29. Editing Chart Data
    30. Inserting Apps for Office Programs
  9. 4. Adding Shapes to Office Documents
    1. Introduction
    2. Drawing and Resizing Shapes
    3. Adding Text to a Shape
    4. Creating and Editing Freeforms
    5. Adding a Quick Style to a Shape
    6. Adding a Quick Style to Shape Text
    7. Applying Color Fills
    8. Applying Picture or Texture Fills
    9. Applying Gradient Fills
    10. Applying Shape Effects
    11. Aligning and Distributing Objects
    12. Aligning Objects to Gridlines and Guides
    13. Changing Stacking Order
    14. Rotating and Flipping Objects
    15. Grouping and Merging Objects
    16. Selecting Objects Using the Selection Pane
  10. 5. Formatting Office Documents
    1. Introduction
    2. Formatting Text
    3. Changing Alignment
    4. Using the Format Painter
    5. Adding Custom Colors
    6. Understanding Themes
    7. Viewing and Applying a Theme
    8. Creating Theme Colors
    9. Choosing Theme Fonts
    10. Choosing Theme Effects
    11. Creating a Custom Theme
    12. Choosing a Custom Theme
    13. Creating a Template
  11. 6. Creating a Document with Word
    1. Introduction
    2. Viewing the Word Window
    3. Opening and Editing PDF Documents
    4. Changing Document Views
    5. Reading a Document
    6. Navigating a Document
    7. Setting Up the Page
    8. Setting Up the Page Margins
    9. Creating an Outline
    10. Selecting Text
    11. Checking Spelling and Grammar
    12. Inserting New Pages and Sections
    13. Adding Headers and Footers
    14. Inserting Page Numbers and the Date and Time
    15. Inserting or Embedding Online Video
  12. 7. Formatting a Document with Word
    1. Introduction
    2. Formatting Text for Emphasis
    3. Finding and Replacing Formatting
    4. Changing Paragraph Alignment
    5. Changing Line Spacing
    6. Displaying Rulers
    7. Setting Paragraph Tabs
    8. Setting Paragraph Indents
    9. Changing Character Spacing
    10. Applying a Quick Style
    11. Changing a Style Set
    12. Creating and Modifying Styles
    13. Creating Bulleted and Numbered Lists
    14. Hiding Text
  13. 8. Enhancing a Document with Word
    1. Introduction
    2. Adding Desktop Publishing Effects
    3. Adding a Watermark
    4. Adding Page Backgrounds
    5. Arranging Text in Columns
    6. Arranging and Aligning an Object
    7. Wrapping Text Around an Object
    8. Working with Text Boxes
    9. Inserting Building Blocks Using Quick Parts
    10. Creating a Table
    11. Entering Text in a Table
    12. Modifying a Table
    13. Adjusting Table Cells
    14. Formatting a Table
    15. Calculating a Value in a Table
    16. Addressing Envelopes and Labels
    17. Creating a Form Letter
    18. Creating Labels
    19. Inserting a Table of Contents
    20. Creating an Index
    21. Creating Captions
    22. Creating a Table of Figures
    23. Creating Footnotes or Endnotes
    24. Creating a Bookmark
    25. Inserting Cross References
    26. Comparing and Merging Documents
    27. Using Track Changes
    28. Adding a Cover Page
  14. 9. Creating a Worksheet with Excel
    1. Introduction
    2. Viewing the Excel Window
    3. Selecting Cells
    4. Moving Around the Workbook
    5. Entering Labels on a Worksheet
    6. Entering Values on a Worksheet
    7. Entering Content Quickly with AutoFill
    8. Inserting Content with Flash Fill
    9. Editing Cell Contents
    10. Clearing Cell Contents
    11. Inserting and Deleting Cell Contents
    12. Selecting Rows, Columns, and Special Ranges
    13. Selecting and Naming a Worksheet
    14. Inserting and Deleting a Worksheet
    15. Moving and Copying a Worksheet
    16. Hiding and Unhiding Worksheets and Workbooks
    17. Hiding and Unhiding a Column or Row
    18. Inserting a Column or Row
    19. Deleting a Column or Row
    20. Adjusting Column Width and Row Height
    21. Splitting a Worksheet into Panes
    22. Freezing and Unfreezing a Column or Row
    23. Showing and Hiding Workbook Elements
  15. 10. Building a Worksheet with Excel
    1. Introduction
    2. Understanding Formulas
    3. Understanding Cell Referencing
    4. Creating a Simple Formula
    5. Creating a Formula Using Formula AutoComplete
    6. Editing a Formula
    7. Naming Cells and Ranges
    8. Entering Named Cells and Ranges
    9. Managing Names
    10. Simplifying a Formula with Ranges
    11. Calculating Totals with AutoSum
    12. Calculating Totals with Quick Analysis
    13. Correcting Formulas
    14. Auditing a Worksheet
    15. Creating Functions
    16. Creating Functions Using the Library
    17. Calculating Multiple Results
    18. Using Nested Functions
    19. Using Text Functions
    20. Using Lookup and Reference Functions
    21. Summarizing Data Using Subtotals
    22. Summarizing Data Using Functions
    23. Converting Text to Columns
    24. Creating a Table
    25. Formatting a Table
    26. Formatting Table Elements
    27. Creating Calculations in a Table
    28. Removing Table Rows and Columns
    29. Working with Tables
    30. Sorting Data in a Table
    31. Displaying Parts of a Table with AutoFilter
    32. Using Slicers to Filter a Table
    33. Creating Groups and Outlines
    34. Adding Data Validation to a Worksheet
    35. Creating a Drop-Down List
  16. 11. Designing a Worksheet with Excel
    1. Introduction
    2. Formatting Numbers
    3. Applying and Creating Cell Styles
    4. Applying Conditional Formatting
    5. Applying Specialized Conditional Formatting
    6. Creating Conditional Formatting
    7. Managing Conditional Formatting
    8. Creating Sparkline Formatting
    9. Controlling Text Flow
    10. Formatting Tabs and Background
    11. Adding Borders to Cells
    12. Setting Up the Page
    13. Inserting Page Breaks
    14. Adjusting Page Margins
    15. Adding Headers and Footers
    16. Customizing Worksheet Printing
    17. Setting the Print Area
  17. 12. Creating a Presentation with PowerPoint
    1. Introduction
    2. Viewing the PowerPoint Window
    3. Browsing a Presentation
    4. Understanding PowerPoint Views
    5. Creating New and Consistent Slides
    6. Working with Objects
    7. Entering and Editing Text
    8. Resizing Text While Typing
    9. Changing Text Spacing
    10. Inserting and Developing an Outline
    11. Moving and Indenting Text
    12. Modifying a Bulleted and Numbered List
    13. Creating Text Columns
    14. Organizing Slides into Sections
    15. Rearranging Slides
    16. Using Slides from Other Presentations
    17. Making Your Presentation Look Consistent
    18. Controlling Slide Appearance with Masters
    19. Controlling a Slide Layout with Masters
    20. Modifying Placeholders
    21. Controlling a Slide Background with Masters
    22. Adding a Background Style
    23. Inserting a Table
    24. Modifying a Table
    25. Adding a Quick Style to a Table
    26. Formatting a Table
    27. Creating a Text Box
  18. 13. Delivering a Presentation with PowerPoint
    1. Introduction
    2. Changing Slide Setup Options
    3. Adding Animation
    4. Using Specialized Animations
    5. Coordinating Multiple Animations
    6. Adding Slide Timings
    7. Creating Slide Transitions
    8. Inserting Videos and Audio
    9. Editing and Formatting Videos and Audio
    10. Setting Video and Audio Play Options
    11. Recording a Narration
    12. Setting Up a Slide Show
    13. Creating a Custom Slide Show
    14. Starting a Slide Show
    15. Navigating a Slide Show
    16. Annotating a Slide Show
    17. Displaying a Slide Show in Presenter View
    18. Saving a Presentation as a Slide Show
    19. Saving a Presentation as a Video
    20. Packaging a Presentation on CD
    21. Preparing Handouts
    22. Preparing Speaker Notes
    23. Adding a Header and Footer
    24. Inserting the Date and Time
    25. Inserting Slide Numbers
    26. Previewing Slides
    27. Printing a Presentation
  19. 14. Creating a Database with Access
    1. Introduction
    2. Creating a Desktop Database
    3. Viewing the Access Window
    4. Changing Database Display Options
    5. Viewing Database Objects
    6. Working with Database Objects
    7. Planning Tables
    8. Creating a Table by Entering Data
    9. Creating an Application Part Using a Template
    10. Creating a Table Using SharePoint
    11. Working with a Table
    12. Importing Data into Tables
    13. Working with a Table in Design View
    14. Working with Fields
    15. Specifying Data Types and Field Properties
    16. Changing Field Properties
    17. Creating Input Masks
    18. Creating a Lookup Field
    19. Defining Table Relationships
    20. Ensuring Referential Integrity
    21. Backing Up and Repairing a Database
    22. Packaging and Sharing a Database
  20. 15. Managing and Presenting Data with Access
    1. Introduction
    2. Sorting Records
    3. Filtering Out Records
    4. Creating Complex Filters Using Forms
    5. Understanding the Different Types of Queries
    6. Creating a Query Using a Wizard
    7. Creating a Query in Design View
    8. Getting Information with a Query
    9. Modifying a Query in Design View
    10. Performing Calculations in Queries
    11. Summarizing Values with a Crosstab Query
    12. Creating a Parameter Query
    13. Finding Duplicate Fields
    14. Creating a Form
    15. Working with a Form in Design View
    16. Entering and Editing Data in a Form
    17. Modifying a Form
    18. Creating a Report
    19. Modifying a Report in Design View
    20. Performing Calculations in Reports
    21. Formatting a Form or Report
    22. Grouping and Sorting in Reports
    23. Formatting a Datasheet
    24. Changing the Page Setup
    25. Previewing and Printing Information
  21. 16. Creating a Web App with Access
    1. Introduction
    2. Creating a Web App
    3. Adding Tables and Data to a Web App
    4. Viewing and Editing Data in a Web App
    5. Creating Views in a Web App
    6. Modifying a Web App
    7. Packaging a Web App
  22. 17. Communicating with Outlook
    1. Introduction
    2. Preparing for Outlook
    3. Using Outlook for the First Time
    4. Viewing the Outlook Window
    5. Using the To-Do Bar
    6. Using the Folder Pane
    7. Viewing Items and Folders
    8. Creating a Contact
    9. Finding Contacts
    10. Sorting Contacts
    11. Creating and Addressing an E-Mail Message
    12. Formatting Message Text
    13. Attaching a File or Item to a Message
    14. Using Stationery
    15. Creating a Signature
    16. Inserting Message Content
    17. Sending Messages
    18. Setting Message Delivery Options
    19. Receiving and Reading Messages
    20. Flagging Messages
    21. Categorizing Messages By Color
    22. Deleting Messages
    23. Replying To and Forwarding a Message
    24. Finding and Filtering Messages
    25. Organizing Messages in Folders
    26. Managing Messages with Rules
    27. Managing Messages with Quick Steps
    28. Using Search Folders
    29. Working with a Message Conversation
    30. Reducing Junk Messages
    31. Archiving Messages
    32. Cleaning Up Messages
    33. Setting Outlook Options
    34. Working with Outlook Data
    35. Sending and Receiving Instant Messages
  23. 18. Managing Information with Outlook
    1. Introduction
    2. Viewing the Calendar
    3. Customizing the Calendar
    4. Scheduling an Appointment and Event
    5. Scheduling Meetings
    6. Participating in Online Meetings
    7. Responding to Meeting Requests
    8. Updating and Canceling Meeting Requests
    9. Working with Calendars
    10. Viewing the Weather in Calendars
    11. Creating and Updating Tasks
    12. Organizing Tasks
    13. Assigning Tasks to Others
    14. Monitoring Task Progress
    15. Managing Tasks
    16. Organizing Items by Categories
    17. Customizing How You View Items
    18. Creating and Modifying Notes
    19. Previewing and Printing Items from Outlook
    20. Connecting to Social Networks
    21. Publishing and Sharing Calendars
    22. Working with Site Mailboxes
    23. Adding and Viewing RSS Feeds
  24. 19. Creating a Publication with Publisher
    1. Introduction
    2. Viewing the Publisher Window
    3. Creating a New Publication
    4. Creating a Blank Publication
    5. Opening an Existing Publication
    6. Changing Your View
    7. Working with Pages
    8. Inserting and Editing Text
    9. Inserting Content
    10. Controlling Pages Appearance with Masters
    11. Applying Color
    12. Checking Your Design
    13. Setting Up the Page
    14. Printing a Publication
    15. Saving for Photo Printing
    16. Saving for Commercial Printing
  25. 20. Designing a Publication with Publisher
    1. Introduction
    2. Setting Up Layout Guides
    3. Viewing Elements and Tools
    4. Working with Text
    5. Connecting Text Frames
    6. Creating a Consistent Look
    7. Creating Tables
    8. Working with Shapes and Pictures
    9. Wrapping Text Around an Object
    10. Layering Objects
    11. Grouping Objects Together
    12. Aligning with Precision
    13. Rotating and Flipping Objects
  26. 21. Publishing Office Documents for the Web
    1. Introduction
    2. Opening a Web Page
    3. Previewing a Web Page
    4. Creating a Hyperlink
    5. Adding Hyperlinks to Slide Objects
    6. Formatting a Cell Hyperlink
    7. Changing Web Page Options
    8. Saving a Web Page
    9. Publishing a Web Page
    10. Saving Slides as Web Graphics
    11. Creating Refreshable Web Queries
    12. Getting Data from Web Queries
    13. Getting Documents from the Web
  27. 22. Protecting and Securing Office Documents
    1. Introduction
    2. Inspecting Documents
    3. Protecting a Worksheet
    4. Locking or Unlocking Worksheet Cells
    5. Adding Security Encryption to a Document
    6. Adding Password Protection to a Document
    7. Adding a Digital Signature
    8. Adding a Signature Line
    9. Avoiding Harmful Attacks
    10. Using the Trust Center
    11. Selecting Trusted Publishers and Locations
    12. Setting Document Related Security Options
    13. Setting App Catalog Security Options
    14. Setting Add-in Security Options
    15. Setting ActiveX Security Options
    16. Setting Macro Security Options
    17. Changing Message Bar Security Options
    18. Setting Privacy Options
    19. Setting External Content Security Options
    20. Working with Office Safe Modes
    21. Marking a Document as Read-Only
  28. 23. Reviewing and Sharing Office Documents
    1. Introduction
    2. Sharing Workbooks
    3. Creating and Reading a Cell Comment
    4. Editing and Deleting a Cell Comment
    5. Adding Comments to a Presentation
    6. Tracking Workbook Changes
    7. Comparing and Merging Presentations
    8. Creating and Linking Notes
    9. Sending a Document Using E-Mail
    10. Sending a Document by Internet Fax
    11. Sending a Document by Instant Message
    12. Creating a PDF Document
    13. Creating a XPS Document
    14. Exporting and Importing Data
    15. Linking and Embedding Files
    16. Consolidating Data in Excel
    17. Linking Data in Excel
    18. Getting Text Data in Excel
    19. Connecting to Data in Excel
    20. Getting Query Data from a Database
    21. Getting Data from Access
    22. Sharing with SkyDrive and SharePoint
    23. Saving and Opening on SkyDrive and SharePoint
    24. Syncing Documents on SharePoint
    25. Sharing a SkyDrive Document
    26. Working Together with Online Documents
    27. Publishing Slides to an Online Library
    28. Broadcasting an Online Presentation
    29. Giving a Presentation at an Online Meeting
    30. Posting to an Online Blog
  29. 24. Expanding Office Functionality
    1. Introduction
    2. Viewing and Managing Add-ins
    3. Loading and Unloading Add-ins
    4. Enhancing a Document with VBA
    5. Setting Developer Options
    6. Understanding How Macros Automate Your Work
    7. Recording a Macro
    8. Creating a Macro
    9. Running a Macro
    10. Controlling a Macro
    11. Building a Macro
    12. Adding a Digital Signature to a Macro Project
    13. Assigning a Macro to a Toolbar or Ribbon
    14. Saving a Document with Macros
    15. Opening a Document with Macros
    16. Inserting ActiveX Controls
    17. Using ActiveX Controls
    18. Setting ActiveX Control Properties
    19. Adding VBA Code to an ActiveX Control
    20. Playing a Movie Using an ActiveX Control
    21. Changing the Document Information Panel
  30. 25. Working with Other Office Tools
    1. Introduction
    2. Working with OneNote
    3. Viewing the InfoPath Designer Window
    4. Working with InfoPath Designer
    5. Viewing the InfoPath Filler Window
    6. Working with InfoPath Filler
    7. Communicating Online with Lync
    8. Working with Office Tools
    9. Maintaining and Repairing Office
  31. New! Features
    1. Microsoft Office 2013
  32. Microsoft Office Specialist
    1. About the MOS Program
    2. What Does This Logo Mean?
    3. Preparing for a MOS Exam
    4. Taking a MOS Exam
    5. Getting More Information
  33. Index
  34. Online Workshop