To 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. Be sure that you have the latest version of Excel before you begin.
-Add your name and your travel destination.
-Add first and last names for all travelers.
-Create formulas for the Total and Amount Due columns. (The information is given on the sheet).
-Create a pivot table for the information. Use the travelers, totals, and amount due fields.
-Filter the pivot table to show only those travelers with a balance of 2000 or more. HINT: you should have four (4) travelers after you filter.
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|