区间数据的快速统计汇总，无比这个更好的办法，实用且简单易学
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-axegupay5k/0efaffe534874522a25b1f61f18f374e~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727956282&x-signature=MnF5NaB%2Bgcrct7swbb3KR10r3zg%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 style="color: black;"><span style="color: black;">大众</span>好，欢迎来到无非课堂，我是无非~</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;">在<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>用Vlookup函数与数据透视表等功能都<span style="color: black;">能够</span>实现。在一众<span style="color: black;">办法</span>中，无疑数据透视表是最<span style="color: black;">明显</span>的，真的是又快又好。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/e49eeddbfaed44698f4bcaebf5224977~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727956282&x-signature=tzdlwjXR8MbhpFHLh2KqWWcBemg%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 style="color: black;">无非老师分享一个用数据透视表来实现工资表区间人数的统计案例，赶紧学起来吧！</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;">如下图所示的工资表，</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/220362c57e4f4f3aaa06ccf82dc35262~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727956282&x-signature=4%2FYTL8rZeg8fJlJCw6sCB1B3Bk0%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 style="color: black;"><span style="color: black;">需求</span>统计出<span style="color: black;">区别</span>区间工资的人数，得到如下图所示的效果。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/6f25d9dcc10042649bb26f3f0161a68a~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727956282&x-signature=V39W2%2FEFPUtgBtQc%2FW3XjKzpIvc%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 style="color: black;"><span style="color: black;">详细</span><span style="color: black;">过程</span>如下：</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.如下图所示，选定数据区域任一单元格，按快捷键Ctrl+A选定所有数据单元格区域；</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/88ea252b97c749059149fcdc02f55b48~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727956282&x-signature=GTIOLHNj%2Fb%2BYXJKsSf%2F6CQIwC10%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 style="color: black;">2.如下图所示，<span style="color: black;">选取</span>“<span style="color: black;">插进</span>”选项卡，<span style="color: black;">选取</span>“表格”组里的“数据透视表”，<span style="color: black;">选取</span>“表格或区域”；</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/19c94e5a79e34f31b9cc46713ad53df7~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727956282&x-signature=ErXu7PXqjzn0VmFFf%2BhBbfmaieQ%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 style="color: black;">3.如下图所示，在弹出的”来自表格或区域的数据透视表“对话框中确认”表/区域“准确（若不准确可重新<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></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/e1f312272f934da0a2fd2d59806a444e~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727956282&x-signature=G5FZUtoHgq8WG8g7nre7SG3T%2BAg%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 style="color: black;">4.如下图所示，在”数据透视表字段“窗格中，将”合计“字段拖放至”行“和”值“框里；</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/11f422498220429f958d99571e2269a2~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727956282&x-signature=I70lHkormBS2t9TRqzM4Ebh1clM%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 style="color: black;">5.如下图所示，选定”行标签“中任一单元格，<span style="color: black;">选取</span>”数据“选项卡，<span style="color: black;">选取</span>”分级<span style="color: black;">表示</span>“组里的”组合“，在下拉菜单中<span style="color: black;">选取</span>”组合“；</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/54114dad2967405eb7d4f260ad2d1213~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727956282&x-signature=AQj4iqD4jpJ%2F8MB6%2BBX%2FmH31%2FIU%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 style="color: black;">6.如下图所示，在打开的”组合“对话框中设置”<span style="color: black;">初始</span>“、”终止“、”步长“的值（<span style="color: black;">按照</span>源数据决定，默认会<span style="color: black;">表示</span>数据区域的最小值与最大值），单击”确定“按钮；</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/6c89fc3e396942fb94220aab962ff607~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727956282&x-signature=A4ohYug0CEa671RfQHAjw95thGE%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 style="color: black;">7.如下图所示，选定”求和项：合计“中任一单元格，在其上右击，在弹出的快捷菜单中<span style="color: black;">选取</span>“值汇总方式”，<span style="color: black;">选取</span>“计数”；</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/5f60542d544c4b51886fefc8f8117a3f~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727956282&x-signature=VG8b98yWUyMEIDY2Ltsn0t9B9Z0%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 style="color: black;">8.如下图所示，修改透视表的”行标签“为”工资“，”求和项：合计“为”人数“，添加标题”工资区间统计表“，设置合适的表格框线、字体字号、行高列宽等格式；</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/12bcea122ce84f90884f3cbaf61dd218~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727956282&x-signature=t8tS6j%2FecdWmFeKOZAFY9A6TrWI%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 style="color: black;">9.如下图所示，选定表格数据区域（标题与总计行除外），<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></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/66582c1edf644ff8a83eff52296bd252~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727956282&x-signature=m44yP14XJcamCvwRwGrn5yKk1Ag%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 style="color: black;">10.如下图所示，删除图例，<span style="color: black;">隐匿</span>图表上的坐标轴字段按钮和值字段按钮，修改标题为“工资区间统计图”并设置合适格式，删除垂直轴<span style="color: black;">重点</span>网格线，应用样式5，修改数据标签位置和颜色，大功告成。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/2cd338d24b0d4747add1a32b0aeac6b8~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727956282&x-signature=MWHMfTr0orzjOH3zGYZUW43bPcs%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 style="color: black;">无非提示:数据透视表不愧是个神器，简单几步，就<span style="color: black;">容易</span>实现了数据区间统计，绝对是区间统计中最好用的<span style="color: black;">办法</span>，<span style="color: black;">无</span>之一，你学会了吗？</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;">觉得有用请点“赞”和“在看”、<span style="color: black;">保藏</span>，转发分享给自己备份一份，<span style="color: black;">以避免</span>以后需要用时找不到哦！</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/038337be415a436ab027d909d087b3b7~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727956282&x-signature=Jivyeh7CvYKUp9MFYXMhgH%2FWsf8%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 style="color: black;">配套案例素材文件：SAE098_快速区间统计.xlsx，关注"无非课堂（ID:nothingbutcourse）后回复“1111”获取，有任何疑问或有更好的<span style="color: black;">办法</span>，请在下方评论区留言交流~~</span></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">零<span style="color: black;">基本</span>快速入门到精通请点击：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;">
<div style="color: black; text-align: left; margin-bottom: 10px;">
<div style="color: black; text-align: left; margin-bottom: 10px;">
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/f0aefc479252447d8df1a615c56fef77~noop.image?x-expires=2020377154&x-signature=QGZtZM706gzw3YgQkfFVOTlt0qY%3D" style="width: 50%; margin-bottom: 20px;">
<div style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">专栏</span></div>
</div>
<div style="color: black; text-align: left; margin-bottom: 10px;">
<div style="color: black; text-align: left; margin-bottom: 10px;">Excel零<span style="color: black;">基本</span>速成</div>
<div style="color: black; text-align: left; margin-bottom: 10px;">作者：无非Excel</div>
<div style="color: black; text-align: left; margin-bottom: 10px;">
<div style="color: black; text-align: left; margin-bottom: 10px;">99币</div>
<div style="color: black; text-align: left; margin-bottom: 10px;">13人已购</div>
</div>
<div style="color: black; text-align: left; margin-bottom: 10px;">查看</div>
</div>
</div>
</div>
</div>
你字句如珍珠，我珍藏这份情。
页:
[1]