Page 2 of 12PREVNEXT

Import data: Filter external data before importing it into Excel

Database, filter, and filtered data imported into Excel

Filter data before importing it into Excel.

You can import as much or as little data as you want to. For example, if you have 10,000 employees, and you want a list of only the employees hired this year, you can import just the names of those employees, instead of the names of each and every one of them.

To import the data, you'd filter by those employees hired this year. You could also sort the data by last name and by hire date before importing it.

You can do all this by using the Query Wizard, which steps you through the process.

To continue reading this lesson on your own, click Next.

Page 2 of 12PREVNEXT