Excel教程:用数据透视表进行求和
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/a3jzy4ibVheH4jDsy3MdeBHfm7n1P4j2jW1y8SxjMv99aXJamyzBc0Rs8x3wDef1ZWV57QOYibgTMV0HDM5LsUkw/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" 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 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 style="color: black;">状况</span>。<span style="color: black;">怎样</span>用</span><span style="color: black;">EXCEL来快速得到这些结果信息呢?</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;">1、</span>提取多表不重复值</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">有3个表,需要把不重复的<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://mmbiz.qpic.cn/mmbiz/4jUToJBtQvTMvJytDWgbmJK9kw7rU8PhjKIYJibxJx29j3v05XhbXnakS8DzJqxxmoibXvYxYBwdWTXjhJzhRv0w/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" 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;">注</strong>:按<span style="color: black;">alt</span>+<span style="color: black;">d</span><span style="color: black;">而后</span>快速按<span style="color: black;">p </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;">2、</span>合并同类项</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>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz/4jUToJBtQvTMvJytDWgbmJK9kw7rU8PhdR7MvM6O5S9S6mVRILQy5rs0Odmf4UBmxbSSoAy3yEJibetRohyVhcw/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" 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 style="color: black;">3、</span> 自动批量创建表格</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>吗?NO!数据透视表又来了!</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz/4jUToJBtQvTMvJytDWgbmJK9kw7rU8Ph9WuGENncqfVIcX08GE7nOibQlSSCdYJHbKAKLtkGPuveAAhauBqfFZw/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/a3jzy4ibVheFBGOyvr0DKJiaIUE63QliaviaS1EUhQ33n9ic6Hybotde6sSuBsVFuAKybEZO2Qxt8YIiaWFOVZAL3alw/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
期待楼主的下一次分享!” 一看到楼主的气势,我就觉得楼主同在社区里灌水。 说得好啊!我在外链论坛打滚这么多年,所谓阅人无数,就算没有见过猪走路,也总明白猪肉是啥味道的。 太棒了、厉害、为你打call、点赞、非常精彩等。
页:
[1]