You are previewing Microsoft® Office® Professional 2013 Plain & Simple.
O'Reilly logo
Microsoft® Office® Professional 2013 Plain & Simple

Book Description

Learn the simplest ways to get things done with Microsoft Office 2013

Get the full-color, visual guide that makes learning Microsoft Office 2013 plain and simple! Follow the book’s easy steps and screenshots and clear, concise language to learn the simplest ways to get things done with Microsoft Word, Excel, Outlook, PowerPoint, Access, Publisher, and OneNote.

Here’s WHAT you’ll learn:

  • Navigate with mouse, keyboard, or touch

  • Create documents, reports, databases, and presentations

  • Share your desktop, worksheets, and files

  • Manage your email and organize your calendar

  • Stay connected with online meetings and instant messaging

  • Access your programs and your documents via the cloud

  • Here’s HOW you’ll learn it:

  • Jump in wherever you need answers

  • Follow easy STEPS and SCREENSHOTS to see exactly what to do

  • Get handy TIPS for new techniques and shortcuts

  • Use TRY THIS! Exercises to apply what you learn right away

  • Table of Contents

    1. Special Upgrade Offer
    2. Acknowledgments
    3. 1. About this book
      1. Plain talk about Office 2013
      2. The Plain & Simple approach
      3. What’s new in Office 2013
      4. Which editions of Office 2013 are available?
      5. What you’ll find in this book
      6. A few assumptions
      7. Before we begin
      8. Adapting task procedures for touchscreens
    4. 2. Getting started with Office 2013
      1. Launching Office 2013
        1. Start Office apps from the Windows 8 Start screen
        2. Launch Office 2013 in Windows 7
      2. Adding Office 2013 to the Windows 8 desktop
        1. Add Office 2013 to the Windows 8 desktop
        2. Exploring the look and feel of Office 2013
        3. Learning the Office 2013 screen
      3. Using the ribbon
        1. Use the ribbon
      4. Displaying minibars
        1. Display minibars
      5. Changing the ribbon display
        1. Change ribbon options
      6. Going backstage
        1. Use the Backstage view
    5. 3. Office 2013 by touch, mouse, and keyboard
      1. Navigating Office 2013
      2. The givens for navigating in Office 2013
      3. Pointing and clicking by using the mouse or trackpad
        1. Point and click
      4. Selecting and dragging text
        1. Dragging to select text
      5. Right-clicking to access related options
        1. Right-click for more options
      6. Using the scrollbar
        1. Scroll the screen
      7. Navigating the ribbon with the keyboard
        1. Navigate the ribbon with the keyboard
        2. Using key combinations
      8. Creating your own keyboard shortcuts
        1. Create your own keyboard shortcuts
        2. Exploring touch techniques
      9. Turning on touch mode
        1. Turn on touch mode
      10. Single-tapping to select an item
        1. Single-tap the screen
      11. Tapping and holding an item
        1. Tap and hold
        2. Choose your keyboard
      12. Swiping the screen to view content
        1. Swipe the screen
      13. Spreading and pinching to enlarge and reduce content
        1. Zoom in and out
    6. 4. Accomplishing basic tasks in Office 2013
      1. Launching apps
        1. Launch an app
      2. Choosing an Office background and theme
        1. Choose a background
        2. Select an Office theme
      3. Adding services
        1. Add services
        2. Changing services
      4. Managing your Office 2013 account
        1. Manage your account
        2. Setting program options
      5. Getting help
        1. Get help
      6. Moving among open apps
        1. Move among open apps
      7. Docking apps
        1. Dock apps on the screen
      8. Adding Office apps to the Windows 8 taskbar
        1. Add apps to the Windows 8 taskbar
      9. Using app jump lists
        1. Use jump lists
      10. Opening new files
        1. Open a new file
      11. Opening existing files
        1. Open an existing file
      12. Saving files to the cloud
        1. Save to the cloud
        2. Add a place to save
      13. Saving files on your computer or device
        1. Save files on your computer or device
      14. Closing files
        1. Close a file
      15. Exporting files
        1. Export a file
      16. Previewing and printing files
        1. Preview and print files
      17. Changing view controls
        1. Work with view controls
      18. Protecting files
        1. Mark a file as final
        2. Save a file with a password
      19. Sharing files
        1. Invite others to share your file
      20. Sending files via email
        1. Emailing files
    7. 5. Creating and saving a Document in Word 2013
      1. Getting started with Word 2013
        1. Open the Word 2013 Start screen
        2. Tour the Word window
      2. Creating documents
        1. Start with a blank document
        2. Start with a template
      3. Opening existing documents
        1. Open an existing document
      4. Adding text to your document
        1. Enter text
      5. Changing the view
        1. Change the view
        2. Use Read Mode
      6. Inserting pictures
        1. Insert a picture
      7. Editing pictures
        1. Edit a picture
        2. Flow text around a picture
      8. Making simple text edits
        1. Edit text
        2. Find and replace text
      9. Correcting misspellings
        1. Correct Misspelled Words
        2. Customizing spelling checks
      10. Formatting text
        1. Format selected text
        2. Add a bulleted or numbered list
      11. Inserting tables
        1. Create and modify tables
      12. Adding text boxes
        1. Add a text box
        2. Adding apps for Office
      13. Adding and playing online video
        1. Add and play online video
    8. 6. Formatting your content in Word 2013
      1. Understanding design tools in Word 2013
        1. Themes
        2. Style sets
        3. Styles
        4. Why use styles?
      2. Choosing a theme
        1. Select a theme for your document
      3. Choosing and saving a style set
        1. Choose and save a style set
      4. Adjusting the colors of your document
        1. Adjust the document color
      5. Selecting fonts
        1. Select a font
      6. Saving a new theme
        1. Save a theme
      7. Applying styles
        1. Apply a style to text
        2. Work with the style pane
      8. Modifying styles
        1. Modify a style
      9. Creating a new style
        1. Create a new style
      10. Managing styles
        1. Organize your styles
      11. Using the Style inspector
        1. Use the Style inspector
      12. Formatting and spacing paragraphs
        1. Choose paragraph alignment
        2. Control paragraph spacing
      13. Working with tabs, indents, and margins
        1. Display the ruler
        2. Add tabs
      14. Indenting your content
        1. Indent your content
      15. Adding a border
        1. Add a border to a page
    9. 7. Collaborating with Word 2013
      1. A bird’s-eye-view of the collaboration features in Word
      2. Co-authoring in the cloud
        1. Open a shared document
      3. Working collaboratively in a document
        1. Work collaboratively in a document
        2. Contact your co-author while you work
      4. Opening and editing PDF files
        1. Open a PDF file
        2. Save the PDF file
      5. Tracking document changes
        1. Turn on track changes
        2. Lock tracking
        3. Show and hide the Reviewing pane
      6. Turning on Simple Markup
        1. Turn on and use Simple Markup
        2. Choose the markup you want to see
      7. Adding and responding to comments
        1. Add a comment
        2. Respond to a comment
        3. Delete a comment
      8. Accepting or rejecting changes
        1. Navigate to changes
        2. Accept changes
        3. Reject changes
      9. Presenting your document online
        1. Get ready to present
        2. Present your document
        3. Sharing and taking notes while you present
      10. Setting up a blog
        1. Set up your blog
      11. Publishing content to your blog
        1. Post to a blog
        2. Add images to your blog post
      12. Comparing and combining documents
        1. Compare two document versions
        2. Combine documents
      13. Restricting document editing
        1. Restrict editing
        2. Choose the styles allowed in restricted formatting
    10. 8. Creating long documents in Word 2013
      1. Inserting page numbers
        1. Add page numbers
        2. Format page numbers
        3. Remove page numbers
      2. Adding headers and footers
        1. Choose a header or footer from the gallery
        2. Create a header or footer from scratch
      3. Working with headers and footers
        1. Move among headers and footers in your document
        2. Change the header and footer display
      4. Creating sections
        1. Insert a section break
        2. View section breaks
        3. Remove a section break
      5. Choosing columns
        1. Create columns
        2. Change column width and spacing
      6. Adding footnotes and endnotes
        1. Insert a footnote
        2. Add an endnote
        3. Format footnotes and endnotes
      7. Working with footnotes and endnotes
        1. Navigate footnotes and endnotes
        2. Show your notes
      8. Creating sidebars and pull quotes
        1. Add a sidebar or pull quote
      9. Inserting a table of contents
        1. Add a table of contents
        2. Remove the table of contents
        3. Create a custom table of contents
      10. Preparing a mail merge
        1. Start a mail merge
        2. Enter your recipient list
        3. Use an existing recipient list
        4. Edit the recipient list
      11. Creating the mail merge document
        1. Create the merge document and insert fields
        2. Preview the merge
        3. Complete the merge
        4. What are Quick Parts?
    11. 9. Creating and saving worksheets in Excel 2013
      1. Getting started with Excel
        1. Launch Excel in Windows 8
        2. Explore the Excel window
      2. Starting a new workbook from the Start screen
        1. Create a blank workbook
        2. Start a worksheet from a template
      3. Entering worksheet data
        1. Type new data
        2. Enter data by using Flash Fill
        3. Flash Fill is a little bit of Excel magic
      4. Importing worksheet data
        1. Import worksheet data
      5. Editing your data
        1. Navigate the worksheet by using the keyboard
        2. Navigate the worksheet by touch
        3. Edit your data
        4. Move data by using the mouse
        5. Move data by touch
        6. Copy and paste data
      6. Adding a new worksheet to the workbook
        1. Add a blank worksheet
      7. Creating a new worksheet from a template
        1. Create a new worksheet from a template
      8. Creating charts
        1. Add a new chart
        2. Use recommended charts
      9. Modifying charts
        1. Choose a different chart style
        2. Change the chart type
      10. Adding and formatting chart elements
        1. Add chart elements
        2. Format chart elements
        3. Filter chart data
      11. Saving and protecting a workbook
        1. Protect the current sheet
        2. Add a password
        3. Mark the workbook as final
      12. Sharing a workbook
        1. Share your workbook with others
        2. Present the workbook online
      13. Tracking workbook changes
        1. Turn on Track Changes
        2. Review changes
      14. Commenting on a workbook
        1. Insert a comment
        2. Delete a comment
      15. Exporting a workbook
        1. Create a PDF of your worksheet
        2. Export the workbook in other file types
    12. 10. Formatting and enhancing an Excel 2013 worksheet
      1. Choosing a theme
        1. Apply a theme
        2. Modify and save a custom theme
      2. Formatting worksheet cells
        1. Format selected cells
        2. Format numbers
        3. Adjust column width
        4. Adjust row height
      3. Adding images
        1. Insert a picture file
        2. Search for clip art
      4. Adding and deleting columns and rows
        1. Insert a column
        2. Insert a row
        3. Remove a column or row
        4. Delete selected content
      5. Adding a background image
        1. Add a background image
      6. Hiding and displaying information
        1. Hide columns or rows
        2. Reveal hidden columns or rows
      7. Working with multiple worksheets
        1. Change the order of worksheets
        2. Remove a worksheet
        3. Select multiple worksheets
        4. Enter and format data on several worksheets at one time
      8. Previewing and printing worksheets
        1. Set up your page for printing
        2. Preview your worksheet
      9. Printing your worksheets
        1. Choose the print area
        2. Print the worksheet
    13. 11. Analyzing your Excel 2013 data
      1. Using conditional formatting to showcase data trends
        1. Highlight data results
        2. Display data bars
        3. Add icon sets
      2. Adding sparklines
        1. Create sparklines
        2. Edit sparklines
      3. Understanding Excel formulas and functions
        1. Learning about cell references
        2. Understanding formulas and functions
      4. Performing common calculations
        1. Do a basic calculation
        2. Use the Sum tool for common calculations
      5. Subtotaling data values
        1. Subtotal data values
      6. Entering formulas
        1. Type a formula
      7. Troubleshooting formulas
        1. Check for formula errors
      8. Working with functions
        1. Find the function you want
        2. Add function arguments
      9. Creating and modifying data tables
        1. Create an Excel table
        2. Name an Excel table
        3. Resize an Excel table
      10. Sorting data
        1. Do a simple sort
        2. Create a custom sort
      11. Filtering worksheet data
        1. Filter selected data
        2. Use a slicer to filter a table
      12. Creating PivotTables
        1. Create a recommended PivotTable
        2. Create a PivotTable
      13. Viewing data instantly with Quick Analysis
        1. Apply Quick Analysis
    14. 12. Creating a presentation in PowerPoint 2013
      1. Getting started with PowerPoint 2013
        1. Launch PowerPoint in Windows 8
        2. A look at the PowerPoint Window
      2. Starting a new presentation from the Start screen
        1. Start a blank presentation
        2. Start a presentation from a template
      3. Opening an existing presentation
        1. Open an existing file
      4. Choosing themes and variants
        1. Apply a theme
        2. Choose a variant
      5. Changing the slide background
        1. Change the slide background
      6. Adding text to slides
        1. Add slide text
      7. Adding new slides
        1. Insert a new slide
        2. Change a slide layout
      8. Inserting pictures
        1. Add a picture from your computer or the cloud
        2. Add an online picture
      9. Editing pictures
        1. Apply a picture style
        2. Correct picture sharpness and contrast
      10. Aligning elements by using Smart Guides
        1. Align elements
      11. Merging shapes
        1. Merge shapes on a slide
      12. Adding and editing video
        1. Insert a video
        2. Edit your video
      13. Adding sound to your presentation
        1. Record presentation audio
      14. Adding transitions
        1. Choose a transition
      15. Animating slide elements
        1. Animate a slide element
        2. Set timing and reorder animations
    15. 13. Collaborating and finishing your presentation in PowerPoint 2013
      1. Commenting on a presentation
        1. Add a comment
        2. Respond to a comment
        3. Navigate comments
      2. Sharing your presentation with colleagues
        1. Invite others to share your presentation
        2. Email the presentation to others
      3. Co-authoring presentations in real time
        1. Open a shared presentation
        2. Co-author a presentation
      4. Previewing your presentation
        1. Preview your presentation
        2. Reorder slides in Slide Sorter view
      5. Timing the presentation
        1. Time the presentation
      6. Incorporating speaker notes
        1. Add speaker notes
        2. Create notes pages
      7. Printing presentation materials
        1. Print slides
        2. Prepare handouts
      8. Presenting live
        1. Display Presenter View
        2. Use Presenter View
      9. Navigating your presentation
        1. Use the navigation grid
        2. Focus audience attention with slide zoom
      10. Packaging your presentation
        1. Package your presentation
        2. Publish your slides
      11. Saving your presentation as a video
        1. Create a video
      12. Broadcasting your presentation online
        1. Present your presentation online
    16. 14. Managing and sharing notes in OneNote 2013
      1. Getting started with OneNote 2013
        1. Launch OneNote 2013
        2. Explore the OneNote window
      2. Creating a notebook
        1. Start a new notebook
      3. Opening existing notebooks
        1. Open a notebook from SkyDrive
        2. Open a notebook from your computer
      4. Setting up your notes pages
        1. Create a new page based on a template
        2. Add lines to the page
      5. Adding notes
        1. Add a note
        2. Draw notes
      6. Formatting notes
        1. Add simple formatting
        2. Apply styles
      7. Tagging notes
        1. Tag your note content
        2. Find tagged notes
      8. Inserting pictures
        1. Insert pictures
        2. Insert online pictures
      9. Recording audio and video notes
        1. Record audio
        2. Record video
      10. Inviting others to share your notebook
        1. Invite others to share your notebook
        2. Send a link to your notebook
      11. Sharing notebooks in a meeting
        1. Share your notebook in a meeting
      12. Searching for notes
        1. Search for note content
    17. 15. Stay in touch with Outlook 2013
      1. Launching Outlook 2013
        1. Start Outlook
      2. Looking around the Outlook window
        1. Mail
        2. Calendar
        3. People
        4. Tasks
      3. Tweaking the Outlook window
        1. Change the Outlook window
      4. Setting up mail accounts
        1. Set up a mail account
      5. Reading and responding to messages
        1. Read and reply to a message
      6. Using Quick Steps to manage mail
        1. Set up and use a Quick Step
      7. Flagging mail for follow-up
        1. Flag mail
        2. Add a reminder
      8. Categorizing your mail
        1. Categorize your email
        2. Use Quick Click categories
      9. Working with mail folders
        1. Organize your mail by using folders
        2. Move mail to the new folder
      10. Creating email signatures
        1. Create a signature
        2. Add the signatures to a message
    18. 16. Keeping your calendar current
      1. Working in the calendar window
        1. Navigate the calendar
        2. Search your calendar
      2. Creating appointments
        1. Add a calendar entry quickly
        2. Create an appointment
      3. Creating meetings
        1. Create meeting invitations
      4. Scheduling recurring appointments
        1. Create a recurring item
      5. Creating and joining online meetings
        1. Create online meetings
        2. Join an online meeting
      6. Working with calendar views
        1. Customize the calendar display
        2. Change the layout of the calendar window
      7. Using the To-Do Bar
        1. Use the To-Do Bar
        2. Add favorites to the To-Do Bar
      8. Working with team calendars
        1. Open a calendar
        2. Merge shared calendars
      9. Creating and using calendar groups
        1. Save a calendar group from existing calendars
        2. Create a new calendar group
      10. Setting calendar options
        1. Set calendar options
      11. Sending your calendar by email
        1. Send a calendar by email
    19. 17. Managing people, tasks, and notes in Outlook 2013
      1. Adding new contacts
        1. Add a new contact
      2. Editing contacts
        1. Edit a contact
      3. Adding contact groups
        1. Add a contact group
        2. Add new members to the group
      4. Working with People view
        1. Display contacts in People view
      5. Finding contacts
        1. Find a contact
      6. Creating a new task
        1. Create a task
        2. Set task properties
      7. Assigning a task
        1. Assign a task
      8. Marking a task completed
        1. Mark a task as complete
      9. Creating and viewing notes
        1. Create a note
        2. Change the way notes are displayed
    20. 18. Make contact now with Lync 2013
      1. Signing in to Lync
        1. Start Lync 2013
        2. Personalize your sign in
      2. Getting started with Lync
        1. Display and work with the Lync menu bar
        2. Use the Quick Lync bar
      3. Personalizing your Lync information
        1. Update your status
        2. Set your availability
        3. Specify your location
        4. Set your Lync preferences
      4. Adding contacts
        1. Create a contact group
        2. Add a new contact
      5. Adding external contacts
        1. Add an external contact
        2. View a contact card
      6. Viewing and finding contacts
        1. View your contacts
        2. Find a contact
      7. Having instant conversations
        1. Send an instant message
      8. Making phone calls with Lync
        1. Set up your audio device
        2. Make a Lync call
      9. Making video calls with Lync
        1. Set up your video device
        2. Make a video call
    21. 19. Creating publications with Publisher 2013
      1. Launching Publisher 2013
        1. Launch Publisher
        2. Create a blank publication
      2. Choosing a template
        1. Start a new publication based on a template
      3. Modifying the publication
        1. Modify the publication
      4. Setting up pages
        1. Choose page setup options
        2. Insert pages
      5. Adding and importing text
        1. Add new text
        2. Import text
      6. Linking text boxes
        1. Link text boxes
      7. Formatting text
        1. Format text
      8. Adding pictures
        1. Insert a picture
      9. Editing and adding style to pictures
        1. Edit a picture
        2. Add a picture style
      10. Inserting tables
        1. Add a table
        2. Format a table
      11. Arranging and grouping page elements
        1. Arrange objects
        2. Group page elements
      12. Finalizing your publication
        1. Run the Design Checker
        2. Preview and print your publication
    22. 20. Creating a desktop database with Access 2013
      1. Starting Access 2013
        1. Start Access
        2. Use the Start screen
      2. Creating a new desktop database
        1. Create a blank desktop database
        2. Start a database from a template
      3. Preparing your data table
        1. Create a new data table
        2. Add fields to your table
      4. Adding your data
        1. Add data to a datasheet
      5. Importing data
        1. Import data
      6. Creating table relationships
        1. Define a relationship
      7. Creating a simple form
        1. Create a data form
        2. Modify a form
      8. Creating reports
        1. Use the Report Wizard
    23. 21. Creating a web app with Access 2013
      1. Creating a new web app
        1. Start a web app from a template
        2. Create a blank web app
      2. Adding tables
        1. Search and find a table
        2. Add a blank table
      3. Editing a data table
        1. Edit the table
      4. Adding data
        1. Add new data
      5. Working with views
        1. Work with a list view
        2. Work with a Datasheet view
      6. Creating a new view
        1. Create a new view
      7. Launching and using a web application
        1. Launch and use a web app
      8. Working with a team site
        1. Open a web app in Access 2013 from a team site
    24. A. Appendix
      1. Big features in Windows 8
      2. Learning about your Microsoft Account
      3. Exploring the Start screen
        1. Use the Start screen
      4. Launching an app
        1. Launch an app
      5. Using the Windows 8 charms
        1. Use the charms
      6. Working with the Windows 8 desktop
        1. Work with the desktop
      7. Changing app options
        1. Change app options
      8. Moving from app to app in Windows 8
        1. Move from app to app
      9. Rearranging app tiles
        1. Rearrange app tiles
    25. B. About the Author
    26. Index
    27. About the Author
    28. Special Upgrade Offer
    29. Copyright