把握数据透视表的10个有效操作技巧
<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>它操作简单功能又很大大。今天<span style="color: black;">博主</span>带<span style="color: black;">大众</span><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;">•透视表10大操作技巧</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>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">•2、删除不存在的项目</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;">•3、<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;">•4、合并单元格</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;">•5、刷新后列宽保持不变</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;">•6、<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;">•7、<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;">•8、生成排名</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;">•9、按汇总行排序</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;">•10、按内容拆分成多个表格</span></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 style="color: black;">表示</span>。只需要在日期上右键点击组合，再<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;">注：<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></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-axegupay5k/0744d52d2d9c44eaba3c356d73fb6992~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950026&x-signature=0kYc5wP9%2Fwgv7Eu8S2IAigPgr3k%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;"><strong style="color: blue;"><span style="color: black;">2、删除不存在的项目</span></strong><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></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/6bb7875c59e246d3ac4c571a45f5aff3~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950026&x-signature=QARXWEpKAmfJDSBEityb8EXBYUY%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;"><strong style="color: blue;"><span style="color: black;">3、<span style="color: black;">表示</span>最大、小值</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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/dc29a83ba46a47a68c2a669e02d27956~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950026&x-signature=HubBD962zIatveAocl21IOjdhvY%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;"><strong style="color: blue;"><span style="color: black;">4、合并单元格</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 style="color: black;">经过</span>选项中的合并。。选项<span style="color: black;">能够</span>把行字段合并单元格。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/3b3006f0a2744ffbbf6d2c75ef169991~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950026&x-signature=LPBggqshwNn430CYO1OWbi0%2FIx0%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;"><strong style="color: blue;"><span style="color: black;">5、刷新后保持列宽不变</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 style="color: black;">调节</span>列宽选项删除。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/0ab868b6490b470b94ed981a666e21f5~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950026&x-signature=6zcZfsbCGh4W4MlHo%2BQNe3sAi5k%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;"><strong style="color: blue;"><span style="color: black;">6、<span style="color: black;">插进</span>切片器</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 style="color: black;">选择</span>透视表-在上面找到透视表分析- <span style="color: black;">插进</span>切片器</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/e0ecc83d7fc34f8da30744caaaedeaf6~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950026&x-signature=cbLG2x5wMtPElnWMXrg0Cyvqc0s%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;"><strong style="color: blue;"><span style="color: black;">7、<span style="color: black;">表示</span>占比</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 style="color: black;">表示</span>方式-父行（列）汇总百分比</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/50a3690dd7ad4c3fa3460e5d9087428a~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950026&x-signature=tDiAvrBsK1mjTwf4AeEctxEKdtk%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;"><strong style="color: blue;"><span style="color: black;">8、生成排名</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 style="color: black;">表示</span>方式-降序<span style="color: black;">摆列</span></span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/a1e1877661b347d7a9522040f5870ff2~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950026&x-signature=imyhv65ykYm47abCOFP989uDg58%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;"><strong style="color: blue;"><span style="color: black;">9、按汇总行排序</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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p26-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/9e39dbb844ab4dc0af90c37fd7d7e260~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950026&x-signature=sH5huZMbuU2HJcFT%2FLEBz%2BnmvJk%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;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">十、</span>按内容拆分表格</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 style="color: black;">选择</span>页字段 - 透视表分析- 选项 - <span style="color: black;">表示</span>报表筛选页</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/c24a0912c3be4901ae5e8cf4feae5346~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950026&x-signature=%2F74f2jLj5kXErRdeWq%2FWUhQgmvw%3D" style="width: 50%; margin-bottom: 20px;"></div>
楼主继续加油啊！外链论坛加油！ 你的话语如春风拂面，让我心生暖意。 大势所趋，用于讽刺一些制作目的就是为了跟风玩梗，博取眼球的作品。
页:
[1]