Excel教程：数据透视表中常用的5个小技巧
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/XVayrImXFrNLgYP93SiczibW2ibu2fibd6Via7NYQv1XTOh7Uib6zs4abehXSiamECXF5QWzgY5IBpQhic5MqGgo5oSjpQ/640?wx_fmt=gif&wxfrom=5&wx_lazy=1&tp=webp" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_png/bePCGbRich1E0WNKTSF0wICRHBmuy34VYeBmEAeXJQN9kQzh6YHxQZ5mlWyPcMIrMRF6gxW7XRP60lr3vJl7Aiaw/640?wx_fmt=png&from=appmsg&wxfrom=5&wx_lazy=1&wx_co=1&tp=webp" style="width: 50%; margin-bottom: 20px;"></a></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 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></p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">插进</span>数据透视表</span></strong></h1>
<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>先来学习一下<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 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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/XVayrImXFrNse3DKFl35GwgxvVGYvo7TCILJbVicCYc84YlBibwLBqibotRH2qdBIbB6d3TQSmN1KVvF17fKfFBNg/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></p><strong style="color: blue;"><span style="color: black;">年龄<span style="color: black;">根据</span>间隔3岁统计区间占比</span></strong>
<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><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 style="color: black;">插进</span>数据透视表后的值字段拖动演示。<span style="color: black;">咱们</span><span style="color: black;">能够</span>将年龄字段拖动至行标签，<span style="color: black;">而后</span>分别拖动年龄字段两次到值标签，并且将值字段中的自动求和更改为计数，回到数据透视表的数据中，选中行标签的年龄数据，鼠标右键组合，<span style="color: black;">咱们</span>将步长更改为3确定，接着将计数的年龄字段中的一个更改为总计百分比<span style="color: black;">就可</span>。</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_gif/XVayrImXFrNse3DKFl35GwgxvVGYvo7T5wYJFhMib9Hday8umem1tE7nZ74twfDJeeiaibQqZUnM4M6osTiaKibGx5w/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">表示</span>各<span style="color: black;">分部</span>的数据</span></strong></h1>
<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>跟普通表格<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 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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/XVayrImXFrNse3DKFl35GwgxvVGYvo7Tk35ERruktvQs5AC3Yiawlx9PErXS4Z2o7UbxsOurkf4Ow1pPgciaNfBA/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><strong style="color: blue;"><span style="color: black;">统计各<span style="color: black;">分部</span>学历分布</span></strong></h1>
<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><span style="color: black;">分部</span>的学历数据，<span style="color: black;">咱们</span>只需要分别将<span style="color: black;">分部</span>字段拖动行标签，学历拖动列标签，和值字段（计数）<span style="color: black;">就可</span>实现。简单的拖动几下比函数统计快多了。</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_gif/XVayrImXFrNse3DKFl35GwgxvVGYvo7TibL0fhueOpFkpvmpvzaf0CWOd1D0LY5sJhzFvukhqJVWtSYtl7AfysQ/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">根据</span>年份统计<span style="color: black;">分部</span>入职人数</span></strong></h1>
<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><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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/XVayrImXFrNse3DKFl35GwgxvVGYvo7Tj2DfoicmkzEo331icRXHYwRUtue2sHUDFbwfpCE55qMyslo9DzWMw2Jw/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/gC0ymMIMUyEIdH7wShyXeFke9MkyDz8uOkYwfia7zaWkh1C0UPSibO9mJbDNJBaTaibdIJjBiawBonf3T6BLp4rVOw/640?wx_fmt=png&from=appmsg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=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/sz_mmbiz_png/bePCGbRich1E0WNKTSF0wICRHBmuy34VYeZBg49eW4OBN8pSRNvjemjq1h6Hd2HX6yib6iceUm74BWTWnN9oJJgZQ/640?wx_fmt=png&from=appmsg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=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/sz_mmbiz_png/bePCGbRich1E0WNKTSF0wICRHBmuy34VYn0R0X3F7GFRZSm1e7Da4V6DpPvgSUTxia4Sgib65Y345FDI6eXhNCoPQ/640?wx_fmt=png&from=appmsg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=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/sz_mmbiz_png/bePCGbRich1E0WNKTSF0wICRHBmuy34VYjibT1yuxWM3lOibxE6pX1mYdSYZia2iapHXurduQbw4RBB942ThFf8kgSQ/640?wx_fmt=png&from=appmsg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=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_gif/0jZ2JWHnNSlcJ8Y7GkHCPjrDJITwmtI8iaUHOft6Ez8licKpk2YrLrtz89RZHWpebo5E9guekDbJNHibWBY35xfYw/640?wx_fmt=gif&wxfrom=5&wx_lazy=1&tp=webp" style="width: 50%; margin-bottom: 20px;"><strong style="color: blue;">如果还有什么需要咨询的，联系<span style="color: black;">微X</span>客服18074746783</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><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/sz_mmbiz_png/bePCGbRich1GXRE1YeOr3zQjYyaH5Q9B6Jwq25D1dWAPwSc0RVZFHCq9mX8L5MppkEbDKD3iaShZkudT9FFTC9fw/640?wx_fmt=png&wxfrom=5&wx_lazy=1&wx_co=1&tp=webp" 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_gif/XVayrImXFrOJKwvDg8o6XkaMLSCqp9nia2x0EmTJavf1ORsQbRr3GDicoCuib6y0gAYhic1glSgDjYmcX1Dz7xkZXA/640?wx_fmt=gif&wxfrom=5&wx_lazy=1&tp=webp" style="width: 50%; margin-bottom: 20px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">点击阅读原文<span style="color: black;"><strong style="color: blue;"><span style="color: black;">一键登录官网，海量视频vip任意学！(可试看)</span></strong></span></span></strong></span></p>
“沙发”（SF，第一个回帖的人） 软文发布论坛开幕式圆满成功。 http://www.fok120.com
页:
[1]