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.
Creating a Pivot Table
- Select the target area.
- In the “Insert” ribbon, click the button of “Pivot Table”.
- In the pop-up window, click the button “OK”.
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.
- Check the option of “Name” on the “PivotTable Field List”.
- Check the option of “Algebra Scores”.
- And then you can see the two 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.
- After the three steps in the above part, click the arrow next to “Row Label”.
- In the drop-down menu, put your cursor on the option “Value Filters”.
- In the new menu, click the option “Greater Than”.
And then you will see a new window pop up.
- Input the number “90” into the text column.
- And then click “OK”. And then the result will appear. Now we know that only Natalie gets 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.
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