Microsoft Office Professional 2013 for Touch Devices Plain & Simple

Table of contents

1. Dedication
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 for touch devices?
      1. Quick response to your touch
      2. Making sure touch is on target
      3. Typing flexibility on a touchscreen
   4. Big new features in Office 2013
   5. What you’ll find in this book
   6. A few assumptions
   7. Before we begin
4. 2. The touchable Office 2013: navigation basics
   1. Starting Office 2013 on your touch device
      1. Start Office apps from the Windows 8 start screen
      2. Add Office 2013 to the desktop
   2. Starting Office 2013 on your Windows 8 phone
      1. Start Office on your phone
      2. Explore the Office Hub
      3. Open an Office file on your phone
   3. Learning the Office 2013 screen
   4. Using the ribbon
      1. Use the ribbon
   5. Displaying minibars
      1. Display minibars
   6. Modifying the ribbon display
      1. Change ribbon options
   7. Working with the Backstage view
      1. Use the Backstage view
   8. Touch techniques for everyday use
   9. Using the new 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
   12. Swiping the screen to view content
       1. Swipe the screen
   13. Spreading and pinching to zoom in and out
       1. Enlarge and reduce the screen
   14. Choosing your On-Screen Keyboard
5. 3. Setting up your portable Office 2013
   1. Managing your Microsoft Account
      1. Change your account settings in Microsoft Office
   2. Choosing an Office background
      1. Choose an Office background
   3. Selecting an Office theme
      1. Choose an Office Theme
   4. Adding services
      1. Add services
   5. Moving among open apps
      1. Move among open apps
   6. Docking apps
      1. Dock apps
   7. Adding Office apps from the Windows Store
      1. Add an Office app
   8. Opening files
      1. Open a new file
      2. Open an existing file
   9. Saving files
      1. Save to the cloud
      2. Add a new place to save
      3. Save files to your touch device
   10. Closing files
       1. Close a file
   11. Sharing files with others
       1. Invite others to share your file
       2. Send your file via email
   12. Previewing and printing files
       1. Preview and print files
   13. Getting help
       1. Get help
6. 4. Staying in touch with Outlook 2013
   1. A first look at Outlook 2013
      1. Mail
      2. Calendar
      3. People
      4. Tasks
   2. Getting started with Outlook 2013
      1. Start Outlook
      2. Set up an email account
   3. Reading and responding to messages
      1. Read and reply to a message
   4. Adding contacts
      1. Add a new contact manually
   5. Editing contacts
      1. Edit a contact
   6. Adding contact groups
      1. Add a contact group
      2. Add new members to the group
   7. Managing your mail by using Quick Steps
      1. Set up and use a Quick Step
   8. Flagging mail for follow-up
      1. Flag mail
      2. Add a reminder
   9. Categorizing your mail
      1. Categorize your email
   10. Moving messages to folders
       1. Organize your mail with folders
       2. Move mail to the new folder
7. 5. Updating your schedule and managing tasks with Outlook 2013
   1. Exploring the calendar window
      1. Navigate the calendar
      2. Search your calendar
   2. Opening a calendar
      1. Open a calendar
      2. Open a shared calendar
   3. Creating a new calendar
      1. Create a new calendar
   4. Creating calendar groups
      1. Create a calendar group
   5. Creating appointments
      1. Add a calendar entry
   6. Creating meetings and sending invitations
      1. Send meeting invitations
   7. Changing the look of the calendar
      1. Change the calendar color and scale
      2. Change the layout of the calendar window
   8. Sending your calendar by email
      1. Send a calendar by email
   9. Adding tasks to your to-do list
      1. Create a task
      2. Set task properties
   10. Managing tasks
       1. Assign a task
8. 6. Connecting right now with Lync 2013
   1. Launching and signing in to Lync
      1. Start Lync 2013
   2. Getting started with Lync
   3. Learning the Lync window
      1. Display and use the Lync menu bar
      2. Use the Quick Lync Bar
   4. Personalizing your Lync info
      1. Update your status
      2. Set your availability
      3. Specify your location
      4. Set your Lync preferences
   5. Adding and managing contacts
      1. Add a new contact
      2. View a contact card
   6. Instant messaging friends and colleagues
      1. Send an instant message
      2. Respond to an instant message
   7. Making calls by using Lync
      1. Make a Lync call
      2. Place a video call
   8. Setting up an online meeting
      1. Schedule the meeting
      2. Meet now
   9. Hosting your meeting
      1. Use Lync meeting tools
