Product Price:- $ 99.00 USD

Language:- English
Overview/Description
In Excel 2007, there are a number of options for importing data and sharing data with other applications. Excel 2007 includes built-in functionality for importing text files and creating database queries to retrieve data from a variety of databases. Other applications, such as Access, Word, and Outlook, can also import Excel data. Using XML in conjunction with Excel enables you to further manage and customize workbooks. This course explores creating links, importing text files, and creating database and web queries. Importing Excel 2007 data into other applications and using XML in Excel 2007 are also covered.

Target Audience
End users seeking proficiency in the use of Microsoft Excel 2007 at a power user level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2007 at an Expert level or an equivalent.

Expected Duration (min)
180

Lesson Objectives
Exchanging Data with Excel 2007 | In Excel 2007, there are a number of options for importing data and sharing data with other applications. Excel 2007 includes built-in functionality for importing text files and creating database queries to retrieve data from a variety of databases. Other applications, such as Access, Word, and Outlook, can also import Excel data. Using XML in conjunction with Excel enables you to further manage and customize workbooks. This course explores creating links, importing text files, and creating database and web queries. Importing Excel 2007 data into other applications and using XML in Excel 2007 are also covered. | Topic T21 Objective O22 | create links to data | Topic T21 Objective O70 | identify how to import data | Topic T21 Objective O71 | embed a file in a workbook | Topic T24 Objective O26 | create database queries in Excel 2007 | Topic T24 Objective O58 | import an entire Access table | Topic T28 Objective O30 | import Excel data into Access | Topic T28 Objective O75 | copy Excel data to Word | Topic T28 Objective O76 | import Excel data into Outlook | Topic T32 Objective O87 | embed a file in a workbook | Topic T32 Objective O89 | import data from a text file into Excel | Topic T32 Objective O34 | import data from a database into Excel | Topic T32 Objective O80 | use Excel data in a Word document | Topic T36 Objective O38 | retrieve data from an Access database using the Wizard | Topic T36 Objective O81 | create a manual query to retrieve data from an Access database | Topic T3 Objective O4 | identify how XML works in Excel | Topic T3 Objective O63 | recognize the components of a basic XML system | Topic T6 Objective O8 | create an XML map and map elements to it | Topic T6 Objective O84 | import XML data | Topic T6 Objective O86 | export XML data into mapped cells | Topic T10 Objective O12 | use XML data in Excel 2007

Prerequisites
Some knowledge of word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality
Estimated Duration:- 3