&p&更新：&/p&&p&notability经过这几天的使用，手写搜索还是比起goodnotes差太多，最新手写的几页基本搜索不到，也不会对文档可搜索内容根据页数增加进行更新，还需要继续优化啊！&/p&&p&目前我个人主力笔记app是goodnotes，但是滑动翻页这个确实蛋疼……&/p&&p&===========华丽的分割线=========&/p&&p&更新：&/p&&p&最新的notability更新已经支持了手写搜索这一大杀器功能，同时支持了侧边栏调取查看PDF列表。&/p&&p&个人感受的变化：&/p&&p&goodnotes手写优化其实很OK，是最接近在纸上书写效果的，而且压感最好，不会出现散墨之类的情况，notability写的字最差，切换压感之后出现散墨情况，其余完美。至于notesplus，会出现笔记丢失情况，小bug不少，逐渐让我对它丧失了信心。&/p&&p&ps：2000多收藏，500多赞同真的大丈夫吗？大家记得赞一下呀 &/p&&p&===========华丽的分割线=========&/p&&p&&b&去年狠心换了自己用了三年的iPad Air2，换成了iPad Pro+Apple pencil，真的，这是一个让你爽的飞起的组合，学习，娱乐，无所不能，今天我主要给大家介绍一下它在学习上的应用。&/b&&/p&&p&&br&&/p&&h2&&b&
出场设备和app介绍&/b&&/h2&&p&&b&设备&/b&：&/p&&p&
iPad Pro+Apple pencil&/p&&p&&b&出场app：&/b&&/p&&p&
1.笔记类&/p&&p&
（1）Notes Plus&/p&&p&
（2）GoodNotes&br&&/p&&p&
（3）Notability&/p&&p&
2.PDF阅读类&/p&&p&
（1）MarginNote P&/p&&p&
（2）LiquidText&/p&&p&
3.便捷工具类&/p&&p&
（1）MathPad&/p&&p&
（2）WolframAlpha&/p&&p&
4.绘画类&/p&&p&
（1）Procreate&/p&&p&&br&&/p&&figure&&img src=&https://pic3.zhimg.com/v2-8ddeba20281a6aeea15165cbb0ce2272_b.jpg& data-rawwidth=&638& data-rawheight=&99& data-caption=&& data-size=&normal& class=&origin_image zh-lightbox-thumb& width=&638& data-original=&https://pic3.zhimg.com/v2-8ddeba20281a6aeea15165cbb0ce2272_r.jpg&&&/figure&&h2&&b&
笔记类测评&/b&&/h2&&p&一.Notes Plus&br&&/p&&p&我眼中Notes Plus是书写效果最出彩的一款，字迹流畅，公整，钢笔的书写效果特别好，还有就是特色的小功能很实用，在书写文字上来回滑动删除文字，直接画圈括住想要操作的部分就能对该部分进行操作。&/p&&p&但是它也不是没有缺点，纸张的种类很少，而且经过我测试，在非白色背景之下操作延迟严重，所以相当于纸张种类就很固定，效果如下，我个人感觉已经很棒了。&/p&&figure&&img src=&https://pic4.zhimg.com/v2-9a5eceba93cf_b.jpg& data-rawwidth=&640& data-rawheight=&854& data-caption=&& data-size=&normal& class=&origin_image zh-lightbox-thumb& width=&640& data-original=&https://pic4.zhimg.com/v2-9a5eceba93cf_r.jpg&&&/figure&&figure&&img src=&https://pic1.zhimg.com/v2-c4ec7ddef583b5f59c644_b.jpg& data-rawwidth=&640& data-rawheight=&854& data-caption=&& data-size=&normal& class=&origin_image zh-lightbox-thumb& width=&640& data-original=&https://pic1.zhimg.com/v2-c4ec7ddef583b5f59c644_r.jpg&&&/figure&&p&二.GoodNotes&/p&&p&GoodNotes纸张相对丰富，但是没有其他颜色的笔记本类型，书写流畅且支持压感，是最具有纸张书写感的笔记类app，一些小功能也很使用，是我所提的三款app中唯一支持笔记搜索功能这一大杀器功能的。&br&&/p&&p&效果如下：（盗用别人的效果图，我的太丑了 ）&/p&&figure&&img src=&https://pic3.zhimg.com/v2-f01b4b9ac2c8f0f1edbd32_b.jpg& data-rawwidth=&640& data-rawheight=&853& data-caption=&& data-size=&normal& class=&origin_image zh-lightbox-thumb& width=&640& data-original=&https://pic3.zhimg.com/v2-f01b4b9ac2c8f0f1edbd32_r.jpg&&&/figure&&p&三.Notability&br&&/p&&p&录音功能最强大的一款，笔记本类型最丰富的一款，书写感觉还行，综合起来可能是最好的一款。&/p&&p&效果如下：（前段时间做的托福口语听写）&br&&/p&&figure&&img src=&https://pic2.zhimg.com/v2-3c02ad370c95d3c10b6c2f_b.jpg& data-rawwidth=&640& data-rawheight=&854& data-caption=&& data-size=&normal& class=&origin_image zh-lightbox-thumb& width=&640& data-original=&https://pic2.zhimg.com/v2-3c02ad370c95d3c10b6c2f_r.jpg&&&/figure&&figure&&img src=&https://pic3.zhimg.com/v2-8ddeba20281a6aeea15165cbb0ce2272_b.jpg& data-rawwidth=&638& data-rawheight=&99& data-caption=&& data-size=&normal& class=&origin_image zh-lightbox-thumb& width=&638& data-original=&https://pic3.zhimg.com/v2-8ddeba20281a6aeea15165cbb0ce2272_r.jpg&&&/figure&&h2&&b&
PDF阅读类测评&/b&&/h2&&p&一.MarginNote P&br&&/p&&p&这款软件功能丰富，有一个特色的问答功能挺有意思的，随便选中一段就可以对他进行google翻译，而且做笔记流畅，可以生成思维导图，除了手写功能稍差一点点，其余真的很赞了。&br&&/p&&p&效果图如下：&/p&&figure&&img src=&https://pic2.zhimg.com/v2-400ed959b80ebd69616d_b.jpg& data-rawwidth=&640& data-rawheight=&480& data-caption=&& data-size=&normal& class=&origin_image zh-lightbox-thumb& width=&640& data-original=&https://pic2.zhimg.com/v2-400ed959b80ebd69616d_r.jpg&&&/figure&&p&二.LiquidText&/p&&p&这款app是我觉得iPad平台上最炫酷的PDF阅读类软件，手写效果流畅，功能炫酷，因为实在太丰富，大家具体可以百度。&/p&&p&效果图如下：&br&&/p&&figure&&img src=&https://pic4.zhimg.com/v2-ae5bddd88d8a57b04fdf_b.jpg& data-rawwidth=&640& data-rawheight=&480& data-caption=&& data-size=&normal& class=&origin_image zh-lightbox-thumb& width=&640& data-original=&https://pic4.zhimg.com/v2-ae5bddd88d8a57b04fdf_r.jpg&&&/figure&&p&&br&&/p&&figure&&img src=&https://pic3.zhimg.com/v2-8ddeba20281a6aeea15165cbb0ce2272_b.jpg& data-rawwidth=&638& data-rawheight=&99& data-caption=&& data-size=&normal& class=&origin_image zh-lightbox-thumb& width=&638& data-original=&https://pic3.zhimg.com/v2-8ddeba20281a6aeea15165cbb0ce2272_r.jpg&&&/figure&&h2&&b&
便捷工具类详述&/b&&/h2&&p&&b&可能是最便捷查询各种知识的解决方案！&/b&&/p&&p&&b&MathPad+WolframAlpha&/b&&/p&&p&来自MyScript公司的MathPad软件则是一款手写的输入软件，被称为发电机LaTex的手稿，可以通过手写直接写出复杂的数学算式，并支持导出为LaTex以及MathML格式的代码。最重要的是，支持跨软件使用WolframAlpha运算写出来的式子。这样以来，就可以像在草稿纸上一样写出需要计算的式子，然后直接导入到WolframAlpha中就可以计算了。&/p&&p&上图。&/p&&p&第一步：在MathPad中写入要计算的式子&/p&&figure&&img src=&https://pic4.zhimg.com/v2-0fa17ae18d622b8c50b9037631eaf3f3_b.jpg& data-rawwidth=&580& data-rawheight=&773& data-caption=&& data-size=&normal& class=&origin_image zh-lightbox-thumb& width=&580& data-original=&https://pic4.zhimg.com/v2-0fa17ae18d622b8c50b9037631eaf3f3_r.jpg&&&/figure&&p&&br&&/p&&p&第二步：点击右上角，弹出窗口中选择LaTex或MathML任意一种，点击导出，并选择使用WalframAlpha计算。&/p&&figure&&img src=&https://pic2.zhimg.com/v2-e3b1addc9a239f15a0771_b.jpg& data-rawwidth=&580& data-rawheight=&773& data-caption=&& data-size=&normal& class=&origin_image zh-lightbox-thumb& width=&580& data-original=&https://pic2.zhimg.com/v2-e3b1addc9a239f15a0771_r.jpg&&&/figure&&p&&br&&/p&&p&第三步：如果你的设备连接了网络，计算结果几秒钟之后就会显示出来了&/p&&figure&&img src=&https://pic1.zhimg.com/v2-6ac8b5e9d895d41f1ca184_b.jpg& data-rawwidth=&580& data-rawheight=&773& data-caption=&& data-size=&normal& class=&origin_image zh-lightbox-thumb& width=&580& data-original=&https://pic1.zhimg.com/v2-6ac8b5e9d895d41f1ca184_r.jpg&&&/figure&&p&最厉害的是，WolframAlpha不仅可以查询理工科知识，英语，社会知识无所不知，简直就是一本百科全书！&br&&/p&&figure&&img src=&https://pic3.zhimg.com/v2-8ddeba20281a6aeea15165cbb0ce2272_b.jpg& data-rawwidth=&638& data-rawheight=&99& data-caption=&& data-size=&normal& class=&origin_image zh-lightbox-thumb& width=&638& data-original=&https://pic3.zhimg.com/v2-8ddeba20281a6aeea15165cbb0ce2272_r.jpg&&&/figure&&p&&br&&/p&&h2&&b&
绘画类app&/b&&/h2&&p&&b&Procreate：iPad上无敌绘画app&/b& &/p&&p&总之一句话，如果你对画画有兴趣，特别是有一点绘画功底，那么大师级画板可能就是你在 iOS 上最佳的选择了！特别是 Procreate 与 iPad Pro、Apple Pencil 的结合，无论在流畅度、画笔的压感力度、精度灵敏度以及延迟都非常出色，大概也是目前民用级别中最佳的数字绘画体验了吧。&/p&&p&大师级画板相比 Paper、素描2 (Tayasui Sketches 2 Pro) 等同类应用要强大专业得多，你基本上能用 Procreate 画出你一切想要画的东西。好了！拿上你的 iPad，下载一个大师级画板，尽情享受画画的艺术创作过程吧！&/p&&p&给大家展示一下一个菜鸡用Procreate画的简笔画：&/p&&figure&&img src=&https://pic1.zhimg.com/v2-183f27afdbff_b.jpg& data-rawwidth=&640& data-rawheight=&480& data-size=&normal& class=&origin_image zh-lightbox-thumb& width=&640& data-original=&https://pic1.zhimg.com/v2-183f27afdbff_r.jpg&&&figcaption&社会主义的围笑&/figcaption&&/figure&&p&再放一张其他大师用Procreate画的作品来洗洗眼睛 ：&/p&&figure&&img src=&https://pic3.zhimg.com/v2-2f8ef9cfefb2da_b.jpg& data-rawwidth=&640& data-rawheight=&480& data-caption=&& data-size=&normal& class=&origin_image zh-lightbox-thumb& width=&640& data-original=&https://pic3.zhimg.com/v2-2f8ef9cfefb2da_r.jpg&&&/figure&&p&&br&&/p&&figure&&img src=&https://pic3.zhimg.com/v2-8ddeba20281a6aeea15165cbb0ce2272_b.jpg& data-rawwidth=&638& data-rawheight=&99& data-caption=&& data-size=&normal& class=&origin_image zh-lightbox-thumb& width=&638& data-original=&https://pic3.zhimg.com/v2-8ddeba20281a6aeea15165cbb0ce2272_r.jpg&&&/figure&&h2&&b&
后记&/b&&/h2&&p&&b&很多人都说iPad Pro只是单纯的娱乐休闲设备，但是其实作为苹果的野心之作，生产力先不提，在学习上其实是很有可为了，电子笔记的趋势，电子绘画，你可以在iPad上用Apple pencil书写无限可能。&/b&&/p&&figure&&img src=&https://pic3.zhimg.com/v2-e6728efd9acb0f3d9ebe327ff000cb92_b.jpg& data-rawwidth=&638& data-rawheight=&99& data-caption=&& data-size=&normal& class=&origin_image zh-lightbox-thumb& width=&638& data-original=&https://pic3.zhimg.com/v2-e6728efd9acb0f3d9ebe327ff000cb92_r.jpg&&&/figure&&p&大家可以看看我的另外一篇关于实用网站的推荐：&/p&&p&&a href=&https://zhuanlan.zhihu.com/p/& class=&internal&&&span class=&invisible&&https://&/span&&span class=&visible&&zhuanlan.zhihu.com/p/36&/span&&span class=&invisible&&007584&/span&&span class=&ellipsis&&&/span&&/a&&/p&&p&快，关注这个公众号，一起涨姿势～（聊聊篮球与数码那些事）&/p&&figure&&img src=&https://pic4.zhimg.com/v2-006a9b92d04a1c0cd4df_b.jpg& data-rawwidth=&435& data-rawheight=&254& data-caption=&& data-size=&normal& class=&origin_image zh-lightbox-thumb& width=&435& data-original=&https://pic4.zhimg.com/v2-006a9b92d04a1c0cd4df_r.jpg&&&/figure&&p&&/p&
更新：notability经过这几天的使用，手写搜索还是比起goodnotes差太多，最新手写的几页基本搜索不到，也不会对文档可搜索内容根据页数增加进行更新，还需要继续优化啊！目前我个人主力笔记app是goodnotes，但是滑动翻页这个确实蛋疼……===========…
&p&年龄二十几岁，按照男生的消费观念，太贵的会直接选择实体店，所以外套300、卫衣100、短袖50、裤子200，在这之内还是有不少值得选择的淘宝男装店铺。&/p&&p&&br&&/p&&p&当然还不能是烂大街的款式！&/p&&p&&br&&/p&&p&网购退换频率最高的就是不合身、色差、材质不符合，想要最大化的减少这些问题，就要注意三点。&/p&&p&&br&&/p&&p&尺寸：不能以之前穿过的衣服尺寸为标准，每个厂商衣服的尺寸在生产和设计时都是不同的，要仔细阅读购买商品的尺码表，卫衣、短袖买大不买小，鞋子尺码特殊或者经常出现半码的同学，请转身实体店选购。&/p&&p&&br&&/p&&p&色差：室内室外光线对色差的影响非常大，选购时要另外注意，室内拍摄会更接近实物。&/p&&p&&br&&/p&&p&材质：评论里的买家秀是一个非常好的鉴别场地，不要看那些精修或者长的特别好看的图片，选择原图与卖家秀进行对比，就可以大概分析出材质的情况。还可以根据追加评论，查看材质是否起球或者掉色。&/p&&p&&br&&/p&&p&以上三点适用于所有网购服装，不分男女，童叟无欺。&/p&&p&&br&&/p&&p&接下来就是淘宝性价比、颜值都超高的平价男装店铺，分享给你~&/p&&p&&br&&/p&&p&关于现价值得买与否，可在线体验历史价格↓↓↓&/p&&p&&br&&/p&&blockquote&在线查询体验页面：：&a href=&//link.zhihu.com/?target=http%3A//tool.manmanbuy.com/HistoryLowest.aspx%3Fhmsr%3Dzhihu%26hmpl%3Dwsdhab%26hmcu%3Dhmkw%3D%26hmci%3D& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&查询商品历史价格 --慢慢买比价网&/a&&/blockquote&&figure&&img src=&https://pic4.zhimg.com/50/v2-8bf7c53ac8c_b.jpg& data-caption=&& data-size=&normal& data-rawwidth=&729& data-rawheight=&384& class=&origin_image zh-lightbox-thumb& width=&729& data-original=&https://pic4.zhimg.com/50/v2-8bf7c53ac8c_r.jpg&&&/figure&&p&&br&&/p&&p&&br&&/p&&p&1.GBstudios原创男装&/p&&p&&br&&/p&&p&关键词：原创、简约&/p&&p&推荐：衬衫、卫衣&/p&&p&&br&&/p&&figure&&img src=&https://pic1.zhimg.com/50/v2-7bac19da045a48dd80a28aa_b.jpg& data-caption=&& data-size=&normal& data-rawwidth=&1080& data-rawheight=&1920& class=&origin_image zh-lightbox-thumb& width=&1080& data-original=&https://pic1.zhimg.com/50/v2-7bac19da045a48dd80a28aa_r.jpg&&&/figure&&p&&br&&/p&&p&2.无糖工作室SUGF&/p&&p&&br&&/p&&p&关键词：随和、简约&/p&&p&推荐：T、裤子&/p&&p&&br&&/p&&p&&br&&/p&&figure&&img src=&https://pic2.zhimg.com/50/v2-a4bdfd869cbdb329defb5e1_b.jpg& data-caption=&& data-size=&normal& data-rawwidth=&1080& data-rawheight=&1920& class=&origin_image zh-lightbox-thumb& width=&1080& data-original=&https://pic2.zhimg.com/50/v2-a4bdfd869cbdb329defb5e1_r.jpg&&&/figure&&p&&br&&/p&&p&&br&&/p&&figure&&img src=&https://pic3.zhimg.com/50/v2-66b5e6d85f5c03ef6d0f1_b.jpg& data-caption=&& data-size=&normal& data-rawwidth=&1080& data-rawheight=&1920& class=&origin_image zh-lightbox-thumb& width=&1080& data-original=&https://pic3.zhimg.com/50/v2-66b5e6d85f5c03ef6d0f1_r.jpg&&&/figure&&p&&br&&/p&&p&3.GXG旗舰店&/p&&p&&br&&/p&&p&关键词：欧美&/p&&p&推荐：短袖、外套&/p&&p&&br&&/p&&figure&&img src=&https://pic4.zhimg.com/50/v2-bdf31d8eac45e7b502aced4_b.jpg& data-caption=&& data-size=&normal& data-rawwidth=&1080& data-rawheight=&1920& class=&origin_image zh-lightbox-thumb& width=&1080& data-original=&https://pic4.zhimg.com/50/v2-bdf31d8eac45e7b502aced4_r.jpg&&&/figure&&figure&&img src=&https://pic1.zhimg.com/50/v2-d746cc89347c1fef652aaad_b.jpg& data-caption=&& data-size=&normal& data-rawwidth=&1080& data-rawheight=&1920& class=&origin_image zh-lightbox-thumb& width=&1080& data-original=&https://pic1.zhimg.com/50/v2-d746cc89347c1fef652aaad_r.jpg&&&/figure&&p&&br&&/p&&p&4.西西里男装&/p&&p&&br&&/p&&p&关键词：港风、纯色&/p&&p&推荐：外套、衬衫&/p&&p&&br&&/p&&p&&br&&/p&&figure&&img src=&https://pic3.zhimg.com/50/v2-2c3ccfeb91bcded4a1099_b.jpg& data-caption=&& data-size=&normal& data-rawwidth=&1080& data-rawheight=&1920& class=&origin_image zh-lightbox-thumb& width=&1080& data-original=&https://pic3.zhimg.com/50/v2-2c3ccfeb91bcded4a1099_r.jpg&&&/figure&&p&&br&&/p&&p&5.47RONIN&/p&&p&&br&&/p&&p&关键词：简单粗暴&/p&&p&推荐：短袖&/p&&p&&br&&/p&&p&&br&&/p&&figure&&img src=&https://pic1.zhimg.com/50/v2-50cf80a4f5cd09a1763bd0_b.jpg& data-caption=&& data-size=&normal& data-rawwidth=&1080& data-rawheight=&1920& class=&origin_image zh-lightbox-thumb& width=&1080& data-original=&https://pic1.zhimg.com/50/v2-50cf80a4f5cd09a1763bd0_r.jpg&&&/figure&&figure&&img src=&https://pic3.zhimg.com/50/v2-6fed793e1ecbc42b02884_b.jpg& data-caption=&& data-size=&normal& data-rawwidth=&1080& data-rawheight=&1080& class=&origin_image zh-lightbox-thumb& width=&1080& data-original=&https://pic3.zhimg.com/50/v2-6fed793e1ecbc42b02884_r.jpg&&&/figure&&figure&&img src=&https://pic2.zhimg.com/50/v2-a5eeb22f48_b.jpg& data-caption=&& data-size=&normal& data-rawwidth=&1080& data-rawheight=&1080& class=&origin_image zh-lightbox-thumb& width=&1080& data-original=&https://pic2.zhimg.com/50/v2-a5eeb22f48_r.jpg&&&/figure&&p&&br&&/p&&p&&br&&/p&&p&&br&&/p&&p&6.美丽的脏店混搭风男装&/p&&p&&br&&/p&&p&关键词：混搭&/p&&p&推荐：外套&/p&&p&&br&&/p&&p&&br&&/p&&figure&&img src=&https://pic3.zhimg.com/50/v2-4c85da2ca1b6c3fc50f2a_b.jpg& data-caption=&& data-size=&normal& data-rawwidth=&1080& data-rawheight=&1920& class=&origin_image zh-lightbox-thumb& width=&1080& data-original=&https://pic3.zhimg.com/50/v2-4c85da2ca1b6c3fc50f2a_r.jpg&&&/figure&&p&&br&&/p&&p&7.GAON&/p&&p&&br&&/p&&p&8.隐蔽者&/p&&p&&br&&/p&&p&关键词：港风、休闲&/p&&p&推荐：裤子、卫衣&/p&&p&&br&&/p&&p&&br&&/p&&figure&&img src=&https://pic2.zhimg.com/50/v2-bc33d0f379eebad9d926f6e8a752d4f6_b.jpg& data-caption=&& data-size=&normal& data-rawwidth=&1080& data-rawheight=&1920& class=&origin_image zh-lightbox-thumb& width=&1080& data-original=&https://pic2.zhimg.com/50/v2-bc33d0f379eebad9d926f6e8a752d4f6_r.jpg&&&/figure&&p&&br&&/p&&p&&br&&/p&&figure&&img src=&https://pic3.zhimg.com/50/v2-5b109ccc730_b.jpg& data-caption=&& data-size=&normal& data-rawwidth=&1080& data-rawheight=&1080& class=&origin_image zh-lightbox-thumb& width=&1080& data-original=&https://pic3.zhimg.com/50/v2-5b109ccc730_r.jpg&&&/figure&&figure&&img src=&https://pic2.zhimg.com/50/v2-edb549efd2f3a_b.jpg& data-caption=&& data-size=&normal& data-rawwidth=&1080& data-rawheight=&1080& class=&origin_image zh-lightbox-thumb& width=&1080& data-original=&https://pic2.zhimg.com/50/v2-edb549efd2f3a_r.jpg&&&/figure&&p&&br&&/p&&p&&br&&/p&&p&&br&&/p&&figure&&img src=&https://pic4.zhimg.com/50/v2-81b1e6f732fa5ec2a0b5d2_b.jpg& data-caption=&& data-size=&normal& data-rawwidth=&1080& data-rawheight=&1920& class=&origin_image zh-lightbox-thumb& width=&1080& data-original=&https://pic4.zhimg.com/50/v2-81b1e6f732fa5ec2a0b5d2_r.jpg&&&/figure&&p&&br&&/p&&p&&br&&/p&&figure&&img src=&https://pic3.zhimg.com/50/v2-4e5bf16a3d9edf06cf6da69e44240bb0_b.jpg& data-caption=&& data-size=&normal& data-rawwidth=&1080& data-rawheight=&1080& class=&origin_image zh-lightbox-thumb& width=&1080& data-original=&https://pic3.zhimg.com/50/v2-4e5bf16a3d9edf06cf6da69e44240bb0_r.jpg&&&/figure&&p&&br&&/p&&p&&br&&/p&&p&&br&&/p&&p&9.二十八间原创商铺&/p&&p&&br&&/p&&p&10.AK男装旗舰店&/p&&p&&br&&/p&&p&关键词：酷、Man&/p&&p&推荐：夹克&/p&&p&&br&&/p&&p&&br&&/p&&figure&&img src=&https://pic1.zhimg.com/50/v2-fe3cb5fd8bb5df3030ca1_b.jpg& data-caption=&& data-size=&normal& data-rawwidth=&1080& data-rawheight=&1920& class=&origin_image zh-lightbox-thumb& width=&1080& data-original=&https://pic1.zhimg.com/50/v2-fe3cb5fd8bb5df3030ca1_r.jpg&&&/figure&&p&&br&&/p&&p&&br&&/p&&figure&&img src=&https://pic1.zhimg.com/50/v2-34e3ca8e1fa655c94b7daa59eec64035_b.jpg& data-caption=&& data-size=&normal& data-rawwidth=&1080& data-rawheight=&1080& class=&origin_image zh-lightbox-thumb& width=&1080& data-original=&https://pic1.zhimg.com/50/v2-34e3ca8e1fa655c94b7daa59eec64035_r.jpg&&&/figure&&p&&br&&/p&&p&&br&&/p&&p&&br&&/p&&p&&br&&/p&&figure&&img src=&https://pic1.zhimg.com/50/v2-9d91e489e5b30a8f6ad81_b.jpg& data-caption=&& data-size=&normal& data-rawwidth=&1080& data-rawheight=&1920& class=&origin_image zh-lightbox-thumb& width=&1080& data-original=&https://pic1.zhimg.com/50/v2-9d91e489e5b30a8f6ad81_r.jpg&&&/figure&&p&&br&&/p&&p&&br&&/p&&figure&&img src=&https://pic1.zhimg.com/50/v2-8a65c2da08f0be77dc8645_b.jpg& data-caption=&& data-size=&normal& data-rawwidth=&1080& data-rawheight=&1080& class=&origin_image zh-lightbox-thumb& width=&1080& data-original=&https://pic1.zhimg.com/50/v2-8a65c2da08f0be77dc8645_r.jpg&&&/figure&&p&&br&&/p&&p&不知道怎么搭的直男，不知道给自己男票买什么的妹子，拿去不谢。&/p&&p&&br&&/p&&hr&&p&&br&&/p&&p&&b&值=质量＋价格&/b&&/p&&p&&b&慢慢买帮你甄选好得质量、值得价格&/b&&/p&&p&&b&值得价格=低于历史最低＋小于全网同款价&/b&&/p&&p&&b&下载&&&&&&&a href=&//link.zhihu.com/?target=http%3A//home.manmanbuy.com/app.aspx%3Fhmsr%3Dzhuhu%26hmpl%3Ddaogou%26hmcu%3Dwsdhab%26hmkw%3D%26hmci%3D& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&慢慢买APP&/a&，钱少也能过优质生活！&/b&&/p&&p&&br&&/p&&figure&&img src=&https://pic4.zhimg.com/50/v2-8bf7c53ac8c_b.jpg& data-caption=&& data-size=&normal& data-rawwidth=&729& data-rawheight=&384& class=&origin_image zh-lightbox-thumb& width=&729& data-original=&https://pic4.zhimg.com/50/v2-8bf7c53ac8c_r.jpg&&&/figure&
年龄二十几岁，按照男生的消费观念，太贵的会直接选择实体店，所以外套300、卫衣100、短袖50、裤子200，在这之内还是有不少值得选择的淘宝男装店铺。 当然还不能是烂大街的款式！ 网购退换频率最高的就是不合身、色差、材质不符合，想要最大化的减少这些问…
&figure&&img src=&https://pic3.zhimg.com/v2-1abda1074d_b.jpg& data-rawwidth=&524& data-rawheight=&350& class=&origin_image zh-lightbox-thumb& width=&524& data-original=&https://pic3.zhimg.com/v2-1abda1074d_r.jpg&&&/figure&&p&&/p&&a class=&video-box& href=&http://link.zhihu.com/?target=https%3A//www.zhihu.com/video/763392& target=&_blank& data-video-id=&& data-video-playable=&true& data-name=&& data-poster=&https://pic1.zhimg.com/80/v2-bef7cadb5f50e5c_b.jpg& data-lens-id=&763392&&
&img class=&thumbnail& src=&https://pic1.zhimg.com/80/v2-bef7cadb5f50e5c_b.jpg&&&span class=&content&&
&span class=&title&&&span class=&z-ico-extern-gray&&&/span&&span class=&z-ico-extern-blue&&&/span&&/span&
&span class=&url&&&span class=&z-ico-video&&&/span&https://www.zhihu.com/video/763392&/span&
&p&&/p&&p&制作PPT最痛苦的事情，就是非专业的你，正在你摆弄一个专业工具。&b&据说在职场中81%的人都在使用PPT，但90%的人都在抱怨&/b&——要么像我们之前所说的，你可以使用斧子演示或者sway等工具，要么，你是否需要老老实实地从头学习设计？&/p&&p&&br&&/p&&p&&br&&/p&&p&&b&那也不一定，还有一款插件也许能够帮到你，那就是 &/b&&a href=&http://link.zhihu.com/?target=https%3A//www.islide.cc/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&iSlide--让PPT设计简单起来！&/a&&/p&&p&&br&&/p&&p&&br&&/p&&p&当你的Powerpoint软件安装了这款插件。你不必再忍受杂乱的字体、颜色和排版，也不用做一页一页去更改调整这样的重复性工作。&b&你可以一键统一文本格式、一键添加参考线、快速建立布局规范；&/b&&/p&&p&&br&&/p&&p&&br&&/p&&p&同时，我们不再需要用眼睛或者依靠自带的参考线去布局图文，使用islide，也可以实现参数化调整，不止布局更加专业好看，也省去了大量时间；&/p&&p&&br&&/p&&p&&br&&/p&&p&&b&图表也是PPT最常用的元素之一，使用islide，人人都可以实现数据的视觉化设计，而且你随时可以更改图标、更改数据。&/b&当然，插件中，还拥有大量的图标、图示库，供你随意选择、任意切换。如果你对色彩搭配并不擅长，也可以使用色彩库，建立专业的色彩主题。&/p&&p&&br&&/p&&p&&br&&/p&&p&另外，islide还有其他的一些小功能，比如将你制作的PPT一键生成长图，方便用于社交网络的分享和学习。&/p&&p&&br&&/p&&p&&br&&/p&&p&可自行前往官网下载这款插件，也可以在我们同名微信公众号后台回复【&b& PPT插件&/b& 】获取。&/p&&h2&&b&更多干货戳这里：&a href=&http://link.zhihu.com/?target=http%3A//topbook.cc& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&topbook.cc&/a&&/b&&/h2&&p&&b&收藏也要点赞，可不敢白嫖！&/b&&/p&
制作PPT最痛苦的事情，就是非专业的你，正在你摆弄一个专业工具。据说在职场中81%的人都在使用PPT，但90%的人都在抱怨——要么像我们之前所说的，你可以使用斧子演示或者sway等工具，要么，你是否需要老老实实地从头学习设计？ 那也不一定，还有一款插件也…
&p&我这也算是非常有良心了吧&/p&&figure&&img src=&https://pic2.zhimg.com/50/v2-d8cbe067fb571d0511055aa_b.jpg& data-rawwidth=&640& data-rawheight=&395& data-size=&normal& class=&origin_image zh-lightbox-thumb& width=&640& data-original=&https://pic2.zhimg.com/50/v2-d8cbe067fb571d0511055aa_r.jpg&&&/figure&&p&&br&&/p&&p&&b&EXCEL常见技巧锦集&/b&&/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%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&057、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dda04c1ddc7f029e180f25e6340bcf0cc%26chksm%3Decaccea14f7a9b33a5c886a57%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&隐藏单元格的另一种方法&/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%