Excel 公式教程——数据透视表2
<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;">第1</span>个教程中，<span style="color: black;">咱们</span>介绍了数据透视表的概念。</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 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/c1fd0b8d22454cb9bb8ff58a0dbffb03~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958568&x-signature=g3Kv%2BjobgTK8abd7cHJDIbuiT3g%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/6eeaf701b3c94fdb8d1478f0c47ea2bf~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958568&x-signature=wvr8%2BKZjm%2BG9qF6hwNsNFt02%2Fcs%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/f506d8114ccf4f1eb85ca377c070bbf0~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958568&x-signature=nVZQG2cM%2FhNLa4RUjrm5d4glfug%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 style="color: black;">经过</span>为“类型”添加</span></strong><strong style="color: blue;"><span style="color: black;">列字段</span></strong><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 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/6a51e203848147248f71e428460bce3e~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958568&x-signature=t2qV80ZCYOGYcWgIktyCl2J47aI%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 style="color: black;">不方便</span>于理解，请尝试：</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/26c9de025a1e4cd9bf0ade053f647622~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958568&x-signature=8AOZLUO%2FrcutvsNHWn5b1aOwUF0%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></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/9046e7122fae4436a41c37e9ea05891a~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958568&x-signature=1qhEoKV55RgJL%2F%2BuD5yxR0kk3jM%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/277aa13748bc4566b455a2c0b4fe2e3a~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958568&x-signature=xBWcPVd5lcOaFQvmwZ%2FP8mhq2RM%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 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/42e5dd45788a4ef1b8bed1f9c4fbf1b4~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958568&x-signature=3eHittg6XHho%2FBQxc4dlcdHWf2Y%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 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/8cf6e23b68af40b090999cb5b449b4d2~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958568&x-signature=mIQemqcGU9ulc4iNjObUw6aa3oI%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 style="color: black;">能够</span><span style="color: black;">这般</span>想。</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 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/ca38637b9c3b409a9962c87cb1e8b9f1~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958568&x-signature=STlI3%2BpIC7RsRhfYvneTUOb%2Br9g%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 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/74272cc146af4532a3d819bbbb4f77a8~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958568&x-signature=Ilx9rfKD9nFk%2Fa1R%2F%2Bloecj2QqE%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;">第1</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/94636d05740242879c3450f8f2aa44ae~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958568&x-signature=PP9b1itCmRMRFQrTcbQdGudUoCU%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><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/0014bcd117f34dec907e35c38f8172bb~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958568&x-signature=GvEOF78fPu2uYKILLGRYuXar89I%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/a8a7f46b49524e4baf10b0696a2dcd50~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958568&x-signature=XocfeCX5xrz7LoqIz%2B5cfFBu79g%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/533c42a85e8948a19ef72cdcdeac339f~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958568&x-signature=cb53BDkXPpVC9TyexyVPtz3qw8Y%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></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/767d54803d7b4e6793bad3510a3220e2~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958568&x-signature=9FYVfu0wEOYrcBezy%2B%2B1ctShKHQ%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></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/5325bdf6eecf4ba6a1b28ab70ec6368a~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958568&x-signature=9WWzjGoZ4itlT6cj%2B%2F34KYdLTkw%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/c51f036798e54d9f9e70dc7824af2455~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958568&x-signature=8IpPYyzQ9IahUF%2FU%2FOLcw9Pi49E%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></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/5529c703d2274ae7ba7d27c1f8c86dbf~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958568&x-signature=szGI%2Bse2fHFRByQuaFk6hrP7C0Q%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/57977e49bf93479499df64df87ea054c~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958568&x-signature=8AvARrsLJyZ6EP%2BZynwsu3z2Jsc%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/560d3af5f9424cd7880cebeac9f8851d~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958568&x-signature=Zhk%2B%2FzN4tG9C4OLeqNDVL5b9DyU%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/1e1cd84e526545bba08eceed1ebb7d88~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958568&x-signature=GSCS6MwFZjv5FGp3LKMmFgg96Ng%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/1c23c0853a554f03a666621e19244d0e~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958568&x-signature=BEyOi3r3oqymgSK0HAsKa2IPpyM%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/f3e33ef125ce4f4d8e9601fda5a7d8d8~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727958568&x-signature=np0D4xYpG%2BIv%2FnxIY5PmqHJyq4M%3D" style="width: 50%; margin-bottom: 20px;"></div>
感谢你的精彩评论，带给我新的思考角度。 你的留言真是温暖如春，让我感受到了无尽的支持与鼓励。
页:
[1]