To calculate the total sales in the table below, enter the SUM function and select the summation area.

2. Fast date entry

Enter the current date:

Press [CTRL] and [; ] two shortcut keys

Enter the current time:

Select a cell, and then press [Ctrl] [Shift] [; ] three shortcut keys

3. ID card information extraction

According to the ID number, manually enter the first person's birthday. Then press the shortcut key [Ctrl+E] to fill in quickly and automatically extract other people's birthdays.

4. Super table creation

The shortcut key [Ctrl+T] transforms a table into a super table, and quickly beautifies the data.

5. Enter the same data in batches.

For filling the same data, you can use the shortcut key Ctrl+Enter in addition to dragging!

6. Add units to the data and calculate them.

Select the area where data needs to be entered, and the cell format setting window will pop up in [Custom] in rG/ General format. Enter cells directly, and click [OK]. When entering data, you can automatically bring the unit after entering the number, which will not affect the calculation!

7. Delete duplicate data

[Ctrl+A] Select all data, and click [Data] tab-[Column]-[Delete Duplicate Value] to delete duplicate data at one time!

8. Light speed projection

To filter out all member information of Tik Tok System, just find a Tik Tok System and click the right mouse button-Filter by Cell Value to filter out all data of Tik Tok System.

9. The serial number will be updated automatically

To make a table column serial number, first enter 1, and then enter 2 to drop down. If you delete a serial number, it's all messed up! We can enter [=row ()- 1] in the second line of the [serial number] column and press the [Enter] key to fill in directly.

10. Segmented display of mobile phone number

No need to manually enter the short column! First, select the range [Ctrl+ 1] to input data, call it out quickly, set the cell format and open the window, and change the rG/ general format to 000-0000-0000 in [Custom].