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.
Get Free Quote!
439 Experts Online