|
Provided by: Serebra Learning Corporation Exchanging Data with Excel 2007 |
 |
Training
Provided by Serebra Learning Corporation
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. 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.
|
|
||||||||
Exchanging Data with Excel 2007
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.
Topics
Objectives
- Link, Import, and Embed Data in Excel 2007
- create links to data
- identify how to import data
- embed a file in a workbookCreate Database Queries in Excel 2007
- create database queries in Excel 2007
- import an entire Access tableImport Excel 2007 Data into Other Applications
- import Excel data into Access
- copy Excel data to Word
- import Excel data into OutlookIntroduction to XML in Excel 2007
- identify how XML works in Excel
- recognize the components of a basic XML system Work with XML Data in Excel 2007
- create an XML map and map elements to it
- import XML data
- export XML data into mapped cells
About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1,825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
