手机号段查询列表
输入手机号码：
手机号码：
号码类型：
手机号段列表:&&下面列表里的号码仅供查询使用！不销售，买号请点击进入->
中国移动 网络：GSM、TD-SCDMA
中国联通 网络：GSM、WCDMA
中国电信 网络：CDMA、CDMA2000
扫码关注微信公众号：gouhaowang
(C) 圣元泰吉（北京）投资管理有限公司旗下品牌： 版权所有 京ICP备号&p&几天前刷知乎的时候，偶然看到了一个话题，“怎么背英语单词才高效”，回忆起学生时代的各种挣扎与尝试，现在想来还是觉得蛮有意思。&br&不清楚普遍的工科生是否也是如此，不过对于我而言，在语言习得上确实没有什么天赋，尤其是在背单词这件事情上。&/p&&p& 在那个诺基亚盛行的年代，学习英语的软件近乎于零，而如今的手机APP对于当年的塞班系统更是天方夜谭。那时候想要查一个单词是什么意思，除了文曲星之类的电子词典之外，似乎真的只剩下厚厚的英语字典了。而我在长达数年的英语学习过程中，背英语词汇基本上也都仅仅只是遮挡单词嘴里默念。&/p&&p& 后来，我觉得这种方式背单词的效率实在是太差了，于是就用Visual Basic写了一个背单词的工具，可以随机背词汇，帮你校对正确与否，还能温习错误频率较高的词汇。而下面这张照片就是当年开发的工具，曾经还用来背过德语单词。&/p&&figure&&img src=&https://pic4.zhimg.com/v2-7edec283d3b258de714b25cf0b63643b_b.jpg& data-caption=&& data-size=&normal& data-rawwidth=&1080& data-rawheight=&593& class=&origin_image zh-lightbox-thumb& width=&1080& data-original=&https://pic4.zhimg.com/v2-7edec283d3b258de714b25cf0b63643b_r.jpg&&&/figure&&p&可惜随着时间的流逝，再也没能找到当年这个工具的代码。而当我前几天在知乎上看到这个问题的时候，心中尤其感慨，于是就重新用MATLAB写了类似的一个工具。&/p&&figure&&img src=&https://pic2.zhimg.com/v2-9d4ec300a417fed1fdce31_b.jpg& data-caption=&& data-size=&normal& data-rawwidth=&921& data-rawheight=&474& class=&origin_image zh-lightbox-thumb& width=&921& data-original=&https://pic2.zhimg.com/v2-9d4ec300a417fed1fdce31_r.jpg&&&/figure&&p&首先通过几个动图来简单地了解一下这个工具的一些小细节以及如何使用。&/p&&p&&br&&/p&&p&01 加载数据库&/p&&figure&&img src=&https://pic3.zhimg.com/v2-ad8de68fc68eada7cc5b8_b.jpg& data-caption=&& data-size=&normal& data-rawwidth=&984& data-rawheight=&590& data-thumbnail=&https://pic1.zhimg.com/v2-ad8de68fc68eada7cc5b8_b.jpg& class=&origin_image zh-lightbox-thumb& width=&984& data-original=&https://pic1.zhimg.com/v2-ad8de68fc68eada7cc5b8_r.jpg&&&/figure&&p&数据库是以Excel的形式体现，其中包括三列，分别是英语单词，中文意思，以及在背单词过程中统计的错误频率。而目前在工具的使用过程中，数据库是大学英语四级词汇。数据库是能够根据个人需求进行替换的，你可以换成六级词汇，也可以换成自己所需的语种，比如德语、法语，甚至你还可以换成古诗背诵，或者是针对小孩的加减乘除的题目。 &/p&&p&用途的自由度很大，只需要按照Excel的格式需求，更换数据库的内容。&/p&&figure&&img src=&https://pic1.zhimg.com/v2-ec8cbd70863daa7ad0cc_b.jpg& data-caption=&& data-size=&normal& data-rawwidth=&663& data-rawheight=&178& class=&origin_image zh-lightbox-thumb& width=&663& data-original=&https://pic1.zhimg.com/v2-ec8cbd70863daa7ad0cc_r.jpg&&&/figure&&p&&br&&/p&&p&02 选择背单词的模式&/p&&figure&&img src=&https://pic3.zhimg.com/v2-7bdf80fde3f518d841f2a_b.jpg& data-caption=&& data-size=&normal& data-rawwidth=&640& data-rawheight=&384& data-thumbnail=&https://pic3.zhimg.com/v2-7bdf80fde3f518d841f2a_b.jpg& class=&origin_image zh-lightbox-thumb& width=&640& data-original=&https://pic3.zhimg.com/v2-7bdf80fde3f518d841f2a_r.jpg&&&/figure&&p&在模式选择上，默认的是非记忆模式，也就是可以浏览单词以及相对应的中文意思。除此以外，可以选择英语模式，用于记忆中文意思，也可以选择中文模式，用于记忆英文单词。&/p&&p&03 选择单词范围&/p&&figure&&img src=&https://pic1.zhimg.com/v2-b3ee6d4ccc41b6739882_b.jpg& data-caption=&& data-size=&normal& data-rawwidth=&984& data-rawheight=&590& data-thumbnail=&https://pic3.zhimg.com/v2-b3ee6d4ccc41b6739882_b.jpg& class=&origin_image zh-lightbox-thumb& width=&984& data-original=&https://pic3.zhimg.com/v2-b3ee6d4ccc41b6739882_r.jpg&&&/figure&&p&在单词范围选择上，可以选择背数据库中所有的词汇，或者选择只背没有背过的新词，还可以选择只背曾经错误的单词。&/p&&p&04 背单词&/p&&figure&&img src=&https://pic3.zhimg.com/v2-db9c12ac245edb346e1ab_b.jpg& data-caption=&& data-size=&normal& data-rawwidth=&984& data-rawheight=&590& data-thumbnail=&https://pic4.zhimg.com/v2-db9c12ac245edb346e1ab_b.jpg& class=&origin_image zh-lightbox-thumb& width=&984& data-original=&https://pic4.zhimg.com/v2-db9c12ac245edb346e1ab_r.jpg&&&/figure&&p&在背单词的过程中，以背英语单词为例，在写完之后，点击对比的按钮，记忆正确的单词将会显示绿色，而背错的单词将会显示红色，同时会在背错的单词后面通过中括号显示正确的单词。&/p&&p&&br&&/p&&p&05 错误频率录入数据库&/p&&figure&&img src=&https://pic3.zhimg.com/v2-092b00ddeb15fd9f1b0eece9_b.jpg& data-caption=&& data-size=&normal& data-rawwidth=&984& data-rawheight=&590& data-thumbnail=&https://pic2.zhimg.com/v2-092b00ddeb15fd9f1b0eece9_b.jpg& class=&origin_image zh-lightbox-thumb& width=&984& data-original=&https://pic2.zhimg.com/v2-092b00ddeb15fd9f1b0eece9_r.jpg&&&/figure&&p&最后通过“Rewrite Database”的按钮，就可以把这次背单词的结果录入数据库，更新错误频率。Excel数据库的另一个好处，就是能够通过筛选的功能，过滤出平时练习过程中经常出错的单词，可以打印出来，有针对性的复习一下。 &/p&&figure&&img src=&https://pic2.zhimg.com/v2-ccc9cfbb59f_b.jpg& data-caption=&& data-size=&normal& data-rawwidth=&900& data-rawheight=&60& data-thumbnail=&https://pic4.zhimg.com/v2-ccc9cfbb59f_b.jpg& class=&origin_image zh-lightbox-thumb& width=&900& data-original=&https://pic4.zhimg.com/v2-ccc9cfbb59f_r.jpg&&&/figure&&p&&br&&/p&&p&以上就是这个工具的大致使用过程。有兴趣的朋友，可以在公众号后台回复“&b&背单词&/b&”自动获取下载链接。&/p&&p& 不过，需要注意的是，因为这个工具是在一个小时内仓促完成的，只是大致呈现我的思路，以及能够满足我个人的基本需求以及使用情况。不可避免的是，在你们使用的过程中，可能会出现我未曾测试到的Bug，或是你认为不合理的功能。我在这里恳请你们的谅解。&/p&&p& 这个工具整体的实现思路并不难，GUI的框架，再加上字符串的对比，使用的函数只是strcmp而已。我很感谢知乎的朋友对我这个工具的认可，不过授人以鱼不如授人以渔，我更希望对这个工具感兴趣的朋友可以稍花些许时间根据自己的需求DIY独属于自己的背单词利器。&/p&&p&&br&&/p&&p&以上&/p&&p&如果你有兴趣，欢迎关注我的微信公众号“打浦桥程序员”，谢谢&/p&
几天前刷知乎的时候，偶然看到了一个话题，“怎么背英语单词才高效”，回忆起学生时代的各种挣扎与尝试，现在想来还是觉得蛮有意思。 不清楚普遍的工科生是否也是如此，不过对于我而言，在语言习得上确实没有什么天赋，尤其是在背单词这件事情上。 在那个诺…
&p&&b&EXCEL常见技巧锦集&/b&&/p&&figure&&img src=&https://pic3.zhimg.com/50/v2-6b1fef825b1fbfe5d068efb_b.jpg& data-rawwidth=&640& data-rawheight=&427& data-size=&normal& data-default-watermark-src=&https://pic2.zhimg.com/50/v2-614c16dfb1be3f5784faebc_b.jpg& class=&origin_image zh-lightbox-thumb& width=&640& data-original=&https://pic3.zhimg.com/50/v2-6b1fef825b1fbfe5d068efb_r.jpg&&&/figure&&p&&b&一、基础操作部分：&/b&&/p&&p&001、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D2%26sn%3Dee3c4a601d4fe26ed7d45%26chksm%3Deca1a4d55acaee6bb64fdcc2dc337370beescene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&基础环境介绍&/a&&/p&&p&002、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D2%26sn%3D7def3f08b74549dbe1c196ecddc1a595%26chksm%3Decaf593cece7fa402e040dc934cd9c8d09a5%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&录入技巧（光标跳转设置、重复上面单元格的内容、填充、分数录入、输入当前日期）&/a&&/p&&p&003、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D2%26sn%3D61f964be1c%26chksm%3Deca139dbdfbadc1df81e64bdec788c33f%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&基本操作技巧（多个单元格内容复制到一个单元格中、CTRL+D填充、快速做序列号）&/a&&/p&&p&004、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D2%26sn%3Dd7fbd13a87d3dchksm%3Decaa2af8d94ff83d5e17b0ebff4fb762e2f%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&实时预览、双击格式刷、微调字体大小&/a&&/p&&p&005、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D2%26sn%3D663ec1a2c73a199a192f96fb%26chksm%3Dec41286fdb36a89bcc87fd0e7d229baa83ddfa63bedb41fascene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&快速移动、复制、互换位置、凹凸边框制作、给文字添加拼音、斜对齐&/a&&/p&&p&006、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D2%26sn%3Db6c2d3c130cb853%26chksm%3Deca16fa3f429bce987d8b96%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&跨列居中、快速选定内容、斜线表头的制作&/a&&/p&&p&007、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D2%26sn%3Ddff6e77de%26chksm%3Dec41287edb36aaabcecdaa558b024b6e%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&自定义数字格式1&/a&&/p&&p&008、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Db4a0acfb2ad13df0c2c0af%26chksm%3Dec412f30db36aedcdc43bbaef9aa9c85acbc45208ca5eee17e7d7c10909%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&自定义数字格式2&/a&&/p&&p&009、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D93fbf9c7db0a894707cfd877bae6d661%26chksm%3Dec412cdcdb36a5ca142e245b81ac507db7efb5c98b0c9301dc1bbe8eef%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&表格样式（单元格格式、表格样式、一次性编辑多表）&/a&&/p&&p&010、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D67b666a97e4b493abf4da7%26chksm%3Dec412c8cdb36a59ab20a37a8dc2b8ad7c460fdebde26524facff993%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&不完全重复的项如何删除&/a&&/p&&p&011、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dbade06c4e13bc34df37c3ad%26chksm%3Dec412c8fdb36a2ca08cc0d08a0f880fbb8030fd41acebf51%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&剪贴板的用处你了解吗？（多列合并一列、复制多个单元格内容到一个单元格、多表合并到一个表）&/a&&/p&&p&012、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D05b4ceef1b%26chksm%3Dec412c81db36abc6ee880f3e5aa27aa935b8acd10b83b43d17b722e%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&初识条件格式&/a&&/p&&p&013、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D19cf2e8d64e3b99e50aa%26chksm%3Dec412c9ddb36a58bf8fec0e4cabffdb4b168a94b1a845bescene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&快速隔行或者隔列插入&/a&&/p&&p&014、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dcae3b750f018ce792965fbcfchksm%3Dec412c64db36af6a789f82a8cde4f6a81192defa2ca6cb8b81d8cbce3e27b4d3ea9%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&强大的CTRL+E（仅限13版本以上的excel）&/a&&/p&&p&015、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dffadcb1f2aeb71a2f9d2524aef46aefd%26chksm%3Dec412c74db36a562e2af897e166bdfa47a1a2f11ascene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&你真的懂查找和替换吗？&/a&&/p&&p&016、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D00a084bfab07a603ae89%26chksm%3Dec412c40db36a556e11eacc44cdbb427e81fd99afdb10b9e%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&全面了解选择性粘贴&/a&&/p&&p&017、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dc56b60f1a6a0e1f10bc7c0efa1a924bc%26chksm%3Dec412c5bdb36a54d4cd1607efd41c74fc83ac518baf210f467a29fef4fdc38898b%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&保护工作表的N种方法&/a&&/p&&p&018、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D2ff85cd154e%26chksm%3Dec412a89db36a39fca820f2a0a54c8911aff187eae3f3f6c602b1c247cfc7e89%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&数据透视表基础&/a&&/p&&p&019、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Ddd2210aaa85a30e3bcad5b7%26chksm%3Dec412c3cdb36a52a55f21aa7f6632b3fdbcecb92a7ea304ff5beb8e26e1ccfa3e23%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&你该熟练掌握的数据透视表技巧&/a&&/p&&p&020、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D450b10cb6ae4ff66dd396dfchksm%3Deca1b06efb603da1aa71cf7f4e469a788a52bdd9696a%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&多重合并数据透视&/a&&/p&&p&021、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D31ada109cf70a3a8b4bb8aec42b5e9cd%26chksm%3Dec412c0fdb36aec7d66e503f8dc7fc8bf328ce93ec9c9dc29affde3e%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&破解工作表保护密码的黑科技&/a&&/p&&p&022、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Db9aa2fb369ccb%26chksm%3Dec412deddb36a4fb38ec2b3f723522dfc6b907b0d3a2e91cffdfca%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&让你更快一点（F2、CTRL+TAB、ALT+TAB）&/a&&/p&&p&023、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dde7ad64230af4eebf83f64a60e5a232e%26chksm%3Dec412ddcdb36a4caad3c73e29bda67224ae0bde589cb%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&提取实战（CTRL+E）&/a&&/p&&p&024、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D8e65cdeec5c687dab3d75%26chksm%3Dec412ddfdb36a4c92e8cec843e7dd24f9be8f991e0cdd4dcc5bea964ab2aee516%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&你可曾遇见这样的烦恼（被超链接、对齐之缩进）&/a&&/p&&p&025、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dbdbb3bce9%26chksm%3Dec412d24db36a4325cfee1bdea19ff977f8b5a11a10e0c1b56c38e9%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&合并单元格筛选查看技巧&/a&&/p&&p&026、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Df27ffb85b4ba2f134d60af277fa92a5f%26chksm%3Dec412a6cdb36a37ae856f35c0edacd274c55338fca83d785f3cabad17ef940bb922%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&多个工作表快速合并&/a&&/p&&p&027、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D43e039e34a51fc32526b%26chksm%3Dec412a5fdb36aad2ce5688014aaacebbeb2cddafd20e272e607ef9a8bddf02b13%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&E表打印技巧&/a&&/p&&p&028、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dcaea18f671b0a%26chksm%3Dec412bbddb36a2abfcee1b9ef52dbdf7eed7e49bscene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&数据验证不允许输入不符合条件的值怎么破？&/a&&/p&&p&029、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D7c57a554dd%26chksm%3Dec412bb4db36a2ad2b3beebbefbec751cbe07afcaaa%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&输入法里深藏的技巧&/a&&/p&&p&030、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D6d584ed6c22c35%26chksm%3Deca1f4e2b29cca30b3b7b4bacb%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&用查找法快速查看工作表&/a&&/p&&p&031、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D8fc42bd53795c69cbe6a2%26chksm%3Deca1f6bae523e21a07cc5cda1cc39afec543%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&快速制作工资条的三种办法&/a&&/p&&p&032、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D1bb06eba8%26chksm%3Dec4128ccdb36a1da5f0cf00b03edfedb4c0c300dfeb1218%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&高级筛选&/a&&/p&&p&033、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dbb982b21f9c11f87f97fd32db7ef7e12%26chksm%3Dec412d18db36a40ee6fc34b62b0537fea5f207ec44c934d223e3cee321ce3fb5e%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&浏览长表的技巧（冻结行列、单元格、快速返回表头）&/a&&/p&&p&034、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3De5d1ebba18a6b52c383d8f%26chksm%3Dec4128afdb36a1b9fcdd56d02b0a49a94affe17a815fdb16333afb1e7%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&让你爽翻了的邮件合并功能&/a&&/p&&p&035、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D4f9ec5cef9a611ba907f%26chksm%3Deca1b71c49a69f87b69bbfa75fd32a68ae822%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&2016版excel新增的几个功能&/a&&/p&&p&036、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Ddc96e934fb2ed5a509c709%26chksm%3Deca0c648b6c553a0b5b60eecb9fa6de820df%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&EXCEL中按方向键光标居然不动了&/a&&/p&&p&037、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D64eeb2a452a5d226a626%26chksm%3Deca0c7cd7a8da923ed81faf8ef9d9b9c0fc69691f7fbdb7bff8d331f%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&基本操作练习题（分列，定位）&/a&&/p&&p&038、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D9b860ffbbc56e7%26chksm%3Dec4129acdb36a0ba2abf179eb536bd1bdf980b5c605cedbc89c6ad9091a7abeed%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&一次性复制格式同时去掉数据中的公式&/a&&/p&&p&039、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Ddd361bc188f310ec831a9f%26chksm%3Deca0b691cc018d5edbb3cd3a21faea10bdf3%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&一招让以科学计数法显示的数据恢复本来的面貌&/a&&/p&&p&040、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dede318d9facc%26chksm%3Dec4129bfdb36a0a94260c6cbc94ef29b6de610d5af9a8cdea8ee9368cfb299cff5%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&给你的Excel设定个允许填写日期（数据验证）&/a&&/p&&p&041、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D7db94b894d1%26chksm%3Dec4129bbdb36a0ad7adc8c0d73c6667c8ddd7e55af444d1e3fb3dc%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&口内打对?或者?怎么弄&/a&&/p&&p&042、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D7db94b894d1%26chksm%3Dec4129bbdb36a0ad7adc8c0d73c6667c8ddd7e55af444d1e3fb3dc%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&没保存的文件意外关闭该怎么办&/a&&/p&&p&043、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D20f0aed870e67c73c035f0f%26chksm%3Decafe3129d93ddafd87caceaf438b5d38c505d14d704a83%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&批量获取文件名&/a&&/p&&p&044、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D361f9016dbe6cb5baaeb%26chksm%3Decafe61859f9ddfd16fcfc2a56551f74dcfbe81aa3142c%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&批量在Excel中插入照片&/a&&/p&&p&045、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D7acc2edbe4d892e19cd650da7d78e054%26chksm%3Decafaeddf36c454308cdaa8a1dfscene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&邮件合并批量生成N个文档&/a&&/p&&p&046、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D2f07e6f1453%26chksm%3Decafa051a4136ea9adfbafc85580ad7fbfd54818cbc2141e%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&邮件合并批量插入对应的照片&/a&&/p&&p&047、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dc5eab594dc7e4d1d431b%26chksm%3Decaf8ef4e54c49d8d60a57b68d5cfde585b7e271d35f4bfc82ef0f787%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&批量修改文件名&/a&&/p&&p&048、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D4a2c31d8103edc486eafb%26chksm%3Decaf3fbca2af5a96a500aac3fb5ec3c5c5781a3eafcdd%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&跨列、跨越居中&/a&&/p&&p&049、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3De68db87a55d32a7e6609e%26chksm%3Decafaeacd1ad2ebbefab49f7cfaceb578a6%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&在Excel中插入截图的技巧&/a&&/p&&p&050、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D7d684da85dab0b23a1cad0%26chksm%3Dec41269bdb36af8df28ed0ecd3b9eb4fa51f7890acb2ec22d9e89%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&分列功能里的技巧&/a&&/p&&p&051、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dfce900d419c686b89b5aeda97ad738c9%26chksm%3Decaed282c152b0eeb44443efe1cfb34fefff137a2e11ffc%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Excel中的创建组&/a&&/p&&p&052、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dcf05acf7c%26chksm%3Decaee1d461fb81d8dbae3bbf84bd604a40a03f98f5b6ebf20f7fce%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&根据相同的内容批量合并单元格&/a&&/p&&p&053、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D4d5dcb3eb2f341f0b356da869d51d291%26chksm%3Decaea4e6d3c3fa8df5eb012871ecc2a4a%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&账期提醒表&/a&&/p&&p&054、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Ddf913b463e21bdaed1c12a5fbchksm%3Decae13b79ed33bed54b2efa335e3a8d19fe51f436e209ff4db979cb5%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&一分钟恢复损毁的EXCEL文件&/a&&/p&&p&055、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dfb503fe05f0f317be125bc%26chksm%3Decae15fde6d2044cdac2f52ccba0fcf49f3aa44c104%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&13个必学的Excel技巧&/a&&/p&&p&056、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D95db0cd20baf85%26chksm%3Dec41258adb36ac9cfd0b37749bce119cb33a18cdefd3a220c00e127a15fcaffa69%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&给excel打印文件添加水印&/a&&/p&&p&&b&二、函数部分：&/b&&/p&&p&001、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Df4aee3e11%26chksm%3Dec412dd6db36a4cdfdbf8b5ad11c3b29fe99ffc93ef30b%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&来自一个护士的烦恼（列与矩阵互转）&/a&&/p&&p&002、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D2%26sn%3D8e2025cedd3ec3f3564fbf%26chksm%3Decae557e5b3da6c4ee107dc5af3fdfa70cddea5ce5dc19e9%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&sum函数经典用法&/a&&/p&&p&003、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D68d3a96a32be75e9ccddec8%26chksm%3Dec412d79db36a46fda92cb12ddcfef1c76e69e1daae98ed0f1ca4a%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&sumif函数（条件表达方式）&/a&&/p&&p&004、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Daf2b4f0bf382b46f146ceac%26chksm%3Dec412d76db36a460d80cfc67b765c772f32da1b63c8d028bcea3d218acscene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&sumifs函数（多条件求和）&/a&&/p&&p&005、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D1ae939e4b27b4f2d92bf%26chksm%3Dec412d44db36ade54c68fc2bb72e4f901a24e7ad12cd06cdb9db0672ee2ccd117%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&数组思维下的sumifs&/a&&/p&&p&006、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D8e0df1dec%26chksm%3Dec412d5edb36a448e9107d8ace18cb43caf99a2a33f83bd094ca977ee80d14ebe8c%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&强大的sumproduct函数&/a&&/p&&p&007、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Deac9da1dac%26chksm%3Dec412d57db36aace2a515ae77aeb3d1b4cfb9cdcc882b%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&多条件求和练习题（sumproduct、sumifs、sumif、sum）&/a&&/p&&p&008、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Deac9da1dac%26chksm%3Dec412d57db36aace2a515ae77aeb3d1b4cfb9cdcc882b%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&if、iferror普及课&/a&&/p&&p&009、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D8f48b86d595b84a6c9e8d88echksm%3Dec412d2cdb36a43a381f06d22eaebac8c7a73291ed%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&工作中需要的不仅仅是四舍五入（round、roundup、rounddown、int）&/a&&/p&&p&010、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dbdbb3bce9%26chksm%3Dec412d24db36a4325cfee1bdea19ff977f8b5a11a10e0c1b56c38e9%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&舍入函数（floor、ceiling）&/a&&/p&&p&011、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dbb982b21f9c11f87f97fd32db7ef7e12%26chksm%3Dec412d18db36a40ee6fc34b62b0537fea5f207ec44c934d223e3cee321ce3fb5e%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&计数函数大合集&/a&&/p&&p&012、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D1834c2bad9fcachksm%3Dec412af9db36a3eff7afe6d5a3b3a5ba7b116c562a422ef8b73cd9c%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&女神（vlookup）驾到，快来迎接&/a&&/p&&p&013、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dd8d387ec188ea%26chksm%3Dec412af3db36a3e5e9e06c0c3bbf6b1d1ecc9f71e284e6b%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&经典的查找函数lookup&/a&&/p&&p&014、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Da464bc2c49b8c29ab43b2b%26chksm%3Dec412acbdb36a3ddea024bacfd24b5f95f25dec5cc21770dabf4fe9d96%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&lookup的查找原理&/a&&/p&&p&015、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dcb6d06df948cf485abbb3%26chksm%3Dec412ac2db36a3d46f402f9ab5feacb8979abad%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&字符串中的数字提取（isnumber、match）&/a&&/p&&p&016、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D08fec1a60ba6f80fdaf221c9e27eef24%26chksm%3Dec412ad1db36a3c78ca7eb362fdbc746be330ee94296c0bffdcba8b%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&字符串中的数字提取进阶！（N^0=1）&/a&&/p&&p&017、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dc078070dcfcc8a1c7f1b82b8e9b570b6%26chksm%3Dec412ad0db36a3c6cfac21a4e61ba1f35efad51cad%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&求区域中最后一个数字（max、min、mod、indirect、text）&/a&&/p&&p&018、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D79ab0f40ca69%26chksm%3Dec412aa6db36a3b07d34adc5dcd7dbb21f06a50dbacac37f%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&检验下你的水平（区间判断if、lookup、len、lenb）&/a&&/p&&p&019、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dacdd53c728f619%26chksm%3Dec412aa0db36a3b6f59e01eac32dec0a30a028e2cff19c7c70a3ca56fd3ed5d94c4fdfa359ee%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&温故而知新（前面所学函数汇总）&/a&&/p&&p&020、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Ddcacb86cf992bb8%26chksm%3Dec412ab6db36a3ab1f4ea94b56544cdf24af3f943fadd6fdb7362dd%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&在多表中查询数据（函数中引用工作表的办法）&/a&&/p&&p&021、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D72a2518bfabe3ee6b04f784fdd6e47a5%26chksm%3Dec412a9ddb36a38bdd9e5bc2f45a99b658a3549f0bbc324a6d21a44bd2d%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&连续编号的技巧（合并单元格编号，筛选、隐藏行后的编号）&/a&&/p&&p&022、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D72a2518bfabe3ee6b04f784fdd6e47a5%26chksm%3Dec412a9ddb36a38bdd9e5bc2f45a99b658a3549f0bbc324a6d21a44bd2d%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&把一列中大分类相同的小分类放到一行的方法&/a&&/p&&p&023、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dd41fef317da%26chksm%3Dec412b30db36a226ee6c61e3a78fc6c04efb7a075f2cae1cb5f668ab6f7c07b5810c%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&把一列中大分类相同的小分类放到一个单元格中的方法&/a&&/p&&p&024、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Da106e9c18c864dc2c8e9%26chksm%3Dec412a94db36a382a55cd04e195d1f2fa5efba0dscene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&银行账号间自动加空格&/a&&/p&&p&025、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Da106e9c18c864dc2c8e9%26chksm%3Dec412a94db36a382a55cd04e195d1f2fa5efba0dscene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&两列中互相重复的数字提醒&/a&&/p&&p&026、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dc44063e8edd1a41aa4739e%26chksm%3Dec412a69db36a37fb947beef04398af8cac631bef406df158c6cc%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&时间日期函数（datedif）&/a&&/p&&p&027、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D020e3a3dd3c05d51d3808aeedbc863c8%26chksm%3Dec412a67db36af8f0f8d9dddab7c71b02%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&人民币小写金额转换大写&/a&&/p&&p&028、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D272e48cfaa092bdcd224d%26chksm%3Dec412a7edb36aaaa275aa6a8cd0e1e7b8bc6a29d0c844%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&练练你的基本功（每个分类编序号、合并单元格求和）&/a&&/p&&p&029、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D1c22fc8fd0a71be85e6e%26chksm%3Dec412a5adb36a34c3f6a7c68d9fa10ef4f56e0e529e8a01ef34657f%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&rept、trim函数&/a&&/p&&p&030、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D4ea823f1c5e735b8ae4e51%26chksm%3Dec412a51db36a347e86a08acede69805ddac4d819ecf4b32ff6c7c64c9ac3df68%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&知其然也知其所以然（把一行字按照分隔符拆分成一列）&/a&&/p&&p&031、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3De81b99baccc6be%26chksm%3Dec412a2cdb36a33adb2d00add7b7acf0abd107b14cbab6dce7d0ff8ad%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&三个简单的一看就会的函数（large、rank、phonetic）&/a&&/p&&p&032、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D3fb792b68ba93db0e5a94dc%26chksm%3Dec412a2bdb36a33dbb8a387b9bc236f4fc9fea3aa507%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&必学的技巧（累计求和、带单位的数字求和、small）&/a&&/p&&p&033、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Da2bdd1f9631afe8d77262%26chksm%3Dec412a20db36a336bb5d6cb1d0cf7d6eaece0da3aa10eb49%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&综合练习（从身份证号码中提取生日、性别）&/a&&/p&&p&034、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D3b3b9e25dde3bf1de7b88040daacfea3%26chksm%3Dec412a35db36a32396abcf2f15a91bc8a35e87fa3c25cabe5de343cc94e74bcf%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&根据填充颜色求和（get.cell、formulatext）&/a&&/p&&p&035、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D0ebb8aa81cd311a8d66a191%26chksm%3Dec412a0fdb36ad4cba7ce5f04e9901fcc75439cbab785fc19d69a4%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&获取演讲比赛成绩的前三名（综合练习）&/a&&/p&&p&036、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D5dc410a22c17c0769ef5bfaaeea058b6%26chksm%3Dec412a08db36a31ef84d57d695bb1e107cc16b38ede7%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&逆向查询（vlookup、lookup、index+match）&/a&&/p&&p&037、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dceda07d7d7b9f05b83c51a1%26chksm%3Dec412a05db36a31316bcdf3cf82afc9fad7af68c785b7c865eb0be7ee%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&统计区间个数的专属函数（frequency）&/a&&/p&&p&038、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D3febae76f347ae587a25e%26chksm%3Dec412a1cdb36a30a3ccb2fc16b82e13c29c11c4af8debc%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&循环引用的妙处&/a&&/p&&p&040、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D61c5f526070adbb361acf44532dde89d%26chksm%3Dec412a1adb36a30c43c89b78acb6eb0260b8ddf0a76b7db12c3006%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&高手的玩法（查找综合练习）&/a&&/p&&p&041、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D1b5c2a47b85ee68ef4e0a5e%26chksm%3Dec412a10db36ae02d10a7d0ffc6afa9f4ec35edscene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&隔行隔列求和&/a&&/p&&p&042、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D1dc363ca4af8d%26chksm%3Dec412beedb36a2f831c4cf12eed75eb80a7fb2692dcb822f642b1d72%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&提取不重复的值&/a&&/p&&p&043、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D5d67b53fcd1cb400d49d4e%26chksm%3Dec412beadb36a2fcdadbf6e935b6f73c52be44cecbfcfdb883e3e707%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&数据库函数dcount、dcounta&/a&&/p&&p&044、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D1d2c3ea5aa2f822d0319bd7fad38f7f1%26chksm%3Dec412bfddb36a2eb54fdeb089f5cf2b83e5ce4bfff1dafa%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&时间函数大全&/a&&/p&&p&045、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Db462b7fdad7%26chksm%3Dec412bfcdb36a2ea392a65d812de1de59fe4a85ac91b26beca45c9d4cea4ebed2fc%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&日期函数大全1&/a&&/p&&p&046、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D537acdee441e8dc20d27e9b2%26chksm%3Dec412bf6db36a2e0a619badc24cadcea16ed2ceb4a87e6%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&日期函数大全2&/a&&/p&&p&047、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D60f83deef3db939ce69d075%26chksm%3Dec412bc1db36a2d69f454b946a36f9ab8d1bd9442ca3cbda92af69e51af55f6f80%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&条件排名的四种思路&/a&&/p&&p&048、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D6e4fc2a070%26chksm%3Dec412bc0db36a2d6ec9ffa8cf8dbff7bc1db6b0d681e3c0fb2e67c%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&transpose函数&/a&&/p&&p&049、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D174fc579f0bbda71a9c6902%26chksm%3Dec412bc3db36a2d58a20f21b5670821aba404e0d749b2c%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&hlookup函数&/a&&/p&&p&050、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D6ce386d1d514b5182f9ed%26chksm%3Dec412bc2db36a2d49baf32cbbfeb95da815cbb8e74dc4700%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&address函数&/a&&/p&&p&051、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D9cce3aff2e07d71dbdb0c7d%26chksm%3Dec412bdbdb36a2cda23e6ebb8b3eff96ebd3b2e84c45e1ad%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&打印表中某个单元格按次序引用一列的内容&/a&&/p&&p&052、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D59beb8dc363f45baefac9b3%26chksm%3Dec412bd3db36a2c5faf0c4a76de6fccba986bf3981dfbascene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&文本运算式求值&/a&&/p&&p&053、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D57dd86fa21ba0e0b2fcef6%26chksm%3Dec412bbcdb36a2aae9b92a470da8ec2d4ee5f94db8dcbb8ca4c6666%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&多级下拉菜单的制作&/a&&/p&&p&054、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D96b6fa23e7c7cchksm%3Dec412bb5db36a2a3be9d42eab2d2f5b49d9d5a785bec084abbd0e0bc%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&联想式下拉菜单的制作&/a&&/p&&p&055、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D7eefa1fcbf2%26chksm%3Dec412b84db36a0b214e886d7fb38cb22c572a81f5d88c2ad91bb8b45fbscene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&用excel做个九九乘法表&/a&&/p&&p&056、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Da101eb7ac79%26chksm%3Dec412b92db36af221707bec0ea413b8af65b17eb6e797cdd21a8edb%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&给你的工作簿做个目录&/a&&/p&&p&057、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Ddb5232fdca0a16da153ed%26chksm%3Dec412b6ddb36a27bf1efbdfb42baf994escene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&hyperlink函数&/a&&/p&&p&058、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D71ae92fb2a297c5a5b36d8a6f27bb296%26chksm%3Dec412b65db36a273ad22a157cf902ef843053dfcedba821f54db1814%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&最大公约数函数GCD&/a&&/p&&p&059、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Db361aa72a9a%26chksm%3Dec412b64db36a272d38a378e725c45ff752cd98ea3a04a1a87adf993a5b0240ecd%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&最小公倍数函数LCM&/a&&/p&&p&060、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dc77eeaf29d575f803c076ddea29d89b3%26chksm%3Dec412b67db36ada050bfeabd8d2eab4eed%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&去掉一个最高分，去掉一个最低分求平均值(trimmean)&/a&&/p&&p&061、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Da72a727b991ca72cb10fee2d12c06430%26chksm%3Dec412b66db36accae952afb2debaadaca185%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&没学quotient之前你是怎么求商数的&/a&&/p&&p&062、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D9bc016be1cf95d1e215fd%26chksm%3Dec412b7bdb36a26d4f801e02e99f3e4ef152fe081c34a4f8a074e963e15a333e4%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&检测是否完成任务还可以这样(sign)&/a&&/p&&p&063、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dceaff6cb7bcb54%26chksm%3Dec412b4edb36a80e8fa9b24c3c9cede5a3%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&int与trunc的区别&/a&&/p&&p&064、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D75fdc22f12a38ecbbf03d10cchksm%3Dec412b49db36a25fa10dccdda1d6d4495228ebf9f1b5cc704fec080c7bf95f87b%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&求企业连续几年业绩的平均增长率（geomean）&/a&&/p&&p&065、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D92b6bf7382bafc6de1a72322efa375ec%26chksm%3Dec412b4adb36a25c73eb5ccd73c1d8e87f5628fed69e8f1c%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&英文字母大小写转化，阿拉伯数字转罗马数字（upper、lower、roman）&/a&&/p&&p&066、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Daeb1dbfb58fc7f27e61922%26chksm%3Dec412b45db36a8572ddc17e2dad71ff66a7efa698f381e2bdba7ac%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&product，可曾听说过&/a&&/p&&p&067、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dc0ae658cc0ffa7f49ec12f%26chksm%3Dec412b44db36a6c777d8837edb76e9f334c04a5c3ba8%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&随机函数rand、randbetween&/a&&/p&&p&068、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dcf8aacc1903ef2daf4c98df4fec826cb%26chksm%3Dec412b5ddb36a24b6f333d0fd3cfeefc84b4dffscene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&用excel做个抽奖器&/a&&/p&&p&069、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dbc2a8f802a47f7e1ebd45d%26chksm%3Dec412b27db36a231ee776ee2862aecd4a557d340c85e6a13b633f71cefscene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&根据进货、出货求库存（综合练习）&/a&&/p&&p&070、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D624daed982aae58e4df5b2%26chksm%3Dec412b39db36a22fb0f1dad72cbfc203fd054ce0e238e%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&中文数字转化成阿拉伯数字&/a&&/p&&p&071、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D6ea38b4ecafc244b02699%26chksm%3Dec412b38db36a22e98b543d0a8dca4f561fbbc2e796aa95e686a2a92ac7c9f28dff0%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&这就是我为啥老推荐你使用2016版excel的原因（新增的几个函数）&/a&&/p&&p&072、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D250a9c25bf9a5dc7fd42b00f3efa0358%26chksm%3Dec412b07db36a2112b9dfeda456de5e42fe0ac0d39d4bascene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&综合练习题（表格自动化）&/a&&/p&&p&073、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D6b2737204cbb58bchksm%3Dec412b15db36a203ce2a77d3fa1d9d7d2ce163e8ebaa5c6ed97e5e3150c%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&跨表求和&/a&&/p&&p&074、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dbe26fb236ab3f9a6b45bc%26chksm%3Dec412b11db36a2073dfbdd14d244f7d72f5b6314bfa981a403f5c8ab6f099f1b3e6430c2beb4%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&跨表条件求和&/a&&/p&&p&075、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Df4142cfe3faed5echksm%3Deca1fd11a75d16aac247c24ae2e3b3982%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&自动在很多表中同时提取该表的表名&/a&&/p&&p&076、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D92892aeb3e9ec9419fcecfc36abcf569%26chksm%3Dec4128cbdb36a1dd440b7b26ddc94c17c4d6310add7de315c308b50a2%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&函数综合练习（一道可以考考你函数掌握水平的题目）&/a&&/p&&p&077、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dce8da47e%26chksm%3Dec4128aadb36a1bc3b9bd6fbafaf2c16efc5bed42120ebde1b0b4c0%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&动态表格的制作&/a&&/p&&p&078、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3De7ffdc1b9ec06fdchksm%3Decaed51aa4ac2710eba5a3d21ad20d52e2b0fscene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&HR常用的Excel技巧&/a&&/p&&p&079、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D2b4ace1df51da6b10cc24f7%26chksm%3Deca16f4162dfbc8fae94c0aa43f680d21d79f4df1f%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&从有重复客户记录的数据源里直接提取排名&/a&&/p&&p&080、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D07cd1e31f9cabdaafd6afc42b3e4f73d%26chksm%3Deca1546fe47cce73d2e2d6d0f73c28860a62bda23c0c78fcf1eab66fe95d1ee47f%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&按条件从有重复记录的数据中按名次提取数据&/a&&/p&&p&081、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Da1d05fd034da608a0c45%26chksm%3Deca0a7f655cf1c84c685fb3e340a16%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&显示一行中出现次数最多的字符（code、char、mode）&/a&&/p&&p&082、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dd092fc15c3f26fefbad4e35fchksm%3Dec4129bedb36a0a8cdd0cc0b047d868e44eb07860fad8271cac7956%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&函数大全（对函数分类做个全面的了解）&/a& &/p&&p&083、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D4beadebcde8d8e%26chksm%3Dec4126fddb36afebad6baccb4eebb5cb7eebe4cdf3b967ed%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&抽奖器的制作（照片随名字变动而变动）&/a&&/p&&p&084、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D9cdc0981e19ebd96adebaf983a16d2eb%26chksm%3Dec41266bdb36af7d48a24edfd2e362e728ac9a76adab036ae91e2%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&分解任务遇到的问题（ceiling、floor、sumif通配符求和）&/a&&/p&&p&085、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Ddd58d128b85f39dchksm%3Dec41264edb36afc2d86e3f16dc81dd2ce861f1cb264f5%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&合并单元格引起的各种困扰&/a&&/p&&p&086、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3De5e15d14a241b999b61d%26chksm%3Decae903d335ad05d90ee43f27b6d9df3ef3d52c1e2e5ff9aea117a%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&对一组数据中不合格的数据进行计数&/a&&/p&&p&087、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D3aa597b4307e30fadad35c%26chksm%3Dec41274edb36ae58ae8b47ed4aa3aeb005fef%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&根据多个条件查找对应的区间&/a&&/p&&p&088、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D752cea0bbbca%26chksm%3Dec41274adb36ae5c1ec2a4cac8ff120ef0f269e6ab56c%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&087文章的答案&/a&&/p&&p&089、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D7267cca1f0fcc3c063c51e%26chksm%3Dec41272edb36ae38bd8fad9a55f38ebb5b9ae13b8c3571a17acbc0%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&一个字符串中是否包含另一个字符串中的几个字符的判断&/a&&/p&&p&090、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dbb9aad3ec3ffc0f8achksm%3Dec4124bedb36ada830ee7ce6cbdc77e9c8912ceb92a89f5e%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&相对引用与循环引用的实例练习&/a&&/p&&p&091、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dc3f40c17db0ac2acdfacb91%26chksm%3Decad8aac0b1a49c8fdca5e6f402c48e52d2b835bacd5%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&怎样生成不重复的随机数&/a&&/p&&p&092、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Df482a73e62ea252a9c829%26chksm%3Decad5e76edfcb1a7abcbac630b54be172b185%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&用vlookup进行模糊查找&/a&&/p&&p&&b&三、图表部分：&/b&&/p&&p&001、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D94780bdd62ccce602e8c%26chksm%3Decabdd7a4dea2b0e5c5278028cdfd97f634a6%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&别样的簇状柱形图之系列重叠&/a&&/p&&p&002、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dcfd9faaa0192931ebcb9f%26chksm%3Dec41286fdb36a172dd091b89b4bfd537c629b52fe57c02%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&别样的簇状柱形图之显示系列差距&/a&&/p&&p&003、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Ddb4b6e3ada%26chksm%3Dec41287edb36ac7830bcffa4c93ab4e5a108b911f1e%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&别样的簇状柱形图之电池电量图&/a&&/p&&p&004、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Df056fb5accd53a7b36e276%26chksm%3Dec41285ddb36a14b5e2a63d8d67c9dc30a247bcb4c57377eea251ab6e9ed6cda9%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&借助辅助列制作漂亮的柱形图&/a&&/p&&p&005、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D0f9a052af5f18cfb0330%26chksm%3Dec41285cdb36a14a3cd7f3cd0bdd67c118d43cbf43ee44f1afbd65b8c5f56fb3d%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&双层柱形图&/a&&/p&&p&006、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D3da835638bcb6%26chksm%3Dec41285adb36a14cf1ba5b2c18c2e46f5a11bf8c44aa954ascene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&堆积柱形图之系列线应用&/a&&/p&&p&007、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D595c270fb7cd4fac3bff4%26chksm%3Deca144200bcf831b82dcc8ef51cb72f8eb2%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&柱形图之断层图&/a&&/p&&p&008、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dfe5af9d6b6c13dfa8cf0c%26chksm%3Deca134ed463fbfbf73d6dbf27%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&花式条形图&/a&&/p&&p&009、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dd24d0ea6e03fef5cd2d64cfe%26chksm%3Deca10e11019ff7afb08f66ad1fefc3d0b3%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&蝴蝶条形图&/a&&/p&&p&010、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Db002f979a493d9dbcd690acd%26chksm%3Dec41281bdb36a10d786faebb370fa5c1dafe53e1e458d3bcfb4dfd5%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&折线图添加数据标记和改变线型&/a&&/p&&p&011、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D87c%26chksm%3Deca0e0dedf8a1bfb06aefc5fddacbc063ffcdc4e2e2e131f%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&传神的散点图&/a&&/p&&p&012、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D4a7c8bd59a6fac8b423c9e7%26chksm%3Deca0d71052ddffd9c524da7eec10fea818a758b432d%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&复合条形饼图中条形个数的调整&/a&&/p&&p&013、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D304a2c325b6d5ace0845%26chksm%3Dec4129dadb36a0ccefd080eca98cbescene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&饼图中会动的图例&/a&&/p&&p&014、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dc7ce1c217fefc19bc5b92%26chksm%3Deca0cebce025ab4cccf0d8efae9df2cce1db8a180c115fdb%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&百分比堆积面积图的（用公司logo做图例）&/a&&/p&&p&015、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D4ffab330d0ed%26chksm%3Deca0c3db76bd74a4d030083ebfc321a7%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&雷达图里存在的bug&/a&&/p&&p&016、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dd2ee165af4accdfa823e7%26chksm%3Deca0c253ab4b18ddca23c637ed78e4adfd5ed57fee36d8%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&数据差异较大时用次坐标来调整&/a&&/p&&p&017、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Defddchksm%3Deca0c71c401de8ef1a446a9a54ascene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&甘特图&/a&&/p&&p&018、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D22b61cfdf56d47068fad7cc98b23c3e9%26chksm%3Deca0c0b76ac177f0c0a4fcb55c277f5bf7e9cb10e1f41a95%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&图表中强调数据的技巧&/a&&/p&&p&019、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dd51cb93ddacaf2%26chksm%3Deca0c5f9ba9e5befabc7f4c4ebec46c9ef8f216c4a30692%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&自定义图表中图形形状&/a&&/p&&p&020、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dfb1e8aa24fed92cchksm%3Deca92e1e309acf50ec903c85escene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&圆环图与柱形图的组合&/a&&/p&&p&021、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D76a1e02dbd78dbabecd862a%26chksm%3Deca0865abcfccc927bba2b1bf157aed87fd8c51c7e7e%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&折线图也可以那么美丽&/a&&/p&&p&022、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dcc7b24e42301e9cbf5465%26chksm%3Dec41297ddb36a06bddb1afbd76dede571efcef5c995ca13c75dscene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&别样的圆环图&/a&&/p&&p&023、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dd70f09e8ca83c79d994b8f%26chksm%3Dec41297cdb36a06aa38a4a00dc9aa3e8b63f1a0dfaef472cc350e2de97e01c924%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&漏斗图&/a&&/p&&p&024、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D0e87d5edb737d6cf1d0b%26chksm%3Dec41297fdb36ae0dfc7fe664bab8f12b00eb88cf3923a8cfc70a48a%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&瀑布图&/a&&/p&&p&025、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D7aeaaa0af7bd1efa8d22a%26chksm%3Decaf10cdccd2da6edd25cf9%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&蛇形图--高大上的商务图表&/a&&/p&&p&026、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dacb8f4c5e854bad42258%26chksm%3Dec41295bdb36a04dff0c9046598aaf43ce18eca8bad006dd8b74}