excel数据分析与处理-数据透视图的基本操作
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/37fbca5a210646b383ea93e115d6fe81~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727957918&x-signature=EUEBR7U46A6UZvqyNyUfnpwrRUQ%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;">视频讲解通道</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><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;">第1</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>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">创建数据透视图</h1>
<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>其中一个，两者的创建内容完全一致。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/bc2e102565ea4660bc379572480ccb06~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727957918&x-signature=4a3KhIvR1B2mMJOcoQ6ZZrQMwPs%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>在弹出的对话框中设置数据<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-qvj2lq49k0/80a5e012e55048829bbeee3a01f5f98d~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727957918&x-signature=rt%2Bfxj8XwH0VDFCOL3Uk3FapJlM%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Excel将会创建一个数据透视表和一个数据透视图，<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-qvj2lq49k0/bfe6bc6bdf4e4107989f451cf078abc7~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727957918&x-signature=4dYtYM2JQp9qkjC%2FlQepbPXZXmc%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">怎样</span>设置活动字段</h1>
<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;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/ffbc65ad1d1143f68314fc4fab8d2a53~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727957918&x-signature=VkkfHm7ZU6EvUMCqsd9Gs6eiZD0%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">数据透视图的数据连接与刷新</h1>
<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>如下：依次点击数据透视图分析，刷新；</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/ea375f46e46e46a4ba42dc00057eccfe~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727957918&x-signature=TVHcFR7Oapt9%2BCdl0p3H4Xhct3Y%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>选中数据透视图右键<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-qvj2lq49k0/8521f6d1bce244f388a70bb1adb8f9ce~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727957918&x-signature=C48FwIcdff3LNncDDVbAlSkOVM0%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>需要修改数据<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-qvj2lq49k0/bb9e94bac5ed44fe9251938a71ee2c73~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727957918&x-signature=iBOeQ2dZY8rc%2Bf2sUceFr5tM88Q%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>想要让数据透视表连接到<span style="color: black;">外边</span>数据<span style="color: black;">或</span>刷新<span style="color: black;">外边</span>数据同数据透视表完全一致，可观看本教程的第四期视频学习<span style="color: black;">怎样</span>操作。</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">数据透视图的数据筛选</h1>
<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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/d9af15e000b8432088bb0e5454454baf~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727957918&x-signature=t2vMlQT8805jMkCgc4CLCyzoviQ%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-qvj2lq49k0/411154fdfccd4436a04bd8f1b041fe39~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727957918&x-signature=jb0gLg2adkgLS67zCsluwgtJdBM%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>想要实现更<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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/76f773f3249242959df046de5ab0cfbd~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727957918&x-signature=YcQULuG69PS1jOeN4k0kPVrU1S0%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>想要更深入学习切片器和日程表的<span style="color: black;">相关</span>操作可观看本教程第六期视频内容学习<span style="color: black;">怎样</span>操作。</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">数据透视图移动操作</h1>
<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;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/fd34156653b74fd4954db3d99976ef0b~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727957918&x-signature=iO7IV79RLzk5J5G%2BaADTZZTPmlg%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><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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/ca60039982dd4e158ce7c28142aa56e2~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727957918&x-signature=v8KmjrfJLuU6XPh7ln2jOj0nhZ0%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>，该操作只会清除图表<span style="color: black;">表示</span>数据，不会删除数据透视图，<span style="color: black;">倘若</span>要删除数据透视图<span style="color: black;">能够</span>直接选中数据透视图<span style="color: black;">而后</span>按delete键。</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">数据透视图自定义计算</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">最后在数据透视图分析菜单中还有一个计算菜单栏。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/4f0f2d8c7b334de08039d2468016bbef~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727957918&x-signature=T01Wf4FWss2agGaIJ1z%2Fxi1Zt%2FM%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><span style="color: black;">更加多</span>计算字段，计算项的知识<span style="color: black;">能够</span>观看本教程第12期内容。</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>赘述了。</p>
顶楼主，说得太好了！ 外贸网站建设方法 http://www.fok120.com/ 楼主节操掉了，还不快捡起来！
页:
[1]