Description

Independent Project 4-5

YOU GET 4 TRIES

Boyd Air is monitoring flight arrival status as well as capacities. Before formatting the data as an Excel table, you will export it as a text file for use in the reservation software. You will filter the data in the table, build a PivotTable, and create a PivotChart.

[Student Learning Outcomes 4.1, 4.2, 4.3, 4.4, 4.7, 4.8]

File Needed: BoydAir-04.xlsx (Available from the Start File link.)

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

Skills Covered in This Project

  • Export data as a text file.
  • Format data as an Excel table.
  • Use a number filter in a table.
  • Set conditional formatting with an icon set.
  • Filter data by cell icon.
  • Create and format a PivotTable.
  • Create and format a PivotChart.

  1. Departure label in row 4 displays filter icon
    Figure 4-106 Filter results for Departure Time field

  2. The red flag is not used in the Sort dialog box
    Figure 4-107 Custom sort for the 3 Flags icon set

  3. Excel 4-5 completed
    Figure 4-109 Excel 4-5 completed