Discuss the following:
Continue our travel project theme, we will first complete our data and then create a Pivot Table to provide us with the travelers that have a balance due greater than or equal to $2000.
Open the Module Data file linked below and follow these steps:
Module Data File
a. Add your name and your travel destination.
b. Add first and last names for all travelers.
c. Create formulas for the Total and Amount Due columns.
d. Create a pivot table for the information. Use the travelers, totals, and amount due fields.
e. Filter the pivot table to show only those travelers with a balance of 2000 or more. HINT: you must have four travelers after you filter.
f. Save the Excel document using the naming convention.