[会计] 75 个 Excel 函数搞定一切 [复制链接]

银河飞雪

管理员

TA的每日心情

	开心 2023-11-28 10:15

签到天数: 85 天

[LV.6]常住居民II

电梯直达

1^#

发表于 2024-8-13 15:13:01 |只看该作者 |倒序浏览

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.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
.4 COUNT 函数........................................................................................................................ 45
6.5 COUNTIF 函数..................................................................................................................... 45
6.6 COUNTIFS 函数 .................................................................................................................. 46
6.7 LARGE 函数 ......................................................................................................................... 46
6.8 SMALL 函数 ......................................................................................................................... 47
6.9 MAX 函数 ............................................................................................................................. 48
6.10 MIN 函数............................................................................................................................. 48
6.11 RANK 函数 .......................................................................................................................... 49

欢迎下载学习