Excel数据透视表，分时段计算，1分钟学会
<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-axegupay5k/4302d053b9224ed1b6a8f7f09044d8e8~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727960905&x-signature=aubMm3pL1G2eYJedWju2dGYnL58%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">1、透视表分析，分小时段</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>数据透视表</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/2ff1274eb326474db9821d65e5b96ec9~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727960905&x-signature=n0lIvwQL%2Fsn44XpMQQ%2BHmhV1Pv8%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/d08dcfc6cf29486482a67d2cb5678e9c~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727960905&x-signature=rC4KGUgw3%2BUUwmNehsDAyKZcguo%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>下，Excel会自动的帮你列出来<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 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/463d0002f2c64916bf3cc3baf61d0aa7~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727960905&x-signature=QpCdo%2FBS2NDy1Tdr8wflqQWSK1w%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">2、每4小时统计</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>你每4个小时出单<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>一个时间对应表，时间段列出来，<span style="color: black;">而后</span>前面的数字，分别为<span style="color: black;">起始</span>的时间点除以24</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">因此</span>是0/24，4/24，8/24，12/24，以些类推</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/48eb6cd460ea463baed37a881b270cd9~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727960905&x-signature=5ganKLeEnqJ2%2FfH4%2BLlv5pOb7%2Bg%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>mod(a2,1)，获取时间部分，<span style="color: black;">而后</span><span style="color: black;">经过</span>vlookup模糊<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/19771772da9f4b9db49366f5c7ef0ddb~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727960905&x-signature=TY7TyHd0lQdgGBAXU8p%2FzA2bcY0%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>数据透视表，将商品放在列，将时间段放在行，将金额放在值，得到如下数据</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p26-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/7b65fdf655d94fc2b5fefd31d4a5abad~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727960905&x-signature=ESowVpKuW4pMEdJSEfS0xoBrdA0%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/9bdb2e8818284a589242b76f2dd41566~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727960905&x-signature=DFOhn%2FAHA9QvlqY4b3je7IJ5R34%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">关于这个小技巧， 你学会了么？动手试试吧！</p>
期待你更多的精彩评论，一起交流学习。 你的话语真是温暖如春，让我心生感激。
页:
[1]