![](https://www.xqppt.com/uploads/admin/article_thumb/20210122/34ad87741fe86d1a57f89ec0a998de04.png)
除了sum求和函数,你还知道哪些求和函数?
![](/static/index/images/article/time.png)
Excel中求和操作是经常都会用到的,如果你只会sum求和函数,你会发现很多求和操作无法完成,因为还有很多复杂的求和操作,下面一起来学习几个不错的求和技巧。
![](https://www.xqppt.com/uploads/admin/article_thumb/20200724/c1dff958f5a7906160fb057e156b7285.jpg)
![](https://www.xqppt.com/uploads/admin/article_thumb/20200421/1ade8eb623d905e81cbc3075974f799e.png)
![](https://www.xqppt.com/uploads/admin/article_thumb/20200615/27f19f438df5e4074960024850dcf3ca.jpg)
为什么Excel录入身份证老是错误?这几招搞定它!
![](/static/index/images/article/time.png)
在Excel中输入身份证经常会出现一些错误,下面给大家演示在Excel中录入身份证可能出现的三种错误和解决方法!
![](https://www.xqppt.com/uploads/admin/article_thumb/20200319/7dbd1b3858318db1f91ee2df05d1857a.png)
![](https://www.xqppt.com/uploads/admin/article_thumb/20200722/62f40df9a77327c765c48601d6676873.jpg)
提取Excel单元格中的英文、汉字、数字,用Power Query轻松解决!
![](/static/index/images/article/time.png)
日常工作中都会遇到一些不规范的数据,对于数据的提取是个头疼的事情,今天教大家用Power Query快速提取你想要的内容,超简单,又实用的技巧。
![](https://www.xqppt.com/uploads/admin/article_thumb/20201225/762234eb05ff25dd92faca5b59e8981a.png)
![](https://www.xqppt.com/uploads/admin/article_thumb/20201222/78e5c026f3fab94750b2f8bcb89f5ec9.png)
![](https://www.xqppt.com/uploads/admin/article_thumb/20201211/6f47f5771c108e89574cc69549585936.png)