【实用教程】数据分析利器--EXCEL 数据透视表（一）
<p 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>之一。下面是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;"><span style="color: black;">一一</span>Excel表格里三足鼎立：excel技巧操作千万变化;excel函数以不变应万变;excel VBA无所<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;"><span style="color: black;">一一</span>在学习excel数据透视表之前，<span style="color: black;">咱们</span>有必要<span style="color: black;">认识</span>它的概念。什么是数据透视表呢？</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">一一</span>理论上讲，数据透视表是excel<span style="color: black;">供给</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;">能够</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;"><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="/mpres/htmledition/ueditor/themes/default/images/spacer.gif?wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><img src="/mpres/htmledition/ueditor/themes/default/images/spacer.gif?wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><img src="http://mmbiz.qpic.cn/mmbiz/gbR8kwd7POkpA475WyBhwzhoGuz7BOKkWkn8j4umprugPiasT3jjWmAJTybsB8g4C59yY61IpLJXRPzfhxxNLiaw/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 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&wxfrom=5&tp=webp&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 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&wxfrom=5&tp=webp&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 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&wxfrom=5&tp=webp&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 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&wxfrom=5&tp=webp&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>许你会说你是不是用了传说中的宏，对不起，我没写一句代码。以上。。。全是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;"><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;">一一</span><span style="color: black;">第1</span>讲中<span style="color: black;">咱们</span>简单介绍了</span><span style="color: black;">什么是excel数据透视表</span><span style="color: black;">，关于数据透视表的基本概念还有<span style="color: black;">非常多</span>，<span style="color: black;">倘若</span><span style="color: black;">此刻</span>拿来全讲，估计<span style="color: black;">朋友</span>们听起来会象天书一样。基本的概念<span style="color: black;">咱们</span><span style="color: black;">能够</span>在后面逐步介绍，我想<span 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><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;"><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>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>，但最基本、最常用的是“<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;"><span style="color: black;">一一</span>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 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;">1 空字段名<span style="color: black;">包含</span>空列，<span style="color: black;">没法</span>制作数据透视表</p><span style="color: black;">一</span>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">2 相同的字段名，会自动添加序号，以示区别 </p><span style="color: black;">一</span>
<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><span style="color: black;">一</span>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>制作数据透视表，数据表的整理<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 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 style="color: black;">一一</span>原材料</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&wxfrom=5&tp=webp&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;"><span style="color: black;"><span style="color: black;"><span style="color: black;">一一</span>第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;"><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/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRTueknNjqJVK1jdraZIATR5a16yIHhzR4wAn2icicG0YibcBSaDYM8fvrfg/640?wx_fmt=jpeg&wxfrom=5&tp=webp&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>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&wxfrom=5&tp=webp&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>第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&wxfrom=5&tp=webp&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>第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&wxfrom=5&tp=webp&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;">一一</span>A <span style="color: black;">把地区拖动到行标签</span></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">一一</span>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&wxfrom=5&tp=webp&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>：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&wxfrom=5&tp=webp&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">一一</span>拖动完成后，一个数据透视表的雏形已展<span style="color: black;">此刻</span><span style="color: black;">咱们</span>的面前，如下图所示。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRTTYd89VsgzNjpwTKgSqDxslXtefNUJd6In2R71CPhmuQXA4wcrgibR1w/640?wx_fmt=jpeg&wxfrom=5&tp=webp&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">一一</span>在欣喜自已成功创建数据透视表之余，<span style="color: black;">一样</span>会有<span style="color: black;">非常多</span>疑问<span style="color: black;">伴同</span>而来：<span style="color: black;">什么是行标签</span>？<span 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 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>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&wxfrom=5&tp=webp&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></p>
<p 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;"><span style="color: black;"><span style="color: black;">一一</span>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&wxfrom=5&tp=webp&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&wxfrom=5&tp=webp&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;"><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 style="color: black;">一一</span>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&wxfrom=5&tp=webp&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&wxfrom=5&tp=webp&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>：合并单元格除第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 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 style="color: black;">一一</span>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&wxfrom=5&tp=webp&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></p>
<p 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>：转换成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;"><span style="color: black;">一一</span>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&wxfrom=5&tp=webp&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&wxfrom=5&tp=webp&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></p>
<p 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></p>
<p 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;"><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 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>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&wxfrom=5&tp=webp&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>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&wxfrom=5&tp=webp&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>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&wxfrom=5&tp=webp&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">一一</span>A <span style="color: black;">报表筛选区域</span>（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;"><span style="color: black;">一一</span>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;"><span style="color: black;">一一</span>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;"><span style="color: black;">一一</span>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>会<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;"><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><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;"><img src="http://mmbiz.qpic.cn/mmbiz/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRTqJBCa45dUIVUVsUNGFGn5Vk9rph4fjXQxM3GgYhMziaa2hz26ibXUMqw/640?wx_fmt=jpeg&wxfrom=5&tp=webp&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 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 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&wxfrom=5&tp=webp&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/4jUToJBtQvSvgNg3q7sPqichcwDjN7QRTxUfibTstQaviceUbjD8Pv4VzVicYgUicia1z6ajBhnI8nZNU9PAUN3fPp5A/640?wx_fmt=jpeg&wxfrom=5&tp=webp&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></p>
<p 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;"><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>成数据透视表后，<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&wxfrom=5&tp=webp&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>数据透视表 - 在顶部找到“设计”选项卡 - 再打开报表布局下拉菜单，会看到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;"><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>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;"><span style="color: black;">一一</span>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;"><span style="color: black;">一一</span>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;"><span style="color: black;">一一</span>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;">TOP10 <span style="color: black;">精彩导航（回复<span style="color: black;">文案</span>前数字阅读）</span></strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">19 EXCEL在宽带薪酬<span style="color: black;">调节</span>中的应用</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">17 Excel自动到期提醒，狠实用! </span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">14 <span style="color: black;">哪些</span>颠覆你三观的Word<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;">15 Excel技巧大全，接住！</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">11 图解麦肯锡<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;">18 酷炫excel2013体验 </span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">12 Excel自动筛选的9个高级用法 </span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">01 瀑布图，你会用吗？ </span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">03 做<span style="color: black;">报告</span>PPT时，有<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;">04 EXCEL数据有效性——行政人事<span style="color: black;">必须</span> </span></p><span style="color: black;">OFFICE职场训练营</span>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">受欢迎的OFFICE应用分享</strong></p><strong style="color: blue;"><strong style="color: blue;"><span style="color: black;"><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;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">怎样</span>订阅</span></strong></span></strong>
</strong>
<p 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><span style="color: black;"><span style="color: black;">OFFICE</span><span style="color: black;">职场训练营</span></span><span style="color: black;"><span style="color: black;">”</span></span><span style="color: black;"><span style="color: black;">订阅</span></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span 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>
页:
[1]