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.

Learning objectives

  • Share a workbook with advanced sharing settings
  • Recognise 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

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

60 Minutes

365 Days

loading...