ikkhksvu 发表于 2024-10-1 09:59:36

excel数据分析与处理-认识数据透视


    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/cc7ced7c42554e3688e348eab59ad22f~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727959825&amp;x-signature=aRc89fdej%2F5xFau%2BUu1pyqaOMi0%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>
    <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 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>学习和工作中常用的微软三件套，谷歌工作表和金山WPS都支持数据透视功能。</span></p>
    <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 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;">数据透视功能的替代工具</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>的市场上，Excel是最常用和广泛接受的数据透视表工具，<span style="color: black;">因此</span>本视频<span style="color: black;">重点</span>以excel为例进行操作演示。</span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/fe2b80ac89aa4d1ca0aa145a915f5577~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727959825&amp;x-signature=I3Op%2BHVeAH1uUaPNhBbH4MMcokY%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 style="color: black;">亦</span>有其他<span style="color: black;">有些</span><span style="color: black;">商场</span>软件和在线平台<span style="color: black;">供给</span>类似的数据透视表功能，例如：</span></p><span style="color: black;">Tableau</span><span style="color: black;">QlikView</span><span style="color: black;">Power BI</span><span style="color: black;">BIRT</span><span style="color: black;">Jaspersoft</span>
    <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></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;">在Excel中，数据透视功能分为数据透视表和数据透视图两种。</span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p26-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/46b24a727eb34eafa93661b14727d8b4~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727959825&amp;x-signature=vr1exc3NR7nnJgFsStqKtAJAlCc%3D" style="width: 50%; margin-bottom: 20px;">
      <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">数据透视表</p>
    </div>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/f7c0fe7187ba45478e7677b0d6bb2062~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727959825&amp;x-signature=u%2FkRZIM2HKYurXyF%2BpmpJQHtlvU%3D" style="width: 50%; margin-bottom: 20px;">
      <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">数据透视图</p>
    </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>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/601061848bb349b3bb359fad4fa6bf8b~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727959825&amp;x-signature=1YAfh6usEFxWSV3HRSSGUxpbFx4%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><strong style="color: blue;"><span style="color: black;">数据透视</span></strong><span style="color: black;">，数据透视表或数据透视图用于设置或修改数据透视区域名<span style="color: black;">叫作</span>，其中选项按钮<span style="color: black;">能够</span>对数据透视表或数据透视图进行<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-qvj2lq49k0/1800504428174b609d85e0a6bc0d4365~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727959825&amp;x-signature=e%2Fd27YFN7FNmTE%2ByHd07ZlKcu9Q%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><strong style="color: blue;"><span style="color: black;">活动字段</span></strong><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></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></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 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-qvj2lq49k0/aba8164ad3be489c8a3ff9943cc518ed~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727959825&amp;x-signature=m4YkLHLCLPGYemwj9JhpjU7sGFk%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><strong style="color: blue;"><span style="color: black;">筛选</span></strong><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><strong style="color: blue;"><span style="color: black;">数据</span></strong><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></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">接下来是</span><strong style="color: blue;"><span style="color: black;">操作</span></strong><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></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><strong style="color: blue;"><span style="color: black;">计算</span></strong><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></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">最后是</span><strong style="color: blue;"><span style="color: black;"><span style="color: black;">表示</span></span></strong><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></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 style="color: black;">咱们</span><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-qvj2lq49k0/122ba6e889c349b198a66e228c021b50~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727959825&amp;x-signature=e1%2BePfbFJKJPVgeic7013bqcSmk%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 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>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/182007eb8b414d9aa8121c2a977a666e~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727959825&amp;x-signature=d57uXC3xniNwD%2BFhJQdMpkz5FaA%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 style="color: black;">倘若</span><span style="color: black;">无</span>自<span style="color: black;">活动</span>出，<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-qvj2lq49k0/1b0e81b1598b49e38546c0b56262fd4f~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727959825&amp;x-signature=lqR3KcyxFxiGMv8N%2FclAmt5bNhU%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 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>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/f52f3abc12ba4f1197018d22760fdbe6~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727959825&amp;x-signature=o%2BjnUiu7HtT%2Fvm2BYImPlyk6RCk%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 style="color: black;">经过</span>拖拽的方式，将字段从字段列表中添加到字段区域里，你<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-qvj2lq49k0/d7486be03e6c4c2eb9b34f049fe723b1~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727959825&amp;x-signature=0vvdmxAEGflFtKFg7gopJXi%2Fasw%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 style="color: black;">经过</span>点击字段区域中的字段，在弹出的菜单选项里<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-qvj2lq49k0/97d7fbb81f3b4ddd843ee05c2d8804b2~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727959825&amp;x-signature=cqxVUp9G%2F0JMXWEn0962u9f4ZZc%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 style="color: black;">重视</span>到了，在弹出的菜单选项中还有一个字段设置的选项，该选项<span style="color: black;">能够</span>设置字段的计算方式，excel<span style="color: black;">通常</span>会自动判断数据的计算方式，<span style="color: black;">倘若</span>与预期不符，则<span style="color: black;">能够</span><span style="color: black;">这里</span>处自定义设置。</span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p26-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/d690123725234370b2469d42f1805a20~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727959825&amp;x-signature=g%2FjBfRMxngIIElbi3rKeseE%2BzJI%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 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;">创建你的<span style="color: black;">第1</span>个数据透视图</h1>
    <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>准备好了一个简单的示例数据。</span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/8e073c0158344bb38459411ae1e551f5~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727959825&amp;x-signature=yDTeyWb5n1ZNb%2Br%2BNjPdIT8h7CI%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><strong style="color: blue;"><span style="color: black;"><span style="color: black;">插进</span></span></strong><span style="color: black;">，再点击图表中的</span><strong style="color: blue;"><span style="color: black;">数据透视图按钮</span></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-qvj2lq49k0/8eb8e7d44fd645bf95931e2524599fb4~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727959825&amp;x-signature=cLL9W0Vfmll7WUmFBwdCM%2BoACJ8%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 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><strong style="color: blue;"><span style="color: black;"><span style="color: black;">运用</span><span style="color: black;">外边</span>数据源</span></strong><span style="color: black;">，再单击</span><strong style="color: blue;"><span style="color: black;"><span style="color: black;">选取</span>连接</span></strong><span style="color: black;">，最后点击</span><strong style="color: blue;"><span style="color: black;">浏览<span style="color: black;">更加多</span></span></strong><span style="color: black;">就<span style="color: black;">能够</span><span style="color: black;">选取</span>数据，你<span style="color: black;">能够</span><span style="color: black;">选取</span>本地的excel文件数据，<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;"><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>所在单元格有数据，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 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;"><span style="color: black;"><span style="color: black;">因此</span><span style="color: black;">咱们</span>取消创建数据透视图，点击数据区域中的单元格，<span style="color: black;">而后</span>按</span><strong style="color: blue;"><span style="color: black;">ctrl键+T键</span></strong><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;"><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></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 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;"><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;"><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></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/70db995414ad4f739333fe57245349b6~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727959825&amp;x-signature=bhxBehm%2F4zWgOjM2RMJGoDE%2FtGE%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;">创建你的<span style="color: black;">第1</span>个数据透视表</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><strong style="color: blue;"><span style="color: black;"><span style="color: black;">插进</span></span></strong><span style="color: black;">，此时<span style="color: black;">选取</span>表格中的</span><strong style="color: blue;"><span style="color: black;">数据透视表，</span></strong><span style="color: black;"><span style="color: black;">而后</span>弹出与数据透视图创建时类似的向导对话框，<span style="color: black;">按照</span>需要依次设置<span style="color: black;">就可</span>。</span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p26-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/865dac33a81746ce8b5ec8be69d33df7~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727959825&amp;x-signature=NdrdxSkqucFJDPeoE7zfItcq4w4%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 style="color: black;">不消</span>修改，数据透视表展示区域<span style="color: black;">选取</span></span><strong style="color: blue;"><span style="color: black;">现有工作表</span></strong><span style="color: black;">，<span style="color: black;">而后</span><span style="color: black;">选取</span>一个空单元格，最后点击</span><strong style="color: blue;"><span style="color: black;">确定</span></strong><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 style="color: black;">亦</span><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-qvj2lq49k0/4f3cfe7e0ea042c0bdb764fd28b29047~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727959825&amp;x-signature=8hmQ86s%2BoDJzhK0dWoJHGNRLVoo%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 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>sum if函数进行求和，非常的简单、方便和<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;">按照</span>需要<span style="color: black;">选取</span><span style="color: black;">是不是</span>下载。</p>




nqkk58 发表于 2024-10-5 14:18:35

期待楼主的下一次分享！”

wrjc1hod 发表于 2024-11-7 07:34:28

论坛的成果是显著的，但我们不能因为成绩而沾沾自喜。
页: [1]
查看完整版本: excel数据分析与处理-认识数据透视