Using Excel 2010 Data Connections: Web Queries, XML, and Databases

End users seeking proficiency in the use of Microsoft Excel 2010 at a power user level, who are familiar with spreadsheets, Microsoft Office, and online work environments

Prerequisite
Please contact us for information about prerequisites.

Expected Duration
60 minutes

Description
There are a number of methods for accessing and using external data with Excel 2010. Creating new or using existing data connections, you can access data from the Internet, Access and SQL Server databases, and Analysis Services. You can also import and export XML data, use Microsoft Query and the Query Wizard to create your own queries, and work from text files. This course explores the concept of data connections, including how to use existing connections to access data and how to create your own. In addition, this course covers how to create a web query to access online data and use it within Excel. Importing XML data is covered, and the course also describes the process of using the Query Wizard to create and edit queries.

Objective

Accessing External Data with Excel 2010

  • use and configure existing data connections
  • create a web query
  • recognize when to use a web query
  • create a data connection to an XML file
  • create a data connection to a data source using the Query Wizard
  • use data connections in Excel 2010

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.