O'Reilly logo

Hands-On Financial Modeling with Microsoft Excel 2019 by Shmuel Oluwa

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required