blondiechick
Board Regular
- Joined
- Oct 13, 2006
- Messages
- 60
This has already been done.
Create a PivotTable that analyzes fees by employee and year. User the total of fee in the data area.
This I have a hard time understanding...
Notice the fee averages would be more informative than fee totals. Using the PivotTable Wizard, change the Data to Average of Fee. If there are any long deciamls, change the cell format for all cells to two decimal places. Rename the PivotTable sheet PivotTable and rename the data sheet List.
Okay, so I did all of that, and I think I did it correctly. Now, I am confused on renaming the data sheet to list? Isn't the tab the same as the data sheet, and the tab I named PivotTable.
Create a PivotTable that analyzes fees by employee and year. User the total of fee in the data area.
This I have a hard time understanding...
Notice the fee averages would be more informative than fee totals. Using the PivotTable Wizard, change the Data to Average of Fee. If there are any long deciamls, change the cell format for all cells to two decimal places. Rename the PivotTable sheet PivotTable and rename the data sheet List.
Okay, so I did all of that, and I think I did it correctly. Now, I am confused on renaming the data sheet to list? Isn't the tab the same as the data sheet, and the tab I named PivotTable.