What are 10 useful Excel techniques?

What are the 10 useful Excel skills? I believe many inexperienced people are helpless about this. For this reason, this article summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

1. Photo blue background for red background Operation method: Select photo-Tools-Delete background 2. One-click summation Operation method: Select data area, press Alt + = to complete summation

3. One key to find different operation methods: select two columns of data, press Ctrl+ one second to find different values. 4. Quick check of two tables. Operation methods: copy one table data, select the other table-selective pasting-minus 5. Extract birthday from ID card.

Step 1: Copy ID number to birthday column

Step 2: Data Disaggregation. Step 1: Choose a fixed width. Step 3: Keep the 8-digit birthday number and format it as a date. take care of

Animation demo:

Extraction Results:

6, one second to generate Excel chart operation method: select the data area, press Alt+F1 key to insert the chart 7, digital split operation method: first enter a row of content, and then press Ctrl + E quick split 8, quick production payroll operation method: enter the serial number in the next column, copy twice, and then copy the title line to the bottom, and then sort by serial number. Excel forms are printed on a piece of paper.

Operation method: page layout-set one page width and one page height

10, quickly find duplicate values operation method: select two columns-conditional format-highlight cell rule-duplicate valuesAfter reading the above content, you have mastered 10 useful Excel skills What is the method? If you still want to learn more skills or want to know more related content, welcome to pay attention to the industry information channel, thank you for reading!