ikkhksvu 发表于 2024-10-1 17:48:32

Excel必学技巧，1个切片器，掌控多个数据透视表


    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Excel数据透视表，用来分析汇总数据非常强大，结合切片器，<span style="color: black;">能够</span>随时筛选查看<span style="color: black;">区别</span>维度，强强联合</p>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;">1、数据透视表切片器</h1>
    <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>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-axegupay5k/74ff6349bb484c2c9309a44188af97bb~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727978324&amp;x-signature=y4FgxKIbLobRSt2KEg1nzbDUNhk%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <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;">咱们</span>只需要选中任一个单元格数据，<span style="color: black;">而后</span>在<span style="color: black;">插进</span>选项卡下，<span style="color: black;">选取</span>数据透视表：</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">为了方便演示，<span style="color: black;">这儿</span><span style="color: black;">咱们</span>把数据透视表放在H2单元格的位置</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p26-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/8df930bca4204f8187cb523a21f6265d~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727978324&amp;x-signature=oDPyemVc%2FaYEw5whVnknWpIwRIg%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <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;">得到想要的结果：</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/aed2f769dff343498fc89f62043be878~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727978324&amp;x-signature=Ky040IEZVSwKVvKHt2cLs3B%2F9z4%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <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;">倘若</span><span style="color: black;">咱们</span>只是把月份字段放在筛选字段，<span style="color: black;">而后</span>再去选中筛选，那就有点Low了</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/2cfd24703d89434184b1e0302a03f282~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727978324&amp;x-signature=AG3b9jDOC6EZCnjeOYiUVWa4Lts%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">咱们</span><span style="color: black;">能够</span>有更高级的做法，那<span style="color: black;">便是</span><span style="color: black;">运用</span>切片器来筛选：</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">咱们</span>选中数据透视表，<span style="color: black;">而后</span>在分析下，点击<span style="color: black;">插进</span>切片器，<span style="color: black;">而后</span><span style="color: black;">选取</span>月份</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/bb19c0815963473fadd0baa237204e0f~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727978324&amp;x-signature=QStL6TrS86kXoQYjCc7mQT4GSe0%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">这个时候，就会筛选一个筛选按纽，点到哪里，数据就会自动的变动，更方便筛选和呈现结果</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/05938744973746c08f7ada3bd0bb7d8e~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727978324&amp;x-signature=d1hR6R9McAnS1SJwVj1cVL3bcqk%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;">2、切片器的联动</h1>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">这个时候，老板又提出了一个<span style="color: black;">需要</span>，他还想<span style="color: black;">晓得</span>各区域的<span style="color: black;">营销</span>数量和金额<span style="color: black;">状况</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">那样</span><span style="color: black;">咱们</span><span style="color: black;">一样</span>的操作，<span style="color: black;">能够</span><span style="color: black;">插进</span>数据透视表</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">只<span style="color: black;">不外</span>这个时候，行标签，放入的是区域，<span style="color: black;">一样</span>将数量和金额放在值里面，得到如下的结果：</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/5a8edd0dcf214a2fbad0050af396fe0e~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727978324&amp;x-signature=1VBhF%2BQ3HZuKh6r4RAjcjeuYUh0%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">然则</span>，这个时候，<span style="color: black;">咱们</span>之前创建的切片器，点击之后，它只会<span style="color: black;">掌控</span><span style="color: black;">第1</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>对应月份的数据：</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/cc7ca8a2e125452285d7cc2354417089~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727978324&amp;x-signature=JpZmb1Sj9T8Fu2JloQeY%2B%2BSuz8M%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">倘若</span><span style="color: black;">咱们</span>想一个切片器，<span style="color: black;">同期</span>筛选这两个数据透视表的内容</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">咱们</span>只需要选中切片器，<span style="color: black;">而后</span>在上方<span style="color: black;">选取</span>报表连接，<span style="color: black;">而后</span><span style="color: black;">选取</span>第2个数据透视表</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/d9f5dcbe676a4df8a07c464c07b0b962~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727978324&amp;x-signature=2Umgd6%2BGKgAjjOCsziivJ1BF09w%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">经过</span><span style="color: black;">这般</span>连接之后，<span style="color: black;">咱们</span>用一个切片器，就<span style="color: black;">能够</span><span style="color: black;">同期</span><span style="color: black;">掌控</span>两个透视表的数据了：</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/f2afc8e01fb8484fa5da093f7a1dc2b2~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727978324&amp;x-signature=qPKgZOi91okf7hmU%2FRiBbOyVers%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">关于这个小技巧，你学会了么？动手试试吧！</p>




nykek5i 发表于 2024-10-5 08:22:01

一看到楼主的气势，我就觉得楼主同在社区里灌水。

7wu1wm0 发表于 2024-10-15 17:36:53

我完全赞同你的观点，思考很有深度。

m5k1umn 发表于 2024-11-9 10:53:18

这夸赞甜到心里，让我感觉温暖无比。

4zhvml8 发表于 7 小时前

祝福你、祝你幸福、早日实现等。
页: [1]
查看完整版本: Excel必学技巧，1个切片器，掌控多个数据透视表