Page 1 of 12PREVNEXT

Import data: Filter external data before importing it into Excel

Import external data into Excel using Microsoft Query
Learn to filter and sort data that is stored in a database by using Microsoft Query before importing into Microsoft Office Excel.

About this course

This course includes:

  • One self-paced lesson and one practice session for hands-on experience.
  • A short test at the end of the lesson; the test is not scored.
  • A Quick Reference Card you can take away from the course.

Goals

After completing this course you will be able to:

  • Use Microsoft Query to import external data that's stored on your hard drive or on a server into Excel.
  • Use the Query Wizard to select the data to enter, filter, and sort into Excel.

Before you begin

To learn about other ways to import external data, see the following courses:


External data is data that is stored outside of Excel, in databases created in Microsoft Office Access or Microsoft SQL Server, for example.

Importing the data into Excel is a snap, but did you know that you can filter and sort the external data before bringing it into Excel, limiting how much data you import?

And if the information in the external data ever changes, you can always refresh the data in Excel to keep it up to date.

To learn more about this course, read the overview information or the table of contents in the left column. When you're done reading this page, click Next to start the first lesson.

Page 1 of 12PREVNEXT