Excel 2019 In Practice - Ch 10 Independent Project 10-6 (Windows Only) THIS ASSIGNMENT IS USING EXCEL.. CAN SOMEONE PLEASE HELP WITH RECORDING THEMSELVES DOING IT PLEASE??? Boyd Air Keeps A Text File With Performance Codes And A Microsoft Access Table With Flight Details. You Import The Data In Power Pivot To Use The Data Model For A PivotTable. [Student Learning Outcomes 10.3, 10.6, 10.7, 10.8] File Needed: EX2019-IndependentProject-10-6.xlsx (Available from the Start File link.) and Text-BoydAir10.txt and Database-10.accdb (Available from the Resources link.) Completed Project File Name: [your name]-EX2019-IndependentProject-10-6.xls IMPORTANT: The projects in this chapter are for Windows (PC) computers only. The Power Query, Power Pivot, and Get & Transform features used in these projects are not currently available in Excel 365 for Mac. STEPS BEGIN HERE... im confused on how to import the txt file. Open the EX2019-IndependentProject-10-6 start file. Click the Enable Editing button. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it. Launch Power Pivot. Import the Text-BoydAir10.txt file from your downloaded from the Resources link. Use the first row as column headers. Get the TblBoydAir table from the Microsoft Access Database-10 downloaded from the Resources link. NOTE: If you receive a Security Warning message, click OK and continue on to the next step. Create a relationship using the date field as the common field. Create a PivotTable from the Power Pivot data model in cell A1 in your existing worksheet. Name the worksheet PivotTable. Display the Flight and the FlightDate fields from TblBoydAir in the Rows area with the Flight field first. If the date field separates to include months or quarters, drag unnecessary field names out of the PivotTable Fields pane to remove them. Display the Passengers field in the Values area. Choose tabular form for the report layout. Place the Code field from the Text-BoydAir10 list. It is a Rows field. Insert a slicer for the Arrival field. Apply White, Pivot Style Medium 15 style to the PivotTable and White, Slicer Style Dark 3 to the slicer. Filter the data for GRB (Figure 10-86). Position the slicer in the top left corner of cell F2 as shown in the figure. Save and close the workbook. Upload and save your project file. Submit project for grading. Figure 10-86 Completed PivotTable for Excel 10-6 THIS IS THE RESOURCE THEY GIVES US...... "FlightDate","Flight","Code" 2/1/2020 0:00:00,"BD 2345","On Time" 2/4/2020 0:00:00,"BD 980","Delayed" 2/7/2020 0:00:00,"BD 1234","Delayed" 2/10/2020 0:00:00,"BD 1345","Delayed" 2/13/2020 0:00:00,"BD 4567","On Time" 2/16/2020 0:00:00,"BD 2213","Delayed" 2/19/2020 0:00:00,"BD 6578","On Time" 2/22/2020 0:00:00,"BD 234","On Time" 2/25/2020 0:00:00,"BD 981","On Time" 2/28/2020 0:00:00,"BD 123","On Time" 3/3/2020 0:00:00,"BD 221","Delayed" 3/6/2020 0:00:00,"BD 134","Delayed" 3/9/2020 0:00:00,"BD 98","On Time" 3/12/2020 0:00:00,"BD 4567","On Time" 4/1/2020 0:00:00,"BD 2345","Delayed" 4/4/2020 0:00:00,"BD 980","On Time" 4/7/2020 0:00:00,"BD 1234","Delayed" 4/10/2020 0:00:00,"BD 1345","On Time" 4/13/2020 0:00:00,"BD 4567","On Time" 4/16/2020 0:00:00,"BD 2213","On Time" 4/19/2020 0:00:00,"BD 6578","Delayed" 4/22/2020 0:00:00,"BD 234","Delayed" 4/25/2020 0:00:00,"BD 981","Delayed" 4/28/2020 0:00:00,"BD 123","On Time" 5/3/2020 0:00:00,"BD 221","Delayed" 5/6/2020 0:00:00,"BD 134","On Time" 5/9/2020 0:00:00,"BD 98","On Time" 5/12/2020 0:00:00,"BD 4567","On Time"