Import a comma-separated values text file.
Click the Expense Info sheet tab.
Select cell A4.
Click the From Text/CSV button [Data tab, Get & Transform Data group].
Find and select the ClemensonText-04.csv file downloaded from the Resources link in the Import Data window.
Verify that Comma is selected as the Delimiter in the Navigator window.
Click the Load arrow and select Load To. Select Existing worksheet.
Verify that cell A4 displays as the destination and that Table is how the data will be imported.
Click OK to import the text data (Figure 4-96).Figure 4-96 CSV file imported as a table
Cut and paste (or drag and drop) the labels in row 3 to replace the labels in row 4.
Select cell A5 and click the Convert to Range button [Table Design tab, Tools group]. Click OK to remove the query definition.
Select cells A4:D31 and clear the formats [Home tab, Editing group].
Select cells A4:D31 if necessary, and change the font size to 11 pt.
Select the labels in row 4 and center align them.
Format the dates in column C with the Short Date format.
Select columns A:D and size each column to 12.14 (90 pixels) wide. Deselect the columns.