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. 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 Information Rights Management. 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.

For an optimal experience please check the minimum computer system requirements.

This online course forms part of the SkillsNet short course suite.

Please note this course is only available to CPA Australia members.

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

Individuals 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...