9. 7. Creating and saving a document in Word 2013
   1. Word 2013: introducing basic touch-friendly features
      1. Use the Word 2013 Start screen
   2. Touring the Word window
   3. Creating documents and adding content
      1. Start with a blank document
      2. Start with a template
      3. Enter text
   4. Searching and replacing text
      1. Find and replace text
   5. Selecting a theme
      1. Choose a theme for your document
   6. Choosing a style set
      1. Select a style set
   7. Applying styles
      1. Apply a style to text
   8. Formatting your document
      1. Create a bulleted list
      2. Add a numbered list
   9. Changing the view
      1. Change the view
      2. Use Read Mode
   10. Inserting pictures and video
       1. Insert an online picture
       2. Edit a picture
       3. Add and play online video
       4. Flow text around a picture
   11. Inserting tables
       1. Create and modify tables
   12. Adding headers and footers
       1. Insert a header or footer from the gallery
       2. Create your own header or footer
   13. Saving your Word document
       1. Save your document
   14. Exporting document content
       1. Export as a PDF
10. 8. Working with shared documents in Word 2013
    1. Understanding the collaboration features in Word
    2. Sharing your documents
       1. Open a shared document
    3. Collaborating in the cloud
       1. Work collaboratively in a document
    4. Contacting coauthors in real time
       1. Contact your coauthor while you work
    5. Restricting document editing
       1. Restrict editing
       2. Choose the styles allowed in restricted formatting
    6. Opening and editing PDF files
       1. Open a PDF file
       2. Save the PDF file
    7. Tracking document changes
       1. Turn on Track Changes
       2. Lock tracking
    8. Using Simple Markup
       1. Turn on and use Simple Markup
       2. Choose the markup you want to see
    9. Adding and responding to comments
       1. Add a comment
       2. Respond to a comment
       3. Delete a comment
    10. Accepting or rejecting changes
        1. Navigate to changes
        2. Accept changes
        3. Reject changes
    11. Presenting your document online
        1. Get ready to present
        2. Present your document
11. 9. Designing, editing, and saving a worksheet in Excel 2013
    1. Getting started with Excel
       1. Start Excel in Windows 8
    2. Creating a new workbook
       1. Create a blank workbook
       2. Start a worksheet from a template
    3. Exploring the Excel window
    4. Adding and importing worksheet data
       1. Type new data
       2. Enter data by using Flash Fill
       3. Import worksheet data
    5. Applying a theme
       1. Apply a theme
    6. Formatting worksheet data
       1. Format selected cells
    7. Inserting pictures
       1. Insert a picture file
    8. Adding charts
       1. Add a new chart
       2. Use recommended charts
    9. Filtering chart data
       1. Filter chart data
    10. Saving and protecting a workbook
        1. Save your workbook
        2. Protect the current sheet
        3. Add a password
    11. Sharing a worksheet
        1. Share your workbook with others
        2. Present the workbook online
    12. Tracking changes
        1. Turn on Track Changes
        2. Review changes
    13. Exporting worksheet data
        1. Create a PDF of your worksheet
12. 10. Using Excel 2013 for data analysis
    1. Applying conditional formatting
       1. Highlight data results
       2. Display data bars
    2. Quickly analyzing your data
       1. Apply Quick Analysis
    3. Adding sparklines
       1. Create sparklines
       2. Edit Sparklines
    4. Understanding Excel formulas and functions
       1. Learning about cell references
       2. Understanding formulas and functions
    5. Creating a formula
       1. Type a formula
    6. Checking and revising a formula
       1. Check for formula errors
    7. Using functions
       1. Find the function you want
    8. Sorting data
       1. Do a basic sort
       2. Create a custom sort
    9. Creating and modifying PivotTables
       1. Create a recommended PivotTable
       2. Create a PivotTable
    10. Filtering your data by using slicers
        1. Filter selected data
        2. Use a slicer to filter a table
