论坛 › 浙江 › 这种比Excel数据透视表还好用的分组汇总功能，你晓得吗？

4zhvml8 发表于 2024-10-1 10:02:31

这种比Excel数据透视表还好用的分组汇总功能，你晓得吗？

    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">点击下方&nbsp;↓&nbsp;关注，<span style="color: black;">每日</span>免费看Excel专业教程</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">置顶公众号</strong><span style="color: black;">或</span><strong style="color: blue;">设为星标 ↑&nbsp;</strong><span style="color: black;"><span style="color: black;">才可</span><span style="color: black;">每日</span><span style="color: black;">即时</span>收到推送</span></p><span style="color: black;">个人<span style="color: black;">微X</span>号 | （ID：LiRuiExcel520）</span><span style="color: black;"><span style="color: black;">微X</span>服务号&nbsp;|&nbsp;跟李锐学Excel（ID：LiRuiExcel）</span><span style="color: black;"><span style="color: black;">微X</span>公众号&nbsp;| Excel函数与公式（ID：ExcelLiRui）</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>归类统计，分组汇总，<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></p>
    <p 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="https://mmbiz.qpic.cn/mmbiz_png/QhrwhO5yJrH4H8QJyaNCowrsC7nIliaFOojIT9II6NPDv5NibRexx021eiaVcyFsDjkGIT9TR62qp6mVj4Rclh1CQ/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">今天要介绍的<span style="color: black;">办法</span><span style="color: black;">不仅</span><span style="color: black;">能够</span>自动<span style="color: black;">归类</span>汇总，还兼容以下几种<span style="color: black;">状况</span>：</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 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>先自己思考1分钟，再从下文去看给出的<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;"><strong style="color: blue;">本教程内容担心记不全的话，<span style="color: black;">能够</span>分享到<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>Excel技能，少走弯路的<span style="color: black;">朋友</span>，请</span><span style="color: black;"><strong style="color: blue;">搜索<span style="color: black;">微X</span>公众号“</strong></span><span style="color: black;"><strong style="color: blue;">跟李锐学Excel</strong></span><span style="color: black;"><strong style="color: blue;">”点击底部菜单的“</strong></span><span style="color: black;"><strong style="color: blue;">知识店铺</strong></span><span style="color: black;"><strong style="color: blue;">”或下方扫码进入</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;"><span style="color: black;">更加多</span></span><strong style="color: blue;"><span style="color: black;">区别</span>内容、<span style="color: black;">区别</span>方向</strong><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;">长按识别二维码↓</strong></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="https://mmbiz.qpic.cn/mmbiz_jpg/QhrwhO5yJrG8Cpamocn0ibYY7Rx6kgmcYGa6Mc0B5ulYsNCQo7vTHcHibmxF35MrQKVnaI6YNSs99zQcdyKvV2jA/640?wx_fmt=jpeg&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">（手机<span style="color: black;">微X</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>变动时，结果同步更新的<span style="color: black;">状况</span>。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">当原始记录的金额变动时，如下图所示。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/QhrwhO5yJrH4H8QJyaNCowrsC7nIliaFOWlUpUFz9S3HLzqZ47qQJxYpm9XJtgLddhUj0EAdHebV8pwrKSUia7vw/640?wx_fmt=gif&amp;tp=webp&amp;wxfrom=5&amp;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><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;">将订单4的区域从中山路店改为新华路店，对应的金额<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/QhrwhO5yJrH4H8QJyaNCowrsC7nIliaFOnR0Ew7qs3FicBZiaEtn7aYgrktTELmWGpDZtdcb0Lb3cmgCjJPgwKKDw/640?wx_fmt=gif&amp;tp=webp&amp;wxfrom=5&amp;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><span style="color: black;">，如下图所示。</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/QhrwhO5yJrH4H8QJyaNCowrsC7nIliaFOkkUIibSFTRqJWzmgwNaFpGE1lBck3DfoKdoVD0QwL6ufnicznmoJgAwA/640?wx_fmt=gif&amp;tp=webp&amp;wxfrom=5&amp;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><span style="color: black;">，如下图所示。</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/QhrwhO5yJrH4H8QJyaNCowrsC7nIliaFOmnh0ymy2Bib4ffn9SwlkNcTqfqQBPoywXn7cOwj2cy2SSWdicnn2SYkA/640?wx_fmt=gif&amp;tp=webp&amp;wxfrom=5&amp;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><span style="color: black;">，如下图所示。</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/QhrwhO5yJrH4H8QJyaNCowrsC7nIliaFONqXu4ibziaoiazvV0gdjsYlzcVGKMEIE4nFuibF7W04tm54kuHCBFKWXuQ/640?wx_fmt=gif&amp;tp=webp&amp;wxfrom=5&amp;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>
    <p 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>Power Query工具进行数据转换和处理。</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 2016版以上或Office365版本。用2013或2010的<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;"><strong style="color: blue;"><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></strong><span style="color: black;"><span style="color: black;">（下方有联系方式）</span>。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">下面说说操作<span style="color: black;">过程</span>，<span style="color: black;">首要</span>将数据导入Power Query编辑器。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">单击数据-从表格</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/QhrwhO5yJrH4H8QJyaNCowrsC7nIliaFOGkfuGgnT4MKR8GhXErXia7pRqdNNibR9wUB69qqzACYMnwBASKoHL36w/640?wx_fmt=jpeg&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">而后</span><span style="color: black;">按照</span>你想要的<span style="color: black;">要求</span>进行分组统计。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">本案例<span style="color: black;">需求</span><span style="color: black;">根据</span>区域和<span style="color: black;">途径</span>分组，<span style="color: black;">因此</span>选中这两列，单击分组依据，如下图所示。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/QhrwhO5yJrH4H8QJyaNCowrsC7nIliaFOlkfWiaV0ILlPAFhmia1Cf9lRppmNSbqNcuH0VrwuVRqvwjaDvsYOtEEA/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">添加新列名，对金额按求和统计，如下图所示。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/QhrwhO5yJrH4H8QJyaNCowrsC7nIliaFOAl3ltI2nWtpsEFxWiaMSNfVqicCme6ZrM20lor0dILm1B9wxNLkQgY6g/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;"><span style="color: black;">而后</span>在Power Query编辑器中，按你想要展示的<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;">单击“关闭并上载”，将数据上载到Excel工作表。</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_png/QhrwhO5yJrH4H8QJyaNCowrsC7nIliaFO1BJhw8gDuCdibVJBur7PFaSGeNbwRIwtBhaVYd31MP6XaNr7FYL76zQ/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">这般</span>点几下鼠标，<span style="color: black;">不消</span>1分钟，就实现了数据自动分组汇总。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">这仅仅是Power Query众多强大功能中的一个，不足1%，<span style="color: black;">更加多</span>丰富好用的技能我<span style="color: black;">已然</span>整理为超清视频的PQ初级班，便于你快速学习。</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>涨价。</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><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;"><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_jpg/QhrwhO5yJrE0icKrQzyPzNmVyI3Fq4oqy2Obaib4JDgfCwHhQF3zTbFoF0jcsJroS4M8EszOcFzN706zmhcS0ztw/640?wx_fmt=jpeg&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">下面视频可<span style="color: black;">以避免</span>费试听↓</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">（正式课是超清视频，比这个更加清晰）</span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;">
      <div style="color: black; text-align: left; margin-bottom: 10px;">
            <div style="color: black; text-align: left; margin-bottom: 10px;">
                <div style="color: black; text-align: left; margin-bottom: 10px;">
                  <div style="color: black; text-align: left; margin-bottom: 10px;">
                        <div style="color: black; text-align: left; margin-bottom: 10px;">关闭</div>
                        <div style="color: black; text-align: left; margin-bottom: 10px;"><strong style="color: blue;">观看<span style="color: black;">更加多</span></strong></div>
                        <div style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">更加多</span></div>
                  </div>
                </div>
            </div>
      </div>
      <div style="color: black; text-align: left; margin-bottom: 10px;">
            <div style="color: black; text-align: left; margin-bottom: 10px;">
                <div style="color: black; text-align: left; margin-bottom: 10px;">
                  <div style="color: black; text-align: left; margin-bottom: 10px;">
                        <div style="color: black; text-align: left; margin-bottom: 10px;">退出全屏</div>
                  </div>
                </div>
            </div>
      </div>
      <div style="color: black; text-align: left; margin-bottom: 10px;">
            <div style="color: black; text-align: left; margin-bottom: 10px;">
                <div style="color: black; text-align: left; margin-bottom: 10px;">
                  <div style="color: black; text-align: left; margin-bottom: 10px;">
                        <div style="color: black; text-align: left; margin-bottom: 10px;">
                            <div style="color: black; text-align: left; margin-bottom: 10px;">
                              <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">视频加载失败，请刷新页面再试</p><a style="color: black;"><img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAACIAAAAqCAMAAADhynmdAAAAQlBMVEUAAACcnJycnJycnJyoqKicnJycnJycnJycnJycnJyfn5+cnJydnZ2enp6kpKSdnZ2cnJyenp6cnJycnJycnJybm5t8KrXMAAAAFXRSTlMAyeb3CNp3tJRvHIEtJhBgqztWRJ+p5TqGAAABCklEQVQ4y5WTi27DIAxFAUMhgTzX8/+/urB2pdKI0x0pSoRuruyLbf7gF3PBaDE6X44LyY0D1SJQsfd9PpMM/CJx60v8SmV1HMSi1lKyA1n0jnwWSO08l04uJbxpBmTrpDtbGB6fmxC6Tc4BHv9aZDJdJsHW9w43Jez9x8T5M4l31WZsJn2bsYY+nUum2lQkGIVANPZ4FCLWOJImSTgjZE2SkU9crmu57mj9JBc93Qzj9R1d3HSG5bN5MRsnUzcGKK8Ns02z+Da7rYQE4bUE2PG1C6kVnkCyf0pwX8/jwbyxCLhcHpKTFkvkwK3pRmXtRrVFoTGYLvN+t0EUl0qrRaF1pFBz0anp/ptvNB4SY1XDAVMAAAAASUVORK5CYII=" style="width: 50%; margin-bottom: 20px;"> 刷新 </a>
                            </div><img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADkAAAA5CAMAAAC7xnO3AAAAY1BMVEUAAAD///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////+aRQ2gAAAAIXRSTlMAOx20pMJbzBQNTDGTh2ohLCZmeUF2hEmXCFdxUquef4yHE17nAAACnklEQVRIx9WW2xqiIBSFRc1AUATJU1a+/1MOm0NYKvnNXM260ZLftRcbqCQinOLI0yiY/iXKuUZPjx5Fk+6RhF1yHiVF0wC6IZfr9fqIkpRqdNyQ9AoiUU8g+YZ8Xn96YmNKvkhkLMskKgEo/yJzaxkXeZsGsjeWKEIFU/FBZgA+D5yEwGtTgR0J18lYUvdcLZ1YkUjLf+a0saYYSG/J3Hury+WSkTCjCETtF6Mvd8QGJMZSWIfsAlKhWGRl5zQ1ZNBDgy/zzvvFavWUK7SyTRs+rsiUZS/4LHIHyo8VgBx7vDkKx2WhPS7dD1Q6cNlu2dTa0gMys4bz/vJR6ph8ADgcVcSVUkfnhzJTc6gRj8fbCOHk30UI2KC+V4gKjskJQqC5frFHli0kafogFIfFkAXVCSqdAFVR8pmtVCWiXCtaarbWpGtQAYx7sjf2GCbfjFRQpH7lTLucveSMBE7+Z6VqViT2/PVs0d7hPk9TUcTaUuVaT8k/f/v6SXOgyG7InZaSvM8vj/309LrbvpSAORDH2/kWGyHhm/u5AYUc8qdFBRRrsV749bRv6I5x1OY50GZUUxQz9aGplAXZcOQ1DL3vwsTyvHQ2YWgjZV2rDTmxYRjUuoBvcQDr7QRLBiiNzJ4BawG3FLtTmEMGBigTRyC2oIKht1vbwLWrKmXKBZal+yApDGhm4q5JCVdNdrZeQBe8B44WnE2NGmxrR1bCvMugHdkhSwMWI9wjIGeosnPlJmNrst6PQrpeFkBSyAmkdD016DYqAVC6HHcNtnCPgazcuytAd5IqB/qYtq4bkP7vnEaL3W4KH9/HhKBAKl8XFUlMIWYIek4hZgh6UtjHBLVA4pPkCKRf9jOQ5Kwp1UvPDyb3qkPJaRG8Ln7f8Q8Bki/Kj5IYnQAAAABJRU5ErkJggg==" style="width: 50%; margin-bottom: 20px;">
                        </div>
                  </div>
                </div>
            </div>
      </div>
    </div>
    <div style="color: black; text-align: left; margin-bottom: 10px;">
      <div style="color: black; text-align: left; margin-bottom: 10px;"> <a style="color: black;"> 视频详情 </a> </div>
    </div>
    <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 style="color: blue;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">更加多</span>经典的实战技能，已整理成超清视频的系统课程，方便你系统<span style="color: black;">提高</span>。</strong></span></strong></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;"><strong style="color: blue;">&gt;</strong></span><span style="color: black;"><strong style="color: blue;">&gt;</strong></span></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">举荐</span>阅读</strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">&nbsp;&lt;</span><span style="color: black;">&lt;</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;"><a style="color: black;">VLOOKUP遇到她，瞬间秒成渣！</a></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;">99%的财务会计都会用到的表格转换技术</a></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;">86%的人都撑不到90秒，这条万能公式简直有毒！</a></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;">最有用最常用最</a>实用10种Excel<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;"><a style="color: black;">以一当十：财务中10种最偷懒的Excel批量操作</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;">为何</span>要用Excel数据透视表？这是我见过最好的答案</a></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;">如此精简的公式，却刷新了我对Excel的认知…</a></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;">错把油门当刹车的十大Excel车祸现场，最后一个亮了…</a></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;">让人脑洞大开的VLOOKUP，竟然还有这种操作！</a></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;">Excel动态数据透视表，你会吗？</a></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;">让VLOOKUP如虎添翼的三种扩展用法</a></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;">这个Excel万能公式<span style="color: black;">容易</span>KO四大<span style="color: black;">困难</span>，<span style="color: black;">便是</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;">SUM函数到底有多强大，你真的不<span style="color: black;">晓得</span>！</span></a></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/QhrwhO5yJrE0icKrQzyPzNmVyI3Fq4oqyHK8iatUkia2z6T2fGvNcjES0lBYum8QrweAOCFjqVD2uaibBTOCBwQWPw/640?wx_fmt=jpeg&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">长按识别二维码↓进知识店铺</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></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>有的老学员是4年前购买的课程，因买过的课程较多或因时间久忘记从哪里听课，<span style="color: black;">因此</span>专门将各平台的已购课程入口统一整理至下图。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">1、搜索<span style="color: black;">微X</span>公众号“</span><strong style="color: blue;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;">跟李锐学Excel</strong></span></strong></strong><span style="color: black;">”点击底部菜单“</span><strong style="color: blue;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;">已购课程</strong></span></strong></strong><span style="color: black;">”，<span style="color: black;">就可</span>查看到你在各平台的已购课程，方便<span style="color: black;">大众</span>找到并随时复学课程。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">2、课程分销推广的奖金<span style="color: black;">亦</span><span style="color: black;">是由于</span>此公众号转账至<span style="color: black;">大众</span>的<span style="color: black;">微X</span>钱包（<strong style="color: blue;">关注后可自动收钱，进入你的<span style="color: black;">微X</span>零钱，在<span style="color: black;">微X</span>支付有转账记录</strong>），老学员<span style="color: black;">能够</span>进“</span><strong style="color: blue;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;">知识店铺</strong></span></strong></strong><span style="color: black;">”点击底部按钮“</span><strong style="color: blue;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;">推广<span style="color: black;">挣钱</span></strong></span></strong></strong><span style="color: black;">”<span style="color: black;">或</span>“</span><strong style="color: blue;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;">我的</strong></span></strong></strong><span style="color: black;">”-“</span><strong style="color: blue;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;">推广中心</strong></span></strong></strong><span style="color: black;">”<span style="color: black;">查找</span>到推广奖励明细记录，支持主动</span><strong style="color: blue;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;">提现</strong></span></strong></strong><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>留言反馈，助手在24小时内回给到回复。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">按上图↑识别二维码，查看详情</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">请把这个公众号<span style="color: black;">举荐</span>给你的<span style="color: black;">伴侣</span>：）</span></p>
    <p 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;"><span style="color: black;">更加多</span>干货<span style="color: black;">文案</span>加下方小助手查看。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">倘若</span>你<span style="color: black;">爱好</span>这篇<span style="color: black;">文案</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">欢迎点个</span><span style="color: black;"><strong style="color: blue;">在看</strong></span><span style="color: black;">，分享转发到<span style="color: black;">伴侣</span>圈</span></p><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 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;"><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></p>
    <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>公众号（ExcelLiRui），<span style="color: black;">每日</span>有干货</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">关注后</span><span style="color: black;"><strong style="color: blue;">置顶公众号</strong></span><span style="color: black;">或</span><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;">再<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;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">关注后<span style="color: black;">每日</span>都<span style="color: black;">能够</span>收到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;">举荐</span>给你的<span style="color: black;">伴侣</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">↓↓↓点击</span><span style="color: black;"><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;"><strong style="color: blue;">&nbsp; &nbsp; &nbsp;全面、专业、系统<span style="color: black;">提高</span>Excel实战技能</strong></span></p>

m5k1umn 发表于 2024-11-13 22:30:28

这篇文章真的让我受益匪浅，外链发布感谢分享！

查看完整版本: 这种比Excel数据透视表还好用的分组汇总功能，你晓得吗？