18. Importing to Excel

Chapter 9 begins by Importing Data to Excel from several different types of files: a native Excel file, a Comma Delimited Text file, an Access Database file, a Word Document file, and from a Webpage. Excel can import lots of different file types including from XML maps & files, recent innovative file types.

Excel contains data filters to accommodate each different file type of import. These filters assist you in helping Excel to place the data so that when combining files into a spreadsheet, arts and crafts can be kept to a minimum, while you add the data.

Materials Covered:Excel Project 9 - Importing Data, Working with PivotCharts, PivotTables, and Trendlines, pp. 706-734