Description

Open this Excel workbook and save the worksheet as "FirstInital_LastName_PivotIPA04_.xlsx." Highlight the entire data set, and insert a pivot table. For more information on how to create a pivot table, click here. Create a new worksheet, and sort the pivot table as follows: Move Student level to the Column level. Move the Year will move to Values, changing your values to count instead of sum. Move the Course to Row Label.