Excel数据透视表，筛选之王切片器，3个小技巧-外链论坛

6hz7vif 发表于 2024-10-1 17:49:36

Excel数据透视表，筛选之王切片器，3个小技巧

<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>
<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>选中数据区域，<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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-axegupay5k/0e30eed7d5ae49cf953a91cbaa725292~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727978693&x-signature=ICvu%2FFUn4hXsB0M6wNdphYc6H10%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><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/1ccf44b29ce54de886c0e216bd170443~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727978693&x-signature=qkM6c8OHfH9tnxYdLCD7sBoBPSk%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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/3a249cb1bcdb4922a10cb612cebbf0df~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727978693&x-signature=uPwr8alxzGba%2B1wBbRkCYhswLpM%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>按住CTRL键，<span style="color: black;">而后</span>再单选想要的月份，就<span style="color: black;">能够</span>进行多选了</p>
<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>的项目比较多，需要进行多列展示出来</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>对应的列数</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>4列时，它的<span style="color: black;">摆列</span>方式就变<span style="color: black;">成为了</span>4列</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/29075855b70f4502921623a898f8f470~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727978693&x-signature=F%2BeI1BVBuD%2FF%2FJOV5s6w7XkRXSk%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">3、切片器<span style="color: black;">次序</span>问题</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>是从10月，11月，12月<span style="color: black;">起始</span>的<span style="color: black;">而后</span>再是1月，它默认的排序规则是按文本首字母来排的</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>是1月，2月，3月...正常下来到12月的</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;">咱们</span>找到Excel选项，找到高级，找到最底下的，编辑自定义列表</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/260f68e6276147d481fc192805bb263f~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727978693&x-signature=rWCUiOIh649ff8HSfhPLKXcVfew%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>列表</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/a1cdc97059924d609f26bfe99eda2b95~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727978693&x-signature=ADPr9XykZY2jPxvS5ZpYrvgF7rY%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><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://p26-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/72863d0f2abb4308a87561802866822c~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727978693&x-signature=XPTfRYqyKBRsUyCZTbXykM3ZCOY%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;">
   <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;"><img src="https://p3.toutiaoimg.com/large/pgc-image/15566074939218e441b3ae5" style="width: 50%; margin-bottom: 20px;">
               <div style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">专栏</span></div>
            </div>
            <div style="color: black; text-align: left; margin-bottom: 10px;">
               <div style="color: black; text-align: left; margin-bottom: 10px;">Excel数据透视表视频教程</div>
               <div style="color: black; text-align: left; margin-bottom: 10px;">作者：Excel自学成才</div>
               <div style="color: black; text-align: left; margin-bottom: 10px;">
                     <div style="color: black; text-align: left; margin-bottom: 10px;">29.9币</div>
                     <div style="color: black; text-align: left; margin-bottom: 10px;">1,024人已购</div>
               </div>
               <div style="color: black; text-align: left; margin-bottom: 10px;">查看</div>
            </div>
         </div>
   </div>
</div>

4lqedz 发表于 2024-10-21 10:03:43

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

页: [1]

外链论坛's Archiver

Excel数据透视表，筛选之王切片器，3个小技巧