Excel教程：10年老技巧一朝成网红，打脸透视表！（EXCEL吐槽大会）
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMy46PTZPG4BGLVZJmia20gUXsFwPf9sDbvQoMSXv1g5eib8qB0yGmzXrF32mbySZyVnwPVdUXJUFkQA/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;"><strong style="color: blue;"><span style="color: black;">↑</span></strong></strong><strong style="color: blue;"><span style="color: black;">入群，免费领取500个Excel函数学习↑ </span></strong></span></strong></span>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">每日</span>一点小技能</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">职场打怪不得怂</strong></p><img src="https://mmbiz.qpic.cn/mmbiz_gif/k6kCsib3eJMwY0OFSrNT3ia8icQZ7PfJGEujYl6Y6002J6gxSU0S4nfqrNPib5ciciaHb5yxeKr3eBTzkp91cYwss0XA/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">编按：</span><span style="color: black;"><span style="color: black;">哈喽，<span style="color: black;">大众</span>好！</span><span style="color: black;">Excel切片器是数据筛选的网红、明珠。</span><span style="color: black;">它到底有<span style="color: black;">那些</span>功能、怎么<span style="color: black;">运用</span>？</span><span style="color: black;">凭啥被<span style="color: black;">非常多</span>用户追捧？</span><span style="color: black;">在Excel吐槽大会上，筛选、IF函数、数据透视表纷纷上台群嘲，结果反而帮切片器做了一个彻底宣传：</span><span style="color: black;"><span style="color: black;">不仅</span><span style="color: black;">能够</span>实现按键式的动态筛选，还<span style="color: black;">能够</span><span style="color: black;">同期</span><span style="color: black;">掌控</span>多个数据透视表进行筛选。</span></span></p><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwNo0aic77ia0cpKT6lB5ibxRNveAKaeDXjAqzX3HtMic0TFa0SpaUdm3nQKGoGDkFHufJFhiauy9l9tYQ/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">【<strong style="color: blue;"><span style="color: black;">主持人</span></strong>：隆重开场】欢迎来到《EXCEL吐槽大会》，今晚<span style="color: black;">咱们</span>请到3位EXCEL中的大咖<span style="color: black;">一块</span>吐槽EXCEL界的网红担当——“切片器”，下面请出<span style="color: black;">咱们</span>今夜吐槽的主咖。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzA7QtOHYoQv5JrPDHaaiaLkownGyQN5gu5zmofr2ib5hGWpgEf24wDjhgACfLricPOEsicYgUiaJUrjNw/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">【<strong style="color: blue;"><span style="color: black;">切片器</span></strong>：表现出大度】<span style="color: black;">大众</span>好，我是EXCEL中的“切片器”，吐槽我OK的，请<span style="color: black;">大众</span>敞开量的“吐”。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">【<strong style="color: blue;"><span style="color: black;">主持人</span></strong>：坏笑】您这是<span style="color: black;">夜晚</span>没吃饱，准备等口儿“热的”，是吧。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">【<strong style="color: blue;"><span style="color: black;">切片器</span></strong>：微笑对视】…这节目用“马吃饭的坏毛病起名字”，<span style="color: black;">亦</span>算亘古一奇了，看来你们节目组<span style="color: black;">亦</span>都是平时吃不饱饭，凑一堆儿尝尝“别人家的饭都是什么味儿的”吧。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">【<strong style="color: blue;"><span style="color: black;">主持人</span></strong>：避而不答】一会儿<span style="color: black;">咱们</span>请的几位嘉宾，有可能会说你好多的“坏话”，要是听的不顺心了…别人我是管不了，就我个人<span style="color: black;">来讲</span>，我<span style="color: black;">能够</span><span style="color: black;">尽可能</span>——忍着不笑。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">【<strong style="color: blue;"><span style="color: black;">切片器</span></strong>：保持微笑】<span style="color: black;">近期</span><span style="color: black;">亦</span>是有<span style="color: black;">非常多</span>网友说我抢了EXCEL功能圈里面不少人的“饭碗”，长江后浪推前浪，后浪<span style="color: black;">必定</span>要狠拍<span style="color: black;">吗</span>。<span style="color: black;">不外</span>话又说回来，我<span style="color: black;">能够</span>接受吐槽，<span style="color: black;">由于</span>这<span style="color: black;">亦</span>说明别人在关注我，<span style="color: black;">认识</span>自己在别人眼中的长处短处，对日后的工作开展是一种助力，<span style="color: black;">因此</span>我应该勇于笑着面对。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">【<strong style="color: blue;"><span style="color: black;">主持人</span></strong>：】那就有请<span style="color: black;">咱们</span>今夜嘉宾：在任何工作表中都会<span style="color: black;">显现</span>的“筛选功能”；函数出场之王“IF函数”；即使不会函数和VBA<span style="color: black;">亦</span><span style="color: black;">能够</span>让你做出数据分析的无冕之王“数据透视”。欢迎各位的到来。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">下面请“筛选”带来今晚<span style="color: black;">第1</span>个表演，掌声有请~~</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">【<strong style="color: blue;"><span style="color: black;">筛选</span></strong>：与主持人交换舞台，面对观众】<span style="color: black;">大众</span>好，我是筛选，很荣幸<span style="color: black;">第1</span>个出场吐槽<span style="color: black;">咱们</span>的切片器。<span style="color: black;">首要</span>我要<span style="color: black;">褒奖</span>一下切片器，<span style="color: black;">由于</span>它是我看到EXCEL中“学我，学得最像的一个”，<span style="color: black;">经过</span>他的自我介绍就<span style="color: black;">能够</span>看出来。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzA7QtOHYoQv5JrPDHaaiaLkNnb1jiaznlLAa0ENa7iahfWxKzx4QOdKebziaRjnHV2iaWd0hnWKkQj18A/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">这可是他自己写的啊。你说你写个自我介绍，还把我带上，让我说什么好呢，是谢你帮我宣传？还是说你蹭我的热度啊？</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">（坏笑）</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">咱们</span>再来<span style="color: black;">瞧瞧</span>你“筛选数据”的效果吧：</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">选取</span>数据区域，按CTRL+T创建“表”的套用格式，<span style="color: black;">而后</span><span style="color: black;">插进</span>——“切片器”，勾选需要的筛选项，点击确定：</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzA7QtOHYoQv5JrPDHaaiaLkBktdfaQSAAHx10zxntibCOhPE5nkvk3mlczKg04ezPkppicjyyZQibSHA/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">此时，工作表区域就会<span style="color: black;">表示</span>出带有标题的切片器，<span style="color: black;">而后</span>选中某个切片器，在工具栏选项中将其<span style="color: black;">调节</span>为分列<span style="color: black;">表示</span>：</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzA7QtOHYoQv5JrPDHaaiaLkV11lNseXruRBRPSM6MibpLNlUaM20xLlfIMUQaMJ74nU3sZAJsicbynA/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">此处应有掌声啊，果然<span style="color: black;">高挑</span>上，<span style="color: black;">每一个</span>选项都<span style="color: black;">能够</span>很直观地<span style="color: black;">表示</span>。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzA7QtOHYoQv5JrPDHaaiaLks7okvuGhoP2px4ibb3bkEdiaibbNzTQ6qnkAgvuD1Q9kJr1es5y7TgGVw/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">然则</span>我就不明白了，<span style="color: black;">文本内容你<span style="color: black;">表示</span>得<span style="color: black;">那样</span>好，可是日期和金额这些数值型的内容，怎么就<span style="color: black;">那样</span>差强人意，连个基本的范围<span style="color: black;">选择</span>都做不到</span>。再想想我就明白了，<span style="color: black;">为何</span>你<span style="color: black;"><span style="color: black;">必定</span>要基于“套用格式”和“数据透视表”中<span style="color: black;">运用</span></span>，<span style="color: black;">由于</span>这两个操作都默认自带筛选，看来你离开我还是不行啊，没事儿，你做得到的我能做，你做不到的我<span style="color: black;">亦</span>都能做。（继续坏笑）</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">选中某个切片器后，按ALT+S组合键，<span style="color: black;">能够</span>使这个切片器<span style="color: black;">拥有</span>“多选”的功能</span><span style="color: black;">。</span></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzA7QtOHYoQv5JrPDHaaiaLksyRVKIIXvXIEgjN8NctGm1f39xIs8HwwibdS1EBJFX4MFvjMibFOPa3Q/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">要不是有这个多选的功能，我真是为你的筛选方式“捏一把汗”啊！<span style="color: black;">咱们</span>来看一波操作：</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/k6kCsib3eJMzA7QtOHYoQv5JrPDHaaiaLkibkXFyArhLYUezgaX1CYeWbbMzpicMOZvJeofASnTgiaM2aemdOxgK47g/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">估计观众们<span style="color: black;">无</span>明白我这段演示的效果吧。不卖关子了，<span style="color: black;">上面的操作是：切片器的全选方式。</span></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">亦</span>是说，<span style="color: black;"><span style="color: black;">倘若</span>要“全选”数据，需要开启切片器的多选功能，并选中切片器中的所有选项</span>，才<span style="color: black;">能够</span>达到效果。好吧，<span style="color: black;">期盼</span>选项不太多吧。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">因此</span>说，切片器用的再好，<span style="color: black;">亦</span>请不要<span style="color: black;">忽略</span>“筛选”的功能，就说到这了，谢谢<span style="color: black;">大众</span>！（和切片器握手，下台。）</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">【主持人：上台】感谢筛选的表演，下面有请IF函数登场。（掌声响起）</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">【IF函数：】<span style="color: black;">大众</span>好，<span style="color: black;">做为</span>今天<span style="color: black;">独一</span>出场的函数嘉宾，在EXCEL中<span style="color: black;">来讲</span>我<span style="color: black;">亦</span>算是跨界了，<span style="color: black;">不外</span>EXCEL发展这么<span style="color: black;">数年</span>来，<span style="color: black;">好似</span>任何操作里，都没有离开过<span style="color: black;">咱们</span>函数的出场。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">今天呢，我不是来吐槽的，<span style="color: black;">针对</span>需要别人<span style="color: black;">帮忙</span><span style="color: black;">才可</span>实现功能的人<span style="color: black;">来讲</span>，<span style="color: black;">咱们</span>就大度<span style="color: black;">有些</span>吧。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">为何</span>这么说？举个例子：<span style="color: black;">倘若</span>你要<span style="color: black;">对数值内容进行筛选，<span style="color: black;">能够</span>让我给你做一列辅助列，再以辅助列制作切片器</span>。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/k6kCsib3eJMzA7QtOHYoQv5JrPDHaaiaLkE8hKHrU0wIUEWN7PH2nwFiaSibGJ81Ihg0uRiajqo58vaJ4F4f3vrIFGw/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">况且</span>我<span style="color: black;">发掘</span>切片器这点做得很好，<span style="color: black;">便是</span>“随变”随的<span style="color: black;">尤其</span>快，我把函数的部分做一下更改，<span style="color: black;">大众</span>看一下效果：</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/k6kCsib3eJMzA7QtOHYoQv5JrPDHaaiaLkQNFfRicTWrfrorPCuuBkQfTaOhRkEAb1GW9kibFDXvZJNVlF8ZOjImgQ/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">一样</span>的，<span style="color: black;">倘若</span><span style="color: black;">切片器对日期的筛选<span style="color: black;">亦</span>很“不近人情”</span>，<span style="color: black;">不碍事</span>，还是老哥我来帮你处理，就像下面的操作。<span style="color: black;">咱们</span>先<span style="color: black;">插进</span>两个辅助列，分别是“年份”“月份”。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzA7QtOHYoQv5JrPDHaaiaLkUQ0dUMc21ibVARSWMV8q1VZGeJqDX2I3ba4Zggmqcn1bEPUYe9dCcTA/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">而后</span>再基于这两个辅助列创建切片器。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/k6kCsib3eJMzA7QtOHYoQv5JrPDHaaiaLkVUibMQ9VSOKibRYXbHYA6BLIUyWjlffUdnSM576ZSxD8g9ZrgPyntA4w/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">虽然和我IF函数<span style="color: black;">无</span>关系，<span style="color: black;">然则</span>常用的100多个函数，哪个<span style="color: black;">不可</span>帮你处理点儿数据啊，是不是！好了，别的我<span style="color: black;">亦</span>就不多说了，我看“数据透视表”老弟早就按捺不住了。（向观众鞠躬，和切片器握手下台。）</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">【<strong style="color: blue;"><span style="color: black;">主持人</span></strong>：下台】IF函数这不是来吐槽的，<span style="color: black;">便是</span>来标榜的啊，合着切片器那点儿功能还都是别人的功劳了。既然<span style="color: black;">说到</span>了数据透视表，<span style="color: black;">那样</span>下面<span style="color: black;">咱们</span>就有请他为<span style="color: black;">咱们</span>表演。（掌声）</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">【数透：严肃着脸】等半天了，你说你怎么就<span style="color: black;">成为了</span>EXCEL的网红了呢？叫什么<span style="color: black;">欠好</span>，叫“切片器”，不<span style="color: black;">晓得</span>还以为你是“切面包片的<span style="color: black;">设备</span>”呢！</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">红就红了呗，<span style="color: black;">然则</span>你不<span style="color: black;">晓得</span>感恩啊。你说你<span style="color: black;">除了“套用格式表”和“数据透视表”之外，你还能在哪<span style="color: black;">运用</span>？你的<span style="color: black;">存活</span>——能且只能，在<span style="color: black;">咱们</span>俩的<span style="color: black;">基本</span>上去创建。</span></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">其实我<span style="color: black;">亦</span>能理解你，以前<span style="color: black;">咱们</span>的筛选系统默认都是自带的，你<span style="color: black;">此刻</span>这是要从“幕后<span style="color: black;">步行到</span>幕前”呀，要给自己“刷刷存在感”呗。好吧，你做到了，但那又怎么样呢，不还是要等我出场之后，你<span style="color: black;">才可</span>跟我出来不是！（假装一撇）</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">不外</span><span style="color: black;">亦</span>确实，你<span style="color: black;">此刻</span><span style="color: black;">步行到</span>了台前，“穿着打扮”确实比以前好看多了，<span style="color: black;">加了不少的格式设置啊</span>！<span style="color: black;">例如</span>：</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">1.<span style="color: black;">能够</span>对切片器的选项卡“高度、宽度”进行设置</span><span style="color: black;">；</span></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzA7QtOHYoQv5JrPDHaaiaLkFdMACibJU3g0BAv6iawhXGJ0wr3HlPhUbTXiceKeHAib13xfeWVflv3Uhg/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">2.<span style="color: black;">能够</span>对选项卡的格式进行设置</span><span style="color: black;">；</span></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzA7QtOHYoQv5JrPDHaaiaLk3icyruqRGJSWrYicYufibq34qATECFS81wc9Ds3nld8mACzqAPXKHcQ9g/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">3.<span style="color: black;">能够</span>像操作<span style="color: black;">照片</span><span style="color: black;">同样</span>的排版</span><span style="color: black;">；</span></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzA7QtOHYoQv5JrPDHaaiaLkpZ3ohtemqJeFNicpiaxLnYmsibrTO4hkdAvtdyfPNcfp05pRiagdFb6VFQ/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">4.<span style="color: black;">更加多</span>的设置，<span style="color: black;">亦</span><span style="color: black;">能够</span>单击鼠标右键，在弹出菜单中，点击“切片器设置”；</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzA7QtOHYoQv5JrPDHaaiaLkO0GOEYkLqfZYYXLm8SeDwf5w2EwTBAk3nXwFpO5sz1h2X96gyYYDrg/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">然则</span>这些功能除了美观以外，<span style="color: black;">实质</span>的效果<span style="color: black;">咱们</span>自己<span style="color: black;">亦</span>能实现，有你没你都<span style="color: black;">同样</span>啊！</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzA7QtOHYoQv5JrPDHaaiaLk4sQEgUK85nxMD8lE5a4DSUvNXKJOwOC0HWk0ibSRsibfKKBk5pd9Xicew/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">好了，<span style="color: black;">亦</span>实在想不出你还能做什么，那就说这么多吧。（鞠躬下台）</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">【主持人：看了一眼数据透视】感谢数据透视“怨妇式的吐槽”，下面有请<span style="color: black;">咱们</span>的主咖“切片器”登场。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">【切片器：微笑上台】来的<span style="color: black;">亦</span>都是EXCEL界很<span style="color: black;">熟练</span>的<span style="color: black;">伴侣</span>们哈，感谢<span style="color: black;">大众</span>对我的“吐槽”，我到底是多么“优秀”才让你们有这么多话<span style="color: black;">能够</span>说。（观众笑~~）</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">当然了，<span style="color: black;">倘若</span>你们以前的表现<span style="color: black;">亦</span>都和我<span style="color: black;">同样</span>“优秀”的话，<span style="color: black;">亦</span>就<span style="color: black;">无</span>我的诞生了。（观众大笑，为这句话的睿智鼓掌）</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">确实，我是<span style="color: black;">基于筛选功能应运而生，操控筛选数据于“套用格式表”和“数据透视表”，并且还需要<span style="color: black;">有些</span>函数的辅助，<span style="color: black;">才可</span>实现<span style="color: black;">有些</span><span style="color: black;">繁杂</span>的功能。</span></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">然则</span>眼界限制了你们的思维，<span style="color: black;">例如</span>说：</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">1.我应该算是最简单的“控件”功能；</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">2.我独立于工作表，<span style="color: black;">做为</span>一种“对象”的身份<span style="color: black;">显现</span>，<span style="color: black;">能够</span>“加载宏”；</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzA7QtOHYoQv5JrPDHaaiaLkibw7keMUFctLgeDNq67J255659SqdAmlM0icpKxkiaIzOlPAYCj3gbmmw/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">3.<span style="color: black;">能够</span>用一个切片器，<span style="color: black;">同期</span>操作多个基于同一个数据源的“数据透视表”；</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">那上面这三种<span style="color: black;">状况</span>，诸位都能做到吗？</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">其实并不是说，我<span style="color: black;">仅在</span>“套用格式表”和“数据透视表”中<span style="color: black;">运用</span>，在比较热门的POWER BI的可视化中，切片器依然是重点可视化操作的一个组件，<span style="color: black;">因此</span>我<span style="color: black;">针对</span>数据联动操作的<span style="color: black;">功效</span>“怎么能说是重要的呢”，那是“相当重要”。今天不扯远的，最后以一张在EXCEL中制作的“可视化数据看板”<span style="color: black;">做为</span>结束吧。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">过程</span>1：借用刚才筛选老哥的数据源，<span style="color: black;">运用</span>数据透视图功能，创建4个独立的图表源，如下图：</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">过程</span>2：新建一个空白工作表，将4个数据透视图，剪贴到新的工作表中。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">过程</span>3：将“求和项：汇款率”数据透视图的值字段类型设置为平均值，并分别操作4个图表，<span style="color: black;">隐匿</span>图表中所有的字段按钮。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">而后</span><span style="color: black;">根据</span><span style="color: black;">每一个</span>人<span style="color: black;">区别</span>的审美配色、排版、移动布局。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">过程</span>4：<span style="color: black;">选取</span>其中1个图，添加想要的“切片器”字段，如“年份”“月份”“区域”“<span style="color: black;">机构</span>名<span style="color: black;">叫作</span>”字段，再分别把这些切片器进行“报表连接”，既然<span style="color: black;">大众</span>在刚才都<span style="color: black;">已然</span>把我介绍的<span style="color: black;">那样</span>全面，我<span style="color: black;">亦</span>就不多说，直接给出效果吧。谢谢<span style="color: black;">大众</span>。（和众人握手，下台）</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">【画外点评员】“切片器”在数据应用中的时间<span style="color: black;">亦</span>不算短了，2010版就有切片器，可是真能把这些内容融会贯通的表达出来，还真的不多，当然了，这其中<span style="color: black;">亦</span>有其他<span style="color: black;">有些</span>数据功能的通力协作，本身EXCEL<span style="color: black;">便是</span>一个庞杂的组件集合体，善于<span style="color: black;">统一</span>每一个功能用在合适的<span style="color: black;">地区</span>、恰当的<span style="color: black;">机会</span>，才可说是<span style="color: black;">能手</span>所为之。好了，本期《吐槽大会》到此结束！<span style="color: black;">咱们</span>下季再见。</span></p><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">Excel教程<span style="color: black;">关联</span><span style="color: black;">举荐</span></strong></p><a style="color: black;"><span style="color: black;">让领导看傻，3秒自动生成员工值日排班表！</span></a><a style="color: black;"><span style="color: black;">折腾了</span></a>3天，我整理出史上最全的文本函数用法案例，实用到爆！（<span style="color: black;">意见</span><span style="color: black;">保藏</span>）-第二期<a style="color: black;"><span style="color: black;">还不会用match函数？你亏大了！</span></a><a style="color: black;"><span style="color: black;">财务必看！想<span style="color: black;">加强</span>办公效率，你得先学会这张智能表！</span></a><strong style="color: blue;"><span style="color: black;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></span></strong>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">让工作提速百倍的「Excel极速贯通班」</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">↓ 点击<span style="color: black;"><strong style="color: blue;"><span style="color: black;">阅读原文</span></strong></span>，可直接购买。</span></p>
感谢你的精彩评论，为我的思绪打开了新的窗口。
页:
[1]