This course provides detail about connecting worksheets and workbooks for automatic sharing and updating. It also provides detail about importing information from the Web, text files, XML data, Access documents, and other files from external data sources.
Objectives:
Connect two worksheets in separate workbooks
Use the Links tab on the Trust Center
Set up a connection to a Web page
Import an XML file
Connect to an Access database using Microsoft Query
Topics:
Connecting Two Worksheets
Connecting Two Workbooks
Connecting to Data on a Web Page
Connecting to a Text File
Connecting to a Database
Technical Requirements:
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.
