O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Microsoft® Office 2013 QuickSteps, 3rd Edition

Book Description

Full-color, step-by-step guide to the new release of the world’s most popular productivity suite of applications

Get up and running with Office 2013 right away--the QuickSteps way. Full-color screenshots on every page with clear instructions make it easy to use the latest release of Microsoft's powerful productivity suite. Follow along and quickly learn how to create Word documents; build Excel spreadsheets; manage Outlook email, contacts, and schedules; design PowerPoint presentations; and much more. This practical, fast-paced guide gets you started in no time!

Use these handy guideposts:

  • Shortcuts for accomplishing common tasks
  • Need-to-know facts in concise narrative
  • Helpful reminders or alternate ways of doing things
  • Bonus information related to the topic being covered
  • Errors and pitfalls to avoid

The unique, landscape-oriented layout of the QuickSteps series mimics your computer screen, displays graphics and explanations side by side, and lays flat so you can easily refer to the book while working on your computer.

Table of Contents

  1. Cover 
  2. Title Page
  3. Copyright Page
  4. Contents at a Glance
  5. Contents 
  6. About the Authors
  7. Acknowledgments
  8. Introduction
  9. Conventions Used in This Book
  10. Chapter 1: Stepping into Office
    1. Open and Close an Office Program
      1. Start an Office Program in Windows 7
      2. Start an Office Program in Windows 8
      3. Close an Office Program
    2. Open, Close, and Save an Office Document
      1. Using Touch
      2. Open a New Office Document
      3. Locate and Open an Existing Document
      4. Using Templates
      5. Using SkyDrive
      6. Save a Document for the First Time
      7. Save a Document Automatically
      8. Save a Document as a Copy or as a Template
      9. Close an Office Document
    3. Explore an Office Program
      1. Explore an Office Program Window
      2. Understanding the Ribbon
      3. Use the Mouse
      4. Use the Mini Toolbar
      5. Use Tabs and Menus
      6. Use Various Views
    4. Personalize and Customize Office 2013 Programs
      1. Work with the Quick Access Toolbar
      2. Show or Hide ScreenTips
      3. Change the Screen Color
      4. Add Identifying Information
      5. Set General Preferences
      6. Use AutoCorrect
    5. Use Common Office Tools
      1. Open Help
      2. Use the Thesaurus
      3. Translate a Document
      4. Use the Office Clipboard
      5. Check Spelling
      6. Make Accessibility Changes
  11. Chapter 2: Working with Documents in Word
    1. Step into Word
      1. Use the Start Screen for Word
      2. Create a New Document
      3. Locate and Open an Existing Document
      4. Import a Document
      5. Using View Buttons
    2. Write a Document
      1. Enter Text
      2. Determine Where Text Will Appear
      3. Insert Text or Type Over It
      4. Insert Line or Page Breaks
      5. Select Text
      6. Copy and Move Text
      7. Delete Text
      8. Enter Symbols and Special Characters
    3. Navigate a Document
      1. Move Around in a Document
      2. Find and Replace Text
      3. Using Wildcards
    4. Use Word Writing Aids
      1. Use Building Blocks
      2. Count Characters and Words
      3. Use Highlighting
      4. Add Hyphenation
  12. Chapter 3: Formatting a Document
    1. Format Text
      1. Survey the Text-Formatting Tools
      2. Apply Character Formatting
      3. Reset Font Defaults
      4. Change Character Spacing and OpenType Features
      5. Change Capitalization
      6. Create a Drop Cap
    2. Format a Paragraph
      1. Survey the Paragraph-Formatting Tools
      2. Set Paragraph Alignment
      3. Indenting a Paragraph
      4. Change and Remove Indents
      5. Use the Ruler for Indents
    3. Understand Line and Paragraph Spacing
      1. Set Line Spacing
      2. Use Numbered and Bulleted Lists
      3. Define New Multilevel Lists
      4. Add Horizontal Lines, Borders, and Shading
    4. Format a Page
      1. Turn On Formatting Marks
      2. Set Margins
      3. Copy Formatting
      4. Use the Page Setup Dialog Box to Format a Page
      5. Use Mirror Margins with the Menu
      6. Determine Page Orientation
      7. Specify Paper Size
      8. Track Inconsistent Formatting
      9. Set Vertical Alignment
  13. Chapter 4: Customizing a Document
    1. Use Styles
      1. Understanding Themes and Styles
      2. Identify Text with a Style
      3. Apply Predefined Style Sets to a Document
      4. Create a New Style
      5. Modify a Style
      6. Clear a Style from Text or a Document
      7. Delete/Restore a Style from the Gallery
      8. Examine Current Styles
    2. Use Themes
      1. Assign a Theme to Your Document
      2. Change a Theme
      3. Create a Custom Theme
    3. Work with Documents
      1. Create Section Breaks
      2. Create and Use Columns
      3. Use Tabs
      4. Add Headers and Footers
      5. Add Footnotes and Endnotes
      6. Create an Index
      7. Create a Table of Contents
      8. Handling Subdocuments
      9. Create and Use Outlines
  14. Chapter 5: Entering and Editing Data in Excel
    1. Enter Data
      1. Understanding Data Types
      2. Enter Text
      3. Complete an Entry
      4. Enter Numeric Data
      5. Enter Dates
      6. Format Numbers
      7. Use Times
      8. Understanding Excel Dates and Times
      9. Add Data Quickly
    2. Edit Data
      1. Edit Cell Data
      2. Remove Cell Contents
      3. Select Cells and Ranges
      4. Copy and Paste Data
      5. Find and Replace Data
      6. Verify Spelling
      7. Modify Automatic Corrections
      8. Edit Workbooks in the Excel Web App
  15. Chapter 6: Formatting a Worksheet in Excel
    1. Work with Cells, Rows, and Columns
      1. Adjust Row Height
      2. Adjust Column Width
      3. Hide and Unhide Rows and Columns
      4. Add and Remove Rows, Columns, and Cells
      5. Change Cell Borders
      6. Add a Comment
      7. Format Comments
    2. Apply Formatting
      1. Understanding Excel Formatting
      2. Apply Themes
      3. Create Custom Themes
      4. Search for Themes
      5. Use Cell Styles
      6. Change Fonts
      7. Change Alignment and Orientation
      8. Add a Background
      9. Copy Formatting
    3. Arrange and Organize Worksheets
      1. Lock Rows and Columns
      2. Split a Worksheet
      3. Work with Worksheets
      4. View Worksheets from Multiple Workbooks
      5. Compare Workbooks
  16. Chapter 7: Using Formulas and Functions
    1. Reference Cells
      1. Understanding Cell Referencing Types
      2. Change Cell References
      3. Change to R1C1 References
      4. Use Cell Reference Operators
      5. Name Cells
      6. Go to a Named Cell
      7. Use the Name Manager
    2. Build Formulas
      1. Create a Formula
      2. Edit a Formula
      3. Use Formulas
      4. Move Formulas
      5. Copy Formulas
      6. Recalculate Formulas
      7. Use External References in Formulas
      8. Add a Symbolic Formula
      9. Understanding the Trust Center
      10. Format Conditionally
    3. Use Functions
      1. Use Functions Quickly
      2. Enter a Function
      3. Enter a Sum in Columns or Rows Quickly
    4. Find and Correct Errors
      1. Check for Errors
      2. Trace Precedent and Dependent Cells
      3. Watch a Cell
      4. Evaluate a Formula in Pieces
  17. Chapter 8: Creating a Presentation in PowerPoint
    1. Step into PowerPoint
      1. Use the PowerPoint Start Screen
      2. See the PowerPoint Views
      3. Understanding PowerPoint Terminology
      4. Take the PowerPoint Tour
      5. Use PowerPoint Ribbon Tabs
      6. Using Menus and “Launchers” from the Ribbon
    2. Create a Presentation
      1. Create a Presentation from Another Presentation
      2. Create a Presentation Using a Template
      3. Create a Presentation from Scratch
    3. Complete Your Look and Content
      1. Choose a Slide Layout
      2. Apply Themes to Slides
      3. Add Content to a Slide
    4. Outline a Presentation
      1. Create an Outline
      2. Understanding the Outlining Feature
      3. Use the Outlining Commands
      4. Preview and Print the Outline
  18. Chapter 9: Working with Slides
    1. Navigate and Manipulate Slides
      1. Navigate from Slide to Slide
      2. Insert a Slide
      3. Display Multiple Presentations at Once
      4. Duplicate One or More Slides
      5. Move or Copy Slides
      6. Reviewing the Paste Options
      7. Copy a Design Using Browse
      8. Use Zoom
      9. Use a Keyboard with Slides
      10. Using Variants of Themes
    2. Change the Look and Feel of Slides
      1. Change a Theme
      2. Create a Custom Theme
      3. Copy Attributes with the Format Painter
      4. Work with Hyperlinks
      5. Use Footers on Slides
    3. Work with Text
      1. Use a Text Layout
      2. Insert a New Text Box
      3. Changing Font Attributes
      4. Change Regular Text to WordArt Styles
      5. Work with Text Boxes
      6. Use Lists
      7. Use the Font Dialog Box
      8. Align Text
      9. Moving or Copying Text
      10. Spiff Up Your Presentation with SmartArt
    4. Use Transitions and Animations
      1. Work with Transitions
      2. Add Animations to Your Slides
  19. Chapter 10: Polishing and Publishing Your Presentations
    1. Work with Master Slides
      1. Edit a Slide Master or Layout Master
      2. Perform Additional Slide Master Tasks
      3. Understand the Slide Master Ribbon
      4. Work with the Notes Master
      5. Change the Handout Master
    2. Work with Notes
      1. Display the Notes Pane
      2. Understanding PowerPoint Images and Illustrations
      3. Preview Speaker Notes
      4. Use Headers and Footers on Notes and Handouts
      5. Print Notes and Handouts
    3. Share Your Presentation
      1. Share in a Variety of Ways
      2. Export Your Presentation
    4. Present a Slide Show
      1. Set Controls for Two Monitors
      2. Understanding Equipment Setup for Presenting with Dual Monitors
      3. Choosing a Presentation Format
      4. Set Up Your Slide Show
      5. Use a Presenter View Slide Show
      6. Start the Slide Show
      7. Set Up an Automated Slide Show
      8. Record Narrations and Timings
      9. Rehearse Your Timing
  20. Chapter 11: Using Outlook
    1. Set Up E-mail
      1. Set Up Your Outlook Account
      2. Upgrade to Outlook
    2. Explore Outlook
      1. Explore the Outlook Window
      2. Change Views
      3. Use the Navigation Pane
    3. Receive E-mail
      1. Check for E-mail
      2. Read E-mail
      3. Filter Junk Mail
    4. Write Messages
      1. Create a Message
      2. Address a Message
      3. Add Carbon and Blind Copies
      4. Edit a Message
      5. Attach Files
      6. Including Hyperlinks
    5. Send Messages
      1. Reply to Messages
      2. Forward Messages
    6. Handle E-mail Messages
      1. Find a Message
      2. Archiving Messages
      3. Delete Messages
      4. Manage Attachments
    7. Create Contacts in People View
      1. Add a New Contact
      2. Create a Contact Group
    8. Explore the Calendar
      1. Create an Appointment
      2. Create a New Task
  21. Chapter 12: Printing, Using Mail Merge, and Working with Graphics
    1. Print Documents
      1. Set a Default Printer
      2. Define How a Document Is Printed
      3. Print a Document
    2. Merge Lists with Letters and Envelopes
      1. Perform a Mail Merge Using the Wizard
      2. Use Rules
      3. Merge to Envelopes
      4. Merge to Labels
    3. Work with Graphics
      1. Add Pictures
      2. Using the Picture Tools Format Tab
      3. Remove Unwanted Areas
      4. Add Shapes
      5. Create a Diagram
      6. Take a Screenshot
    4. Modify Graphics
      1. Understanding Graphic Positioning in Office Programs
      2. Resize and Rotate Graphics Precisely
      3. Position Graphics
      4. Work with Graphics
      5. Combine Graphics by Grouping
  22. Index