Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Bookmark and ShareShare
Overview
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.

Don’t have the 2007 Office release? You can download a free 60-day trial or buy it now.

  • Length: 20–30 minutes
 


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.
 
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.
AUDIO TEXT

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.

  Go to previous page (disabled)    Next Go to next page
advertisement