You are previewing Microsoft Office Professional 2013.
O'Reilly logo
Microsoft Office Professional 2013

Book Description

The smart way to learn Microsoft Office Professional 2013—one step at a time!

Experience learning made easy—and quickly teach yourself how to get more done with Microsoft Word, PowerPoint, Excel, Outlook, OneNote, Access, and Publisher. With Step by Step, you set the pace—building and practicing the skills you need, just when you need them!

  • Determine the best Office tool for specific tasks

  • Use Office efficiently on touch-enabled devices

  • Create attractive documents, publications, and presentations

  • Manage your e-mail, calendar, meetings, and communications

  • Put your business data to work with Excel and Access

  • Organize and share your notes and ideas with OneNote

  • Table of Contents

    1. Microsoft Office Professional 2013
    2. Dedication
    3. A Note Regarding Supplemental Files
    4. Introduction
      1. Who this book is for
      2. How this book is organized
      3. Download the practice files
      4. Your companion ebook
      5. Getting support and giving feedback
        1. Errata
        2. We want to hear from you
        3. Stay in touch
    5. I. Office Professional 2013 Fundamentals
      1. 1. Getting comfortable in Office Professional 2013
        1. Exploring the Office environment
        2. Working with Office files
        3. Recovering unsaved files and versions
        4. Customizing the user interface
          1. Customizing the Office environment
          2. Customizing the Quick Access toolbar
          3. Customizing the status bar
        5. Customizing the ribbon
        6. Choosing the right application for the task at hand
        7. Key points
      2. 2. Using shared Office features
        1. Identifying new shared features in Office Professional 2013
        2. Applying Office themes
        3. Inserting graphics, videos, charts, and diagrams
          1. Inserting charts
        4. Searching for online templates
        5. Presenting Office documents online
          1. Inserting online video
        6. Key points
      3. 3. Sharing and collaborating
        1. Defining the term cloud service
        2. Signing in and managing your Office account
        3. Connecting cloud services to your Office account
          1. Saving files on SharePoint Online and SkyDrive
          2. Sharing files with others from SharePoint Online or SkyDrive
          3. Opening files from the cloud
        4. Syncing files with SkyDrive for offline use
          1. Syncing with SkyDrive Pro
          2. Syncing with SkyDrive for a Microsoft account
        5. Getting started with co-authoring
        6. Key points
      4. 4. Using touch in Office
        1. Getting comfortable with Office on a tablet
          1. Looking at unsupported features
        2. Using touch mode
        3. Selecting content with touch
        4. Working with ink in Office
        5. Key points
    6. II. Word 2013
      1. 5. Getting comfortable in Word 2013
        1. Exploring the Word 2013 user interface
        2. Modifying your document view
        3. Changing other view options
        4. Discovering what’s new in Word 2013
        5. Key points
      2. 6. Navigating and reading documents
        1. Navigating a document by scrolling and using keyboard shortcuts
        2. Searching and navigating a document by using the Navigation pane
        3. Collapsing and expanding document content
        4. Working with documents in the new Read Mode
        5. Exploring research tools in Read Mode
        6. Key points
      3. 7. Editing and composing documents
        1. Moving the cursor by using keyboard shortcuts
        2. Selecting text by using the keyboard and mouse
          1. Selecting text by using the keyboard
          2. Selecting text by using the mouse
          3. Using other selection methods
        3. Using formatting marks during document composition
        4. Inserting symbols, international characters, and other special characters
          1. Inserting special characters
        5. Using AutoCorrect
        6. Composing documents faster by using building blocks
        7. Key points
      4. 8. Formatting documents
        1. Formatting documents more efficiently
        2. Setting default document formatting for your documents
        3. Setting section formatting
        4. Using styles for paragraph and character formats
        5. Exploring other paragraph formats
        6. Exploring other character formats
          1. Changing case
        7. Managing pagination through formatting
        8. Key points
      5. 9. Presenting information
        1. Formatting simple lists by using bullets and numbering
        2. Creating tabbed lists
        3. Inserting tables
        4. Enhancing tables
        5. Key points
      6. 10. Finalizing documents
        1. Correcting proofing errors
        2. Inspecting documents before publishing
        3. Marking documents as final
        4. Creating PDF files in Word
          1. Converting PDF files for editing
        5. Printing documents
        6. Key points
    7. III. PowerPoint 2013
      1. 11. Getting comfortable in PowerPoint 2013
        1. Getting started working with PowerPoint 2013
        2. Exploring the PowerPoint 2013 tools
        3. Discovering the new features in PowerPoint 2013
        4. Key points
      2. 12. Designing and creating presentations
        1. Creating a new presentation based on a theme or template
        2. Applying a theme to an existing presentation
        3. Customizing your file with colors, fonts, and effects
          1. Theme fonts
          2. Theme colors
        4. Applying theme effects to your presentation
          1. Applying background styles to your presentation
          2. Formatting placeholders on the slide master
        5. Adding graphics to the slide master and layouts
        6. Creating a custom slide layout
        7. Changing your presentation from a 16:9 to a 4:3 format
        8. Key points
      3. 13. Creating on-slide content
        1. Choosing a slide layout and adding text in placeholders
        2. Adding manual text boxes
        3. Adding and formatting a table
        4. Inserting and formatting charts
        5. Creating and formatting SmartArt diagrams
        6. Reusing slides and keeping their source formatting
        7. Key points
      4. 14. Creating Office graphics
        1. Adding and formatting shapes
        2. Applying enhanced fills and effects
        3. Creating your own shapes
        4. Inserting, cropping, and formatting pictures
        5. Key points
      5. 15. Adding animation and multimedia
        1. Adding animation to text and shapes
        2. Editing video and applying transitions
        3. Inserting and playing online video
        4. Saving your presentation as a video
        5. Key points
      6. 16. Finalizing and presenting
        1. Adding and renaming sections
        2. Inserting comments
        3. Printing slides and notes
        4. Finalizing your presentation
        5. Delivering a presentation
        6. Practicing with Presenter view
        7. Key points
    8. IV. Excel 2013
      1. 17. Getting comfortable in Excel 2013
        1. Starting Excel 2013
        2. Identifying what’s new in Excel 2013
          1. Using the new features in Excel
          2. Other enhancements, improvements, and feature upgrades
        3. Key points
      2. 18. Creating and editing worksheets
        1. Entering and organizing data
        2. Changing column widths
        3. Using formatting to alter the appearance of data
        4. Extending a series with AutoFill
          1. Introducing Flash Fill
        5. Selecting and naming cell ranges
        6. Using column headers to define names
        7. Moving around in the worksheet
        8. Moving and adjusting cells
        9. Moving and copying rows and columns
        10. Copying one or more cells to many
        11. Key points
      3. 19. Manipulating numbers and text
        1. Creating, editing, and copying formulas
        2. Using functions
          1. Using the AutoSum button and built-in function
          2. Inserting functions
          3. Using relative, fixed, and mixed cell references
          4. Using names in formulas and validating cell entries
          5. Looking at useful functions
            1. Handy math and trig functions
            2. Handy logical functions
            3. Handy text functions
            4. Handy date and time functions
            5. Handy lookup and reference functions
            6. Handy financial functions
        3. Working with text in Excel
          1. Combining text from multiple cells into one string
          2. Removing extra spaces
          3. Copying cells containing formulas and pasting only their resulting values
          4. Changing the case of text
        4. Restricting cell entries
        5. Key points
      4. 20. Analyzing data
        1. Exploring a built-in template
        2. Performing what-if analyses
          1. Managing multiple what-if models
        3. Using the Quick Analysis tools
        4. Formatting conditionally
        5. Analyzing data from another source
        6. Filtering data with tables
          1. Filter menu commands
        7. Adding data to tables
        8. Sorting data
        9. Creating a custom sort list
        10. Creating a PivotTable
        11. Key points
      5. 21. Formatting worksheets
        1. Applying number formatting
        2. Formatting with styles
        3. Creating custom themes
        4. Formatting in cells
        5. Working with custom number formats
        6. Working with percentage formats
        7. Working with fraction formats
        8. Working with date formats
        9. Protecting worksheets
        10. Setting view options
        11. Storing formats in templates
        12. Key points
      6. 22. Manipulating workbooks and worksheets
        1. Inserting rows and columns
        2. Inserting and deleting cells
        3. Working with panes and page layout options
        4. Printing row and column labels on every page
        5. Adjusting page breaks
        6. Creating a multisheet workbook
        7. Manipulating sheets
        8. Summarizing a multisheet workbook
        9. Working with sheet references
        10. Managing multiple workbooks
        11. Key points
      7. 23. Creating charts and graphics
        1. Creating and modifying a chart
        2. Adding a slicer to a PivotChart
          1. Manipulating chart elements
        3. Adding a timeline to a chart
        4. Manipulating objects
        5. Creating and sharing graphics
          1. Using graphics elsewhere
        6. Key points
    9. V. Outlook 2013
      1. 24. Getting comfortable in Outlook 2013
        1. Setting up an email account in Outlook
        2. Navigating the Outlook interface
        3. Discovering what’s new in Outlook 2013
        4. Key points
      2. 25. Using mail
        1. Creating and sending messages
          1. Addressing messages
          2. Saving and sending messages
        2. Attaching files to messages
        3. Viewing messages and message attachments
        4. Configuring Reading pane behavior
          1. Viewing Reading pane content
          2. Marking messages as read
          3. Single-key reading
          4. The People pane
        5. Responding to messages
          1. Inline replies
        6. Key points
      3. 26. Staying on schedule
        1. Scheduling and changing appointments
          1. Using Quick Entry mode to create date-specific events
          2. Creating recurring appointments and using appointment features
          3. Creating appointments from messages
          4. Configuring a Quick Step to create an appointment from an email message
        2. Scheduling and changing meetings
          1. Updating and canceling meetings
        3. Responding to meeting requests
        4. Displaying different views of a calendar
          1. Views
          2. Arrangements
        5. Using the Date Navigator
          1. Calendar item peeks
        6. Key points
      4. 27. Working with tasks
        1. Creating tasks from scratch
        2. Setting task options
        3. Creating tasks from Outlook items
        4. Updating tasks
        5. Removing tasks and items from task lists
        6. Managing task assignments
        7. Reclaiming an assigned task
        8. Dealing with tasks other people assign to you
        9. Key points
      5. 28. Managing contacts and people
        1. Viewing contacts
          1. Using the People Hub
          2. Viewing Contact Cards
          3. Using contact views
          4. Using the People peek
          5. Creating contacts
        2. Using inline editing
        3. Managing linked contacts
        4. Configuring a social network account
        5. Viewing social network updates
        6. Key points
      6. 29. Saving time with Outlook
        1. Flagging and reviewing important messages
          1. Applying a message flag
          2. Categorizing a message
          3. Creating a high-priority Quick Step
          4. Reviewing high-priority messages
        2. Using the Calendar peek to plan your schedule
        3. Planning ahead with the Weather bar
        4. Organizing your mail with Folder Favorites
          1. Rearranging key folders
        5. Searching for related messages
        6. Finding messages from a specific sender
        7. Conducting quick searches
        8. Using Search Folders to view today’s mail
        9. Creating items quickly
        10. Creating contextual appointments, contacts, and tasks from email messages
        11. Key points
    10. VI. OneNote 2013
      1. 30. Getting comfortable in OneNote 2013
        1. Getting started with OneNote 2013
        2. Exploring the OneNote interface
        3. Identifying new and improved features in OneNote 2013
        4. Key points
      2. 31. Working with notebooks, sections, and pages
        1. Creating a notebook
        2. Creating and organizing sections
          1. Section groups
        3. Creating and organizing pages
          1. Creating subpages
          2. Adding and organizing notes
          3. Inserting images
        4. Working with ink and shapes
          1. Custom pens
          2. Shapes
          3. Erasing ink or shapes
          4. Inserting space
          5. Arranging shapes
        5. Recovering deleted sections or pages
        6. Key points
      3. 32. Using organizational tools
        1. Using tags
        2. Creating and customizing tags
        3. Using styles to format your notes
        4. Connecting OneNote to Outlook
          1. Sending email messages to OneNote
          2. Connecting appointments to OneNote
          3. Annotating contacts
        5. Connecting OneNote tasks to Outlook
        6. Using hyperlinks to tie your notes together
        7. Creating custom hyperlinks to other pages
        8. Creating and organizing tables
        9. Using the Insert Table feature
        10. Searching your notes to find information quickly
        11. Changing your search scope
        12. Key points
      4. 33. Sharing notes with others
        1. Creating a new notebook on SkyDrive
        2. Moving a notebook to SkyDrive
          1. Stopping sharing in SkyDrive
        3. Using a file server to share notes
          1. Stopping sharing on a file server
        4. Sharing notes via SharePoint
        5. Sharing notes with others during a meeting
        6. Sending notes via email
        7. Exporting to other formats
        8. Key points
      5. 34. Using OneNote everywhere
        1. Syncing your notes by using SkyDrive
        2. Accessing your notes in a web browser
        3. Using OneNote on your phone or tablet
        4. Using OneNote on an iPhone or iPad
        5. Using OneNote Mobile for Android
        6. Using OneNote Mobile on a Windows Phone
        7. Using OneNote with a Windows 8 tablet
        8. Key points
      6. 35. Saving time with OneNote
        1. Finding tags
        2. Recording audio
        3. Using Quick Notes
        4. Using screen clipping
        5. Using linked notes
        6. Searching your images
        7. Inserting a spreadsheet
        8. Using the Napkin Math feature
        9. Formatting with templates
        10. Key points
    11. VII. Access 2013
      1. 36. Getting comfortable in Access 2013
        1. Starting Access 2013
        2. Looking at the desktop database window
        3. Exploring the Web App window
        4. Displaying results in a browser
        5. Discovering what’s new in Access 2013
        6. Key points
      2. 37. Understanding Access 2013 databases
        1. Creating a desktop database
          1. Managing trust locations and macro security
        2. Importing and exporting data
          1. Importing from another Access database
          2. Exporting data from an Access database
        3. Navigating the user interface
          1. Working with the tabs
        4. Working with data in a datasheet
          1. Sorting a datasheet
          2. Filtering a datasheet
          3. Adjusting the presentation of a datasheet
          4. Working with a subdatasheet
        5. Copying and pasting from a datasheet
          1. Changing between tab pages and overlapping windows
        6. Configuring Access options
        7. Linking Access to external data
          1. Linking to data in Excel
        8. Compacting, repairing, and encrypting a database
          1. Encrypting with a password
        9. Key points
      3. 38. Creating basic tables and queries
        1. Creating tables for your data
          1. Creating a table in Datasheet view
          2. Choosing a field data type
        2. Adding validation and calculated fields to your tables
          1. Adding a table validation rule
          2. Adding a calculated field
          3. Indexing a table
        3. Linking tables together with relationships
          1. Creating a manual relationship
        4. Creating a select query
          1. Creating a query by selecting specific fields
          2. Joining multiple tables in a query
        5. Working with query criteria
          1. Filtering and sorting a field
          2. Adding multiple criteria to a query
        6. Adding parameters to queries
        7. Working with totals and crosstab queries
          1. Crosstabulating data
        8. Key points
      4. 39. Designing forms and reports
        1. Creating a continuous form
          1. Working with a form in Layout view
          2. Creating a datasheet with conditional formatting
        2. Creating a single record form
          1. Creating a single record form by using the Split Form template
        3. Creating a parent/child form
          1. Creating a parent/child pop-up form by using the Form Wizard
        4. Tying your forms together with a navigation form
        5. Creating a single record report
        6. Creating a tabular report with grouping
          1. Creating a continuous report with conditional formatting
        7. Creating a parent/child report
        8. Key points
      5. 40. Creating and sharing a Web App
        1. Signing in to Office 365
        2. Creating a blank Web App
        3. Opening an existing Web App
        4. Importing data from a spreadsheet
        5. Importing data from an Access desktop database
        6. Navigating a Web App with the table selector
        7. Navigating a Web App with the Navigation pane
        8. Launching a Web App
        9. Opening a database in Access from Team Site
        10. Working with views
        11. Working with a Datasheet view
        12. Working with a List Details view
        13. Adding a new blank table
        14. Creating a lookup
        15. Creating a summary view
        16. Creating a Web App from a template
        17. Key points
    12. VIII. Publisher 2013
      1. 41. Getting comfortable in Publisher 2013
        1. Exploring the Publisher 2013 user interface
        2. Discovering what’s new in Publisher 2013
        3. Key points
      2. 42. Creating publications
        1. Using templates to create publications
        2. Adding elements into your publications
        3. Adding business information to publications
        4. Customizing the page design of a publication
        5. Customizing text font, color, and style
        6. Working with WordArt, text effects, and stylistic sets
        7. Using picture placeholders and captions
        8. Importing, swapping, and formatting pictures
        9. Working with rulers, guides, baselines, and other tools
        10. Importing Word documents into Publisher
        11. Key points
      3. 43. Saving, sharing, and exporting publications
        1. Saving your publications
        2. Sharing publications via email
        3. Printing your publications
        4. Saving for photo printing or commercial printing
        5. Exporting publications to PDF or XPS format
        6. Key points
    13. A. About the authors
    14. Index
    15. About the Authors
    16. Copyright