Excel中快速生成工资条，powerquery生成，可自动更新
<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/d25ffbd19f5d4605a0bf5d832ede3889~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727986236&x-signature=N34tT7aMN9mOXoole1TCGo%2FR9rc%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/2cfd842951084b4cb208b1db667e25c3~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727986236&x-signature=totQFSIkTk8qdu2qEh3M7cQ13LU%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>用Excelk中的Powerquery制作效果如下所示：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/aa1ed1af36f841c79266efa7849848c4~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727986236&x-signature=X8w9GqD29dvBvKs5jSfgN0rgZyg%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">制作过程如下：</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1、<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/9e7554d7aed14d38ac38802a17c93fa6~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727986236&x-signature=JnqmTG7gRSJ4DUgFPh3GQJOgE74%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">2、在弹出的power query中，<span style="color: black;">咱们</span>直接点击关闭，并上载至，<span style="color: black;">咱们</span><span style="color: black;">选取</span>现有工作表的空白位置，<span style="color: black;">例如</span>G3单元格位置</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/6b5e2cc1f2c24cda89b8b513ecc3cace~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727986236&x-signature=whapFDyZ27wVe0Msar5OVvVXXAU%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">3、<span style="color: black;">而后</span><span style="color: black;">咱们</span>选中表格中的，A1:E1单元格，按CTRL+C进行复制标题字段，<span style="color: black;">而后</span>把光标放在G2单元格，点击菜单栏上方的<span style="color: black;">查找</span>，点击编辑，<span style="color: black;">这般</span><span style="color: black;">咱们</span><span style="color: black;">能够</span>跳回到Powerquery界面，<span style="color: black;">而后</span><span style="color: black;">咱们</span>在PQ界面，点击添加列，<span style="color: black;">选取</span>自定义列，<span style="color: black;">而后</span><span style="color: black;">咱们</span>输入双引号，按CTRL+V，进行粘贴，把刚行的标题内容进行粘贴进来，如下所示：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/d4dbfdd05b454b4d95e72d9a29c9bbc3~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727986236&x-signature=ar6%2BZwB7Jrf3Q4pX9vW3N9VRuA0%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">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>设置为空白，公式输入双引号，里面再输入一个空格，如下所示：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/1ad518796b2d4f979f6a5c2e10130be5~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727986236&x-signature=8WDtcQARCy4wf9u%2FYg2SfHdogoI%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">5、<span style="color: black;">而后</span><span style="color: black;">咱们</span>选中除了添加的2列以外的最原始的数据列，点击添加选项卡下的，合并列，<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/cabf5f6185584883baa0e8818fa6fbcc~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727986236&x-signature=qPcbpyMf8v0WBzENHOr07u5l%2Fao%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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>后面的3列数据：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/8bb429dfed9844caab48adb480bed707~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727986236&x-signature=LeEgk7OlEsOcJ3ljCI9IU%2F43Mqw%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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>要把空白列，移动到最右边，<span style="color: black;">而后</span>选中3列，点击转换下的，逆透视列，如下：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/8169d45637714b6d8dc4d0616729d1fa~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727986236&x-signature=gdaX915hn%2BpeyWZIFhcXLCXyrYU%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">8、<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/d51897ca747f46908821c01262e63e81~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727986236&x-signature=O94mVNq9fmWVV48ZJXi64gKiWjo%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">9、选中属性列，<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/0b7c6bf5ad534d2e81ab80347296d1bd~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727986236&x-signature=5vcfc03xJ54%2BIjDAoXxyTzM3OO0%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;">第1</span>行做为标题行，<span style="color: black;">而后</span>CTRL+A，全选数据，点击替换，将null，替换成空白</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/0b9c1110f77d434a9482884b98534904~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727986236&x-signature=%2FHtpPZrXUycZ79iUQAX9a1mys1c%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/12daa6df6026473eb88a2e8b81d64378~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727986236&x-signature=qtIuludDCIwCOn3wCSFSx0cFxQA%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">你学会了么？动手试试吧！</p>
交流如星光璀璨，点亮思想夜空。
页:
[1]