Excel数据透视表6大神技，操作简单不费脑，史上NO.1好用！
<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;">作为</span>许多人最重要的工作伙伴。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">但许多人眼里，<span style="color: black;">数</span><span style="color: black;">据透</span><span style="color: black;">视表只是一个<span style="color: black;">归类</span>汇总的工具，</span></span><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><span style="color: black;"><span style="color: black;">咱们</span>就来给<span style="color: black;">大众</span></span><span style="color: black;">分享几个常用的数据透视表技巧。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">排名</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>rank函数进行排名。其实数据透视表自带排名功能，<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_jpg/k6kCsib3eJMwiaMjsU7vUsmPgqA6NfNSaRfDXufsuBZw52ykIH9VKlpGLe9QYJpstWnSAEtIjttkS5gVV1HfmGRQ/640?wx_fmt=jpeg&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 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/k6kCsib3eJMwiaMjsU7vUsmPgqA6NfNSaRRv1uSib9fibNxA9jD2YCia7LKiaO5eXnlZsXNXCuiaJ45BdyPYxt6xIsdpw/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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwiaMjsU7vUsmPgqA6NfNSaRPDhqLfloaUuddzjia9fnYmGzcUictmGBfnY7dWTn6p2xoMJ9Aj50Cf3Q/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 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/k6kCsib3eJMwiaMjsU7vUsmPgqA6NfNSaRIknA79QOENYBA3mzAmfdPDweTt3D42RA87aqqSaVNr1icuicn8JRydjg/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 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_jpg/k6kCsib3eJMwiaMjsU7vUsmPgqA6NfNSaRKlWR5YVo92JoicrumdZQpSHnKzRQLj8diav61zibEH2054a0SvYkjCLZA/640?wx_fmt=jpeg&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;">2</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">批量创建工作表</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;"><span style="color: black;">举例：<span style="color: black;">此刻</span><span style="color: black;">咱们</span>需要创建4个季度的工作表。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><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/k6kCsib3eJMwiaMjsU7vUsmPgqA6NfNSaRvaRfGP6uzuKNNibCfSu3srh9xkMyq38ct2WhQcPLRlUaHO8M2QeZMnA/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>选中A列数据，单击【<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/k6kCsib3eJMwiaMjsU7vUsmPgqA6NfNSaRTJCBIH8ZkyyfoicyEKQSaHrMkb4ITJ6PrfXqMw21L9Vfv7nibWuYN5pw/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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwiaMjsU7vUsmPgqA6NfNSaRkA3ibzrpEaCb7YJ0PagJ61stV1ogRHFeol0lbaIJW47Vat0VjpuWSPQ/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;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMwiaMjsU7vUsmPgqA6NfNSaRrn3hHEjibfoVyIUsjgWHF3ehBfy57yiaSevtP1h5N87vs9WRiaCYPW9Eg/640?wx_fmt=jpeg&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 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_jpg/k6kCsib3eJMwiaMjsU7vUsmPgqA6NfNSaRnzibUmljztK9RGFOzs0rlia5EQvQTsU4RIPXOCl3t9Lxos6RyPJia0CIQ/640?wx_fmt=jpeg&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 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/k6kCsib3eJMwiaMjsU7vUsmPgqA6NfNSaRDZKiazzcmgk8mQSqkYByQy78VUxKjjkLqLMSBO8osgQeqLQjpTAva4A/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;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMwiaMjsU7vUsmPgqA6NfNSaRfZlQrZib8gPlZQEhyGjdjyx19bVicthlNzGu2wtDdxyJtZF5Wxib4ZhsA/640?wx_fmt=jpeg&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 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_jpg/k6kCsib3eJMwiaMjsU7vUsmPgqA6NfNSaR8y1HhKovyKIoGia7LczMGhdVRic9vNsC4B3xFP66iblQttQFRoO81bwaQ/640?wx_fmt=jpeg&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 style="color: black;">叫作</span>排序的。譬如<span style="color: black;">这儿</span>的<span style="color: black;">第1</span>到第四季度，创建出来的工作表依次是第<span style="color: black;">2、</span>第<span style="color: black;">3、</span>第<span style="color: black;">4、</span><span style="color: black;">第1</span>季度。<span style="color: black;">倘若</span>想按季度<span style="color: black;">次序</span>创建工作表，则输入时改成阿拉伯数字，如第1、第2、第3、第4等季度。<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>前依次添加阿拉伯数字1、2、3等，则工作表按输入<span style="color: black;">次序</span>创建。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">3</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">多表求和</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>请看教程《<a style="color: black;">别瞎忙乎了，多表求和用这个<span style="color: black;">办法</span><span style="color: black;">便是</span>分分钟的事……</a>》。 </span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">4</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">按新增字段分组统计</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;">1、</span><span style="color: black;">2、</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></p>
<h3 style="color: black; text-align: left; margin-bottom: 10px;"><strong style="color: blue;"><span style="color: black;">例1：按日期分组统计</span></strong> </h3>
<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/k6kCsib3eJMwiaMjsU7vUsmPgqA6NfNSaRCciaRQG7KsCh6hF01FzfpRiaAvUfico9OeJMlEMr3sPCqd7kkmz4NPSfQ/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;">（1）选中所有数据，<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_jpg/k6kCsib3eJMwiaMjsU7vUsmPgqA6NfNSaRENo6JJQictXLEj90mYspJg3E8B1RSmnXUoRlyTmrd2Pg6N22nwEfNcQ/640?wx_fmt=jpeg&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;">（2）将“<span style="color: black;">营销</span>日期”字段拖入行区域中，Excel会自动<span style="color: black;">增多</span>一个“月”字段（需要是2016版本），右侧透视表中行标签按月<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_jpg/k6kCsib3eJMwiaMjsU7vUsmPgqA6NfNSaRJibCwLSItkW6kgzc7RysDyAkribt9hQ2tfnvZyYJbeSsOLbialjztT5GQ/640?wx_fmt=jpeg&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;">（3）下面<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="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwiaMjsU7vUsmPgqA6NfNSaRnNhm6UZTib3R1KKcxaw3lNjpLLgmUGI71FVj2kmNZAz4WSvXicoBplzA/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 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;">（4）单击“季度”，<span style="color: black;">而后</span>确定。 </span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwiaMjsU7vUsmPgqA6NfNSaRQcPJzfAQ53xib3k6ibDbKQsy8IbY9Ak61RbP1uBfusnUObMpkZlaslsg/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;">（5）<span style="color: black;">能够</span>看到数据透视表字段中<span style="color: black;">增多</span>了“季度”字段。在左侧的透视表中，单击</span><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwiaMjsU7vUsmPgqA6NfNSaRq76ptAXMicic6JR3j9Po8VHvh6fHqKLJMs2OZpnr8MuvNWEol1zoEnag/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><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_jpg/k6kCsib3eJMwiaMjsU7vUsmPgqA6NfNSaRJrW1p1HfRib9RdgoRH5DGQ1tnHT4xPAMU7icLjOHSibnwuyxarXjHj8Qw/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<h3 style="color: black; text-align: left; margin-bottom: 10px;"><strong style="color: blue;"><span style="color: black;">例2：分数分<span style="color: black;">周期</span>统计</span></strong> </h3>
<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>需要统计<60、60-79、80-100各<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/k6kCsib3eJMwiaMjsU7vUsmPgqA6NfNSaRCiaV8BqkEAnJ7dI3v28BuY25DpAnRxnb62G6pznRELha2gBxG2kn9GA/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;">（1）<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;">（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;"><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;">（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;"><span style="color: black;">（4）<span style="color: black;">此刻</span>按需要修改<span style="color: black;">初始</span>值和终止值、步长。设置<span style="color: black;">初始</span>于60，终止于100，步长20，如下。 </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;">（5）单击“确定”后，行标签变<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;">（6）将“成绩”字段拖到值区域中，实现了人数统计，如不及格的有11人。 </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;">（7）<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>在第（3）步的时候改变做法。譬如选中0-59，右击，<span style="color: black;">选取</span>“组合”，生成“数据组1”，选中“数据组1”，在编辑栏中输入“D”，把“数据组1”改成“D”，这<span style="color: black;">便是</span>成绩D<span style="color: black;">周期</span>；选中60-79，右击组合后改成“C”；选中80-90，右击组合后改成“B”；选中90以上的，右击组合后改成“A”。如此就把成绩分<span style="color: black;">成为了</span>ABCD四个<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;">5</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">非重复计数</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>的完成方式见《<a style="color: black;">围观数据透视表新功能：小东西，大<span style="color: black;">功效</span></a>》</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">6</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">空白值</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>为0。（注：只针对值区域中的空白！）</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;">第1</span>季度中的屏幕300*220项目购买数量为空白，<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>看到C13单元格为空白。 </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></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>
<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></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></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;">总结</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>分享了6个数据透视表实用的技巧。这些技巧都很<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>思考，就会多挖掘一个技巧，让Excel运行更由心。</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>
谷歌外贸网站优化技术。 你的见解独到，让我受益匪浅，期待更多交流。 你的言辞如同繁星闪烁，点亮了我心中的夜空。 外链论坛的成功举办，是与各位领导、同仁们的关怀和支持分不开的。在此，我谨代表公司向关心和支持论坛的各界人士表示最衷心的感谢！ 感谢您的精彩评论，为我带来了新的思考角度。
页:
[1]