OK, students, in this lesson, let's explain how we can adjust the layout of the PivotTable report to a classic layout. What's more, we can see the benefits of adjusting to a classic layout. Now, students, we can choose any cell in this data area, Then click Insert and then click the PivotTable option. OK, let's go directly and click OK. Let's see if the PivotTable we generated at this time is such an effect. OK, I will adjust the zoom ratio a little more so that students can see it more clearly, So students see that the current PivotTable is such an effect. If we want to drag this field into the PivotTable, we will find that there is no effect after dragging. This is because we cannot drag this field directly for the current PivotTable effect, If we want to generate a PivotTable report by dragging fields, we need to right click the mouse to see if we can see here at this time. There is an option for the PivotTable report, we can click it. OK, is this the time when the window for the PivotTable report option appears, Or, you can also click on the PivotTable, and then click on the analysis tab, and we can see whether there is this option in the PivotTable group. We can click on the small triangle next to it, and see that there is also an option here. OK, let's click on it, and we can also call out this window, At this time, the window has appeared. We can find this here
Suitable for people
Finance, clerks, assistants, etc. who need to handle the display and calculation of massive data
You will learn
After learning Excel PivotTable, you can perform some calculations, such as summation and counting
Expand more