Before making the PivotTable report, we converted the data source table from ordinary table to "super table"! One advantage of making an Excel spreadsheet is that when new data is input into the data source, as a "spreadsheet" of data, it can automatically expand its application scope and realize the automatic addition of data. For Excel super tables, many friends may not have heard of it, let alone made it. Let's teach you how to make Excel super tables in detail. Let's learn together! Excel super table making method: 1. Make statistics of the number of trainees (1). Open the flexible PivotTable file of Excel sample source and open the 1 data source table (see the figure below). (2) Copy the entire table of 1 data source → Right-click and select 1 data source → Select the move or copy command (see the following figure) → Select a new workbook in the pop-up dialog box of move or copy worksheet (see the following figure) → Click OK to finish. Using this method, the whole worksheet of Excel can be moved and copied quickly. (3) Select any cell with data in "1 data source" → Select the PivotTable option under the Insert tab → In the pop-up dialog box for creating a PivotTable → Select the new worksheet radio button → Click OK. (4) In the PivotTable field on the right side of the newly created worksheet → drag teachers to rows → drag courses to columns → drag the number of trainees to the value shown below, so that the statistics of the number of trainers for each teacher can be completed. 2. Make a statistical table of the course scores of the instructors (1) Select any cell with data in the 1 data source → Select the PivotTable option under the Insert tab → Select the radio button of the existing worksheet in the pop-up dialog box → Select the cell A 19 of the Sheet2 table (see the figure below) → Click OK. Tip: As can be seen in the figure, the data source area of the created PivotTable is the name of the super table "Table 1" after we applied the super table. (2) The innovative new PivotTable in the "Sheet2" table, drag the teacher to the row area in the PivotTable field area → drag the course score to the value area three times (see the figure below). (3) Select the sum item: the course score cell, and right click → select the option of value summary basis → select the maximum value command (see the figure below). (4) In the same way, select the sum item: the cell of course score 2, and right click → select the option of value summary → select the command of minimum value. Select the sum item: cell 3 of course score, and right click → select the option of value summary basis → select the command of average value. (5) Then, in the value area, select the average item: course score option, and click the small triangle → select the value field setting option (see the figure below). (6) In the pop-up dialog box for setting value fields → click the number format button (see the figure below) → select a numerical option in the pop-up dialog box for setting cell format, and then click OK (see the figure below) to complete the statistics of the "highest score", "lowest score" and "average score" of teachers' course scores (see the figure below). 3. Make the training income statistics table (1), open the "Sheet2" table → select the created PivotTable area in step 1 → select the PivotTable tool → analysis tab → select the whole PivotTable option → then use the copy and paste function to copy it and put it in a blank area (see the following figure) (2) Then, uncheck the "√" before all fields in the field list on the right side of the newly copied PivotTable report, and get a blank PivotTable report (see the figure below). (3) Drag the courses to the row area → drag the large area to the column area → drag the training fees to the value area (see the figure below) to complete the training income statistics of each course in each large area. (4) We make a grouping for these courses, for example, combining Excel and PPT courses into "office Skills". After selecting the cell where Excel and PPT are located → Select the Group Selection option under the PivotTable Tool-Analysis tab to complete the grouping of row labels (see the figure below). After grouping, you can see the top of Excel and PPT, and the "new label" of the first-level data group 1 will automatically appear. Other courses that are not grouped will also add a new label, but the content of the label is itself. For example, the new label of "product manager" is "product manager". (5) After selecting Data Group 1, manually enter office Skills to modify it (see the following figure). (6) Select the product manager to the knowledge IP cell again, and select the PivotTable Tools-Analysis Tab → Group Selection option to complete the grouping (see the above figure) → After grouping, the top of "Product Manager, Communication Skills, Team Management and Knowledge IP" will be visible, and the "new label" of the merged first-level data group 2 will automatically appear. Just change data set 2 to the name you want, for example, management skills. The above is what we have compiled and shared for you. "What is the method of making Excel super tables?" All the content, isn't it wonderful and good? If you have any doubts about the method of making Excel super tables, I suggest you read the tutorial steps again and again! Finally, learn more Excel skills. @