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 the referencing framework

Now that you are all caught up with the theory behind each type of referencing framework and know where to use each of them, let's apply that knowledge to a real-life scenario.

Assume that you are a teacher and that you have the marks of the students in an entire class, and you need to sort and divide the data into different groups, based on the following criteria:

  • Total marks scored by the student in all languages
  • Total marks scored by the student in all sciences
  • Overall marks scored

The referencing framework really comes into its own in such scenarios. We can sort our data using the required criteria by following these steps:

  1. Open the Marks.xlsx file provided to you, which contains the grades of ...

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