This course explores the concept of data connections in Excel, 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.
Description
This course explores the concept of data connections in Excel, 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 Wisard to create and edit queries.
For an optimal experience please check the minimum computer system requirements.
This online course forms part of the SkillsNet short course suite.
Please note this course is only available to CPA Australia members.
Learning objectives
- Use and configure existing data connections
- Create a web query
- Recognise 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 Wisard
Audience
Individuals who seek proficiency in the use of Microsoft Excel 2010 at a power user level and have knowledge of computing, spreadsheets, and the Microsoft Office and online work environments