75个Excel函数搞定一切

银河飞雪

75个Excel函数搞定一切

简介 ........................................................................................................................................................ 4

第 1 章 文本函数 ...................................................................................................................................9

1.1 LEN 函数 ...................................................................................................................................9

1.2 RIGHT 函数 ..............................................................................................................................9

1.3 LEFT 函数 ............................................................................................................................... 10

1.4 MID 函数 .................................................................................................................................11

1.5 PROPER 函数 .........................................................................................................................11

1.6 LOWER 函数.......................................................................................................................... 12

1.7 UPPER 函数 ........................................................................................................................... 12

1.8 SEARCH 函数 ........................................................................................................................ 13

1.9 FIND 函数............................................................................................................................... 13

1.10 REPLACE 函数 .....................................................................................................................14

1.11 SUBSTITUTE 函数 ................................................................................................................ 15

1.12 REPT 函数............................................................................................................................. 15

1.13 CONCATENATE 函数 ......................................................................................................... 16

第 2 章 查找引用函数 ........................................................................................................................ 17

2.1 COLUMN 函数 ...................................................................................................................... 17

2.2 VLOOKUP 函数 .................................................................................................................... 17

2.3 HLOOKUP 函数.................................................................................................................... 18

2.4 COLUMNS 函数 ...................................................................................................................18

2.5 INDEX 函数 ........................................................................................................................... 19

2.6 INDIRECT 函数 ..................................................................................................................... 19

2.7 MATCH 函数 ........................................................................................................................ 20

2.8 OFFSET 函数......................................................................................................................... 21

2.9 ROWS 函数 ........................................................................................................................... 21

2.10 ROW 函数........................................................................................................................... 22

第 3 章 逻辑函数 ............................................................................................................................... 23

3.1 IF 函数.................................................................................................................................... 23

3.2 IS 函数................................................................................................................................... 23

3.3 AND 函数 ............................................................................................................................. 24

3.4 FALSE 函数 ........................................................................................................................... 25

3.5 OR 函数 ................................................................................................................................ 25

3.6 TRUE 函数 ............................................................................................................................ 26

3.7 IFERROR 函数 ...................................................................................................................... 26

3.8 NOT 函数.............................................................................................................................. 27

第 4 章 日期函数 ............................................................................................................................... 28

4.1 WORKDAY 函数................................................................................................................... 28

4.2 WORKDAY.INTL 函数 ......................................................................................................... 28

4.3 WEEKDAY 函数.................................................................................................................... 29

4.4 DATE 函数 ............................................................................................................................ 30

4.5 DATEVALUE 函数 ................................................................................................................ 30

4.6 DAY 函数................................................................................................................................31

4.7 HOUR 函数 .......................................................................................................................... 32

4.8 MINUTE 函数....................................................................................................................... 32

4.9 NETWORKDAYS.INTL 函数............................................................................................... 33

4.10 NETWORKDAYS 函数....................................................................................................... 34

4.11 SECOND 函数 .................................................................................................................... 34

4.12 TODAY 函数 ....................................................................................................................... 35

4.13 NOW 函数.......................................................................................................................... 35

第 5 章 数学函数 ...............................................................................................................................

37

5.1 INT 函数 ................................................................................................................................ 37

5.2 SUMIF 函数 .......................................................................................................................... 37

5.3 SUMPRODUCT 函数.......................................................................................................... 38

5.4 SUMIFS 函数 ........................................................................................................................ 39

5.5 SUM 函数 ............................................................................................................................. 39

5.6 RANDBETWEEN 函数........................................................................................................ 40

5.7 RAND 函数........................................................................................................................... 40

5.8 ROUND 函数 ........................................................................................................................41

5.9 MOD 函数 .............................................................................................................................41

第 6 章 统计函数 ............................................................................................................................... 43

6.1 AVERAGE 函数 ..................................................................................................................... 43

6.2 AVERAGEIF 函数 ................................................................................................................. 43

6.3 AVERAGEIFS 函数 ............................................................................................................... 44

......

032-75个Excel函数搞定一切.zip (1.29 MB, 下载次数: 0, 售价: 200 元本位币)

2024-9-9 23:41 上传

点击文件名下载附件
售价: 200 元本位币  [记录]  [购买]
下载积分: 本位币 -2 元

欢迎下载学习