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.
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
Lesson Objectives
Link, Import, and Embed Data in Excel 2007
- create links to data
- identify how to import data
- embed a file in a workbook
Create Database Queries in Excel 2007
- create database queries in Excel 2007
- import an entire Access table
Import Excel 2007 Data into Other Applications
- import Excel data into Access
- copy Excel data to Word
- import Excel data into Outlook
Working with Data from Other Applications in Excel 2007
Retrieving External Data with Excel 2007
Introduction 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
Using XML Data in Excel 2007
|
Key Concepts:
|
|
Desktop Certifications, Microsoft, Microsoft Certified Application Specialist Certification, 77-602 Using Microsoft Office Excel 2007, Desktop Curricula, Microsoft Office 2007, Microsoft Office 2007: Excel for the Power User
|
|
|
Course Appears in these Categories:
|
• Desktop Certifications >> Microsoft >> Microsoft Certified Application Specialist Certification
• Desktop Skills >> Microsoft Office 2007 >> Microsoft Excel 2007: Power User
• Continuing Professional Education >> National Association of State Boards of Accountancy (NASBA)
|
|
|
Courses you might be interested in:
|
• Programmability and Administration in Access 2007
• Database Administration in Access 2007
• Importing and Exporting Data and Data Presentation in Access 2007
• Advanced Data Management in Access 2007
• Advanced Formatting in Excel 2007
• Advanced Data Management in Excel 2007
• Advanced Customization in Excel 2007
• Customizing Outlook 2007 and Using the Journal
• Configuring Rules, Alerts, and Junk E-mail Settings in Outlook 2007
• Working with SharePoint, Calendars, and Forms in Outlook 2007
• Creating Custom Slide Shows in PowerPoint 2007
|