1分钟学会，数据透视表，3个厉害技巧-天涯论坛

4lqedz 发表于 2024-10-1 08:06:09

1分钟学会，数据透视表，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>神器，今天分享数据透视表3个小细节</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">1、禁用GETPIVOTDATE公式</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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p26-sign.toutiaoimg.com/tos-cn-i-axegupay5k/f7ecfa06c38a463a9b696ac38ff05dbb~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727949768&x-signature=%2BwuUKt9Z1oPew3yN6pW0%2Fxz%2BCBk%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>将地区和商品字段放在了行标签，将数量和金额放在了值，得到了如下的结果：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/d29637baa0ff4e229ef74c17152d7a0f~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727949768&x-signature=RfssK1ZrYfgjjzkbOMV15r%2F6Gho%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;">第1</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/d48ffcf6b18a4e1a9ed253ff7c8a235b~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727949768&x-signature=tA%2F6OikvzomWWxwZ%2FCoNM1QVfPU%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>数据透视表默认是启用GETPIVOTDATE公式来计算的，<span style="color: black;">咱们</span>需要在选项中，取消勾选<span style="color: black;">运用</span>GETPIVOTDATE函数</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/874e4203e66d4e63ae957b316bdafee1~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727949768&x-signature=F9ty5%2BJtFVwuZJeK3awPzWwViMc%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/f121ebe7f98e46cea5e0e877c6e9430f~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727949768&x-signature=taFXyRLW8BXnYyotPugtx0z4vWc%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">2、以表格形式<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></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p6-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/6db42aa2ddc8443ca584a096244ba7a5~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727949768&x-signature=6WQYPPv47MBj2ylPXLR6mjey%2F%2Bw%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>
<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/c7c0299c27584eb8a8764c5206f28fb1~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727949768&x-signature=4TupSOL9Kf80h%2FcIKrfW9nY2Pcc%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">3、切片器按纽</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>选中数据透视表，<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/40d6b92c202d43d789acbc32bf90f14c~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727949768&x-signature=A331k2wa9QJtsBYv71vnMHzWAL0%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>快速的完成筛选数据</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/205485b2843248deb21523c15e124c36~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727949768&x-signature=7FD6toUVFRWPhoWJBdlAkGn3CrY%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/9b891b6fae4045b086b09159adbc663d~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727949768&x-signature=NLfRMNZMtrRZ1Dsol%2FOJyEbh3zg%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">关于这3个小技巧，你学会了么？动手试试吧！</p>

7wu1wm0 发表于 2024-10-15 17:30:58

你的见解真是独到，让我受益匪浅。

qzmjef 发表于 2024-11-6 04:56:32

外贸B2B平台有哪些？

m5k1umn 发表于 2024-11-6 15:27:18

说得好啊！我在外链论坛打滚这么多年，所谓阅人无数，就算没有见过猪走路，也总明白猪肉是啥味道的。

页: [1]

天涯论坛's Archiver

1分钟学会，数据透视表，3个厉害技巧