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>一个问题：在E</span><span style="color: black;">xcel</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>先来看一下数据。如下图所示，A列中的数据为员工姓名，B列中的数据为员工所在的<span style="color: black;">分部</span>，C列中的数据为员工的加班时长。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMxGX59wvshmlGTic46hibO7UKaJjqibD8ia8EnreRV7h1K8ibnFwibAMEAzWZJT16rRNuwaCtwwOosmalww/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">QQ群：427726848，下载练习课件</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 style="color: black;">第1</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;">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;"><span style="color: black;"><span style="color: black;">首要</span>，单击A</span><span style="color: black;">1:C16</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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMxGX59wvshmlGTic46hibO7UKzlyqjWBKE1ibOSxFCGE306iaXqiaaefYibwYdWtv6tpjQamKQRyMwuM34w/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">点击“确定”后，<span style="color: black;">能够</span>看到，在第B3、B9、B1</span><span style="color: black;">3</span><span style="color: black;">、B1</span><span style="color: black;">8</span><span style="color: black;">单元格中，<span style="color: black;">显现</span>了“市场部</span><span style="color: black;">汇总”、“行政部</span><span style="color: black;">汇总”、“财务部 汇总”、“企划部 汇总”；在C</span><span style="color: black;">3</span><span style="color: black;">、C</span><span style="color: black;">9</span><span style="color: black;">、C</span><span style="color: black;">13</span><span style="color: black;">、C</span><span style="color: black;">18</span><span style="color: black;">单元格中，<span style="color: black;">显现</span>了各<span style="color: black;">分部</span>的加班时长总和。<span style="color: black;">同期</span>，在B</span><span style="color: black;">2</span><span style="color: black;">和C</span><span style="color: black;">2</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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMxGX59wvshmlGTic46hibO7UKWGZ8CLrTP1wKO2oibTN1RvYyesg0dunmrmltsfuvGRzn0vzbmAZDzUQ/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">接下来，整理表格。依次点击“数据”-“取消组合”-“清除分级<span 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>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMxGX59wvshmlGTic46hibO7UKKCyX9ks7icicQsMMXhrNI9dz4GxxI7swc3Z19VlbJlam8xHqgpbBb4zg/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">大众</span><span style="color: black;">能够</span>看到，A</span><span style="color: black;">2</span><span style="color: black;">、A</span><span style="color: black;">8</span><span style="color: black;">、A</span><span style="color: black;">12</span><span style="color: black;">、A</span><span style="color: black;">17</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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">step</span><span style="color: black;">.1</span><span style="color: black;"><span style="color: black;">大众</span>选中A</span><span style="color: black;">1:A20</span><span style="color: black;">区域，按下C</span><span style="color: black;">trl+</span><span style="color: black;">G，弹出“定位”对话框，<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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMxGX59wvshmlGTic46hibO7UKYgDII5YPYNQXZxNHfSNsY2gfTwDvIFTuTXIhXHoOLWG9uia3SbiaUQaQ/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">Step.</span><span style="color: black;">2点击“确定”后，A</span><span style="color: black;">2</span><span style="color: black;">、A</span><span style="color: black;">8</span><span style="color: black;">、A</span><span style="color: black;">12</span><span style="color: black;">、A</span><span style="color: black;">17</span><span style="color: black;">这四个空单元格即被选中（ A</span><span style="color: black;">2</span><span style="color: black;">的颜色为白色，<span style="color: black;">暗示</span>当前所在的单元格为A</span><span style="color: black;">2</span><span style="color: black;">）。保持A</span><span style="color: black;">2</span><span style="color: black;">、A</span><span style="color: black;">8</span><span style="color: black;">、A</span><span style="color: black;">12</span><span style="color: black;">、A</span><span style="color: black;">17</span><span style="color: black;">的选中状态不变，直接输入“</span><span style="color: black;">=B3</span><span style="color: black;">”,<span style="color: black;">而后</span>按“C</span><span style="color: black;">trl+</span><span style="color: black;">回车”键，<span style="color: black;">此时</span>公式就批量填充到A</span><span style="color: black;">2</span><span style="color: black;">、A</span><span style="color: black;">8</span><span style="color: black;">、A</span><span style="color: black;">12</span><span style="color: black;">、A</span><span style="color: black;">17</span><span style="color: black;">，这些单元格中的公式分别变<span style="color: black;">成为了</span>“=</span><span style="color: black;">B3</span><span style="color: black;">”、“=</span><span style="color: black;">B9</span><span style="color: black;">”、“=</span><span style="color: black;">B13</span><span style="color: black;">”、“=</span><span style="color: black;">B18</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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMxGX59wvshmlGTic46hibO7UKDDOkhR7nt0Pq677dYE92A4b5JJpbBbNh9TwtHQN0PMySwgA9Ww9fyA/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">这儿</span>，解释一下批量填充的<span style="color: black;">规律</span>。在A</span><span style="color: black;">2</span><span style="color: black;">中，<span style="color: black;">大众</span>输入的是“=</span><span style="color: black;">B3</span><span style="color: black;">”，<span style="color: black;">因为</span><span style="color: black;">运用</span>的是相对引用，<span style="color: black;">因此</span>，A</span><span style="color: black;">2</span><span style="color: black;">单元格引用的是B</span><span style="color: black;">3</span><span style="color: black;">的数据，<span style="color: black;">因此</span>以此类推，A</span><span style="color: black;">8</span><span style="color: black;">单元格引用的是B9的数据……</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>可能还有一点好奇：C</span><span style="color: black;">2</span><span style="color: black;">、C</span><span style="color: black;">8</span><span style="color: black;">、C</span><span style="color: black;">12</span><span style="color: black;">、C</span><span style="color: black;">17</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;">以C</span><span style="color: black;">8</span><span style="color: black;">单元格为例，查看一下就<span style="color: black;">晓得</span>啦！如下图所示，C</span><span style="color: black;">8</span><span style="color: black;">中的公式为“</span><span style="color: black;">=SUBTOTAL(9,C9:C11)</span><span style="color: black;">”。咱们公众号以前的<span style="color: black;">文案</span>里面，有讲过S</span><span style="color: black;">UBTOTAL</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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMxGX59wvshmlGTic46hibO7UKzyibt7ZeRD9h8g5yWEm6BrxGxo2klE0zicBFBblIJV6Xvq1icvQyjDibUg/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">办法</span><span style="color: black;">2、</span>借助</span><span style="color: black;">SUMIF</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><span style="color: black;">SUMIF</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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">1.</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>，选中B列，点击鼠标右键，<span style="color: black;">选取</span>“<span style="color: black;">插进</span>”，在“姓名”和“<span style="color: black;">分部</span>”之间会<span style="color: black;">插进</span>一个空白列，选中C</span><span style="color: black;">2:C16</span><span style="color: black;">，将其复制并粘贴到B</span><span style="color: black;">3:B17</span><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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMxGX59wvshmlGTic46hibO7UKKibfBo69dJJDIPBgodyEYlKS9xQbnW96EBcCVam7c6RHTLZ5X2F21icQ/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">选中B</span><span style="color: black;">2:C16</span><span style="color: black;">，</span><span style="color: black;">按下“C</span><span style="color: black;">trl+\”</span><span style="color: black;">键，则可选中</span><span style="color: black;">B2:C16</span><span style="color: black;">区域中同一行中内容有差异的单元格</span><span style="color: black;">，结果如下图所示，可见，C</span><span style="color: black;">2</span><span style="color: black;">、C</span><span style="color: black;">7</span><span style="color: black;">、C</span><span style="color: black;">10</span><span style="color: black;">、C</span><span style="color: black;">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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMxGX59wvshmlGTic46hibO7UKXLEoXTvY9aj8q7Qr8eNC7rzfUvH1nK7USknPcW8YL6VbuHY98nAZNw/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">此刻</span>，把鼠标放在C</span><span style="color: black;">2</span><span style="color: black;">单元格，点击鼠标右键，依次<span style="color: black;">选取</span>“<span style="color: black;">插进</span>”-“整行”-“确定”，<span style="color: black;">就可</span>在C</span><span style="color: black;">2</span><span style="color: black;">、C</span><span style="color: black;">7</span><span style="color: black;">、C</span><span style="color: black;">10</span><span style="color: black;">、C</span><span style="color: black;">14</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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMxGX59wvshmlGTic46hibO7UKItiac9CuAJ1ILK6jKRgzUXTmU9V0mQJo8wpHuQZqY5DNmHGH3yTicaXw/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">此时，<span style="color: black;">大众</span>将B列（新添加的辅助列）删掉<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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMxGX59wvshmlGTic46hibO7UKFLYFiaZfwBiaeeh2NZwibzdicKlVrFHESRL4oRQic05XiaKEK3RFWhQBUyTA/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">2</span><span style="color: black;">.</span><span style="color: black;">利用S</span><span style="color: black;">UMIF</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;">选中C</span><span style="color: black;">2:C20</span><span style="color: black;">区域，按下“C</span><span style="color: black;">trl+G”</span><span style="color: black;">键，依次<span style="color: black;">选取</span>“定位<span style="color: black;">要求</span>”-“空值”-“确定”，<span style="color: black;">就可</span>批量选中空白的单元格；输入“=</span><span style="color: black;"> SUMIF(B:B,B3,C:C)</span><span style="color: black;">”,</span><span style="color: black;"><span style="color: black;">而后</span>按下“C</span><span style="color: black;">trl+</span><span style="color: black;">回车”键，<span style="color: black;">就可</span>将公式批量填充到C</span><span style="color: black;">2</span><span style="color: black;">、C</span><span style="color: black;">8</span><span style="color: black;">、C</span><span style="color: black;">12</span><span style="color: black;">、C</span><span style="color: black;">17</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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMxGX59wvshmlGTic46hibO7UK5RJnHdLXBxualtSwMFjFGjjD0Jar52v1ViaibJIIiaQAvkn18JqJJibONA/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">这儿</span>是</span><span style="color: black;">SUMIF</span><span style="color: black;">按<span style="color: black;">要求</span>求和公式，其中<span style="color: black;">运用</span>的是相对引用。在经过批量填充，S</span><span style="color: black;">UMIF</span><span style="color: black;">函数的第二参数在C</span><span style="color: black;">2</span><span style="color: black;">、</span><span style="color: black;">C8</span><span style="color: black;">、</span><span style="color: black;">C12</span><span style="color: black;">、</span><span style="color: black;">C17</span><span style="color: black;">中分别变<span style="color: black;">成为了</span>B</span><span style="color: black;">3</span><span style="color: black;">、B</span><span style="color: black;">9</span><span style="color: black;">、B</span><span style="color: black;">13</span><span style="color: black;">、B</span><span style="color: black;">18</span><span style="color: black;">，即对应“市场部”、“行政部”、“财务部”、“企划部”，<span style="color: black;">因此</span>，</span><span style="color: black;">SUMIF</span><span style="color: black;">函数的意思<span style="color: black;">便是</span>对B列中<span style="color: black;">分部</span>为“市场部”、“行政部”、“财务部”、“企划部”的数据，在C列中对应的位置求和。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">3</span><span style="color: black;">.</span><span style="color: black;">进一步完善表格，对A、B两列中的空白单元格进行批量填充</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">选中A</span><span style="color: black;">2:A20</span><span style="color: black;">，按下“C</span><span style="color: black;">trl+G”</span><span style="color: black;">键，依次点击“定位<span style="color: black;">要求</span>”-“空值”-“确定”，输入“</span><span style="color: black;">=B3</span><span style="color: black;">”，<span style="color: black;">而后</span>按下“C</span><span style="color: black;">trl+</span><span style="color: black;">回车”键；选中B</span><span style="color: black;">2:</span><span style="color: black;">B</span><span style="color: black;">20</span><span style="color: black;">，按下“C</span><span style="color: black;">trl+G”</span><span style="color: black;">键，依次点击“定位<span style="color: black;">要求</span>”-“空值”-“确定”，输入“</span><span style="color: black;">=B3&" 汇总"</span><span style="color: black;">”，<span style="color: black;">而后</span>按下“C</span><span style="color: black;">trl+</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>得到的结果，如下图所示。（第二行可再细调一下文字格式和对齐方式，此处略。）</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMxGX59wvshmlGTic46hibO7UKEL8aTxHOUNfCYNgHTGRg0pibBHUgAia0d0UZpDNqRtd11tSNnpcibwtAA/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">好了，今天的教程很初级，但<span style="color: black;">亦</span>是<span style="color: black;">非常多</span>人在问的问题，你学会了吗？</span></p>扫一扫添加老师<span style="color: black;">微X</span>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMxQ9pBIatL1ibJlCLo0nVJm4qoSaeaTzVBkrNicUM6YzgFAcbWavRhkE5MBL5UfAWancWibQxibml2hxg/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;">扫一扫，在线咨询Excel课程</span></p><img src="https://mmbiz.qpic.cn/mmbiz_png/b96CibCt70iabwjyojLhA03PtxUnkNPREnYMIXQoTgtW6libdMibQVNic3eZhU08VyWfSQWdI82zIYSzSTq4Y3YV9nQ/640?wx_fmt=png&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;">Excel教程<span style="color: black;">关联</span><span style="color: black;">举荐</span></strong></p><a style="color: black;"><span style="color: black;">一个复制粘贴的问题，竟然难倒了90%的Excel人（速学秒会）</span></a><a style="color: black;"><span style="color: black;">“我面试了几十个大学生，<span style="color: black;">发掘</span><span style="color: black;">她们</span>竟然还在用分列法拆分数据，难怪效率<span style="color: black;">那样</span>低……”</span></a><a style="color: black;"><span style="color: black;">天天都用Excel排序，却被新同事的排序技巧“碾压”了？</span></a><a style="color: black;"><span style="color: black;">这才是老板们想要的excel图表，你做</span></a>的太low了！
<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></span></strong><strong style="color: blue;"><span style="color: black;">Excel直通车》视频课<span style="color: black;">或</span>《Excel极速贯通班》</span></strong><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;"><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;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">9</span></strong></span></strong>9</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]