论坛 › 甘肃 › 它是excel中最有用的功能，无之一。数据透视表入门教程（1~14）

6257rv7 发表于 2024-10-1 17:40:18

它是excel中最有用的功能，无之一。数据透视表入门教程（1~14）

    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">文/兰色幻想(来自<span style="color: black;">excel精英培训</span><span style="color: black;">微X</span>平台)</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>之一。下面是兰色编写的Excel数据透视表入门教程，共14</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表格里三足鼎立：excel技巧操作千万变化;excel函数以不变应万变;excel VBA无所<span style="color: black;">不可</span>。三者各有长短，互不相下。其中excel技巧阵营中的“老大”非“数据透视表”莫属。从今天<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;"><strong style="color: blue;"><span style="color: black;">第1讲:什么是数据数据透视表？</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></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 style="color: black;">能够</span>把一个明细表进行<span style="color: black;">归类</span>汇总，<span style="color: black;">况且</span><span style="color: black;">能够</span>随意改变汇总模式的一种工具</span>。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">明细表?<span style="color: black;">归类</span>汇总？随意改变模式？工具？神马东东？听起来还是有点抽象，还是看图比较真观。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;"><span style="color: black;">营销</span>明细表</span>：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz/4jUToJBtQvREziagkEah8oIl1bBEYVgwqmPm9j3H7DO408wef7H7MwUAiaj797C1SdxicY63fg9sxt6qPAoQbstIA/640?wx_fmt=jpeg&amp;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 style="color: black;">按照</span><span style="color: black;">地区</span>汇总</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRTUghG2XUibB4WHPibeicE6WiadWic2sUuNyPgnfKdkE2OrdNJOPTUxsnePMA/640?wx_fmt=jpeg&amp;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 style="color: black;">营销</span>员</span>汇总</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRTFEAKAVCmbVutsibzXMqUKLENqibU6ewrsmOOzqCEgswI4QKY4iakGHib5A/640?wx_fmt=jpeg&amp;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 style="color: black;">营销</span>员、商品名<span style="color: black;">叫作</span></span>汇总</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRT81pOe3TqeFcZfp6UQEWQo3tIlnIyhHG4U4u9a3AyJ0XLFQgL5lESUg/640?wx_fmt=jpeg&amp;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 style="color: black;">营销</span>员、商品名<span style="color: black;">叫作</span></span>汇总</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRT8I8iadZCaaZDWjc3H2ZicW2NHBtYeDM5ALnj14KVXntFyZpANh2YpmuA/640?wx_fmt=jpeg&amp;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>许你会说你是不是用了传说中的宏，对不起，我没写一句代码。以上。。。全是excel数据透视表实现的，<span style="color: black;">况且</span>展示的<span style="color: black;">亦</span>只是数据透视表最最最。。<span style="color: black;">基本</span>的汇总功能！！</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">嘿嘿~~是不是动心了呢？你不要<span style="color: black;">可疑</span>你<span style="color: black;">是不是</span>能学会，<span style="color: black;">由于</span>学习数据透视表不需要<span style="color: black;">基本</span>，只要跟着兰色学习，<span style="color: black;">必定</span><span style="color: black;">能够</span>学会的。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">（本系列教程节选自兰色幻想“<span style="color: black;">excel数透视表视频教程28集</span>”,该套视频教程在淘宝独家<span style="color: black;">营销</span> http://item.taobao.com/item.htm?id=19010498628，<span style="color: black;">亦</span><span style="color: black;">能够</span>联系客服QQ&nbsp;<span style="color: black;">649725266</span>&nbsp;咨询。）</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;">第2讲：制作数据透视表</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;">第1</span>讲中<span style="color: black;">咱们</span>简单介绍了<span style="color: black;">什么是excel数据透视表</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;">第1</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;"><span style="color: black;">1 什么样的表格需要做数据透视表</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">数据透视表的用途<span style="color: black;">倘若</span>细数会有<span style="color: black;">非常多</span>，但最基本、最常用的是“<span style="color: black;"><span style="color: black;">归类</span>汇总</span>”，<span style="color: black;">因此</span>当<span style="color: black;">咱们</span>需要对一个流水账式的明细表进行<span style="color: black;">归类</span>汇总时，就需要<span style="color: black;">运用</span>数据透视表。数据透视表的源数据即是“明细表”。如第1讲中的<span style="color: black;">营销</span>明细表。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">2 什么样的格式<span style="color: black;">才可</span>做出数据透视表</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">在制作数据透视表，需要<span style="color: black;">重视</span>以下几点：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1 空字段名<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;">2 相同的字段名，会自动添加序号，以示区别 &nbsp; </p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">3 字段所在行有合并单元格，等同于空字段，<span style="color: black;">亦</span><span style="color: black;">没法</span>创建数据透视表 &nbsp; </p>4 <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>将在第3讲介绍。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">下面<span style="color: black;">咱们</span>就要亲手制作数据透视表了</span>。</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;">微X</span>右下角阅读原文 下载示例表格</span>)</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRT7BWeN1EddM6RRyEJudkUkPjQHnGIJQVcQUeHu09B6z2W8ZE9eIDB2g/640?wx_fmt=jpeg&amp;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 style="color: black;">过程</span></span>：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">第1步</span>&nbsp;<span style="color: black;">选择</span><span style="color: black;">营销</span>明细表，<span style="color: black;">excel2003</span>版 ： 数据菜单 - 数据透视表(<span style="color: black;">Excel2010</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;">excel2003版</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRTueknNjqJVK1jdraZIATR5a16yIHhzR4wAn2icicG0YibcBSaDYM8fvrfg/640?wx_fmt=jpeg&amp;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;">excel2010版</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRT8evGgqKwWycv1BLb8OCyUkibhUB3g6LLvhJShoRicWG7ty46coMsafTA/640?wx_fmt=jpeg&amp;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;">第2步</span>执行“数据透视表”命令后，会进入数据透视表创建向导。（excel2003和excel2010稍有差异，但大体选项是<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>(excel2003版在<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="http://mmbiz.qpic.cn/mmbiz/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRTickicnDMkmiahw6xeKM1uJXXicUuPFGtpqum2ibJdVTIaqjUpk9TEHFSHow/640?wx_fmt=jpeg&amp;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;">第3步</span>&nbsp;进行前两步后，会自动新建一个工作表，且在工作表中会有一个数据透视表空白区域，就象盖楼房地基已打好，需要<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="http://mmbiz.qpic.cn/mmbiz/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRTAtb9GLxF7b1M8E6Lnry9SI8OdNq79icWffPOiaZicSzSicbQUX49VN9Utw/640?wx_fmt=jpeg&amp;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></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">A&nbsp;<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;">B&nbsp;<span style="color: black;">把<span style="color: black;">营销</span>量和<span style="color: black;">营销</span>金额拖动到数值区域</span>。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRTZ8FxQdojTIf7RmMiaUSvcYlC1OISMAHdn87ZOzGkY2LD1wlzLOCibNVA/640?wx_fmt=jpeg&amp;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 style="color: black;">重视</span></span>：excel2003版和excel2010添加方式<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="http://mmbiz.qpic.cn/mmbiz/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRTuguHiayWLqbegEicUnZ7m6ibRbrcVmukYe4LKTN7s9d9M9kUemWuxOzOw/640?wx_fmt=jpeg&amp;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></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRTTYd89VsgzNjpwTKgSqDxslXtefNUJd6In2R71CPhmuQXA4wcrgibR1w/640?wx_fmt=jpeg&amp;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 style="color: black;">怎样</span>修改数据透视表的汇总方式</span>？<span style="color: black;"><span style="color: black;">怎样</span>修改数据透视表的格式...</span>呵呵，别急..一口吃不成胖子，以后兰色会一一帮你揭开谜底。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">第3讲预告</span>：数据透视表的数据源整理</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">excel实例附件下载：http://www.excelpx.com/home/upload/2014_02/temp_14020822335203.zip</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;">第3讲：源表的整理</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></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">1&nbsp;<span style="color: black;">存在空列或<span style="color: black;">无</span>行标题</span>。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRTOxH0vMR8rb1vscYsiadjNTsnU0MSMU9KxmWxOoFQGW2pDVPbUkc2F4A/640?wx_fmt=jpeg&amp;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></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;">2&nbsp;<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="http://mmbiz.qpic.cn/mmbiz/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRTkrJhA6WicnYR7ibqjrWe0omwXQ1NDiaub9yesZ1l0PrU5ruDtOgGicvyHA/640?wx_fmt=jpeg&amp;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;"><img src="http://mmbiz.qpic.cn/mmbiz/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRTTdP6lHk42UNKPCTOlLdQVGmLqicwPdQrjOhS39vUJsFCkicAFdsvTP7Q/640?wx_fmt=jpeg&amp;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></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;">3 存在合并单元格</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRT5VRbhiahN1B8zA5Qicjq9Tb0ejw9nGhmYt8yOTaZ0v7VibEowt8icN1NeA/640?wx_fmt=jpeg&amp;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;"><img src="http://mmbiz.qpic.cn/mmbiz/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRTdU6Fuz4XqmUQDPjbmuTRicnaeLPqmwQCkBscoibJ5Yibh4Yqzg07IOAiaw/640?wx_fmt=jpeg&amp;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>：合并单元格除第1个格外，其他均<span style="color: black;">做为</span>空值处理。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><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;">4 存在<span style="color: black;">违法</span>日期。</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRTDtbeKicib165QzEs6DicFFfachZnotVsCEeQNiblGxCLmlt3ZcvfSBwwiaA/640?wx_fmt=jpeg&amp;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></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">整理</span>：转换成excel认可的日期格式。<span style="color: black;">办法</span>：<span style="color: black;">选择</span>列 - 分列 - 第3步选日期</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;">5 存在文本型数字</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRT2LiaY245kQuibX3NXoFEavccXeXicR6kKK8cibbiayGwb65p8KMXLICTpuw/640?wx_fmt=jpeg&amp;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;"><img src="http://mmbiz.qpic.cn/mmbiz/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRT3Scyb1YkajgwajUmCsl2ms5MnrFPDEicDaUO9WXpJvX0Lq7ibLWTWc4A/640?wx_fmt=jpeg&amp;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></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></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">第4讲：数据透视表的结构</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></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">1&nbsp;<span style="color: black;">字段列表</span>。明细表的所有<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="http://mmbiz.qpic.cn/mmbiz/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRT5W5vsHibKPecOIib58dWtHxv25Mv9woic3h9C6oADBek7b3EvQWnuGaDA/640?wx_fmt=jpeg&amp;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;">2&nbsp;<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="http://mmbiz.qpic.cn/mmbiz/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRT5YL07p8bDB5GRxWVpN4dM32TXErXEwu3uQXzEpoCibR8OMCv5xhOsDw/640?wx_fmt=jpeg&amp;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;">3&nbsp;<span style="color: black;">数据透视表的<span style="color: black;">表示</span>区域</span>。组合成的数据透视表会在这儿<span style="color: black;">表示</span>。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRTfJD1AvLiaqzMCphDTZ9msIske4JMJNdfTcJ7RcY7JMyo4SFHphj6HXg/640?wx_fmt=jpeg&amp;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;">A&nbsp;<span style="color: black;">报表筛选区域</span>（excel2003版<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;">B&nbsp;<span style="color: black;">行标签</span>（2003版<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;">C&nbsp;<span style="color: black;">列标签</span>（2003版<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;">D&nbsp;<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;"><strong style="color: blue;">字段拖放在<span style="color: black;">区别</span>的区域，就会以<span style="color: black;">区别</span>的<span style="color: black;">表示</span>方式<span style="color: black;">表示</span>汇总的结果。<span style="color: black;">况且</span>同一个区域内的<span style="color: black;">次序</span><span style="color: black;">区别</span>，在数据透视表内汇总的先后层次<span style="color: black;">亦</span>会<span style="color: black;">区别</span></strong></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;">微X</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;">第5讲：值的计算方式</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></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRTqJBCa45dUIVUVsUNGFGn5Vk9rph4fjXQxM3GgYhMziaa2hz26ibXUMqw/640?wx_fmt=jpeg&amp;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 style="color: black;">原由</span></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 style="color: black;">办法</span></span>：把<span style="color: black;">营销</span>员从值框中拖出去（删除），<span style="color: black;">而后</span>双击“数量”列标题，在弹出的“<span style="color: black;">值字段设置</span>”窗口中，把“计数”修改为“求和”，如下图所示。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRTINZVEQFOUZhPmJLmF8gcjYm4iaBZiaOoVmlibgIwZFngmAvKj9qV1ViaRg/640?wx_fmt=jpeg&amp;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></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRTxUfibTstQaviceUbjD8Pv4VzVicYgUicia1z6ajBhnI8nZNU9PAUN3fPp5A/640?wx_fmt=jpeg&amp;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></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;"><strong style="color: blue;"><span style="color: black;">第6讲：数据透视表的布局方式</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>你是excel2003以上版本，你会看到多列的内容会显在一列中，如下图所示。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRTOwn9ricvBfIeCeIwqKcefeAyV5A2CJ4hVY4Y5g8ZoX4yYjRRtKiaxVGA/640?wx_fmt=jpeg&amp;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>数据透视表 - 在顶部找到“设计”选项卡 - 再打开报表布局下拉菜单，会看到5种<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;">1 压缩式布局。如本文<span style="color: black;">起始</span>所示。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">2 大纲式视图。特点标题分列<span style="color: black;">表示</span>。汇总<span style="color: black;">表示</span>在每项的上方</span></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 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;">4 重复所有项<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;">5 不重复所有项<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;"><strong style="color: blue;">第7讲：添加和删除汇总项</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></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;"><strong style="color: blue;">1 总计行</strong></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 style="color: black;">表示</span>的命令在 数据透视表右键 - 选项 - 如下图所示。（2003版在数据透视表上右键 - 表格选项 - 行和列总计选中）</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;"><strong style="color: blue;">2 <span style="color: black;">归类</span>汇总行</strong></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="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 style="color: black;">隐匿</span>汇总</span>，在数据透视表相应的列上右键，取消“分汇汇总..”勾选，<span style="color: black;">倘若</span>要恢复操作相同。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><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;"><strong style="color: blue;"><span style="color: black;">第8讲 数据透视表的美化</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></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 style="color: black;">过程</span></span>：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">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;"><span style="color: black;"><span style="color: black;">2</span>&nbsp;点设计 - 其他 - 打开<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;"><strong style="color: blue;">第9讲：修改引用数据源</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 style="color: black;">出现</span>了变化</span>，数据透视表<span style="color: black;"><span style="color: black;">通常</span></span>是不会自动<span style="color: black;">调节</span>数据源的，而需要手工去<span style="color: black;">调节</span>数据源的数据范围。<span style="color: black;">办法</span>是：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">excel2010版<span style="color: black;">选择</span>数据透视表 - 最顶端数据透视表<span style="color: black;">选项</span>&nbsp;-&nbsp;<span style="color: black;">更改数据源</span>&nbsp;- 重新<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;">excel2003版在数据透视表的右键菜单中，有“<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 style="color: black;">通常</span></span>”不会自动更改数据源，难道有“二般”的<span style="color: black;">状况</span>？？</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">还真有，<span style="color: black;">办法</span><span style="color: black;">便是</span>把明细表设置为“数据表”（2003版<span style="color: black;">叫作</span>为列表），<span style="color: black;">设置<span style="color: black;">过程</span></span>是：<span style="color: black;">选择</span>明细表区域，excel2010版<span style="color: black;"><span style="color: black;">插进</span></span>&nbsp;-&nbsp;<span style="color: black;">表格</span>。（excel2003右键菜单中“<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></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">第10讲：数据透视表的刷新</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></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>excel文件中有<span style="color: black;">非常多</span>数据透视表，<span style="color: black;">能够</span>添加“<span style="color: black;">所有</span>刷新”按钮。<span style="color: black;">办法</span>是</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">文件 - Excel选项 - 快捷<span style="color: black;">拜访</span>工具栏 - 左侧栏中找到“<span style="color: black;">所有</span>刷新” - 点击“添加”按钮<span style="color: black;">就可</span>添加到“快捷<span style="color: black;">拜访</span>工具栏”如下图所示</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><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;"><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;"><strong style="color: blue;">第11讲：数据透视表的移动和删除</strong></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></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;">ctrl</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;"><span style="color: black;"><span style="color: black;">选择</span><span style="color: black;">包含</span>所有数据透视表元素的区域，<span style="color: black;">包含</span>透视表筛选区域和行列及数值标签区域，按del键<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;">第12讲：筛选数值项</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></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>筛选数量大于30的行。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;"><span style="color: black;">过程</span>：</span></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>&nbsp;-&nbsp;<span style="color: black;">大于</span>&nbsp;- 输入30，点确定后<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></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>excel的自带筛选功能。如下图所示。</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;"><strong style="color: blue;">第13讲：固定数字和表格格式</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;"><span style="color: black;"><span style="color: black;"><span style="color: black;">处理</span><span style="color: black;">办法</span></span>：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">在数据透视表上右键 - 数据透视表选项 - 去掉“更新时自动<span style="color: black;">调节</span>列宽”，勾选“更新时<span style="color: black;">保存</span>数字格式”</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><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><span style="color: black;">以上</span>问题的<span style="color: black;">办法</span>：把地区放在行标签，<span style="color: black;">而后</span>统一设置数字的格式为千位分隔符样式。<span style="color: black;">而后</span>再筛选所有地区，数字格式均为千位分隔符样式。</p>

    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">第14讲：<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></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">1 全选数据透视表</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">光标放在数据透视表上，最上面数据透视表工具 - 布局 - <span style="color: black;">选取</span> - <span style="color: black;">全部</span>数据透视表。（excel2003版在右键菜单中就有<span style="color: black;">选取</span>的子菜单）</span><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;">2 <span style="color: black;">选择</span>值或行列标签<span style="color: black;">分部</span></span>。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">在第1步中<span style="color: black;">咱们</span><span style="color: black;">发掘</span>除了全选外，其他的都是灰色。这是<span style="color: black;">由于</span>当你<span style="color: black;">选择</span>的范围内<span style="color: black;">包含</span>值等元素时，这些<span style="color: black;">才可</span>用，<span style="color: black;">因此</span>要<span 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;">3 <span style="color: black;">选择</span>某行、某列</span>。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">当你把光标放在数据透视表的某行或某列前面时，你会<span style="color: black;">发掘</span>光标变<span style="color: black;">成为了</span><span style="color: black;">黑箭头</span>。<span style="color: black;">此时</span>你只需要单击就<span style="color: black;">能够</span><span 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>之一的用法。想学习数据透视表<span style="color: black;">更加多</span>深入用法，<span style="color: black;">能够</span>报名平台创办的 <span style="color: black;"><strong style="color: blue;">Excel数据透视表在线精讲班</strong></span>，听向伟老师讲解<span style="color: black;">excel多表透视</span>、<span style="color: black;">在透视表中<span style="color: black;">运用</span>函数公式、高级排序和分析等技巧</span>。本月<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;">微X</span>号</span><span style="color: black;">13837191861</span><span style="color: black;">，（长按下面二维码，<span style="color: black;">点</span><span style="color: black;">识别图中二维码</span><span style="color: black;"><span style="color: black;">能够</span>快速添加客户为<span style="color: black;">微X</span>好友），</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"> &nbsp; &nbsp;<img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">点左下角“<span style="color: black;">阅读原文</span>”查看数据透视表大纲等详情</p>

1fy07h 发表于 2024-10-12 22:49:16

你的话语如春风拂面，让我心生暖意。

nqkk58 发表于 2024-10-15 11:29:58

软文发布平台 http://www.fok120.com/

m5k1umn 发表于 2024-10-26 03:32:33

论坛的成功是建立在我们诚恳、务实、高效、创新和团结合作基础上，我们要把这种精神传递下去。

查看完整版本: 它是excel中最有用的功能，无之一。数据透视表入门教程（1~14）