5ep9lzv 发表于 2024-10-2 15:19:52

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>分享一下excel工资表汇总怎么做？</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_gif/WzMP0qKUhFmkF5ocayLzgV7mBnhficzYzqFzD2G81Au0NmfzGfbxIF1lkOKTLQqEPCLYfGPs1Ob4Psjqcyy97wA/640?wx_fmt=gif&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=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>1：打开演示文件，分别是某<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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/WzMP0qKUhFmkF5ocayLzgV7mBnhficzYzAiazI5icBNnmkNr9ZFF0UMmkZw2XcVMibW3aL7aaSKQMG4KbNsU63OiaYA/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;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>2：</span><span style="color: black;"><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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/WzMP0qKUhFmkF5ocayLzgV7mBnhficzYzfnBGL4liba8WvH2WRPrll6ozLcXyMY4EZ1XSdeyELoRLMd49ocJgYxg/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;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>3：</span><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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/WzMP0qKUhFmkF5ocayLzgV7mBnhficzYzxCZqsDvK5G7LblvnQPxpCFRCiagVCOYZYjtq0b02HoFQiaJaj9H4Yz1A/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;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>4：</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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/WzMP0qKUhFmkF5ocayLzgV7mBnhficzYzNZnLoYqRaeprJE6iaVbr1oo2hUSPJCziaicD79HZzan0U9eVF2InwD9mw/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;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>5：</span><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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/WzMP0qKUhFmkF5ocayLzgV7mBnhficzYzgdJxfLyuB6OnGoax6y4Xrc1tvBlxjAaeI9Jib63OXdJxTNSoAGe3Kkw/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;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>6：</span><span style="color: black;">完成效果如下图所示</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/WzMP0qKUhFmkF5ocayLzgV7mBnhficzYz3e660olic2fx6T493ib9oicM0uBDibpBXjHbwdyqFUstRU31DOnprqSeWw/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>




nqkk58 发表于 2024-10-26 15:12:51

哈哈、笑死我了、太搞笑了吧等。

j8typz 发表于 2024-11-10 00:18:30

你的见解真是独到，让我受益良多。
页: [1]
查看完整版本: excel工资表汇总怎么做？