Trying to help my son in college mis class on excel w/ pivot tables, simple, but I guess I dont understand prof instructions....seems simple...need he

[BlakeG23]

Instructions:<o></o>
1. Open the provided Olympic Athletes file forthe assignment (accessible via the Assignment link).<o></o>
2. Add your name and label to each of the Final PivotTables in cell A1. <o></o>
3. Generate a Pivot table and filtered spreadsheet foreach Pivot tables (ALWAYS include the Athlete name): <o></o>
4. Use the Country as the Row Label for the PivotTable to display the following: <o></o>
a) Display the Athlete name and count of Athletes byCountry. (shown)<o></o>
b) Display the Year and number of Medals for each Countrythat received a medal. <o></o>
c) Display the average age of the athlete for eachCountry received a medal. (shown)<o></o>

d)

Display the exact age and year that each Countrythat received a medal.


1. Createa Pivot Table using ONLY the fieldsmentioned in the requirement.<o></o>

2. Select1 option from the Pivot Table; then create a FILTERED spreadsheet to mimic the results already shown in thePivot table.<o></o>

3. Copyand paste the filtered spreadsheet to the Pivot Table.<o></o>

4. Labelcell A1 with your name and requirement number. Be sure to label the sheet name to therequirement number.<o></o>

5. Increasethe size and bold the field in the Pivot Table and filtered spreadsheet.<o></o>

6. Returnto the ORIGINAL sheet and clear the filters BEFORE creating the next Pivottable and filtered spreadsheet.<o></o>

7. Besure NOT to leave any Pivot tables empty; drag one of the primary fields (AthleteName or Medals) to the Values section.<o></o>

 

[ranman256]

Select the data you want to use in the spreadsheet (header labels too),
menu: INSERT tab
click PIVOT TABLE button (1st on left)
click OK to the range
in the far right pane,are the pivot fields,
grab one (top box) and drag to the ROWS (to make this field show in rows)
grab one and drag to COLUMNS for these values to appear as cols.
then grab one to VALUES , these will show in the intersection of the 2.
(you can set this to a sum, or count, etc.)

 

[BlakeG23]

Select the data you want to use in the spreadsheet (header labels too),
menu: INSERT tab
click PIVOT TABLE button (1st on left)
click OK to the range
in the far right pane,are the pivot fields,
grab one (top box) and drag to the ROWS (to make this field show in rows)
grab one and drag to COLUMNS for these values to appear as cols.
then grab one to VALUES , these will show in the intersection of the 2.
(you can set this to a sum, or count, etc.)

Thanks, I know all that but it is the next piece where he wants to add

1. Generate a Pivot table and filtered spreadsheet for each Pivot tables (ALWAYS include the Athlete name): the filtered spreadsheet, then copy /paste next to the pivot table results and they should mirror each other exactly, then there is more stuff

 

[Joe4]

Please do not expect anyone to do the assignment for him/you.
That would be unethical.

 

[BlakeG23]

no, you dont understand, I already did it, but I dont know how to do a piece of it.....

 

[ranman256]

as i understand it, it is 2 things,
1. make a pivot,
2. then filter the source data to see 1 atheletes data. (to compare against the pivot i guess)