Hands-On Financial Modeling with Microsoft Excel 2019

Implementing pivot tables

In the Marks.xlsx file, we have the percentages of all of the students. Now, let's say we want to find out who the top 10 students are, so that we can award them during our class function. Enter the pivot table using the following steps:

1. Navigate to the Top scores worksheet in the file, which contains all of the students and their percentages in a table.
2. Now, to create a pivot table, we will select all of the columns in the table and create a pivot table using the PivotTable option in the menu:

This results in the following table:

3. Since we want to find out the top 10 scores, we can use a built-in filter in the ...