These days, information systems have to do more than just store your data. They must make it easy for you and your colleagues to work with information as a team. The ability to collaborate is not a luxury, but a key to business success.
If you have Microsoft Office Excel 2003 and Microsoft Windows SharePoint Services, you have powerful tools that allow your group to process and analyze data and to share your accomplishments with other teams. For instance, you can use the new Excel List command to sort, filter, and total your data, and then you can publish your lists using SharePoint Services. Others can update your published data, or they can export it and put it to work in other tools such as Microsoft Office Access 2003.
Note For screen reader text detailing the onscreen actions and a screen reader version of the audio script, click Demo text version.
Demo text version
|Excel 2003 is open, showing a workbook of sales figures. The pointer selects all the data and moves to the Data menu. It points to List and then clicks Create List. The Create List dialog box opens, and the pointer clicks OK. Excel surrounds the selected data with a blue border, and the List toolbar appears.
||The new List feature in Excel 2003 becomes even more powerful when you use it with Windows SharePoint Services.
|The pointer goes again to the Data menu, points to List, and clicks Publish List. The Publish List to SharePoint Site dialog box appears. The pointer clicks Next, then Finish, and the dialog box closes.
||Publishing a list to a SharePoint site is easy. Just follow a brief wizard.
|The pointer moves again to the Data menu, points to List, and clicks View List on Server. The scene changes to show Microsoft Internet Explorer displaying the list on the team Web site.
||I've already published this list to my site, and I can view it in my browser at any time.
|The pointer selects a down arrow next to the column named Q2 Sales, and a menu opens, on which the pointer highlights the Sort Ascending and Sort Descending commands. The menu closes.
||Now, the rest of my team can put the list to work. For example, they can sort and filter data.
|The pointer scrolls down the list and selects the first empty row. Data appears in that row.
||They can also add new data...
|The scene changes back to Excel. On the List toolbar, the pointer clicks the Synchronize List button. The new row of data shown in Internet Explorer appears in the Excel list.
||…and when they're done, they can easily synchronize the list in SharePoint with the list in the original worksheet.
|The scene changes again to Internet Explorer. The pointer opens the Office links task bar.
||SharePoint also makes it easy to do a variety of tasks in Excel and Access. Just display the task bar…
|In the task bar, the pointer clicks Create linked table in Access. The Export dialog box appears.
||…and select a task.
|The pointer selects New Database and clicks OK. The scene changes to Access. The Database window shows a new database titled 2006_2007_Sales. The pointer selects a linked table with the same title.
||I've created a linked table in a new Access database. And now, I have another set of tools that I can apply to my data.
|The pointer selects Reports in the Objects bar, then moves to Create a report by using wizard. The Report Wizard opens. The pointer clicks Next, then Finish, and a report appears with the title 2006_2007_Sales: All Items1.
||For example, I can quickly create a report. I'll use the wizard (and complete it for you again), and there I go.
|The pointer scrolls down the report showing the data first seen in Excel. The animated text Experience Your Own Great Moments appears. Under it appears the static text For more information followed by a URL: http://www.microsoft.com/office.
||This is just a brief glimpse at the ways Excel 2003 can help you and your coworkers be more effective. Get more value from your data with Excel and Office 2003.
Problems watching the video? Try our troubleshooting tips.