Excel数据透视表怎么做？职场达人必学知识点！实例讲解！
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">Excel秘籍大全，前言</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">学习Excel，数据透视表是绕不开的一个重要知识点。利用数透表<span style="color: black;">能够</span>从繁杂无序的源数据中筛选出自己需要的“<strong style="color: blue;">字段标题</strong>”进行<strong style="color: blue;"><span style="color: black;">归类</span>汇总、对比</strong>或<strong style="color: blue;">合并</strong>等操作，<span style="color: black;">做为</span>一种强大的<strong style="color: blue;">交互性报表</strong>，大大简化了数据处理和分析工作的<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;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">Excel秘籍大全</span></span><span style="color: black;">，正文<span style="color: black;">起始</span></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;"><span style="color: black;"><span style="color: black;">文案</span>最后有彩蛋！好礼相送！</span></strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">此刻</span>，Excel秘籍大全<span style="color: black;">经过</span><span style="color: black;">实质</span>案例来给<span style="color: black;">大众</span>讲解数透表的强大能力。以图1<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/6e1edc2fdc764f9e8cdbd6ab15b3723d~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950449&x-signature=ZaHnwXDMd5%2BbS8bjkHvyit80p%2BY%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;">图1</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">如图2所示，<span style="color: black;">首要</span>选中源数据所在的单元格区域即A1：D43，点击菜单栏<strong style="color: blue;">“<span style="color: black;">插进</span>”——数据透视表</strong>，“请<span style="color: black;">选取</span>单元格区域”即为A1：D43，“请<span style="color: black;">选取</span><span style="color: black;">安置</span>数据透视表的位置”这里<span style="color: black;">选取</span><strong style="color: blue;">新工作表</strong>，点击确定<span style="color: black;">就可</span>。如图3所示，会<span style="color: black;">显现</span>一个新建的工作表，其右边有“<strong style="color: blue;">字段列表</strong>”和“<strong style="color: blue;">数据透视表区域</strong>”两个板块。<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;">“筛选器”“列”“行”“值”</strong>中，以实现<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/5af44c3784d24f9dbea0ab6e9b2bcec1~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950449&x-signature=RwLqWmMDxpMSmHJxKFbwhfhv02Q%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;">图2</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/539328616dda4aae94d2b828047905ed~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950449&x-signature=XdjIPyebUl2yU6cH5ut32HePyn4%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;">图3</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">1、</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>”拖动到“行”中，将销量拖动到“值”中（默认计算方式为求和），如图4所示，<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>，点击值所在的单元格区域即B3单元格，可更改“值”的计算方式，如图5所示，<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/d225552304ae48399062738cd33608e3~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950449&x-signature=kQwAHgCaGwZzUwF52dxfInai9O0%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;">图4</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/dfe41755fbb040e28a08dab3ecb3e09a~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950449&x-signature=Tmpl6h4%2BiaYKtapunxKIY%2F9q%2FaQ%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;">图5</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">2、</span>求各个<span style="color: black;">分部</span>员工的销量分别是多少</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">如图6所示，将“<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/493e23a11c3e4429a4996bda277cf515~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950449&x-signature=zlAUdNJKHV7pERgjYMzaCE3%2BBV8%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;">图6</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">3、</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;">如图7所示，将<span style="color: black;">制品</span>字段拖到“筛选器”中，将<span style="color: black;">分部</span>字段拖动到“行”中，将销量字段拖动到“值”中，点击B1单元格的筛选按钮，<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/488c300b37c845de85720492f903fcdf~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950449&x-signature=mWbUPjy9KAl4%2Bs%2FG1bnrRjjxxVY%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;">图7</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">4、</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;">如图8所示，将<span style="color: black;">制品</span>字段拖动到“行”中，将销量字段拖动到“值”中，<strong style="color: blue;">双击B3单元格</strong>，将计算方式更改为“最大值”，<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/4bc53af26736457fad152d4153047260~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950449&x-signature=9vZvNZ0B8X8Nc3AAh2Xb2Uk9NEI%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;">图8</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">5、</span><span style="color: black;">营销</span>2部“张三”的销量</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">“张三”有多人同名，求的是<span style="color: black;">营销</span>2部的张三销量，而不是所有张三的销量。如图9所示，将员工<span style="color: black;">分部</span>两个字段拖动到“筛选器”中，将销量拖动到“值”中，计算方式为求和（默认为求和），点击B1单元格的筛选按钮，<span style="color: black;">选取</span>“张三”，点击B2单元格的筛选按钮，<span style="color: black;">选取</span>“<span style="color: black;">营销</span>2部”，<span style="color: black;">就可</span>得出<span style="color: black;">营销</span>2部“张三”的销量。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p26-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/96b9ee984e1a4e3a8c381ec387db3bf8~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950449&x-signature=DoyG551anGFmEYJ8IzP5sVJ0fiw%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;">以下<strong style="color: blue;"><span style="color: black;">《900套高逼格工作模板.xls 》免费下载，不收一分钱！</span></strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">常用Excel</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">用Excel玩好报表</span></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 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/b3c04a744b8c4c6c867898f30c83f242~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950449&x-signature=t8oWE9DGx5VIBYpLitqwRjx%2BS3k%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/701889f0324d430a93150b38a4283eb4~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950449&x-signature=BE222E5qGCOQyYp1KO%2FgQMn2jTQ%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;"><strong style="color: blue;">今天<span style="color: black;">举荐</span>的<span style="color: black;"><span style="color: black;">超实用干货</span></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;"><span style="color: black;">《900套高逼格工作模板.xls 》</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;">3.2G高逼格Excel可视化模板</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;"><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;"><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></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><strong style="color: blue;"><span style="color: black;">900</span></strong></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></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></span></p>
你字句如珍珠，我珍藏这份情。 谷歌外贸网站优化技术。 你说得对，我们一起加油，未来可期。
页:
[1]