Being able to collaborate with other users to efficiently disseminate information and complete projects is crucial in today's business environment. Excel 2010 provides numerous tools geared specifically toward collaboration, including Excel Web App and integration with SharePoint that allows for data to be easily exported. Excel 2010 data can also be linked to or embedded in other Office 2010 files, and other Office 2010 data can be linked to or embedded into Excel 2010 to create robust and professional content. This course explores the new Excel Web App, including information on the Web App interface, its limitations, and how to access the full version of Excel 2010 from within it. In addition, this course covers exporting data from a SharePoint list to Excel, and exporting data from Excel into a SharePoint list. Linking Office 2010 content to and embedding Office 2010 content in Excel workbooks is also covered.

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

Learning objectives

  • Identify scenarios appropriate for using Excel Web App
  • Export data from Excel to SharePoint
  • Export data from SharePoint to Excel
  • Paste the contents of another Office file into an Excel worksheet
  • Add an Office document to an Excel worksheet
  • Manage linked Office files in Excel

Audience

End users seeking proficiency in the use of Microsoft Excel 2010 at a power user level, who are familiar with spreadsheets, Microsoft Office, and online work environments

60 Minutes

365 Days

loading...