Title: Learning Objectives
Course: Introduction to Spreadsheets (TEMPLATE) > Section: Competency Modules

Upon completion of this competency, the students should be able to:

- Import data from a text ﬁle
- Work with connections and external data ranges
- Deﬁne a trusted location
- Understand databases and queries
- Use the Query Wizard to import data from several tables
- Edit a query
- Import tables from Access for use with a PivotTable
- Manage table relationships with PowerPivot
- Create a Web query
- Retrieve data using an Office app
- Access data from an XML document
- Work with XML data maps