Exchange data with Excel 2007

Course details

Excel 2007 has a number of options for importing data and share data with other applications. In addition, it includes a built-in functionality with which you can import text files and generate database queries in order to retrieve data from different databases. Excel data also © n can be imported into other applications such as Access, Word and Outlook. The combined use of XML and Excel to manage and customize your book further. In this course how to create links explains, import text files and generate queries both web and database. Also © n the import Excel 2007 data to other applications in question, and the use of XML in Excel 2007.

• create links to data
• know how to import data
• embed a file in a book
• create database queries in Excel 2007
• import a complete Access table
• import data from Excel to Access
• copy data from Excel into Word
• import data from Excel to Outlook
• embed a file in a book
• import data from a text file to Excel
• import data from a database to Excel
• use data from Excel into a Word document
• retrieve data from a database via Wizard Access
• create a manual query to retrieve data from an Access database
• identifying operation in Excel XML
• identify the components of an XML system bá¡sico
• create an XML map and assign items
• XML import data
• XML export data to the cells assigned
• use XML data in Excel 2007