Note: you might not do all of these in one file in the real world.
- Open the Project Data file linked below. Press the Enable Editing button, if necessary.
Module 05 Project Data ( attach below )
Complete the following instructions (save often):
- Formulas and Charts: follow the instructions on the sheet
- Functions: Find the house payment using the PMT function.
- Goal Seek: Using Goal Seek, how many months will it take to save 5,500?
- Sort: Sort the data on Topic and within Topic, sort on Sub Topic.
- Filter: Filter the data on Social Statistics.
- Pivot Tables: Create a Pivot Table for Artist, Location, and Value. Let Excel decide where these fields will go.