Page 10 of 12PREVNEXT

Import data: Filter external data before importing it into Excel

Excel practice file and practice instructions

Download size: 14 KB (<1 min @ 56 Kbps)

Practice in Excel
Problems with the practice?
HelpTry our troubleshooting tips


In the practice session you'll create a new data source by creating a DSN file, filter and sort data. You'll also try something new by connecting to a data source without creating a DSN file.

About the practice session

When you click Practice in Excel, a blank worksheet will download to your computer and open in Excel, and a separate window with practice instructions will appear alongside (see picture).

Note     You need to have Excel 2003 installed on your computer.

Tips

  • If the practice instructions aren't visible, or if they disappear when you click in Excel, click the Excel Help taskbar button and then click the Auto Tile button in the upper-left corner of the instructions.
  • If the practice instructions cover up Excel, click the Auto Tile button in the upper-left corner of the instructions.

Before you begin

Make sure to close Excel if it is already running.

Start the practice

Click Practice in Excel now.

Page 10 of 12PREVNEXT