![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
REPTARRAY函数的用法
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
SUBSTITUTES函数的用法
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
REGEXP函数的用法
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
ARRAYTOTEXT
函数的用法
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
PERCENTOF函数的用法
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
STDEV.P
函数的用法
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
PERCENTRANK.INC
函数的用法
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
PERCENTRANK.EXC
函数的用法
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
PERCENTILE.INC
函数的用法
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
PERCENTILE.EXC
函数的用法
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
SHEETSNAME
函数的用法
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
BOOKNAME
函数的用法
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
SHEETS函数用法
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
SHEET函数用法
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
ROUNDBANK函数用法
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
ARABIC函数用法
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
LAMBDA函数使用技巧
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
LET函数使用技巧
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
无法溢出
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
WRAPROWS将一维数据转化为二维数据
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
WRAPCOLS将一维数据转换二维数据
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
VSTACK垂直方向拼接数据
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
TOROW多行多列转一行
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
TOCOL多行多列转一列
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)