Excel 公式教程——数据透视表1
<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><span style="color: black;">在最基本的数据透视表形式中，数据透视表获取数据并进行汇总，<span style="color: black;">这般</span>人们能够<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-axegupay5k/c9bb3eeef4a44b47b7473f007534edca~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958557&x-signature=l3VbsEfYNENLl8oUtlB7C6rY0P0%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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><span style="color: black;">这有一个更<span style="color: black;">繁杂</span>的。它<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/3db84549c37540c6a969379fb4cb5089~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958557&x-signature=sovE4KZzI3HGdq%2F6ygf3JjKLVSQ%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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><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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/14e5c2ec239f464a80e5af706227e978~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958557&x-signature=IUrIJxmIjCiHJL8kUlXjidVNXQE%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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><span style="color: black;">要制成好的数据透视表，先要<span style="color: black;">保证</span>数据的良好恰当。<span style="color: black;">因此呢</span>在创建前<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/440dc65d61e8472d81ea53a445228f49~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958557&x-signature=D2hoClxG2bzoiaMILbjPMFtWaUg%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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><span style="color: black;"><span style="color: black;">非常多</span>人会用</span><span style="color: black;">“列”这个词。</span><span style="color: black;">但对数据透视表<span style="color: black;">来讲</span>，列<span style="color: black;">便是</span>一个</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/80aee8ed34dd47c98bdd26339d5c68be~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958557&x-signature=F01y9zITrQ6NAs3dfaYOX3jTKTI%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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>重点看一个字段。</span></strong><span style="color: black;">下面的一个字段 </span><span style="color: black;">-</span><span style="color: black;">“金额”</span><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/ac34e62e022348f3bb843b8395473cdc~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958557&x-signature=cj%2Fv4XwPT05YdpWIDaVFXZ%2FgBYA%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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>做到了。</span></strong><span style="color: black;"><span style="color: black;">咱们</span>用数据透视表对</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;">“¥834”</span><span style="color: black;">构<span style="color: black;">成为了</span>一张小的数据透视表，将</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/21439d50c56f44818e47bad6e0378bff~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958557&x-signature=%2FUZ2L3%2BvZLYVseLz3rcS6mSkYqE%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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>制作如此小的数据透视表？</span></strong><span style="color: black;"><span style="color: black;">由于</span>它强调了数据透视表</span><span style="color: black;">值字段</span><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 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/034c534244d94db6878b7cdfb09124ce~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958557&x-signature=Jrz6bjXcc0tJgXjIV%2FQi0UgkkiE%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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>时。</span></strong><span style="color: black;">本例中，<span style="color: black;">咱们</span>添加了新的<span style="color: black;">要求</span></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/e5ace91580394b51b64bcfb5755ca296~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958557&x-signature=LbAx0jIsLQkyG%2BMSw0PFuVVXeDo%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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><span style="color: black;">这次<span style="color: black;">咱们</span>添加的<span style="color: black;">要求</span>是</span><span style="color: black;">“类型”</span><span style="color: black;">，</span><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/449fd5b0380f4c2ab9fa1d4087a648f4~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958557&x-signature=nIf26YLduR5%2FqlakCh4wmHkwzBk%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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><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 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/a196e4ea96004c23a9be2bf641819fdf~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958557&x-signature=3UbzkOaaMqOhLpyy8ar9k%2Bn0Kek%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/94305a2c4b974d1982cb8aebef22c7f2~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958557&x-signature=npe%2FFQuTb50DV3g7038eJgk9H6M%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/a32712f3a3ee42a498fde3dedf00f76e~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958557&x-signature=G29tEb7CxAQLjfyggpXctoA4uN0%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/aaea8ef0f7d2408a973399338fa5ceb0~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958557&x-signature=mdMk%2FqKeN03c4GXTl2Svrc2GLV4%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/b7dde08e2ed049c9a4414cf82e6d3a5c~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958557&x-signature=emPaz6L8LpTiCWiMIFOmd4BDU6E%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/57a17fc2602847239c4abc4d53c3a92a~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958557&x-signature=1ReoWS%2FHrwMjstKwW2vKdJT9GeU%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/94012916f40942a3ac651b3c4beefc6a~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958557&x-signature=5CewFgIggOERkPHYSV4hBsk3lYw%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/aa4aee64eafb4ed58a81cffe119e6b7d~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958557&x-signature=6WWs506avVKFj570oXM%2Bmol0Kwo%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/8d694e7e77bb4979843e67d3947b4722~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958557&x-signature=hLkAAfbuvScuLQYrEOuQxjzt3iU%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/e131f92c3a1942929157c87d9e1523a0~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958557&x-signature=QPnXVoESYjunArynOFycn7TXSFg%3D" style="width: 50%; margin-bottom: 20px;"></div>
我完全同意你的看法，期待我们能深入探讨这个问题。 你的见解真是独到，让我受益匪浅。
页:
[1]