How to Wallpaper
Learn How to Wallaper.
The Easy Way!
HowtoWallPaper
andRemoveIt.com

World of Warcraft
Learn How to Win at
World of Warcraft!
WorldofWarcraft-Guide

Gardening Guide
Amazing Secrets
Find out More..!
Great-Gardening-Guide


Excel 2007 Advanced: Adding Connections and Importing Data

Total Time: 2 hour(s)

Summary: 
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

Ojectives: 
After completing this course, students will be able to:
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, Vista, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

 
   
 
  Home | Privacy | Contact Us