Excel教程：数据透视表和切片器结合运用，制作动态数据表
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">★</strong></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;">编按</strong></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;">★</strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Hello<span style="color: black;">大众</span>好！在做工作<span style="color: black;">报告</span>时比起密密麻麻的数字，老板可能更爱看一目了然的图表，比起静态的图表，能够动起来的图表似乎更加“吸睛”。今天就让<span style="color: black;">咱们</span>来学习一下<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;">01</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;">数据源</strong></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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzA5EyNJaiauYzbQfD3iaeN0wJZeJjqLuZTANlbHqoj8XpmZ0qFAHP76TXAlyuLXUM5fRerKexsK5bg/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" 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;">*说明：</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>为内三元；</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;">02</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></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>需要利用excel，将上表做成动态可筛选的模式，变成一个可<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="https://mmbiz.qpic.cn/mmbiz_gif/k6kCsib3eJMzA5EyNJaiauYzbQfD3iaeN0woNO0jzCIZRVRdnDUd2TWwqCMzUF8yPmiarJkV4jdcnneWpSdLiaLacEw/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" 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;">03</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;">分析思路</strong></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>更为重要”，学会分析，就学会了举一反三的能力，遇到问题时，总能想到<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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">（1）功能上有区别：静态表 vs 动态表，<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;">（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;"><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;">（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></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;">这三种<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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">1、“动态筛选”，<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;">2、<strong style="color: blue;"><span style="color: black;">触及</span>筛选部分</strong>，需<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;">（1）excel自带的筛选</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">（2）数据透视表本身的筛选功能，外加切片器</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">（3）数据有效性</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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">（5）高级筛选等</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;">关于“动态”：</strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">（1）数据透视表本身<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;">（2）<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;">（3）宏、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;">3、再将筛选与动态结合起来，就形<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>是<span style="color: black;">运用</span>数据透视表+切片器的搭配模式，实用性最高，操作起来最简单。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwtYTibF0XFBKyk3oAZgt2VBpIhz8ojpicJY3oVC6RQv2xdELAdrnQeRsd0XcpxBR60kTASyibX8Orcg/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" 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;"><strong style="color: blue;"><strong style="color: blue;"><strong style="color: blue;">↑</strong></strong><strong style="color: blue;">免费领取Excel模板、视频教程学习↑</strong></strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">04</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></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></p><span style="color: black;">取消数据源表中的合并单元格，并快速填充空白单元格。</span><span style="color: black;">*提示：数据源非常重要，是一切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><span style="color: black;"><span style="color: black;">详细</span>操作：取消合并单元格→按Ctrl+G打开定位<span style="color: black;">要求</span>→<span style="color: black;">选取</span>“空值”→在编辑栏输入公式“=B3”（=上方单元格）→按Ctrl+Enter组合键完成公式录入→最后粘贴为数值。</span><span style="color: black;">操作请见如下GIF动图</span>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/k6kCsib3eJMzA5EyNJaiauYzbQfD3iaeN0wDKLNlNYUOYuLDPsbKJSMOcz2alIzicDQKZmaRkCcTc96WDaEnBOYMIg/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" 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;"><strong style="color: blue;">※<span style="color: black;">过程</span>二：制作数据透视表</strong></span></p><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 style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzA5EyNJaiauYzbQfD3iaeN0wacYRD3TaKR4LNARbjh9j3DkmcibHicZDW8JWRNkYuxLXGFIklic8wQwlQ/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><span style="color: black;">结果如下：</span>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzA5EyNJaiauYzbQfD3iaeN0wor111hUEPJI1Af3s6nQdx2dhfib7SRNTClibRbGsOeTrzEBsQHlVEyAA/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><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 style="color: black;">a. 更改数据透视表的布局</span></span><span style="color: black;">点击透视表，单击鼠标右键→<span style="color: black;">选取</span>“数据透视表选项”→在“<span style="color: black;">表示</span>”栏中勾选“经典数据透视表布局（启用网格中的字段拖放）”。</span>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzA5EyNJaiauYzbQfD3iaeN0wG0TicXvKx5sNEwX3MVcVD8aVaJhj9vAA8Wlz6DyroDclyhxnWh8r4Hw/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><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 style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzA5EyNJaiauYzbQfD3iaeN0wRNWCFunK80GILozKnSZJCF0t4WhCIEN2BK658TIEHeuW62u3E1M1sA/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><span style="color: black;">效果如下图所示：</span>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzA5EyNJaiauYzbQfD3iaeN0wsdK3kDlUNhmO3CSWYehftOYM5LfJ6ZicvZwicfqXgyiaS0pt1rajnaicZA/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><span style="color: black;">b. 取消<span style="color: black;">归类</span>汇总</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>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzA5EyNJaiauYzbQfD3iaeN0wCWwKWATgMiaqH5DczU6XCjqbhLVLqsz6N9P2NZdghDvgT8fibibPibeXWQ/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><span style="color: black;">c. 将省份列的空白处填充</span><span style="color: black;">点击透视表，在“数据透视表工具”栏中，点击“设计”→“报表布局”→<span style="color: black;">选取</span>“重复所有项<span style="color: black;">目的</span>签”。</span>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzA5EyNJaiauYzbQfD3iaeN0w9euBAEDriaVfjfDfen2vQScuclCVCf110zak2CcbIVma2OhanXxDzLQ/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><span style="color: black;">d. 取消“展开与折叠”按钮</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>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzA5EyNJaiauYzbQfD3iaeN0wYbVHQHERfL1iapwZ4b8g9WpNE8jAKhMe67vceweKu0NWuXYJcp6bc0g/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" 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;">设置完成后，是不是<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;">※</strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">过程</span>三：</strong><strong style="color: blue;">添加切片器，实现“傻瓜式”动态筛选</strong></span></p><span style="color: black;">数据透视表有自带的手动筛选功能，将需要筛选的字段挪至“筛选”字段下<span style="color: black;">就可</span>实现筛选。</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>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzA5EyNJaiauYzbQfD3iaeN0wsK3ic91N85CAkyiaveH9lZnRGtuuHapaOM8doOrnia2VLwSWJb5B2qV8g/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><span style="color: black;"><span style="color: black;">引起</span>这一现象的<span style="color: black;">原由</span>是<span style="color: black;">因为</span>数据透视表的筛选字段与行字段，是二选一，有我无他的关系。</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 style="color: black;">办法</span>较为繁琐，且展示起来<span style="color: black;">不足</span>简洁明了。</span><span style="color: black;">此时，“切片器”的<span style="color: black;">优良</span>就<span style="color: black;">表现</span>出来了，利用切片器，<span style="color: black;">能够</span>直观的进行数据的筛选。</span><span style="color: black;">哪怕不懂数据透视表，在看到切片器后，就<span style="color: black;">晓得</span>该<span style="color: black;">怎样</span><span style="color: black;">运用</span>了。</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 style="color: black;">就可</span>。</span><span style="color: black;"><span style="color: black;">详细</span>操作请见下方动图：</span>
<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><span style="color: black;">最后再对切片器和数据透视表进行美化，就<span style="color: black;">能够</span>完成<span style="color: black;">目的</span>样式中的动态图表啦~</span>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">说在最后：</span></p><span style="color: black;">除以上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>本例，老师采用透视表来做讲解。若小伙伴们的excel是2013版及以上的，<span style="color: black;">能够</span>直接<span style="color: black;">运用</span>超级表，两步就能完成。操<span style="color: black;">功效</span>法：点击源数据表，<span style="color: black;">运用</span>快捷键Ctrl+T，调用出超级表，<span style="color: black;">而后</span><span style="color: black;">增多</span>切片器功能<span style="color: black;">就可</span>。是不是很简单，小伙伴快来试试吧！</span><span style="color: black;">扫一扫添加老师<span style="color: black;">微X</span></span>
<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;">在线咨询Excel课程</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></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>Excel<span style="color: black;">优秀</span>教程</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;"><span style="color: black;">求职大厂，却被面试官“毒打”：不会这五个技能的人，正在失去职场竞争力</span></a></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;"><span style="color: black;">大厂HR：有这种Excel思维的实习生，我真的想高薪留下来</span></a></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;"><span style="color: black;">靠一只“猪”一秒拆分上千个工作表？！同事的骚操作看呆我......</span></a></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;"><span style="color: black;">比VBA好用100倍！拆分工作表，用数据透视表5秒就搞定！</span></a></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></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><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;"><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;"><span style="color: black;"><strong style="color: blue;">您的“<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>产出的动力。</strong></span></p>
楼主果然英明！不得不赞美你一下！ 你的言辞如同繁星闪烁，点亮了我心中的夜空。 期待你更多的精彩评论，一起交流学习。 你字句如珍珠，我珍藏这份情。 外链发布论坛学习网络优化SEO。
页:
[1]