论坛 › 浙江 › Excel数据透视表最全干货都在这儿了（合集，值得转发保藏）

4lqedz 发表于 2024-10-1 08:49:40

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/2gYBLN8nOjBagGWRAMaYOToH04KoTXxqdNLqfWRQmrVG7MPeu2WyOo2aSso4PHVkiccmTriatsCRmcGhXibYYDkCg/?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;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;"><strong style="color: blue;"><span style="color: black;">（友情提醒，多图，请在wifi下观看！流量壕请无视本条）</span></strong></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 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>的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;">大众</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;"><strong style="color: blue;"><span style="color: black;">我是目录，目录是我</span></strong></p><img src="http://mmbiz.qpic.cn/mmbiz_gif/2gYBLN8nOjA0E5MpXjSvnnE51MDwM2BzhXKPoSQicicRGVictU1ljQiaUXkb5Lia5GHJ1Io1yzyjvtr0Y8hXBpJryHA/?tp=webp&amp;wxfrom=5&amp;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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/2gYBLN8nOjBagGWRAMaYOToH04KoTXxqSnyUjjvd2Zk9h7ECY5MrDBBBoVzs2BRbudQticPEmspribo8N8FOlEIA/?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>上篇：<span style="color: black;">基本</span>操作<img src="http://mmbiz.qpic.cn/mmbiz_gif/2gYBLN8nOjA0E5MpXjSvnnE51MDwM2Bz4y4cvYORAUCbx9YicyrS0vQ7Bx2QMiamuZ7OGKumExP7VgMmaUzBZT8A/?tp=webp&amp;wxfrom=5&amp;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;"><strong style="color: blue;"><span style="color: black;">01 创建数据透视表</span></strong></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;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/2gYBLN8nOjA0E5MpXjSvnnE51MDwM2BzhLEkaRfEFPLsd9Dc4jfzNUsJ81iawFzN8CSibhJ9Mq5P9JF37Vxm3LlQ/?tp=webp&amp;wxfrom=5&amp;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;"><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;"><span style="color: black;">创建透视表<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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/2gYBLN8nOjA0E5MpXjSvnnE51MDwM2BzH5JfDtMwAbY9KO4IQlSKeWsic6YDfMEU5KrBS4oLhuXw15FDn1512Aw/?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;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 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 style="color: black;">便是</span><span style="color: black;">为何</span>透视表能完成各个维度的数据汇总。</span></p><img src="http://mmbiz.qpic.cn/mmbiz_gif/2gYBLN8nOjA0E5MpXjSvnnE51MDwM2Bz4y4cvYORAUCbx9YicyrS0vQ7Bx2QMiamuZ7OGKumExP7VgMmaUzBZT8A/?tp=webp&amp;wxfrom=5&amp;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;"><strong style="color: blue;"><span style="color: black;">02 &nbsp;透视表转普通表格</span></strong></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;">这个很简单，只需要复制数据透视表，粘贴成<strong style="color: blue;">值</strong>就行了，<span style="color: black;">倘若</span><span style="color: black;">爱好</span>透视表的格式还<span style="color: black;">能够</span>像小奚<span style="color: black;">同样</span>粘贴一下<strong style="color: blue;">格式</strong>。</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/2gYBLN8nOjA0E5MpXjSvnnE51MDwM2BzADYsic6xqnibkrRmVq8KOVRITgjiawevDfibetK2TXa5byn61tHw0m8zqw/?tp=webp&amp;wxfrom=5&amp;wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></p><img src="http://mmbiz.qpic.cn/mmbiz_gif/2gYBLN8nOjA0E5MpXjSvnnE51MDwM2Bz4y4cvYORAUCbx9YicyrS0vQ7Bx2QMiamuZ7OGKumExP7VgMmaUzBZT8A/?tp=webp&amp;wxfrom=5&amp;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;"><strong style="color: blue;"><span style="color: black;">03 &nbsp;更改值字段计算方式</span></strong></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;">在前面<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;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/2gYBLN8nOjA0E5MpXjSvnnE51MDwM2BzrsRRFdoJIlVfhImhlxPC9BhNmzrqIUTmODiaBNn4eJ5BD9xIKbrbO3Q/?tp=webp&amp;wxfrom=5&amp;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;">文本类型</strong>，<span style="color: black;">咱们</span><span style="color: black;">能够</span>看到将订单编号拖到值字段时Excel会自动计算，<span style="color: black;">由于</span>文本类型<span style="color: black;">不可</span>求和，而金额是<strong style="color: blue;">数值</strong>，<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>平时的运用中，最常用到的还是<strong style="color: blue;">计数和求和</strong>这两种。</span></p><img src="http://mmbiz.qpic.cn/mmbiz_gif/2gYBLN8nOjA0E5MpXjSvnnE51MDwM2Bz4y4cvYORAUCbx9YicyrS0vQ7Bx2QMiamuZ7OGKumExP7VgMmaUzBZT8A/?tp=webp&amp;wxfrom=5&amp;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;"><strong style="color: blue;"><span style="color: black;">04 &nbsp;<span style="color: black;">插进</span>计算字段</span></strong></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>有一种偷懒的做法，直接在透视表外面乘以0.007，<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>，有的<span style="color: black;">朋友</span>会<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>GetPivotData函数获取数据透视表引用】，如下图所示。</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;">第1</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;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/2gYBLN8nOjA0E5MpXjSvnnE51MDwM2BziaLkUFwr0t3Eh0gjO2AFynN7GEy4elGqNeyO7R39crgOVZYkoRbQwBQ/?tp=webp&amp;wxfrom=5&amp;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;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">因此</span>，其实最好的<span style="color: black;">办法</span>是在Excel里面<span style="color: black;">插进</span>计算字段。</span></strong></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/2gYBLN8nOjA0E5MpXjSvnnE51MDwM2Bzz157hoN3Odulz95licbLYw1uJVE8Vk8xgmxl4hhHEkBZmicQKXkgt7Wg/?tp=webp&amp;wxfrom=5&amp;wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></p><img src="http://mmbiz.qpic.cn/mmbiz_gif/2gYBLN8nOjA0E5MpXjSvnnE51MDwM2Bz4y4cvYORAUCbx9YicyrS0vQ7Bx2QMiamuZ7OGKumExP7VgMmaUzBZT8A/?tp=webp&amp;wxfrom=5&amp;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;"><strong style="color: blue;"><span style="color: black;">05 &nbsp;透视表排序与筛选</span></strong></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>额排名前10的<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>存在多个字段的<span style="color: black;">状况</span>下，怎么筛选出老板想要的呢？直接<span style="color: black;">运用</span>行标签去筛选是行不通的，<span style="color: black;">处理</span><span style="color: black;">办法</span>是：<strong style="color: blue;">将鼠标点在列标签外面一格，<span style="color: black;">而后</span><span style="color: black;">运用</span>筛选功能，<span style="color: black;">详细</span>操作请看下图。</strong></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/2gYBLN8nOjA0E5MpXjSvnnE51MDwM2BzIABpPVxT896aVgnr8M4ticKmJCnA3ht92w8WJFHDRObMEHib9SPHkB1Q/?tp=webp&amp;wxfrom=5&amp;wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></p><img src="http://mmbiz.qpic.cn/mmbiz_gif/2gYBLN8nOjA0E5MpXjSvnnE51MDwM2Bz4y4cvYORAUCbx9YicyrS0vQ7Bx2QMiamuZ7OGKumExP7VgMmaUzBZT8A/?tp=webp&amp;wxfrom=5&amp;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;"><strong style="color: blue;"><span style="color: black;">06 &nbsp;行列百分比汇总</span></strong></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>：<strong style="color: blue;">【右键】-【值<span style="color: black;">表示</span>方式】-可<span style="color: black;">选取</span>相应的百分比选项。</strong></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/2gYBLN8nOjA0E5MpXjSvnnE51MDwM2BzMDNicCqic0Wrephks4ric9bRmP2vpUkwgib337UJIDbu4u0led5pRiaRrHg/?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;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 style="color: black;">咱们</span>只挑选最常用的：<strong style="color: blue;">总计百分比、行/列汇总百分比和父级汇总百分</strong>来看。</span></p>
    <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;"><span style="color: black;">当<span style="color: black;">咱们</span>分析各个项目占总值的百分比时，就<span style="color: black;">能够</span>用总计百分比。例如：老板想看<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></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/2gYBLN8nOjA0E5MpXjSvnnE51MDwM2BzzwtMyj0Q2iavn4elrd7ukjQ52uPpqDbBHD698LApdhprPAe2PZO8uMg/?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;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;"><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;"><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;"><strong style="color: blue;"><span style="color: black;">列汇总百分比</span></strong><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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/2gYBLN8nOjA0E5MpXjSvnnE51MDwM2BzUYb8s7hmLME39obsh7V4VKgoScEHY1W3F3LJJKAMEcg6TjPSOVvzNQ/?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;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;"><strong style="color: blue;"><span style="color: black;">行汇总百分比</span></strong><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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/2gYBLN8nOjA0E5MpXjSvnnE51MDwM2BzMHSHEDWvppRxad7OeCHFdic2GIsq708auxhBYTkicf8fxRVPt6Ssn7JA/?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;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;"><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;"><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>额在<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/2gYBLN8nOjA0E5MpXjSvnnE51MDwM2BzraIHePaTVCq32SwicZA0UtViaicL37DJTIXK9PCyLSve0G9JNJfBRoiaUg/?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><img src="http://mmbiz.qpic.cn/mmbiz_gif/2gYBLN8nOjA0E5MpXjSvnnE51MDwM2Bz4y4cvYORAUCbx9YicyrS0vQ7Bx2QMiamuZ7OGKumExP7VgMmaUzBZT8A/?tp=webp&amp;wxfrom=5&amp;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;"><strong style="color: blue;"><span style="color: black;">07 &nbsp;修改行列字段<span style="color: black;">次序</span></span></strong></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></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;">其实小奚曾经<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></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;"><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;">丢了这么大个人，不扳回一城不是小奚的风格啊，<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></p>
    <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 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></strong></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><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;"><span style="color: black;">08 &nbsp;刷新与更改数据源</span></strong></p>
    <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;"><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 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>设置<strong style="color: blue;">【打开文件时刷新数据】</strong></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;"><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;"><span style="color: black;">【问】：我的数据源表修改了，刷新了<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>列啦，只是刷新是不行的，还需要<strong style="color: blue;">更改数据源。</strong></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;"><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;"><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;"><strong style="color: blue;"><span style="color: black;">把数据源把设置成“表格”就<span style="color: black;">能够</span><span style="color: black;">处理</span>这个问题。</span></strong></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 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></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;"><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><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;"><span style="color: black;">09 &nbsp;透视表的复制与删除</span></strong></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>sheet删除掉吗？</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 style="color: black;">倘若</span>不想重新新建sheet，<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></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">删除透视表只需要全选透视表，直接按detele键就能<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>中篇：美观与布局<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;">10&nbsp; 透视表的三种布局</span></strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><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></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>说起了，这三类布局分别是：<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 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 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;"><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;"><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;"><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>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;"><strong style="color: blue;"><span style="color: black;">无论叠加多少个行字段，都只占一列。</span></strong><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;"><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;"><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;"><span style="color: black;">大纲形式与压缩形式最重要的区别<span style="color: black;">便是</span>：<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;"><span style="color: black;">另一</span>，<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;"><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;"><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;"><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;">1、与大纲形式<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;">2、与大纲形式<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></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;"><strong style="color: blue;"><span style="color: black;">以上的三种布局形式的特点，你都<span style="color: black;">认识</span>了吗？</span></strong></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;"><span style="color: black;">11&nbsp; <span style="color: black;">表示</span>和<span style="color: black;">隐匿</span><span style="color: black;">归类</span>汇总</span></strong></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 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 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;"><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;">看完动图<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><span style="color: black;">：<span style="color: black;">为何</span>小奚<span style="color: black;">选取</span>的是<strong style="color: blue;">在组的顶部<span style="color: black;">表示</span><span style="color: black;">归类</span>汇总</strong>，最后Excel还是<strong style="color: blue;">在组的底部<span style="color: black;">表示</span>的<span style="color: black;">归类</span>汇总</strong>呢？要结合<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;"><span style="color: black;">12&nbsp; 标签项重复<span style="color: black;">表示</span></span></strong></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>：<strong style="color: blue;"><span style="color: black;">第1</span>个是让<span style="color: black;">咱们</span>的标签项重复<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>，标签重复项只对大纲式和表格式有效，对压缩式无效，想想<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><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;"><span style="color: black;">13&nbsp; 合并行标签</span></strong></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></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>在操作Excel的时候，对合并单元格尤为热衷。（虽然合并单元格<span style="color: black;">始终</span>被<span style="color: black;">叫作</span>为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;">摆列</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;"><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><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;"><span style="color: black;">14&nbsp; <span style="color: black;">插进</span>空行间隔</span></strong></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;"><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>空行】</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;"><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 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;"><span style="color: black;">15&nbsp; 取消字段前+/-符</span></strong></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>】-【+/-按钮】</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><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;"><span style="color: black;">16&nbsp; 刷新后格式保持不变</span></strong></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;">不<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></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><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;"><span style="color: black;">17&nbsp; 透视表模板套用</span></strong></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;"><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></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;">最后的最后，关于美观与布局，还<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;"><span style="color: black;">18 文本分组</span></strong></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 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></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">按住Ctrl键<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;"><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><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;"><span style="color: black;">19 日期分组</span></strong></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键选中想要分组的内容来分组，<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>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></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;">怎么样？Excel还是很智能吧？</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;"><span style="color: black;">20 数值分组</span></strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">【问】：1、小奚，我是一个HR，要对员工进行工龄汇总，5年为一个工龄段，有什么简单的<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></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></p>
    <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 style="color: black;">司龄分组：</span></span></strong></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;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">金额段分组：</span></span></strong></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;"><span style="color: black;">大众</span><span style="color: black;">发掘</span>了吗？透视表只能<span style="color: black;">根据</span>等距步长来组合哟！<span style="color: black;">例如</span>司龄的步长设置为5，<span style="color: black;">那样</span>只能<span style="color: black;">根据</span>5的间隔来组合。</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 style="color: black;">例如</span>：1000-2000金额段，2000-5000金额段。<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></p>
    <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><span style="color: black;"><span style="color: black;">根据</span>18分本分组讲的Ctrl选中做组合的方式创建不等距组合，这种方式<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;"><strong style="color: blue;"><span style="color: black;">第二种</span></strong><span style="color: black;"><span style="color: black;">办法</span>是需要在源表<span style="color: black;">创立</span>辅助列，<span style="color: black;">而后</span>用VLOOKUP的模糊匹配，这个<span style="color: black;">咱们</span>会在下一次讲到。</span></p>下篇二：数据表出错<span style="color: black;">原由</span>
    <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>咱们的<strong style="color: blue;">数据源表</strong>出了问题。</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;"><span style="color: black;">21&nbsp; 某些列<span style="color: black;">无</span>标题</span></strong></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><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;"><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;"><strong style="color: blue;"><span style="color: black;">操作：</span></strong><span style="color: black;">需要<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;"><span style="color: black;">22 存在合并单元格</span></strong></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></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;">这可能是数据源表中存在合并单元格，Excel会将除了合并单元格的<span style="color: black;">第1</span>格以外的<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;"><strong style="color: blue;"><span style="color: black;">操作：</span></strong><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 style="color: black;">。</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;"><span style="color: black;">23 日期<span style="color: black;">违法</span></span></strong></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><span style="color: black;">是不是</span>存在<span style="color: black;">违法</span>日期？例如：20170101、2017.1.1等。</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;"><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;"><strong style="color: blue;"><span style="color: black;">操作</span></strong><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><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;"><span style="color: black;">24&nbsp; 数据源存在文本类型的数字</span></strong></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>0呢？</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;"><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;"><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;"><strong style="color: blue;"><span style="color: black;">操作</span></strong><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><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 style="color: blue;">某些列<span style="color: black;">无</span>标题、存在合并单元格、<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>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></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;">&nbsp;可<span style="color: black;">得到</span>本文案例数据源。</span></span></p>
    <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 style="color: black;">倘若</span>你觉得本文对你有所<span style="color: black;">帮忙</span>，请尽情<span style="color: black;">保藏</span>或转发吧！欢迎转载，欢迎后台撩我。</span></strong></p>END<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;"><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;"><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>

nqkk58 发表于 2024-10-17 21:48:52

感谢您的精彩评论，为我带来了新的思考角度。

4zhvml8 发表于 2024-10-31 03:34:52

期待楼主的下一次分享！”

nqkk58 发表于 3 天前

我深感你的理解与共鸣，愿对话长流。

查看完整版本: Excel数据透视表最全干货都在这儿了（合集，值得转发保藏）