You are previewing Office 2010 Web Apps For Dummies®.
O'Reilly logo
Office 2010 Web Apps For Dummies®

Book Description

Enhance your Microsoft Office 2010 experience with Office 2010 Web Apps!

Office Web Apps complement Office, making it easy to access and edit files from anywhere. It also simplifies collaboration with those who don't have Microsoft Office on their computers. This helpful book shows you the optimum ways you can use Office Web Apps to save time and streamline your work. Veteran For Dummies author Peter Weverka begins with an introduction to Office Web Apps and then goes on to clearly explain how Office Web Apps provide you with easier, faster, more flexible ways to get things done.

  • Walks you through Office 2010 Web Apps and shows you the many ways they can save you time and help streamline your work

  • Separates the individual elements of Office Web Apps to provide you with a look at each: Word Web App, PowerPoint Web App, Excel Web App, OneNote Web App, and managing your files on SharePoint 2010 or Windows Live

  • Shows you the ways in which Office 2010 Web apps complements Office by allowing you to access and edit files from anywhere

Office 2010 Web Apps For Dummies helps you discover how to save time and effort when you use Office Web Apps.

Table of Contents

  1. Copyright
  2. About the Author
  3. Author's Acknowledgments
  4. Publisher's Acknowledgments
  5. Introduction
    1. What's in This Book, Anyway?
    2. What Makes This Book Different
      1. Easy-to-look-up information
      2. A task-oriented approach
      3. Meaningful screen shots
    3. Foolish Assumptions
    4. Conventions Used in This Book
    5. Icons Used in This Book
  6. I. Getting Acquainted with the Office Web Apps
    1. 1. Introducing Office Web Apps
      1. 1.1. What Are the Office Web Apps, Anyway?
        1. 1.1.1. Introducing Web applications
        2. 1.1.2. Meeting the Office Web Apps
      2. 1.2. Storing Files on the Internet
      3. 1.3. Sharing Files on the Internet
      4. 1.4. The Office Web Apps and Office 2010
      5. 1.5. Office Web Apps: The Big Picture
      6. 1.6. Going without Right-Clicks and Shortcut Keys
    2. 2. Getting Started with the Office Web Apps
      1. 2.1. Making Sure You Have the Right Browser
      2. 2.2. Installing Microsoft Silverlight
        1. 2.2.1. Finding out whether Silverlight is installed
        2. 2.2.2. Downloading and installing Silverlight
        3. 2.2.3. Getting an up-to-date version of Silverlight
      3. 2.3. Signing Up with Windows Live
      4. 2.4. Signing Up with SharePoint
      5. 2.5. Creating a New File
      6. 2.6. Opening and Closing Files
        1. 2.6.1. Opening a file stored in Windows Live
        2. 2.6.2. Opening a file in SharePoint 2010
        3. 2.6.3. Opening a file in Office 2010
        4. 2.6.4. Closing a file
      7. 2.7. A Tour of Office Web App Oddities
      8. 2.8. Knowing Your Way around the Office Web Apps Interface
        1. 2.8.1. The File tab
        2. 2.8.2. The Quick Access toolbar
        3. 2.8.3. The Ribbon and its tabs
        4. 2.8.4. Context-sensitive tabs
        5. 2.8.5. The anatomy of a tab
          1. 2.8.5.1. Groups
          2. 2.8.5.2. Buttons
          3. 2.8.5.3. Galleries
      9. 2.9. Getting More Room in Office Web App Screens
    3. 3. Making Your Browser Work Better with the Office Web Apps
      1. 3.1. Installing the Right Browser
        1. 3.1.1. Finding out which browser version you have
        2. 3.1.2. Downloading and installing Firefox, Internet Explorer, Safari, and Chrome
        3. 3.1.3. Updating Firefox, Internet Explorer, Safari, and Chrome
          1. 3.1.3.1. Updating Firefox
          2. 3.1.3.2. Updating Internet Explorer
          3. 3.1.3.3. Updating Safari
          4. 3.1.3.4. Updating Chrome
          5. 3.1.3.5. Considering the Cookie Question
        4. 3.1.4. What is a cookie?
        5. 3.1.5. Problems with third-party cookies
        6. 3.1.6. Handling cookies in Firefox, Internet Explorer, Safari, and Chrome
          1. 3.1.6.1. Handling cookies in Firefox
          2. 3.1.6.2. Handling cookies in Internet Explorer
          3. 3.1.6.3. Handling cookies in Safari
          4. 3.1.6.4. Handling cookies in Chrome
      2. 3.2. Getting Right with JavaScript
      3. 3.3. Getting More Room to Work In
      4. 3.4. Bookmarking Files and Folders
        1. 3.4.1. Bookmarking a folder or file
        2. 3.4.2. Going to a folder or file you bookmarked
    4. 4. Doing Common Tasks
      1. 4.1. Changing Views
      2. 4.2. Selecting Text
      3. 4.3. Cutting, Copying, and Pasting Text
      4. 4.4. Changing the Appearance of Text
        1. 4.4.1. Choosing fonts for text
        2. 4.4.2. Changing the font size of text
        3. 4.4.3. Applying font styles to text
        4. 4.4.4. Changing the color of text
      5. 4.5. Aligning Text
      6. 4.6. Lists, Lists, and More Lists
      7. 4.7. Spell-Checking Your Work
        1. 4.7.1. Spell-checking one word at a time
        2. 4.7.2. Spell-checking foreign-language text
      8. 4.8. All about Hyperlinks
        1. 4.8.1. Creating a hyperlink
        2. 4.8.2. Editing hyperlinks
      9. 4.9. Printing Your Work
    5. 5. Handling Artwork and Diagrams
      1. 5.1. All about Picture File Formats
        1. 5.1.1. Bitmap and vector graphics
        2. 5.1.2. Resolution
        3. 5.1.3. Choosing file formats for graphics
      2. 5.2. Inserting a Picture on a Page, Slide, or Note
      3. 5.3. Decorating Files with Clip-Art Images
        1. 5.3.1. What is clip art?
        2. 5.3.2. Finding and inserting a clip-art image
      4. 5.4. Changing the Size of a Graphic
      5. 5.5. Making a SmartArt Diagram
        1. 5.5.1. The basics: Creating a diagram
        2. 5.5.2. Creating the initial diagram
        3. 5.5.3. Handling the text on diagram shapes
        4. 5.5.4. Adding and removing diagram shapes
        5. 5.5.5. Changing a diagram's overall appearance
        6. 5.5.6. Promoting and demoting shapes in a diagram's hierarchy
        7. 5.5.7. Changing a diagram's direction
  7. II. Sharing Files and Collaborating with Others
    1. 6. All about SkyDrive
      1. 6.1. The Big Picture: Storing, Creating, and Editing Files at SkyDrive
        1. 6.1.1. Doing the set-up dance
        2. 6.1.2. Working with folders and files in SkyDrive
      2. 6.2. Signing In to Windows Live
      3. 6.3. Choosing Privacy Options
      4. 6.4. Navigating to the SkyDrive Window
      5. 6.5. Managing Your Folders
        1. 6.5.1. A word about organizing your folders
        2. 6.5.2. Creating a folder
          1. 6.5.2.1. Creating a top-level folder
          2. 6.5.2.2. Creating a subfolder inside another folder
        3. 6.5.3. Going from folder to folder in SkyDrive
        4. 6.5.4. Examining a folder's contents
        5. 6.5.5. Deleting, moving, and renaming folders
      6. 6.6. Creating an Office File in SkyDrive
      7. 6.7. Opening and Editing Office Files Stored on SkyDrive
        1. 6.7.1. Opening and editing a file in an Office Web App
        2. 6.7.2. Opening and editing a SkyDrive file in an Office 2010 program
          1. 6.7.2.1. Opening a file on SkyDrive in an Office 2010 program
          2. 6.7.2.2. Saving a file from Office 2010 to SkyDrive
      8. 6.8. Managing Your Files on SkyDrive
        1. 6.8.1. Making use of the Properties window
          1. 6.8.1.1. Opening the Properties window
          2. 6.8.1.2. Properties window activities
        2. 6.8.2. Uploading files to a folder on SkyDrive
        3. 6.8.3. Downloading files from SkyDrive to your computer
        4. 6.8.4. Moving, copying, renaming, and deleting files
    2. 7. Collaborating, or Coauthoring, with Others on SkyDrive
      1. 7.1. Ways of Sharing Folders
      2. 7.2. Making Friends on Windows Live
        1. 7.2.1. The two types of friends
        2. 7.2.2. Fielding an invitation to be someone's friend
        3. 7.2.3. Inviting someone to be your friend
      3. 7.3. Understanding the Folder Types
        1. 7.3.1. Types of folders
        2. 7.3.2. Knowing what kind of folder you're dealing with
        3. 7.3.3. Public and shared folder tasks
      4. 7.4. Establishing a Folder's Share With Permissions
      5. 7.5. Sharing on a Public or Shared Folder
        1. 7.5.1. Sharing with friends on Windows Live
        2. 7.5.2. Sending out e-mail invitations
        3. 7.5.3. Posting hyperlinks on the Internet
          1. 7.5.3.1. Obtaining a folder's URL link
          2. 7.5.3.2. Obtaining HTML code for a public folder hyperlink icon
      6. 7.6. Writing File Comments and Descriptions
      7. 7.7. Coauthoring Files Shared on SkyDrive
        1. 7.7.1. When you can and can't coauthor
        2. 7.7.2. Finding out who your coauthors are
        3. 7.7.3. Getting locked out of a shared file
    3. 8. Sharing Files in SharePoint
      1. 8.1. Getting Equipped and Getting Started
      2. 8.2. Visiting a SharePoint Web Site
      3. 8.3. Getting from Place to Place on the Web Site
      4. 8.4. Uploading Documents to the SharePoint Library
      5. 8.5. Opening Office Files in a SharePoint Site
      6. 8.6. Coauthoring Files on a SharePoint Site
        1. 8.6.1. When you can and can't co-author
        2. 8.6.2. Finding out who your collaborators are
      7. 8.7. Other Ways to Collaborate at a SharePoint Site
  8. III. Word Web App
    1. 9. Up and Running with Word Web App
      1. 9.1. Creating Documents with Word Web App
      2. 9.2. Comparing Word Web App to Word 2010
      3. 9.3. Introducing the Word Web App Screen
      4. 9.4. Getting Around in Documents
      5. 9.5. Changing Views
    2. 10. Advanced Word Web App Techniques
      1. 10.1. Selecting Text
      2. 10.2. All about Styles
        1. 10.2.1. Types of styles
        2. 10.2.2. Styles and templates
        3. 10.2.3. Applying a style
        4. 10.2.4. Determining which style is in use
      3. 10.3. All about Tables
        1. 10.3.1. Creating a table
        2. 10.3.2. Entering the text and numbers
        3. 10.3.3. Selecting different parts of a table
        4. 10.3.4. Inserting and deleting columns and rows
        5. 10.3.5. Changing the width of columns and the table
        6. 10.3.6. Aligning text in columns
      4. 10.4. Coauthoring Word Documents
        1. 10.4.1. Seeing who your coauthors are
        2. 10.4.2. Synchronizing a Word document
        3. 10.4.3. Revisiting an earlier version of a Word document
        4. 10.4.4. Communicating with a coauthor
  9. IV. Excel Web App
    1. 11. Entering the Data
      1. 11.1. Creating Workbooks with Excel Web App
      2. 11.2. Comparing Excel Web App to Excel 2010
      3. 11.3. Getting Acquainted with the Excel Web App
        1. 11.3.1. Rows, columns, and cell addresses
        2. 11.3.2. Workbooks and worksheets
      4. 11.4. Entering Data in a Worksheet
        1. 11.4.1. The basics of entering data
        2. 11.4.2. How data displays in worksheet cells
        3. 11.4.3. Formatting numbers, dates, and other values
          1. 11.4.3.1. Understanding data formats
          2. 11.4.3.2. Assigning a format to data
          3. 11.4.3.3. Displaying decimal places in numbers
      5. 11.5. Editing Worksheet Data
        1. 11.5.1. Editing data entries
        2. 11.5.2. Selecting cells in a worksheet
        3. 11.5.3. Deleting, copying, and moving data
        4. 11.5.4. Moving around in a worksheet
      6. 11.6. Making a Worksheet Easier to Read and Understand
        1. 11.6.1. Experimenting with text formats
        2. 11.6.2. Aligning numbers and text in columns and rows
        3. 11.6.3. Inserting and deleting rows and columns
        4. 11.6.4. Changing the size of columns and rows
          1. 11.6.4.1. Adjusting the height of rows
          2. 11.6.4.2. Adjusting the width of columns
        5. 11.6.5. Slapping borders on worksheet cells
    2. 12. Crunching the Numbers
      1. 12.1. How Formulas Work
        1. 12.1.1. Referring to cells in formulas
        2. 12.1.2. Referring to formula results in formulas
        3. 12.1.3. Operators in formulas
      2. 12.2. The Basics of Entering a Formula
      3. 12.3. Speed Techniques for Entering Formulas
        1. 12.3.1. Clicking cells to enter cell references
        2. 12.3.2. Entering a cell range
        3. 12.3.3. Copying formulas from cell to cell
      4. 12.4. Working with Functions
        1. 12.4.1. Using arguments in functions
        2. 12.4.2. Writing a formula with a function
      5. 12.5. Sorting and Filtering Data
        1. 12.5.1. Understanding what sorting and filtering are
        2. 12.5.2. Presenting data for the table
        3. 12.5.3. Creating the table
        4. 12.5.4. Sorting a table
        5. 12.5.5. Filtering a table
          1. 12.5.5.1. Filtering by exclusion
          2. 12.5.5.2. Filter by criteria
          3. 12.5.5.3. Unfiltering a table
  10. V. PowerPoint Web App
    1. 13. Getting Acquainted with PowerPoint Web App
      1. 13.1. Creating a PowerPoint Presentation
      2. 13.2. Talking PowerPoint Lingo
      3. 13.3. A Brief Geography Lesson
      4. 13.4. Advice for Building Persuasive Presentations
        1. 13.4.1. Start by writing the text
        2. 13.4.2. Make clear what the presentation is about
        3. 13.4.3. Start from the conclusion
        4. 13.4.4. Personalize the presentation
        5. 13.4.5. Tell a story
        6. 13.4.6. Assemble the content
      5. 13.5. Designing Your Presentation
        1. 13.5.1. Keep it simple
        2. 13.5.2. Be consistent from slide to slide
        3. 13.5.3. Choose colors that help communicate your message
        4. 13.5.4. When fashioning a design, consider the audience
        5. 13.5.5. Beware the bullet point
        6. 13.5.6. Observe the one-slide-per-minute rule
        7. 13.5.7. Make like a newspaper
        8. 13.5.8. Use visuals, not only words, to make your point
      6. 13.6. Comparing PowerPoint Web App to PowerPoint 2010
    2. 14. Constructing and Delivering a Presentation
      1. 14.1. Understanding How Slides Are Constructed
        1. 14.1.1. Slide layouts
        2. 14.1.2. Text frames and content frames
      2. 14.2. Creating New Slides for a Presentation
        1. 14.2.1. Adding a new slide
        2. 14.2.2. Creating a duplicate slide
        3. 14.2.3. Copying a slide
      3. 14.3. Getting a Better View of Your Work
        1. 14.3.1. Changing views
        2. 14.3.2. Editing view: Moving from slide to slide
        3. 14.3.3. Reading view: Proofreading slides
        4. 14.3.4. Slide Show view: Giving a presentation
      4. 14.4. Entering and Editing Text on Slides
        1. 14.4.1. Selecting text on a slide
        2. 14.4.2. Deleting text
        3. 14.4.3. Moving and copying text
      5. 14.5. Aligning Text in Text Frames
      6. 14.6. Handling Bulleted and Numbered Lists
        1. 14.6.1. Creating a bulleted or numbered list
        2. 14.6.2. Removing bullets and numbers from a list
        3. 14.6.3. Making sublists, or nested lists
      7. 14.7. Selecting, Moving, and Deleting Slides
        1. 14.7.1. Selecting slides
        2. 14.7.2. Moving slides
        3. 14.7.3. Deleting slides
      8. 14.8. Hidden Slides for All Contingencies
      9. 14.9. Scribbling Notes to Help with Presentations
        1. 14.9.1. Entering a note
        2. 14.9.2. Reading notes
      10. 14.10. Advice for Delivering a Presentation
        1. 14.10.1. Rehearse, and rehearse some more
        2. 14.10.2. Connect with the audience
        3. 14.10.3. Anticipate questions from the audience
        4. 14.10.4. Take control from the start
      11. 14.11. Giving Your Presentation
        1. 14.11.1. Starting a presentation
        2. 14.11.2. Going from slide to slide
        3. 14.11.3. Ending a presentation
      12. 14.12. Coauthoring a PowerPoint Presentation
  11. VI. OneNote Web App
    1. 15. Writing and Storing Notes
      1. 15.1. Introducing OneNote Web App
      2. 15.2. Creating Notebooks with OneNote Web App
      3. 15.3. Comparing OneNote Web App to OneNote 2010
        1. 15.3.1. OneNote Web App: A Geography Lesson
      4. 15.4. Creating Storage Units for Notes
        1. 15.4.1. Units for organizing notes
        2. 15.4.2. Creating a section
        3. 15.4.3. Creating a page
        4. 15.4.4. Creating a subpage
        5. 15.4.5. Renaming and deleting sections, pages, and subpages
      5. 15.5. Entering and Arranging Notes
        1. 15.5.1. Writing a note
        2. 15.5.2. Arranging and resizing notes
      6. 15.6. Formatting the Text in Notes
    2. 16. Organizing Your Notes
      1. 16.1. Going from Section to Section and Page to Page
      2. 16.2. Making the Navigation Bar Work for You
        1. 16.2.1. Displaying and hiding pages
        2. 16.2.2. Rearranging section names in the Navigation bar
      3. 16.3. Changing Your View in OneNote Web App
      4. 16.4. Seeing Who Wrote a Note
      5. 16.5. Tagging Notes for Follow-Up
      6. 16.6. Some Housekeeping Chores
      7. 16.7. Coauthoring Notebooks with Others
        1. 16.7.1. Coauthoring in OneNote Web App
          1. 16.7.1.1. Seeing who your coauthors are
          2. 16.7.1.2. Handling unmerged notes
        2. 16.7.2. Coauthoring in OneNote 2010
          1. 16.7.2.1. Finding out who your coauthors are
          2. 16.7.2.2. Synchronizing your notebook with coauthors' notebooks
          3. 16.7.2.3. Telling OneNote 2010 how to synchronize
  12. VII. The Part of Tens
    1. 17. Ten Things Everyone Should Know about the Office Web Apps
      1. 17.1. There Are Four Office Web Apps
      2. 17.2. They're Free!
      3. 17.3. You Run Office Web Apps through a Browser
      4. 17.4. Your Files Are Stored Online
      5. 17.5. The Main Purpose of Office Web Apps Is to Share Files
      6. 17.6. Office Web Apps Are Pale Imitations of Office Programs
      7. 17.7. You Can Open Files in Office 2010
      8. 17.8. Office Web Apps Are Companion Programs to Office 2010
      9. 17.9. You Run Office Web Apps on Windows Live or SharePoint
      10. 17.10. You Need to Think about Privacy Issues
    2. 18. Ten Things to Know about File Sharing
      1. 18.1. The Office Web Apps Are All about Sharing
      2. 18.2. You Need a Windows Live Account or SharePoint 2010
      3. 18.3. Share Files in Public and Shared Folders
      4. 18.4. What Sharing Means Is Different in Public and Shared Folders
      5. 18.5. In an Excel and OneNote Web App, Two People Can Work on the Same File
      6. 18.6. You Can Also Share Files in Word, PowerPoint, and OneNote 2010
      7. 18.7. Except for OneNote, You Can't use Office 2010 Programs with Others
      8. 18.8. You Can See Who Your Collaborators Are
      9. 18.9. Sorry, but You Can't Share Password-Protected Files
    3. 19. Ten Things to Know about Browsers and the Office Web Apps
      1. 19.1. The Office Web Apps Favor Four Browsers
      2. 19.2. JavaScript Must Be Enabled
      3. 19.3. Cookies Must Be Allowed
      4. 19.4. Microsoft Recommends Installing Silverlight
      5. 19.5. Zoom Using Browser Commands
      6. 19.6. Open a Second File with the New Window or New Tab Command
      7. 19.7. Get More Room on the Screen
      8. 19.8. Bookmark Your Files
      9. 19.9. Make Use of the Back, Forward, and History Commands
      10. 19.10. Beware of Right-Clicks and Shortcut Keys