1, SUM function sum

2. Average function

3. Logical function IF

4. Shortcut or link creation function hyperlink

5. Counting function

6. Maximum (minimum) value function MAX(MIN)

7. Conditional summation function SUMIF

8. Payment and repayment calculation function PMT

9, sample standard deviation function STDEV

10, ranking function ranking

1 1, rounding function round

12, conditional counting function COUNTIF

13, percentile ranking prediction function

14, and the numerical detection function is a number.

15, lump-sum deposit and lump-sum withdrawal income function PV

16, internal average function TRIMMEAN

17, date and year function year

18, Start and End Day Function Day 360

19, whole function TRUNC

20, character extraction function MID

Orfila's "You should play excel like this" is among the best in your online open class. You can have a look. After learning this course, excel is basically enough.