Excel运用技巧▏数据透视表
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">Excel<span style="color: black;">运用</span>技巧▏数据透视表</strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">认识数据透视表</strong></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_png/t4x9gniadCgrQBibEBOTj07gicjwIib8t9qYmlkWGZziavK5fgv4gJJ0S7DjMkGJE4xtfLf3ybTyRCic4FZZeTjS3NQw/640?wx_fmt=png&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;">数据透视表（Pivot Table）是一种交互式的表，<span style="color: black;">能够</span>进行某些计算，如求和与计数等。所进行的计算与数据跟数据透视表中的<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>动态地改变它们的版面<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>更新数据透视表。——百度</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">数据透视表的<span style="color: black;">功效</span></strong></span></p><img src="https://mmbiz.qpic.cn/mmbiz_png/t4x9gniadCgrQBibEBOTj07gicjwIib8t9qY2tSqhb5pzIQOI4g65tIZy5m4Z2RBOr345ALNeuQJjI6C0whjibofUwg/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/t4x9gniadCgrQBibEBOTj07gicjwIib8t9qYull7Kks48DJNdhzOYm3ia3OPPBsCe3UlhC0Ah9IRsExCKMktoJhQZsA/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">no.1 </span></strong></p><span style="color: black;">数据透视表是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>想要看到的汇总统计和计算内容，是不是很神奇？<img src="https://mmbiz.qpic.cn/mmbiz_gif/t4x9gniadCgrQBibEBOTj07gicjwIib8t9qYj7X027NTicYvq00Mqj5EwFDFhs2wibhf8Z7LVKnKlHiaeicFJyZKhWrsyw/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></span>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">no.2 </span></strong></p><span style="color: black;"><span style="color: black;">强大的筛选功能吧，<span style="color: black;">倘若</span><span style="color: black;">针对</span>一张很大的</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>二组数，瞬间将SUMIF,COUNTIF（S）退下有么有？<img src="https://mmbiz.qpic.cn/mmbiz_gif/t4x9gniadCgrQBibEBOTj07gicjwIib8t9qYlBBlicmxk11uQt0Ko3biakIIrWoibNwiaiclm8iatqjA8GO52zzodPzDlgMA/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></span></span>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">※※※</span></strong></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>几乎涵盖了Excel中大部分的用途，无论是图表、排序、筛选、计算、函数等等，<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;"><span style="color: black;">数据透视表能够将筛选、排序和</span><span style="color: black;">归类</span>汇总<span style="color: black;">等操作依次完成，并生成汇总表格，是Excel 强大</span>数据处理<span style="color: black;">能力的<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;"><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;"><strong style="color: blue;">数据透视表的<span style="color: black;">运用</span></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;">点击选项卡功能区<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>新建工作表），点击确定<strong style="color: blue;"><span style="color: black;">↓↓↓</span></strong></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/t4x9gniadCgrQBibEBOTj07gicjwIib8t9qYTlX76fM1moCz5dibxdemo6pxCOia5H0IclYjRBbXYqenDcbhJqw7jWpQ/640?wx_fmt=png&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;">初步生成数据透视表，拖曳字段<strong style="color: blue;"><span style="color: black;">↓↓↓</span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"> <img src="https://mmbiz.qpic.cn/mmbiz_png/t4x9gniadCgrQBibEBOTj07gicjwIib8t9qYr8E75lGGotv6r3rWDibHic2G9hrR2xLPmGGSTYRjY0Thj38fZR5oJHNA/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></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_png/t4x9gniadCgrQBibEBOTj07gicjwIib8t9qYs86p0pZq9CFSicDg3gynmICt90fHSd8FrEKSkboaCOIlkTpxd4ErEiag/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/t4x9gniadCgrQBibEBOTj07gicjwIib8t9qYs86p0pZq9CFSicDg3gynmICt90fHSd8FrEKSkboaCOIlkTpxd4ErEiag/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/t4x9gniadCgrQBibEBOTj07gicjwIib8t9qYs86p0pZq9CFSicDg3gynmICt90fHSd8FrEKSkboaCOIlkTpxd4ErEiag/640?wx_fmt=gif&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_png/t4x9gniadCgrQBibEBOTj07gicjwIib8t9qYv5q18MoYH5cokTemuKGPAjC9g3O0PzFQdT3ib7DiaEJWIDiazdPia0jEMg/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">，在【<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;"><strong style="color: blue;"><span style="color: black;">↓↓↓</span></strong></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_jpg/t4x9gniadCgrQBibEBOTj07gicjwIib8t9qYIUcr0JDlMZhia0bvF7kszkjZ5hyU7UDu7g96k6JCoFNsAxWKqLjRKFA/640?wx_fmt=jpeg&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_jpg/t4x9gniadCgrQBibEBOTj07gicjwIib8t9qYBEvOIaIHEVp4HuRnHamdgYtgXZuiciauO8lP3Pf4bVYLZKZSzHHL4Evg/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">将鼠标放至数值求和项会有<span style="color: black;">更加多</span>惊喜哦<img src="https://mmbiz.qpic.cn/mmbiz_png/t4x9gniadCgrQBibEBOTj07gicjwIib8t9qYj0jHLexd6r62g8F4eume6f43x40LCJBtKwPIqu7TPdhGyd8OQRibPvg/640?wx_fmt=gif&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_png/t4x9gniadCgrQBibEBOTj07gicjwIib8t9qYHTYiccZa28oSBuFPEv4YFR21IjRrPOWgtkibBtn2KEwfBeVjWRrtgicLw/640?wx_fmt=png&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;"><span style="color: black;">总之，只要<span style="color: black;">基本</span>数据完整，数据透视表<span style="color: black;">能够</span>给你想要的，<span style="color: black;">能够</span>给你<span style="color: black;">非常多</span>惊喜。<img src="https://mmbiz.qpic.cn/mmbiz_png/t4x9gniadCgrQBibEBOTj07gicjwIib8t9qYdvhUeC5TKOZYQGJXdBRqPEkXDUvDsGD9J5Ga7Xm9PNWtaY2JhtjmFw/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/t4x9gniadCgrQBibEBOTj07gicjwIib8t9qYdvhUeC5TKOZYQGJXdBRqPEkXDUvDsGD9J5Ga7Xm9PNWtaY2JhtjmFw/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/t4x9gniadCgrQBibEBOTj07gicjwIib8t9qYdvhUeC5TKOZYQGJXdBRqPEkXDUvDsGD9J5Ga7Xm9PNWtaY2JhtjmFw/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">end</strong></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_jpg/t4x9gniadCgrQBibEBOTj07gicjwIib8t9qY81uqTvMZAmyYQjWEyIuOsG5icj8WicKlicFDO4n3wttmAxIBh0f0yj6cA/640?wx_fmt=jpeg&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;">长按二维码</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">关注<span style="color: black;">咱们</span></p>
我赞同你的看法，你的智慧让人佩服，谢谢分享。
页:
[1]