How to Get Different Views for Same Data Sets via Pivot Table

Excel files provides you with many useful functions. And in this article, we will talk about how to get different views for same data sets via Pivot Table.

Pivot Table can be very helpful in viewing data and information. When the file is very large and there is a lot of information, using Pivot Table can improve your efficiency. And now we will introduce the Pivot Table using the example of student scores.Student Scores Example

Creating a Pivot Table

  1. Select the target area.
  2. In the “Insert” ribbon, click the button of “Pivot Table”.Create a Pivot Table
  3. In the pop-up window, click the button “OK”.Click OK in the Window

And then a new worksheet appears. In this worksheet, there is the new Pivot Table.

How to Get Different Views

On the right of the interface, there are many different choices. And those choices are the column head of score. If you want to view any of the subject scores, you can check it. For example, if want to view the scores of algebra of each student, you can follow the steps below.

  1. Check the option of “Name” on the “PivotTable Field List”.
  2. Check the option of “Algebra Scores”.Check the Targets
  3. And then you can see the two columns.Two Selected Columns

In the original worksheet, there are many columns between these two, and it is not so easy to see everyone’s scores. But here it is much clearer.

Find Certain Numbers

And if you want to know who get algebra scores greater than 90, you can also use Pivot Table.

  1. After the three steps in the above part, click the arrow next to “Row Label”.
  2. In the drop-down menu, put your cursor on the option “Value Filters”.
  3. In the new menu, click the option “Greater Than”.Find Certain Number

And then you will see a new window pop up.

  1. Input the number “90” into the text column.Input the Number
  2. And then click “OK”. And then the result will appear. Now we know that only Natalie gets score greater than 90.The Score Greater than 90

And of course there are many other features in Pivot Table, you can use them according to your requirements.

How to Handle with a Damaged Excel File

As Excel is one of the most popular software in the world, many of you have applied it into your work. Therefore, you may probably meet with Excel file corruption. Don’t worry that you may lose your data. You can use the third party tool to recover Excel. This software specializes in recovering Excel. And it is able to get back the lost data even if the Excel file is badly damaged.

Author Introduction:

Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including word recovery and outlook repair software products. For more information visit www.datanumen.com

Comments are closed.