数据透视表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>它操作简单功能又很大大。今天兰色带<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;">•透视表10大操作技巧</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">•1、按年月组合</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">•2、删除不存在的项目</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">•3、<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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">•5、刷新后列宽保持不变</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;">•7、<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;">•8、生成排名</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">•9、按汇总行排序</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;"><strong style="color: blue;">1、按年月组合</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>。只需要在日期上右键点击组合，再<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 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://q5.itc.cn/q_70/images03/20240716/26d75743b36b433fbcabecca18a507db.gif" 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;">2、删除不存在的项目</strong></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;"><img src="https://q6.itc.cn/q_70/images03/20240716/56446274371246baa8f2feb204340e3b.gif" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">3、<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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="//q1.itc.cn/q_70/images03/20240716/60baec8fdb0e49d29cded58d79d19d38.jpeg" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">4、合并单元格</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>选项中的合并。。选项<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="//q1.itc.cn/q_70/images03/20240716/7b66f5cf8a4041a4a28763f1830b06be.jpeg" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">5、刷新后保持列宽不变</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>列宽选项删除。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://q0.itc.cn/q_70/images03/20240716/3b2d86d822d14d648eb568ff02792373.gif" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">6、<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>透视表-在上面找到透视表分析- <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://q3.itc.cn/q_70/images03/20240716/ad6dc236e53041f4af803172d0546d43.gif" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">7、<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>方式-父行（列）汇总百分比</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://q6.itc.cn/q_70/images03/20240716/37bfc9b1012c43cc9372f95d209e2ea5.gif" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">8、生成排名</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>方式-降序<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="//q1.itc.cn/q_70/images03/20240716/685eef8c2038412bb96049ce75a01904.jpeg" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">9、按汇总行排序</strong></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://q1.itc.cn/q_70/images03/20240716/96fc1aafa3af4645bb5d5ca6045e7e64.gif" style="width: 50%; margin-bottom: 20px;"></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>按内容拆分表格</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>页字段 - 透视表分析- 选项 - <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://q6.itc.cn/q_70/images03/20240716/740812ec9c2842a784a407c67f70c2be.gif" 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 style="color: black;">倘若</span><span style="color: black;">朋友</span>们感兴趣文后点赞，<span style="color: black;">倘若</span>超过500，兰色将分享透视表十大高级技巧，内容更实用。</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><strong style="color: blue;">超</strong><strong style="color: blue;">级透视表，透视表多表、多文件合并</strong>等内容，<span style="color: black;">能够</span>点下面链接购买兰色四合一大全套视频教程，其中<span style="color: black;"><span style="color: black;">包含</span>透视表从入门到精通50集教程，<span style="color: black;">亦</span><span style="color: black;">包含</span>150集函数、185集图表和119集技巧教程</span>。</span><a style="color: black;"><span style="color: black;">返回<span style="color: black;">外链论坛： http://www.fok120.com</span>，查看<span style="color: black;">更加多</span></span></a></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">责任编辑：网友投稿</span></p>
楼主继续加油啊！外链论坛加油！ 你的话语如春风拂面，温暖了我的心房，真的很感谢。
页:
[1]