13. 11. Creating, animating, and saving a presentation in PowerPoint 2013
    1. Getting started with PowerPoint 2013
       1. What’s new in PowerPoint 2013
       2. Start PowerPoint in Windows 8
       3. Learning the PowerPoint window
    2. Starting a new presentation
       1. Start a blank presentation
       2. Start a presentation from a template
    3. Selecting a presentation theme
       1. Apply a theme
       2. Choose a variant
    4. Choosing a slide layout
       1. Change a slide layout
    5. Adding and formatting text
       1. Add slide text
       2. Format slide text
    6. Adding pictures to your slides
       1. Add a picture from your computer
       2. Add an a picture from an online source
    7. Inserting slides
       1. Insert a new slide
       2. Correct picture sharpness and contrast
    8. Adding and editing video
       1. Insert video
       2. Edit your video
    9. Animating slide elements
       1. Animate a slide element
       2. Choose animation effects
       3. Set timing and reorder animations
    10. Adding transitions to your slides
        1. Choose a transition
        2. Modify a transition
14. 12. Collaborating and finishing your presentation
    1. Sharing your presentation
       1. Invite others to share your presentation
       2. Send the presentation to others via email
    2. Commenting on a presentation
       1. Add a comment
       2. Respond to a comment
       3. Navigate comments
    3. Coauthoring presentations in real time
       1. Open a shared presentation
       2. Coauthor a presentation
    4. Previewing your presentation
       1. Preview your presentation
       2. Reorder slides in slide sorter view
    5. Timing your presentation
       1. Time the presentation
    6. Printing presentation materials
       1. Print slides
       2. Prepare handouts
    7. Using presenter view
       1. Display presenter view
       2. Use Presenter View
    8. Broadcasting your presentation online
       1. Present your presentation online
    9. Saving your presentation as a video
       1. Create a video
15. 13. Organizing your research with OneNote 2013
    1. Getting started with OneNote 2013
       1. Starting OneNote 2013
       2. Exploring the OneNote window
    2. Creating a notebook
       1. Start a new notebook
    3. Opening a notebook
       1. Open a notebook saved online
       2. Choose an existing notebook
    4. Capturing notes—anytime, anywhere
       1. Add a typed note
       2. Drawing your notes
       3. Record an audio or video note
    5. Using note templates
       1. Create a new page based on a template
       2. Adding lines to the page
    6. Searching for notes
       1. Search for note content
    7. Sharing notebooks
       1. Invite others to share the notebook
       2. Send a link to a notebook
       3. Share with a meeting
16. 14. Creating, reviewing, and touching up publications with Publisher 2013
    1. Getting started with Publisher 2013
       1. Start Publisher
    2. Creating a new publication
       1. Create a blank publication
    3. Choosing and using a template
       1. Start a new publication based on a template
       2. Modify the publication
    4. Setting up pages
       1. Choosing page setup options
       2. Naming pages
       3. Inserting pages
    5. Adding content
       1. Type and format text
       2. Import content
    6. Linking text boxes
       1. Link text boxes
       2. Create columns
    7. Inserting and replacing pictures
       1. Insert a picture
       2. Replace a picture
    8. Layering objects on Publisher pages
       1. Arrange objects
       2. Rotate items
    9. Finalizing your publication
       1. Run the Design Checker
       2. Preview as email
       3. Preview and print your publication
17. 15. Creating a web app with Access 2013
    1. Getting started with Access 2013
       1. Start Access 2013
       2. Start a web app from a template
       3. Create a blank web app
    2. Exploring the Access window
    3. Adding tables for your data
       1. Search and find a table
       2. Add a blank table
    4. Adding data to the table
       1. Add data to the table
    5. Starting and using the web app
       1. Launch the web app
    6. Choosing the way you view data
       1. Work with a List view
       2. Work with a Datasheet view
    7. Changing an existing view
       1. Edit the view
       2. Create a custom view
    8. Using your web app with a team site
       1. Open a web app in Access 2013 from a team site
18. A. About the author
19. Index
20. About the Author
21. Copyright