Excel简单应用

àì夳堔傛蜴生んèń 2023-08-17 16:31 110阅读 0赞

*  数据透视表的简单应用  
    ![793818-20190823112229024-1597094634.png][]
 *  LEN、LENB  
    ![793818-20190823112541458-879712903.png][]
 *  MID  
    ![793818-20190823111921014-90399712.png][]
 *  LEFT,RIGHT  
    ![793818-20190823111749217-1277510012.png][]
 *  CONCATENATE 和 &  
    ![793818-20190823111607436-704897198.png][]
 *  TRIM(去掉前后空格) 和 SUBSTITUDE(去空格,包括字符串之间的空格)  
    ![793818-20190823111439428-1115289086.png][]
 *  FIND,SEARCH,MID  
    ![793818-20190823111135291-515428132.png][]
 *  时间函数  
    ![793818-20190823113345008-702634932.png][]
 *  DAYS  
    ![793818-20190823142820072-1528277778.png][]
 *  IF  
    ![793818-20190823143635935-1823218638.png][]  
    对应函数`=IF(AND(B13=1,C13=1)=TRUE,"男神",IF(AND(B13=1,C13=0)=TRUE,"靠脸吃饭",IF(AND(B13=0,C13=1)=TRUE,"肌肉男","是个好人")))`
 *  COUNT(统计目标区域有多少个数值类型的单元格)  
    ![793818-20190823145243344-1039504412.png][]
 *  COUNTA(统计所有非空单元格个数) 和 COUNTBLANK(统计空白单元格个数)  
    ![793818-20190823145254795-959887578.png][]
 *  COUNTIF(计算出现的个数)  
    ![793818-20190823150024387-1238294660.png][]
 *  SUMIF()  
    ![793818-20190823150857968-1963019855.png][]

转载于:https://www.cnblogs.com/hankleo/p/11398840.html

[793818-20190823112229024-1597094634.png]: /images/20230810/03d5dc662ec146c9b9973c94a7ba8c55.png
[793818-20190823112541458-879712903.png]: /images/20230810/471edc0250784f50a0ef1373faa4f0ef.png
[793818-20190823111921014-90399712.png]: /images/20230810/6145215bce2d45118a3f7c0550742e47.png
[793818-20190823111749217-1277510012.png]: /images/20230810/a9a6fbd87cd94b4994bc8dd5451421c6.png
[793818-20190823111607436-704897198.png]: /images/20230810/81595634140b40c2b37ac7b682886323.png
[793818-20190823111439428-1115289086.png]: /images/20230810/6f51e040ef2b4827b19100e492f1925a.png
[793818-20190823111135291-515428132.png]: /images/20230810/95df739c86ed4396b1970a204badd11f.png
[793818-20190823113345008-702634932.png]: /images/20230810/b23634673263421bbda7b5273b37f1c9.png
[793818-20190823142820072-1528277778.png]: /images/20230810/e490603fa955445eaee1fa930cde8269.png
[793818-20190823143635935-1823218638.png]: /images/20230810/d365ed35ec084419bee9a692dc413802.png
[793818-20190823145243344-1039504412.png]: /images/20230810/5b61580a10c343efa30c3f664271f3dc.png
[793818-20190823145254795-959887578.png]: /images/20230810/0d1914f3c2154229bdfa18bdb93c284c.png
[793818-20190823150024387-1238294660.png]: /images/20230810/06810029bc92418cb370d338dafe8a2f.png
[793818-20190823150857968-1963019855.png]: /images/20230810/47a92d8b967847bbb77f311227d2e6c5.png