Sharing Excel 2010 Workbooks Online and on a Network


Overview/Description
Target Audience
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description
As both business and home users move toward working in more electronically collaborative environments, the need to share Excel workbooks and to have multiple users edit them simultaneously has increased. Excel 2010 allows you to share workbooks over a network, distribute them by e-mail, and share them online. You can make use of Information Rights Management (IRM) to ensure that users cannot copy or forward workbook content, as well as to expire files and enforce corporate information dissemination policies. You can also specify that users can only edit specific ranges in a shared workbook. This course covers sharing Excel 2010 workbooks on a network with advanced sharing options, the limitations of shared workbooks, and the uses and limitations of IRM. It also covers how to limit users' editing to specific cell ranges in a worksheet, and how to apply the AutoRepublish feature when saving workbooks for use on the Web.

Target Audience
End users who seek proficiency in the use of Microsoft Excel 2010 at a power user level and have knowledge of computing, spreadsheets, and the Microsoft Office and online work environments

Expected Duration (hours)
1.0

Lesson Objectives

Sharing Excel 2010 Workbooks Online and on a Network

  • share a workbook with advanced sharing settings
  • recognize features that are available in a shared workbook
  • protect a workbook with Information Rights Management (IRM)
  • allow users to edit specific ranges in a protected worksheet
  • save a workbook as a Web file
  • share Excel 2010 workbooks
  • Course Number:
    mo_pexl_a01_dt_enus

    Expertise Level
    Beginner