数据透视表的运用办法(入门+进阶共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;">前言:平时<span style="color: black;">咱们</span>看到的都是数据透视表的<span style="color: black;">运用</span>小技巧,很少有系统的讲解数据透视表的知识点。<span style="color: black;">这次</span>兰色把原来发布的数据透视表图文教程整理到<span style="color: black;">一块</span>,共14集,<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;">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&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 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&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 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&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 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&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 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&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>许你会说你是不是用了传说中的宏,对不起,我没写一句代码。以上。。。全是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;"><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></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 相同的字段名,会自动添加序号,以示区别 </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>创建数据透视表 </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&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 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 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&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;">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&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;">第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&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;">第3步</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/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRTAtb9GLxF7b1M8E6Lnry9SI8OdNq79icWffPOiaZicSzSicbQUX49VN9Utw/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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">A <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 <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&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 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&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="http://mmbiz.qpic.cn/mmbiz/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRTTYd89VsgzNjpwTKgSqDxslXtefNUJd6In2R71CPhmuQXA4wcrgibR1w/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 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;"><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 <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&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;"><span style="color: black;">整理</span>: 把标题<span style="color: black;">弥补</span>完整。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">2 <span style="color: black;">存在相同的标题</span>。</span></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&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="http://mmbiz.qpic.cn/mmbiz/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRTTdP6lHk42UNKPCTOlLdQVGmLqicwPdQrjOhS39vUJsFCkicAFdsvTP7Q/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></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&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="http://mmbiz.qpic.cn/mmbiz/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRTdU6Fuz4XqmUQDPjbmuTRicnaeLPqmwQCkBscoibJ5Yibh4Yqzg07IOAiaw/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>:合并单元格除第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&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;"><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&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="http://mmbiz.qpic.cn/mmbiz/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRT3Scyb1YkajgwajUmCsl2ms5MnrFPDEicDaUO9WXpJvX0Lq7ibLWTWc4A/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;"><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 <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&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>。把要<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&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 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&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;">A <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 <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 <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 <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&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 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&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="http://mmbiz.qpic.cn/mmbiz/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRTxUfibTstQaviceUbjD8Pv4VzVicYgUicia1z6ajBhnI8nZNU9PAUN3fPp5A/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;"><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&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>数据透视表 - 在顶部找到“设计”选项卡 - 再打开报表布局下拉菜单,会看到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> 点设计 - 其他 - 打开<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> - <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;">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> - <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> - <span style="color: black;">大于</span> - 输入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></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;"><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></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><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;">excel教程</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>
大势所趋,用于讽刺一些制作目的就是为了跟风玩梗,博取眼球的作品。 这篇文章真的让我受益匪浅,外链发布感谢分享!
页:
[1]