You are previewing Office 2013 All-In-One Absolute Beginner’s Guide.
O'Reilly logo
Office 2013 All-In-One Absolute Beginner’s Guide

Book Description

Make the most of Office 2013–without becoming a technical expert! This book is the fastest way to create, edit, format, build, review, and share virtually any form of Office content! Even if you’ve never used Office before, you’ll learn how to do what you want, one incredibly clear and easy step at a time. Office has never, ever been this simple!

Who knew how simple Microsoft® Office 2013 could be?

This is the easiest, most practical beginner’s guide to using Microsoft’s incredibly powerful new Office 2013 productivity suite…simple, reliable instructions for doing all you really want to do with the brand-new versions of Word, Excel, PowerPoint, Outlook, and OneNote! Here’s a small sample of what you’ll learn:

  • Explore Office 2013’s updated interface and most efficient shortcuts

  • Use Microsoft Office on the Web and mobile devices

  • Streamline Word document creation with templates, tables, and more

  • Efficiently build and review longer documents–by yourself or with teams

  • Quickly create reliable, sophisticated Excel workbooks

  • Analyze and visualize Excel data with charts, sparklines, pivot tables, and slicers

  • Create high-impact presentations with PowerPoint 2013’s newest tools

  • Supercharge presentations with audio, video, animations, and transitions

  • Set up email accounts and personalize Outlook to your own workstyle

  • Manage your life with Outlook contacts, tasks, to-do lists, and notes

  • Use Social Connector to simplify activities on Facebook, LinkedIn, and beyond

  • Organize research more efficiently with OneNote notebooks

  • Integrate text, links, files, media, screen clips, and handwriting into your OneNote notebooks

  • And much more…


  •  

    Table of Contents

    1. About This eBook
    2. Title Page
    3. Copyright Page
    4. Contents at a Glance
    5. Table of Contents
    6. About the Author
    7. Dedication
    8. Acknowledgments
    9. We Want to Hear from You!
    10. Reader Services
    11. Introduction
      1. How This Book Is Organized
      2. Conventions Used in This Book
    12. Part I: Introducing Microsoft Office 2013
      1. 1. Getting Started with Microsoft Office 2013
        1. Exploring the Start Screen
        2. Setting Up Your Office Account
        3. Using the Ribbon Tabs
        4. Using Backstage View
        5. Using Toolbars
        6. Using Task Panes
        7. Getting Help
      2. 2. Working with Office Applications
        1. Working with Files
        2. Sharing Files
        3. Exporting Files
        4. Customizing Office
      3. 3. Working with Text
        1. Formatting Text
        2. Using Bullets
        3. Using Numbered Lists
        4. Using WordArt
        5. Using Text Boxes
        6. Inserting Symbols and Equations
        7. Proofing Your Text
        8. Looking Up a Synonym in the Thesaurus
      4. 4. Working with Pictures
        1. Using Pictures in Office
        2. Inserting Pictures
        3. Inserting Online Pictures
        4. Inserting Screenshots
        5. Modifying Pictures
      5. 5. Working with Shapes and SmartArt
        1. Inserting Shapes
        2. Formatting Shapes Using the Drawing Tools – Format Tab
        3. Using the Format Shape Pane
        4. Working with SmartArt Graphics
      6. 6. Using Microsoft Office on the Web and Mobile Devices
        1. Using SkyDrive
        2. Using SkyDrive Mobile Apps
        3. Using Office Web Apps
    13. Part II: Microsoft Word 2013
      1. 7. Word 2013 Basics
        1. Exploring Word
        2. Starting a New Document
        3. Viewing Multiple Documents
      2. 8. Formatting Pages
        1. Setting Margins
        2. Creating Columns
        3. Changing Vertical Alignment
        4. Adding Headers and Footers to a Document
        5. Inserting Pages, Breaks, and Sections
      3. 9. Using Templates
        1. Understanding Templates
        2. Applying a Template
        3. Finding More Templates
        4. Saving Templates
      4. 10. Applying Advanced Formatting
        1. Applying a Theme
        2. Applying Styles
        3. Adding Special Effects
        4. Adding Borders and Shading
        5. Adding Text with Quick Parts
      5. 11. Adding Tables and Charts
        1. Inserting Tables
        2. Selecting Table Parts
        3. Modifying Tables
        4. Inserting Charts
      6. 12. Printing Documents
        1. Previewing and Printing a Document
        2. Controlling Page Setup
        3. Printing Envelopes and Labels
        4. Using Word’s Mail Merge Tool
      7. 13. Working with Longer Documents
        1. Structuring Documents with Outline View
        2. Inserting Footnotes and Endnotes
        3. Adding Captions
        4. Inserting Cross-References
        5. Creating an Index
        6. Creating a Table of Contents
        7. Inserting Bookmarks
        8. Navigating Long Documents with the Navigation Pane
      8. 14. Collaborating, Reviewing, and Sharing Documents
        1. Tracking and Reviewing Documents
        2. Comparing Documents
        3. Editing Portable Document Format (PDF) Files
        4. Sharing Documents with Others
    14. Part III: Microsoft Excel 2013
      1. 15. Excel 2013 Basics
        1. Exploring the Excel Window
        2. Moving Around and Making Selections on a Sheet
        3. Using Templates to Quickly Create New Workbooks
        4. Working with Sheets and Tabs
        5. Working with Rows and Columns
        6. Working with Cells
      2. 16. Entering Sheet Data
        1. Understanding Excel Data Types
        2. Entering Data
        3. Editing and Managing Data
      3. 17. Formatting Sheets and Cells
        1. Adjusting Row Heights and Column Widths
        2. Aligning Text in a Cell
        3. Formatting Numbers
        4. Creating Hyperlinks
        5. Applying Conditional Formatting
        6. Using Cell Styles to Quickly Apply Formatting
        7. Using Themes to Ensure Uniformity in Design
      4. 18. Using Formulas
        1. Entering a Formula into a Cell
        2. Copying a Formula to Another Cell
      5. 19. Using Functions
        1. Understanding Functions
        2. Entering Functions Using the Function Arguments Dialog Box
        3. Entering Functions Using In-Cell Tips
        4. Using the AutoSum Button
      6. 20. Sorting Data
        1. Sorting Excel Data
        2. Performing a Quick Sort
        3. Fixing Sort Problems
      7. 21. Filtering and Consolidating Data
        1. Filtering Data
        2. Managing Filters
        3. Consolidating Data
      8. 22. Preparing Workbooks for Distribution and Printing
        1. Preparing to Print or Share Your Workbook
        2. Configuring Page Setup
      9. 23. Creating Subtotals and Grouping Data
        1. Creating Subtotals
        2. Grouping and Outlining Rows and Columns
      10. 24. Creating Charts and Sparklines
        1. Creating a Chart
        2. Modifying Charts
        3. Adding Sparklines to Data
      11. 25. Creating Pivot Tables and Slicers
        1. Creating a Pivot Table
        2. Modifying a Pivot Table
        3. Creating Slicers
    15. Part IV: Microsoft PowerPoint 2013
      1. 26. PowerPoint 2013 Basics
        1. Exploring PowerPoint
        2. Creating a Presentation
        3. Adding Slides to Your Presentation
        4. Adding Sections to Your Presentation
      2. 27. Customizing Themes and Backgrounds
        1. Applying a New Theme to Your Presentation
        2. Applying Multiple Themes to a Single Presentation
        3. Applying a New Theme Variant
        4. Formatting Presentation Backgrounds
        5. Customizing Themes
      3. 28. Formatting and Organizing Objects, Slides, and Presentations
        1. Manipulating Objects
        2. Arranging Objects
        3. Working with Gridlines and Guides
        4. Organizing Slides
      4. 29. Adding Tables to a Presentation
        1. Understanding PowerPoint Tables
        2. Inserting a Table
        3. Drawing Custom Tables
        4. Inserting Excel Spreadsheets
        5. Formatting Tables
        6. Deleting Tables and Table Contents
      5. 30. Outlining Presentations
        1. Creating an Effective Presentation Outline
        2. Using Outline View
        3. Modifying Your Outline
        4. Inserting an Outline from Another Application
      6. 31. Reviewing Presentations
        1. Understanding PowerPoint Reviewing Tools
        2. Working with Comments
        3. Comparing Presentations
      7. 32. Working with Charts
        1. Understanding Charts
        2. Inserting Charts
        3. Inserting a Chart from Excel
        4. Modifying and Formatting Charts
      8. 33. Working with Audio and Video
        1. Understanding Audio and Video Formats
        2. Inserting Audio Clips
        3. Inserting Video Clips
        4. Formatting Audio and Video Clips
        5. Specifying Audio and Video Playback Options
        6. Compressing Media Files for Improved Performance
        7. Creating Videos from PowerPoint Presentations
      9. 34. Working with Animation and Transitions
        1. Understanding Animation and Transitions
        2. Setting Slide Transitions
        3. Applying Animation to Objects
        4. Customizing Animations on the Animation Pane
        5. Managing Animations
      10. 35. Working with Slide Masters
        1. Modifying the Slide Master
        2. Adding a Slide Master
        3. Creating a Custom Layout
        4. Managing Slide Masters
      11. 36. Creating and Printing Presentation Materials
        1. Understanding PowerPoint Printing Options
        2. Printing PowerPoint Presentations
        3. Creating Handouts in Microsoft Word
      12. 37. Presenting a Slide Show
        1. Exploring the Slide Show Tab
        2. Setting Up a Show
        3. Rehearsing Timings
        4. Recording Voice Narrations
        5. Creating Custom Shows
        6. Viewing Your Show
        7. Presenting Online
        8. Exploring Presenter View
        9. Packaging a Presentation onto a CD
    16. Part V: Microsoft Outlook 2013
      1. 38. Outlook 2013 Basics
        1. Getting Started with Outlook
        2. Starting and Exiting Outlook
        3. Familiarizing Yourself with the Program Window
      2. 39. Setting Up Accounts and Personalizing Outlook
        1. Understanding Email Services and Internet Access
        2. Adding Email Accounts to Outlook
        3. Working with Outlook Panes
      3. 40. Performing Basic Email Tasks
        1. Composing and Sending Messages
        2. Reading and Replying to Messages
        3. Saving Messages
        4. Working with File Attachments
        5. Using Simple Message Tools
      4. 41. Managing Email
        1. Organizing Messages with Folders
        2. Routing Messages with Quick Steps
        3. Managing Incoming Messages with Rules
        4. Controlling Junk Email
        5. Archiving Messages
      5. 42. Working with Advanced Email Features
        1. Setting Priority and Sensitivity Options
        2. Using Quick Parts
        3. Adding Signatures
        4. Controlling Replies, Forwarding, and Receipts
        5. Working with RSS Feeds
      6. 43. Using the Calendar
        1. Displaying Your Calendar
        2. Recording Events and Appointments
        3. Setting Up Meetings
        4. Sharing Your Calendar
      7. 44. Working with Contacts
        1. Creating Contacts
        2. Working with Contact Groups
        3. Managing Your Contacts
      8. 45. Working with Tasks and To-Do Lists
        1. Creating Tasks
        2. Completing Tasks
        3. Using Task Requests
        4. Viewing Tasks
        5. Creating To-Do Items
      9. 46. Using Social Connector
        1. Configuring the Social Connector
        2. Managing Social Connector Security
      10. 47. Synchronizing and Sharing Outlook Data
        1. Sharing Calendar and Contacts
        2. Using Contacts in Other Programs
      11. 48. Using Color Categories
        1. Assigning Color Categories to Outlook Items
        2. Managing Color Categories
      12. 49. Working with Notes
        1. Exploring Outlook Notes
        2. Creating a Note
        3. Emailing Notes
        4. Organizing Your Notes
      13. 50. Using Folders
        1. Creating New Folders
        2. Managing Folders
      14. 51. Using Search
        1. Using Instant Search
        2. Finding Related Messages
        3. Searching on the People Pane
        4. Creating Search Folders
      15. 52. Working with Views
        1. Managing Views
        2. Creating Custom Views
        3. Using Conditional Formatting
    17. Part VI: Microsoft OneNote 2013
      1. 53. OneNote 2013 Basics
        1. Creating a New Notebook
        2. Working with Sections
        3. Working with Pages
        4. Working with Tags
      2. 54. Inserting Notebook Content
        1. Inserting Files
        2. Inserting Images
        3. Inserting Links
        4. Recording Audio and Video
        5. Inserting Other Notebook Content
        6. Using OneNote Drawing Tools
      3. 55. Viewing and Managing Notebooks
        1. Displaying Full Page View
        2. Docking OneNote to Your Desktop
        3. Using Linked Note Taking
        4. Setting Up OneNote Pages
        5. Working with Microsoft Outlook
        6. Using the Send to OneNote Tool
        7. Protecting Notebook Sections with a Password
        8. Viewing Notebook History
    18. Index