Excel教程：一学就会的数据透视图
<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;">微X</span>扫码观看全套Excel、Word、PPT视频</strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"><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;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMwB2CMISauYufg1DG3oNjj5RQKALIgnfgesEwicF85FgNBQOBnbfbotH9RicYgJEKpKEcubHxCiciayog/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>学习excel动态图表，详见</span><a style="color: black;">《试用期就破格升职加薪？这位95后做的excel图表遭<span style="color: black;">揭发</span>……》</a><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>excel动态图表，已汇成口诀：</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></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></p>
<p 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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">上次武林盟主<span style="color: black;">运用</span>的是“<strong style="color: blue;">数据验证配公式</strong>”大法，今日老衲传授的系“<strong style="color: blue;">切片器加透视表</strong>”大法。废话少说，请施主先<span style="color: black;">瞧瞧</span>GIF操作吧。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/k6kCsib3eJMz1uibTveN1uvdKibEV4e7g1pBxpRVYwHST9vvo1QGdSAlsS5GZjVEyplvc2Lqj57zhsEycQJwJcyxA/640?tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">配套的练习课件请到QQ群：537870165下载</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>式：<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;">数据透视表是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;">选中A2：G8单元格，<span style="color: black;">插进</span>—数据透视表，在创建数据透视表窗口中，“表/区域”的范围即<span style="color: black;">刚才</span>选中的单元格A2：G8，直接点击确定。</span></p><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz1uibTveN1uvdKibEV4e7g1pZ7Z8yvMZ3Ru93MvMDF34GNIJuhp1zXj4SXkFQeYCLazZn8iallvNhqQ/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzX4WKVhfQ6upOZDQfIaydOBib1Q3GK9hsTdKOBvRiaVHV5ICAupPiclqHicIdfmWxT4Ve7ibhTazdicHWw/640?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>应该对数据源（即A2：G8单元格）进行整理，<span style="color: black;">通常</span>数据源的<span style="color: black;">需求</span>为：<span style="color: black;">第1</span><span style="color: black;">行径</span>表头，表头字段<span style="color: black;">不可</span>空白和重复，不要合并单元格。<span style="color: black;">倘若</span>数据源不符合以上<span style="color: black;">需求</span>，点击确认后就会弹出以下窗口</span></p><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz1uibTveN1uvdKibEV4e7g1pWhaFdLk8JWN1Lg8M48V1EIYD1eyezdRzqkLiaichxW5hPf6KfE8Yp7vQ/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">插进</span>透视表后，工作簿会新建一个工作表Sheet1</span></p><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz1uibTveN1uvdKibEV4e7g1pdFs3rc0fPQHibT7aHO0yayxibQOxbcfDj9cLrapw8hzLolT4A5O9Aezg/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">第二式：设置字段列表</span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">首要</span>在“数据透视表字段列表”中<span style="color: black;">选取</span>字段，将<span style="color: black;">区别</span>字段拖入拖动到<span style="color: black;">区别</span>区域。</span></p><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz1uibTveN1uvdKibEV4e7g1p4Zq7yd6ibRusLhHkJ1Y8lKVYFIMeewZjyakkYzau8umBHskiaSOThN2Q/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">上图中，“报表筛选”、“列标签”、“行标签”、“数值”四个<span style="color: black;">区别</span>的区域，在生成的“透视表”中<span style="color: black;">表现</span>在<span style="color: black;">区别</span>的区域内，<span style="color: black;">每一个</span>区域又<span style="color: black;">能够</span>设置字段，“透视表”还可设置<span style="color: black;">归类</span>汇总及布局等等，其中招式老衲或许<span style="color: black;">能够</span>讲上九九八十一天，<span style="color: black;">因为</span>今天<span style="color: black;">大众</span>要修炼的是动态图表，故对此不详细分析。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">此时生成的“透视表”如下</span></p><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz1uibTveN1uvdKibEV4e7g1pO9yPHEMpyb7fUtMeQeRAcKv9VGAYobnIau4gsymgN9wiauJ9Da616XA/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">第三式：生成数据透视图</span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">数据透视表工具—选项—数据透视图</span></p><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz1uibTveN1uvdKibEV4e7g1pMsNWZtWuW2lHS5qkQ6qx6njWhzFwOAEtZlFD7Vk2mqg13llmSibog1g/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">插进</span>图标—柱形图—确定</span></p><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz1uibTveN1uvdKibEV4e7g1pPZue995Bp0yIo0DNHH2FTfRAH76IOicVzma3FFiaxZk3HEianSM4YjkmA/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">自动生成的“数据透视图”如下图：</span></p><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz1uibTveN1uvdKibEV4e7g1p4vsTKyNHUbc2wYRjbjc94JorG0nTOGgQAEre1wmHPzlAKbHZrl78sw/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">左侧即是<span style="color: black;">咱们</span>需要的“excel动态图表”，右侧则是用于筛选的窗格。各位看官都认为这个图表丑出了新高度，老衲自然又要使出“乱花渐欲迷人眼”招式对丑陋的图表进行整容。（</span><span style="color: black;"><span style="color: black;">重视</span>：office版本<span style="color: black;">区别</span>，操作存在<span style="color: black;">必定</span>差异，<span style="color: black;">尤其</span>是office2013版本<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>的office升级到2010版本以上，<span style="color: black;">仅有</span>善于接收新秘籍，<span style="color: black;">才可</span><span style="color: black;">作为</span>绝世<span style="color: black;">能手</span></span><span style="color: black;">）</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><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>好多“求和项”，老衲看着实为不爽，但直接设置属性又修改不了，奈何？</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月”修改为“1月”，点击确定，施主会<span style="color: black;">发掘</span>“数据透视图”的“行标签”<span style="color: black;">亦</span>自动更新了。</span></p><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz1uibTveN1uvdKibEV4e7g1pzN4PHIb3pK3kFk0DbLic7sNTet407C6FMEtCkAwboeGIEGfx9XFhXsQ/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">第二步：套用格式</strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">其实office2013<span style="color: black;">起始</span>，软件自带模板比90%的施主设计的都美观，<span style="color: black;">针对</span><span style="color: black;">需求</span>不高的施主<span style="color: black;">来讲</span>，在用好模板的<span style="color: black;">基本</span>上适当修改，不失为一种<span style="color: black;">加强</span>修炼效率的好<span style="color: black;">办法</span>。</span></p><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz1uibTveN1uvdKibEV4e7g1pr5Pdxc3cIRER3hzJE15RskUB9TKs9CYtE792QjOuRSJ5fuqDnOqPOw/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">老衲<span style="color: black;">这里</span>透露一个修炼技巧，excel中，“Ctrl+1”组合键应该是最值得<span style="color: black;">运用</span>的快捷键，用于弹出“单元格设置”、“属性设置”等之类的窗口，总之，几乎你找不到的设置功能，<span style="color: black;">经过</span>按“Ctrl+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;">选取</span>纵坐标按“Ctrl+1”调出设置窗口，<span style="color: black;">此刻</span><span style="color: black;">咱们</span>对<span style="color: black;">运用</span>模版后的图表进行简单<span style="color: black;">调节</span>。</span></p><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz1uibTveN1uvdKibEV4e7g1pXXf4TqlO5P0y83qWVkgZsdPXJGHAezdduz3v0IoeY6Xgx41N4F78rw/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">调节</span>效果如下：</span></p><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz1uibTveN1uvdKibEV4e7g1po6moeHCktd5SyicOZnn2pU0tQQ6H3zbPlBsAlUGwdP0DUKP8DuDjK9w/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">第三步：调出字段按钮</strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">此处excel2013版本作了比<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><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz1uibTveN1uvdKibEV4e7g1pmc1GiaQbDGaRbqEgvn4tFeWT7fmVHJhiaMtzXXoB0V11NEmb0ONa6egg/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">效果如下：</span></p><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz1uibTveN1uvdKibEV4e7g1pg7J0bfV2dOw6ibbQE5shHU3cTIyOLNNzYqyiciaXhEZKIuPIa27Nlr9Yw/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">其实，学习office秘籍的一个技巧<span style="color: black;">便是</span>，<span style="color: black;">每一个</span>按钮都去点点，<span style="color: black;">瞧瞧</span>它是干<span style="color: black;">吗</span>用的，反正操作自己的office不犯罪，各位施主<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="https://mmbiz.qpic.cn/mmbiz_gif/k6kCsib3eJMz1uibTveN1uvdKibEV4e7g1pXoqjkKQruPiaWicjavQxGaBUP8195JSX2uOt0YlWV66Jlmyibb9sR7aCQ/640?tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">无论是用“公式”还是“透视表”制作动态图表，都有一个<span style="color: black;">一起</span>特点：修改数据源，图表会自动更新。<span style="color: black;">不外</span>透视表需要在修改数据源后，在透视表中单击鼠标右键—刷新。</span></p><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz1uibTveN1uvdKibEV4e7g1pVibX9T5kpgPiacGDf4QZRKLFHBZ3DdDgNAiboMJIEDUcQIqjzmvQL53Aw/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">第四式：百变星君的透视表</span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">经过</span>以上三式，施主或许对此法的<span style="color: black;">方便</span>性感受不深。其实，只需拖动字段，透视表<span style="color: black;">能够</span>从多维度展示<span style="color: black;">归类</span>汇总效果。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">话说，武林盟主某日兴起，欲<span style="color: black;">认识</span>3月份各大侠弑杀魔教人数。<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;">第1</span>步：设置“数据透视表字段列表”</span></p><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz1uibTveN1uvdKibEV4e7g1pFrJqrxicSYq7tCFauYx82FBvFdU1akO5yaiaMSicl7LSEM8wpGEcpO1iaw/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">第二步：<span style="color: black;">插进</span>“数据透视图”<span style="color: black;">就可</span>。</span></p><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMz1uibTveN1uvdKibEV4e7g1pSiaITicpZWxloXTj64lLgYibo3ibhban3E0KRCANibkJ7MSy5RsA1Z6HyHQ/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">只需两步，就能达到盟<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动态图表入门已修炼成功，能够击败90%的江湖人士。然而，动态图表招式繁多，练就途径不拘一格，现施主只走了百步中的一步，<span style="color: black;">想要</span><span style="color: black;">作为</span>绝世<span style="color: black;">能手</span>，请继续关注老衲接下来的修炼。</span></p><strong style="color: blue;"><span style="color: black;">热文<span style="color: black;">举荐</span></span></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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;"><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;"></span></a></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;"><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;"></span></a></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;"><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;"></span></a></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">想要全面系统学习Excel，不妨关注《<span style="color: black;">1星期</span>Excel直通车》视频课<span style="color: black;">或</span>《Excel极速贯通班》。</span></strong></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>Excel直通车》</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></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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">最实用接地气的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;">《<span style="color: black;">1星期</span>Excel直通车》</span></strong></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;">风趣易懂，快速<span style="color: black;">有效</span>，</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">带您7天学会Excel</span></strong></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;">38 </strong></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;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">（已更新完毕，可永久学习）</span></strong></span></strong></span></strong></span></strong></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></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;">主讲老师： 滴答</span></strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">Excel技术大神，资深培训师；</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">课程粉丝100万+；</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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"> 《Excel极速贯通班》。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">原价299元</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;"><strong style="color: blue;"><span style="color: black;">99</span></strong></span></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></p>
<p 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></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;"> 长按下面二维码立即购买学习</span></strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">购课后，加客服<span style="color: black;">微X</span>：blwjymx3领取练习课件</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">让工作提速百倍的「Excel极速贯通班」</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">↓ 点击<span style="color: black;"><strong style="color: blue;"><span style="color: black;">阅读原文</span></strong></span>，可直接购买。</span></p>
你的努力一定会被看见，相信自己，加油。
页:
[1]