5ep9lzv 发表于 2024-10-2 16:54:26

很简单，学会Excel数据透视表，秒变能手！


    <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>Excel中一个非常强大且实用的功能——数据透视表。它是<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 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></span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-axegupay5k/1488410bb5534536a6c1f1a0a5f9d634~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727991083&amp;x-signature=%2BOfnP0%2B1db1o55dXXSbVJqMW2%2FY%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>需要告诉Excel，<span style="color: black;">咱们</span>要对<span style="color: black;">那些</span>数据进行操作。<span style="color: black;">选取</span>表格中的</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 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/440a8da329c74bb2899a5c58b2e1add1~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727991083&amp;x-signature=Cht2KFDATEj6elNHrDrXersJ7Go%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>，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>在当前工作表中找到一个合适的位置。</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/6e2e09efb37c401eb4b8e007f3a4ecb3~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727991083&amp;x-signature=e0hkQa5lGD37TDrq%2FuE9dWqnrf8%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 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/a2c0c879fcba4345917d3203e71e9f16~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727991083&amp;x-signature=zIbhRD8RWeSrZ%2BXXKuVG7%2Fo%2F2Xg%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 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></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><strong style="color: blue;"><span style="color: black;"><span style="color: black;">拖动</span></span></strong><span style="color: black;"><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></span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/1dddbac2b268407ab3376a493581d243~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727991083&amp;x-signature=rBD%2FoChvXY2mwUm1YTqk2UnKbaY%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>点击“确定”时，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></span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/f31390dec20b44f58988b91a8afb755c~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727991083&amp;x-signature=Q48tzFhGWdfQIDehwqkK6iPvO7o%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 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/8689f24a60064dee9f9f5a537a2f7e54~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727991083&amp;x-signature=zLWstVDDVQzUsWbaqSUmjePJ%2F6M%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>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/267fb09abdbd44f48c48337877994455~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727991083&amp;x-signature=j61dxNm3gVxONIVaAUcvw%2BoBbCE%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>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/431bb3393d2a447597b979b15fd5fbba~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727991083&amp;x-signature=%2F2lin3ev8%2FRReMtzKtHHiZPFgM4%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">你学会了吗？</strong></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>对你有所<span style="color: black;">帮忙</span>，请点个赞，关注我，你的支持，是我前进的最大动力！谢谢！</strong></p>




nykek5i 发表于 2024-10-31 13:07:34

楼主的文章深得我心，表示由衷的感谢！
页: [1]
查看完整版本: 很简单，学会Excel数据透视表，秒变能手！