![](https://www.xqppt.com/uploads/admin/article_thumb/20201202/ad53214190e8aecd12c40731637ec255.png)
![](https://www.xqppt.com/uploads/admin/article_thumb/20201202/1da92d85dc15e3e7489024a0d4052b49.png)
![](https://www.xqppt.com/uploads/admin/article_thumb/20201210/5d1c5c6ab8158d0eb19a832a4beb37e2.png)
![](https://www.xqppt.com/uploads/admin/article_thumb/20201210/c88370fbd09c77a5f9964e16493d4dbf.png)
常用的Excel统计函数汇总
![](/static/index/images/article/time.png)
Excel表格数据统计常常都会用到,有了统计函数,分析数据也轻松不少。那么有哪些统计函数呢?下面给大家分享Excel常见的统计函数汇总。
![](https://www.xqppt.com/uploads/admin/article_thumb/20201210/8373ff3cd3ff79ff586312c36bbd0872.png)
![](https://www.xqppt.com/uploads/admin/article_thumb/20201210/3e29f368aa3bbd08416c7d1a78041d09.png)
Excel随机函数公式
![](/static/index/images/article/time.png)
Excel随机函数就是随意生成数字的函数,通常可以利用随机函数来抽奖,生成随机的数字等,在Excel中也有很多作用。如果你还不知道怎么样生成随机函数,一起来学习一下,下面给大家分享三个Excel随机函数的公式。
![](https://www.xqppt.com/uploads/admin/article_thumb/20201214/c82fa8cf1d10c2b370005dd3db2eb941.png)
![](https://www.xqppt.com/uploads/admin/article_thumb/20201214/6dae50bb21303e21a31bc5a945991cde.png)
![](https://www.xqppt.com/uploads/admin/article_thumb/20201214/493804839f36916a2061bd81150f042f.png)
Excel如何冻结首行
![](/static/index/images/article/time.png)
在Excel中,数据比较多的情况下,都会使用冻结首行功能,将表头冻结住,这样往下拉数据的时候,都能清楚的看到表头标签,那么在Excel中如何冻结首行呢?
![](https://www.xqppt.com/uploads/admin/article_thumb/20201214/c2cf45bd2ce99103916fd49e506b0ad9.png)