Move Student level to the Column level

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.

 

Looking for a Similar Assignment? Let us take care of your classwork while you enjoy your free time! All papers are written from scratch and are 100% Original. Try us today!