1. Simple and practical mini-pictures

                                                                                                                      Out Out Out of Insert – Sparkline.

​ ​ 2. Slicer for dynamic insights into data

In the PivotTable Tool - Options - Insert Slicer.

​ 3. Group data in the PivotTable tool

In the PivotTable tool - Options - Group data.

​​ 4. Display the data analysis results in pages

In the PivotTable tool - Options - PivotTable Options - Display the report filter page.

5.Data analysis perspective

In the PivotTable tool - Options - Tools. (Pivot Chart)

Excel

​ 6. Data strips for quick data analysis

Start - Conditional Formatting - Data Strips.

​ 7. Icon set for quick data analysis

Start -condition format -icon set.

​ 8. Quickly mark the top 3 data in the data table

Start - Conditional Formatting - Item Selection Rules.

9. Print the worksheet contents on one page

File - Print - No Zoom - Resize the worksheet to one page.

10.Import and synchronize data from the website

Data - from website - enter the URL in the address bar of the opened website - select the data to be imported - if you want to synchronize, right-click on the selected data - select data range properties.

11. Use of data validity

Data - data validity. (You can also set cell option content, such as drop-down options, and separate each content with,)

12. Intelligent data sorting

​​Select the content to be sorted - data - sort, such as dates, etc.

13. Customize the data display format in the worksheet

Start - "Format Cells - Customize" on the Number tab.