14-ning Sahifa 1OLDKEYINGI

Share Excel data with others by exporting it to a SharePoint site

Hands reaching for data
Export Microsoft Office Excel 2007 data to your Microsoft Office SharePoint Server 2007 site or Windows SharePoint Services 3.0 site so that others can make revisions to the data.

About this course

This course includes:

  • One self-paced lesson and one practice session for hands-on experience.

Practice requires Excel 2007 installed with Microsoft Office Professional 2007 and either Windows SharePoint Services 3.0 or Office SharePoint Server 2007.

  • A test at the end of the lesson; tests are not scored.
  • A Quick Reference Card you can take away from the course.

Goals

After completing this course you will be able to:

  • Prepare data to export to your SharePoint site by converting the data to a table.
  • Export an Excel table to a SharePoint list.
  • Edit data in the SharePoint list.
  • Refresh the Excel table to incorporate changes from the SharePoint list.

Does your company use a Windows SharePoint Services 3.0 site or Office SharePoint Server 2007 site? Do you want more than one person at a time to update data in one place?

If the answers are yes, you may want to learn how to export Excel data to your SharePoint site. That puts data in a shared location that you can tell people about, and where no one has to wait to make revisions if someone else is working on the data.

For example, imagine that you have a list of names in Excel. You need those people to give you additional information. You could export the names to your SharePoint site, where everyone could add their own information, without the bother of having to wait if someone else is adding information at the same time.

To learn more about this course, read this page fully and then click Next.

14-ning Sahifa 1OLDKEYINGI