103 Contract Eller Software Services Contract A

103 Contract Eller Software Services Contract A

103 Contract Eller Software Services Contract A

Eller Software Services has received contract revenue information in a text file. You import, sort, and filter the data. You also create a PivotTable, prepare a worksheet with subtotals, and format related data as an Excel table.

[Student Learning Outcomes 4.1, 4.3, 4.4, 4.5, 4.6, 4.8]

Files Needed: EllerSoftware-04.xlsx (Available from the Start File link.) and EllerSoftwareText-04.txt (Available from the Resources link.)

Completed Project File Name: [your name]-EllerSoftware-04.xlsx

Skills Covered in This Project

  • Import a text file.
  • Use AutoFilters.
  • Sort data by multiple columns.
  • Create a PivotTable.
  • Format fields in a PivotTable.
  • Use the Subtotal command.
  • Format data in an Excel table.
  • Sort data in an Excel table.

Alternate Instruction for Microsoft 365 Apps icon This image appears when a project instruction has changed to accommodate an update to Microsoft 365 Apps. If the instruction does not match your version of Office, try using the alternate instruction instead.


  1. Date header displays filter icon.
    Figure 4-102 Imported data sorted and filtered

  2. Values are identical.
    Figure 4-103 “Contract” field appears twice in the report

  3. Completed PivotTable
    Figure 4-104 Completed PivotTable

  4. Excel 4-4 completed
    Figure 4-105 Excel 4-4 completed
  5. Eller Software Services has received contract revenue information in a text file. You import, sort, and filter the data. You also create a PivotTable, prepare a worksheet with subtotals, and format related data as an Excel table.
    [Student Learning Outcomes 4.1, 4.3, 4.4, 4.5, 4.6, 4.8]Files Needed: EllerSoftware-04.xlsx (Available from the Start File link.) and EllerSoftwareText-04.txt (Available from the Resources link.)Completed Project File Name: [your name]-EllerSoftware-04.xlsx

    Skills Covered in This Project

    • Import a text file.
    • Use AutoFilters.
    • Sort data by multiple columns.
    • Create a PivotTable.
    • Format fields in a PivotTable.
    • Use the Subtotal command.
    • Format data in an Excel table.
    • Sort data in an Excel table.

    Alternate Instruction for Microsoft 365 Apps icon This image appears when a project instruction has changed to accommodate an update to Microsoft 365 Apps. If the instruction does not match your version of Office, try using the alternate instruction instead.


    1. Date header displays filter icon.
      Figure 4-102 Imported data sorted and filtered

    2. Values are identical.
      Figure 4-103 “Contract” field appears twice in the report

    3. Completed PivotTable
      Figure 4-104 Completed PivotTable

    4. Excel 4-4 completed
      Figure 4-105 Excel 4-4 completed