Pivot Table Example 2: Break down the cohort by class Click and drag the class field (XR.CLASS.CURR.TERM) to the row labels. Place it underneath the cohort (X.START.TERM.UG.GR) field. To “pivot” the data, click and drag the field names to change position, thereby changing how data displays. Pivot Table Example 3: Detail in on the 09/FA cohort who have SR status and are from MN. Double click on the count. You see all of the details (in table format) that make up the 7 seniors from Minnesota who have a 09/FA cohort. Pivot Table Example 4: Determine sum and total average of student loan amounts as well as a count of graduating students. Click and drag the Grad Date to the row labels area. Click and drag Total Loans to the values section three times. Click the down arrow next to the second Total Loans and select Value Field Settings… Change the Custom Name if desired. Select Count, Average or other calculation to summarize the data. Click OK. Duplicate Entries To find a duplicate entry:
Pivot Table Example 2: Break down the cohort by class Click and drag the class field (XR.CLASS.CURR.TERM) to the row labels. Place it underneath the cohort (X.START.TERM.UG.GR) field. To “pivot” the data, click and drag the field names to change position, thereby changing how data displays. Pivot Table Example 3: Detail in on the 09/FA cohort who have SR status and are from MN. Double click on the count. You see all of the details (in table format) that make up the 7 seniors from Minnesota who have a 09/FA cohort. Pivot Table Example 4: Determine sum and total average of student loan amounts as well as a count of graduating students. Click and drag the Grad Date to the row labels area. Click and drag Total Loans to the values section three times. Click the down arrow next to the second Total Loans and select Value Field Settings… Change the Custom Name if desired. Select Count, Average or other calculation to summarize the data. Click OK. Duplicate Entries To find a duplicate entry:
EssentialExcelToolsTipsAndTricks.docx