Tools/materials: Glory MagicBook, Windows 10, WPS Office11.1.0.10356.

1. First, open a blank Excel table. In the first row of the worksheet, enter the title of the table.

2. Starting from the second row and the third column, enter four quarters, total, etc.

3. Then enter the table of contents in the horizontal and vertical columns of the worksheet.

4. Click to select the relevant cell, and then click the beginning of the menu bar.

5. Click the merge center to merge.

6. Then click the selected table area. In the Start option, click the border and center the text horizontally and vertically.

7. Continue to click the cell containing the selected title. In the Start option, click Bold and increase the font size of the text.

8. Then adjust the column width and row height of the table, and enter a diagonal header in the first cell of the header.

9. Enter the raw data of quarterly statistics.

10. Click the data of the selected peer, click the formula in the menu bar, and click Auto Sum in the toolbar. Summarize peer data.

1 1. After calculating all the data, click the beginning of the toolbar, and then click Fill Color to fill the cells with colors. The form will be clearer. Quarterly statistics will be ready.