You are previewing Microsoft Office Inside Out: 2013 Edition.
O'Reilly logo
Microsoft Office Inside Out: 2013 Edition

Book Description

Conquer Microsoft Office—from the inside out!

You're beyond the basics, so dive right into Microsoft Office—and really put these productivity tools and services to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts tackle Office—and challenge yourself to new levels of mastery.

  • Take advantage of Office in the cloud with Office 365

  • Get insider tweaks and tips to become more productive

  • Sync your email, calendar, and contacts on multiple devices

  • Organize and edit complex documents with Microsoft Word

  • Enhance Microsoft PowerPoint presentations with rich media

  • Handle data with the Microsoft Excel Quick Analysis tool

  • Get organized with Microsoft OneNote using expert techniques

  • Save, share, and sync documents and settings with SkyDrive

  • Use Microsoft Access, Publisher, and Lync in smarter ways

  • Table of Contents

    1. Microsoft Office Inside Out: 2013 Edition
    2. Dedication
    3. Introduction
      1. Who this book is for
        1. Assumptions about you
      2. How this book is organized
      3. Acknowledgments
      4. Support and feedback
        1. Errata & support
        2. We want to hear from you
        3. Stay in touch
    4. 1. Office Fundamentals
      1. 1. Inside Office 2013
        1. What’s new? What’s changed?
        2. Using Office Web Apps
        3. A field guide to Office 2013 editions
          1. Subscription editions
          2. Retail editions
          3. Volume-license editions
        4. Word 2013
        5. Excel 2013
        6. Outlook 2013
        7. PowerPoint 2013
        8. OneNote 2013
        9. Other Office 2013 programs
      2. 2. Installing and Updating Office 2013
        1. Choosing an Office edition
          1. Subscription editions
          2. Retail perpetual license editions
          3. Volume license editions
        2. Setting up Office
          1. Using the Click-to-Run Office installer
          2. Installing from physical media or an installer file
          3. Activating a trial edition of Office
          4. Activating your Office installation
        3. Keeping Office up to date
        4. Customizing Office with add-ins and apps
        5. Uninstalling Office
      3. 3. Using and Customizing the Office Interface
        1. Mastering Office Backstage view
          1. Viewing document properties in the Info pane
          2. Creating, editing, and saving files in Backstage view
            1. Creating a new document
            2. Opening, saving, and closing files
          3. Printing from Backstage view
          4. Sharing and exporting documents and other Office items
          5. Managing account settings and program options
        2. Using and customizing the ribbon
          1. Using the ribbon
          2. Galleries and live previews
          3. Personalizing the ribbon
        3. Customizing the Quick Access Toolbar
        4. Using and customizing the status bar
        5. Using keyboard shortcuts
        6. Arranging and switching between document windows
      4. 4. Entering, Editing, and Formatting Text
        1. Entering, selecting, and deleting text
          1. Entering symbols and other special characters
            1. Entering characters with Insert Symbol
            2. Entering characters with AutoCorrect
            3. Entering characters with character codes
        2. Expert text-editing techniques
          1. Using Undo, Redo, and Repeat
          2. Entering boilerplate and other oft-used text
          3. Entering hyperlinks
          4. Entering mathematical equations
        3. Applying text formatting
          1. Applying character formatting
          2. Applying paragraph formatting
          3. Using and managing fonts
          4. Copying formatting
        4. Using the Clipboard with Office programs
          1. Using Paste Options
          2. Managing multiple clippings with the Office Clipboard
        5. Finding and replacing text and formatting
        6. Checking spelling
          1. Correcting a single word
          2. Correcting spelling throughout a document
          3. Setting options for spelling correction
          4. Using custom dictionaries
        7. Using the thesaurus
        8. Setting language and regional options
        9. Translating text to another language
      5. 5. Working with Graphics and Pictures
        1. Working with drawing layers in Office documents
          1. Selecting graphics and pictures
            1. Selecting text boxes and WordArt
            2. Working with multiple graphics and pictures
          2. Positioning objects
            1. Aligning and evenly distributing objects
            2. Changing the Z-order of stacked objects
          3. Resizing and rotating graphics and pictures
          4. Grouping objects
        2. Inserting pictures into Office documents
        3. Making your pictures look great
          1. Cropping pictures
          2. Adjusting colors and applying artistic effects
          3. Applying picture styles
          4. Removing the picture background
          5. Undoing picture edits
        4. Finding and using online pictures
        5. Adding shapes and text boxes
        6. Adding SmartArt to documents
        7. Displaying data graphically with charts
        8. Capturing and inserting screenshots
        9. Applying text effects with WordArt
        10. Using Office themes
    5. 2. Office on the Desktop and in the Cloud
      1. 6. Managing Office Files
        1. Where (and how) Office stores files
          1. Custom options in the Save As dialog box
          2. Custom options in the Open dialog box
        2. Which file formats does Office 2013 support?
          1. Understanding the Office 2013 default formats: Office Open XML
          2. Setting a default file format
          3. Checking for compatibility with an earlier Office version
        3. Exporting files and data to alternative formats
        4. Using templates to streamline document creation
        5. Working with (and around) Office security features
          1. What you can and can’t do in Protected View
          2. Inspecting and removing personal and confidential information
          3. Fine-tuning security settings
        6. Organizing and finding Office files
        7. Backup and recovery options
      2. 7. Connecting Office 2013 to SkyDrive and Other Online Services
        1. What happens when you sign in with an Office account?
        2. Saving, sharing, and syncing Office documents with SkyDrive
          1. Using SkyDrive in a web browser
          2. Using SkyDrive from an Office program
          3. Synchronizing SkyDrive files with Windows
        3. Using Office Web Apps
        4. Editing a shared document in real time
      3. 8. Using Office 2013 with an Office 365 Subscription
        1. How Office 365 and Office 2013 work together
        2. Managing your Office 365 account
          1. Working with Office 365 Home Premium
          2. Working with Office 365 business plans
        3. Using Office on Demand
        4. Working with SkyDrive Pro
    6. 3. Word
      1. 9. Inside Word 2013
        1. What’s in a Word document?
        2. Working in an appropriate document view
          1. Read Mode
          2. Web Layout view
          3. Outline view
          4. Draft view
          5. Switching views and zooming
        3. Creating and editing documents
          1. Using tabs
          2. Inserting special characters
          3. Changing case
          4. Controlling line breaks and hyphenation
          5. Inserting the date, time, and document properties
        4. Navigating in Word documents
          1. Navigating within a document
          2. Working with multiple document windows
        5. Searching within a document
          1. Searching for nonstandard characters
          2. Including formatting in your search criteria
          3. Repeating a search
          4. Searching and replacing
        6. Making your documents look good
          1. Formatting text
          2. Formatting paragraphs
          3. Setting page layout options
          4. Adding headers, footers, and page numbers
        7. Giving your documents a consistent appearance
          1. Applying styles
          2. Making global changes to your document
          3. Tools for working with styles
          4. Creating a new style
          5. Applying a template to an existing document
          6. Saving and modifying templates
        8. Adding pictures and graphics
        9. Working with bulleted and numbered lists
        10. Checking grammar and spelling
      2. 10. Working with Complex Documents
        1. Using outlines to plan, organize, and edit documents
          1. Navigating in long documents
        2. Formatting columns and sections
          1. Creating a multicolumn layout
        3. Working with tables
          1. Creating a table
            1. Using the Insert Table command
            2. Drawing a table
            3. Converting text to a table
            4. Using Quick Tables
          2. Working with table data
            1. Selecting table data
            2. Sorting table data
            3. Using formulas in tables
          3. Formatting a table
            1. Aligning text
            2. Rotating text
            3. Adding borders and shading
            4. Applying styles
          4. Changing the table layout
            1. Adjusting column widths and row heights
            2. Adding and removing rows and columns
            3. Merging and splitting table cells
            4. Positioning a table
            5. Working with tables that span a page break
          5. Deleting a table
        4. Inserting references to other parts of a document
          1. Defining reference targets
            1. Creating captions for equations, figures, and tables
          2. Inserting a reference
        5. Creating tables of contents and indexes
          1. Inserting a table of contents
          2. Preparing and inserting an index
            1. Marking index entries
            2. Generating the index
        6. Using review comments in a document
          1. Inserting a comment
          2. Reviewing comments
          3. Printing comments
        7. Tracking and highlighting changes made to a document
          1. Changing view options
          2. Reviewing tracked changes
          3. Setting options for tracking changes
        8. Preparing a document for distribution
          1. Checking a document
          2. Protecting a document
      3. 11. Word 2013 Inside Out
        1. Applying advanced text-formatting capabilities
          1. Applying shadows, reflections, and other text effects
          2. Using ligatures and other fine typography effects
          3. Beginning a paragraph with a drop cap
          4. Understanding linked styles
        2. Using Word to create and edit blog posts
          1. Managing blog accounts
          2. Working with blog posts
        3. Inserting video
        4. Combining documents and data with mail merge
          1. Using the mail merge wizard
          2. Working with data files
          3. Inserting data fields in a document
          4. Previewing the merged output
          5. Completing the merge
        5. Using building blocks
          1. Using AutoText
          2. Creating other types of building blocks
        6. Using fields to automate documents
          1. Working with field codes
          2. Inserting a field
        7. Our favorite Word tweaks and tips
          1. Applying styles from the Quick Access Toolbar
          2. Customizing the Quick Access Toolbar and the status bar
          3. Installing and using apps for Word
          4. Reading document text aloud
          5. Creating a cover page
          6. Printing booklets
          7. Generating “greek” text
    7. 4. Excel
      1. 12. Inside Excel 2013
        1. What’s in an Excel workbook?
        2. Navigating in worksheets and workbooks
          1. Using cell addresses and range names
          2. Using keyboard shortcuts
        3. Entering and filling in data and series
        4. Using formulas and functions
          1. Creating and editing formulas
            1. Making comparisons
            2. Concatenating text
            3. Relative, absolute, and mixed references
            4. Controlling the order of calculation in a formula
          2. Adding functions to a formula
          3. Mastering Excel’s built-in functions
            1. Financial functions
            2. Date and time functions
            3. Text functions
            4. Logical functions
            5. Lookup and reference functions
            6. Statistical functions
            7. Math and trigonometry functions
            8. Engineering functions
            9. Information functions
        5. Formatting cells and ranges
          1. Number formats
          2. Currency and Accounting formats
          3. Date and Time formats
          4. Percentage formats
          5. Fraction formats
          6. Scientific formats
          7. Text formats
          8. Special formats
        6. Finding, editing, moving, and copying data
          1. Using the Clipboard to transform data
          2. Pasting text and formats into multiple worksheets
        7. Customizing the worksheet view
          1. Hiding rows and columns
          2. Arranging worksheet windows
          3. Splitting, freezing, and locking panes
      2. 13. Analyzing Data with Tables and Charts
        1. Sorting out your data analysis options
        2. Using tables to organize and analyze data
          1. Formatting tables with table styles
          2. Expanding (or shrinking) a table
          3. Adding totals and formulas to a table
        3. Sorting and filtering data
          1. Sorting a range, region, or table
          2. Filtering data in a table
        4. Using conditional formatting to highlight cells based on their content
        5. Using sparklines to visualize trends within a range
        6. Turning data into charts
          1. Choosing the right chart type
            1. Column charts
            2. Line charts
            3. Pie charts
            4. Bar charts
            5. Area charts
            6. Scatter (X, Y) charts
            7. Other chart types
          2. Changing a chart’s layout or design
          3. Linking worksheet data to chart elements
      3. 14. Excel 2013 Inside Out
        1. Customizing the default new workbook
        2. Using PivotTables
          1. Creating a PivotTable
          2. Customizing a PivotTable layout
          3. Filtering a PivotTable
          4. Changing the format of a PivotTable
        3. Manipulating text with functions
        4. Advanced worksheet formatting
          1. Creating custom cell formats
            1. Number format codes
            2. Date/Time format codes
            3. Text format codes
            4. Conditions
          2. Creating custom cell styles
        5. Printing a worksheet
          1. Adjusting print settings
          2. Defining a print area
          3. Adjusting page breaks
        6. Our favorite Excel tweaks and tips
          1. Navigating with the Go To dialog box
          2. Entering and sorting data with custom series
          3. Using online forms to collect survey data
          4. Generating random numbers
          5. Using data validation to control data entry
    8. 5. Outlook
      1. 15. Inside Outlook 2013
        1. What you can (and can’t) do with Outlook
          1. Email messages
          2. Appointments and meetings
          3. Contacts
          4. Tasks
          5. Notes and Journal entries
        2. Configuring an Outlook profile
        3. Connecting accounts to Outlook
          1. Using Internet-standard mail servers
          2. Configuring Office 365 and Exchange accounts
          3. Setting up an Outlook.com (Hotmail) account
          4. Getting Gmail and Google Apps to play nicely with Outlook
          5. Connecting to social networks
        4. Managing Outlook data files and folders
          1. Managing data files
          2. Using and managing folders
        5. Creating, sending, and receiving messages
          1. Choosing the right message format
        6. Receiving and synchronizing messages
      2. 16. Organizing Outlook Information
        1. Managing your calendar
          1. Creating and editing appointments and meetings
          2. Setting up recurring appointments and events
          3. Arranging multiple calendars
        2. Organizing your contacts
          1. Viewing and editing contacts in Business Card view
          2. Searching for contacts
          3. Using the Outlook address books
        3. Filtering and filing email messages automatically
          1. Configuring Quick Steps
          2. Using rules to manage messages automatically
        4. Mastering Outlook search
          1. Changing the scope of a search
          2. Adding criteria to a search
          3. Building search queries with keywords
          4. Creating and using search folders
      3. 17. Outlook 2013 Inside Out
        1. Personalizing the Outlook interface
          1. Docking your calendar, contacts, or tasks in the To-Do Bar
          2. Customizing the Folder pane
          3. Using the Reading pane
          4. Creating and saving custom views
          5. Viewing email conversations
        2. Setting follow-up flags and reminders
        3. Importing, exporting, and archiving Outlook data
          1. Importing and exporting Outlook items
          2. Cleaning up your mailbox
          3. Archiving Outlook data
        4. Our favorite Outlook tweaks and tips
          1. Dealing with duplicate contacts
          2. Adding and editing email signatures
          3. Juggling multiple time zones
          4. Managing Auto-Complete lists
          5. Changing default fonts for new email messages
          6. Sharing contact and calendar items
    9. 6. PowerPoint
      1. 18. Inside PowerPoint 2013
        1. What’s in a PowerPoint presentation?
        2. Working in an appropriate view
          1. Normal view
          2. Outline view
          3. Slide Sorter view
          4. Reading view
          5. Notes Page view
          6. Slide Show view
        3. Creating and editing a presentation
          1. Using slide layouts
          2. Creating a presentation from an outline
          3. Editing presentation text
          4. Using slide sections
          5. Setting page orientation and size
        4. Saving and sharing a presentation
        5. Adding graphics, video, and audio
          1. Working with objects
          2. Working with video
            1. Inserting video
            2. Playing video
            3. Editing video
          3. Working with audio
            1. Inserting audio
            2. Editing audio
          4. Working with tables
            1. Inserting a table
            2. Modifying a table
        6. Customizing your presentation’s design
          1. Formatting text
          2. Adding footers
          3. Applying themes
          4. Adding backgrounds
      2. 19. Polishing and Delivering a Presentation
        1. Enlivening a presentation with animations
          1. Adding animation
          2. Layering animation effects
          3. Setting animation order and timing
          4. Duplicating animations with Animation Painter
          5. Triggering an animation effect
          6. Setting additional effect options
        2. Using transitions between slides
        3. Planning and rehearsing a presentation
          1. Recording narration
          2. Setting presentation options
        4. Delivering a live presentation
          1. Navigating in Slide Show view
          2. Adding annotations during a slide show
          3. Turning your mouse into a laser pointer
          4. Zooming in for a closer view
        5. Working with Presenter view
        6. Creating notes and handouts
          1. Printing notes
          2. Printing handouts
          3. Setting color options
          4. Editing the handout header and footer
          5. Editing handouts in Word
      3. 20. PowerPoint 2013 Inside Out
        1. Sharing a presentation with others
          1. Delivering a live presentation online
          2. Turning your presentation into a video
          3. Creating a CD presentation package
        2. Working collaboratively on a presentation
          1. Using comments
          2. Merging and comparing presentations
        3. Saving and reusing slides and themes
          1. Reusing slides
          2. Saving themes
        4. Creating custom slide shows
          1. Hiding slides to create dynamic presentations
          2. Defining a custom show
        5. Laying the groundwork for an expert presentation
          1. Customizing the slide master
          2. Creating a custom layout
          3. Customizing other masters
        6. Our favorite PowerPoint tweaks and tips
          1. Creating a photo album with PowerPoint
          2. Inserting hyperlinks
          3. Inserting action buttons
          4. Embedding fonts in a presentation file
          5. Playing music behind your slides
          6. Creating custom bullets
    10. 7. OneNote
      1. 21. Inside OneNote 2013
        1. What’s in a OneNote notebook?
          1. Creating and opening OneNote files
        2. Filling a notebook with text, pictures, clippings, and more
          1. Text
            1. Text
            2. Lists
            3. Tables
            4. Web clippings
            5. Pictures
            6. Screen clippings
            7. Scanned images
            8. Ink
            9. Equations
            10. Email messages and other Outlook items
            11. File attachments
            12. Printouts
        3. Formatting text
        4. Navigating in OneNote
          1. Opening and moving between notebooks
          2. Working with sections and section groups
          3. Working with pages
          4. Using the Notebook Recycle Bin
        5. Customizing the look and feel of a notebook page
          1. Page title
            1. Page title
            2. Page color
            3. Rule lines
            4. Background image
            5. Paper size and margins
        6. Personalizing the OneNote interface
      2. 22. Tagging, Organizing, and Finding Information
        1. Using tags to highlight important notes
          1. Applying and removing tags
          2. Customizing tags
          3. Copying custom tags to another copy of OneNote
        2. Using links for quick connections
          1. Creating links to webpages or files
            1. Creating links to other places in OneNote
          2. Editing and removing links
        3. Smart search strategies
          1. Searching on a page
          2. Searching by section or notebook
          3. Reviewing recently modified pages
          4. Finding tagged notes
        4. Expert organizational techniques
        5. Backing up and recovering notebooks
      3. 23. OneNote 2013 Inside Out
        1. Using OneNote with Outlook
          1. Sending email messages to OneNote
          2. Linking Outlook contacts to OneNote pages
          3. Connecting appointments and meetings to OneNote
          4. Using Outlook tasks with OneNote
          5. Sending a OneNote page via email
        2. Linking notes to documents and webpages
        3. Sharing and synchronizing notebooks
        4. Printing, publishing, and sharing notes
        5. Recording audio and video
        6. Our favorite OneNote tweaks and tips
          1. Managing page versions
          2. Customizing the OneNote taskbar icon
          3. Using quick notes
          4. Converting printouts and pictures to text
          5. Saving and using custom page templates
          6. Using the immersive Windows Store app
    11. 8. Other Office Programs
      1. 24. Inside Publisher 2013
        1. Publisher vs. Word
        2. Creating a publication
          1. Inserting text
          2. Inserting graphics
          3. Inserting building blocks
        3. Working with pages
          1. Adding or deleting a page
          2. Formatting a page
            1. Size, margins, and orientation
            2. Layout guides
            3. Headers and footers
          3. Using master pages
        4. Applying themes
        5. Merging data
          1. Catalog pages
          2. Mailings
        6. Printing a publication
      2. 25. Inside Lync 2013
        1. What is Lync?
        2. Configuring Lync options
        3. Instant messaging and presence
        4. Telephony and videoconferencing
        5. Screen sharing and whiteboarding
      3. 26. Inside Access 2013
        1. Uses of a database management system
        2. Using Access web apps
          1. Creating an app
          2. Adding tables
          3. Creating and customizing views
          4. Adding data
        3. Using desktop databases
          1. Adding a table
          2. Adding data
          3. Using queries
          4. Working with forms
          5. Creating reports
          6. Automating with macros and modules
    12. A. Index of Troubleshooting Topics
    13. Index
    14. About the Authors
    15. Copyright