need help

pvt1

Exercise 1: *You have a list of repeating group names. *Using a pivot table, count how many times each group name appears in the list. *Keep pivot table in this tab. Notice that this pivot table is a list comprised of each group name only occurring once. Then, within the pivot table, put the list in decreasing order based on the number of times the name appears in the list.

pvt2

Exercise 2 There are preset 3 segments that all groups are put into: Big Medium Tiny Using a pivot table, create a table displaying Revenue for each segment. Keep pivot table in this tab.

pvt3

Exercise 3 Make a pivot table showing each segment's revenue and expenses. Make sure to use both row headers and column headers. Have "Sum of Member Months" be the left most column.

pvt4

Exercise 4 Create a column entitled "Net Income/Loss." This column will represent Revenue minus Expenses. Make a pivot table representing Each Segment and Subdivision by Revenue, Expenses, and Net Income. Use row headers and column headers. Keep pivot table in this tab.

pvt5

Exercise 5 Make a pivot table of Expenses by Service Month and Paid Month for just the "Big" group segment. Keep pivot table in this tab. The result is referred to as a Claims Lag Triangle.

pvt6

Exercise 6 Make a pivot table for the Group Segment "Big" and show Revenue and Expense by Subdivision. Copy and paste the entire pivot table and change the Segment to "Medium." Change the order of each of the rows. Meaning if it was the top row label, switch it with the bottom row label. Now, switch the Revenue column with the Expenses column. Keep pivot tables in this tab.

pvt7

Exercise 7 Because Ramone's Castle is a high outlier, take it out of the pivot table that is already done. Show Revenue and Expenses by Group Segment (excluding Ramone's Castle). Have "Sum of Revenue" be the left column (you may need to switch the two columns). Keep pivot table in this tab.

pvt8

Exercise 8 SUMIF Function Using SUMIF, create the same table as Exercise 2 (Show Revenue By Group Segment).

vLook1

Exercise 1 Create an "Adjusted Region" column created from a vlookup to the table on the sheet.

vlook2

Exercise 2 There are some groups that had Expenses this year, but they didn't have any Revenue. We don’t want those groups included. Create a new column entitled "Groups with 2008 Revenue." Do a vlookup to the "Groups" tab. Look up the Group Name and return the Group Name. Then make a pivot table showing Physician Expense by Group Segment. Filter out the groups with no revenue. Do not remove groups individually. Think of a way to remove them all at once from the pivot table. Keep pivot table in this tab.

Groups