HR怎么样快速生成工资条？简单又容易！
<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>：</span><span style="color: black;">小鱼日志</span></p>0<span style="color: black;">1</span><span style="color: black;">每一个</span>月发工资的时候HR都要给各个<span style="color: black;">分部</span>送工资条，<span style="color: black;">那样</span>工资条是怎么制作出来的呢？<span style="color: black;">正常<span style="color: black;">咱们</span>的工资条里面会有底薪、保险、提成等等，以下<span style="color: black;">咱们</span><span style="color: black;">根据</span>1-12月举例子说明。</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>都会的，“1，2,3，4····”<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/nlqofMlozxgac9lQ1FPmusvNhhyzlvE2x7UmNrFJZaP6UnxWaLYUfRt3AJ7mcZuic4N8ur27cnWuIdrFt3HOibqQ/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></p>0<span style="color: black;">2</span>再将排序复制一份，找到最下面，进行粘贴。最关键<span style="color: black;">过程</span>，点击“排序与筛选”选项卡中的“自定义排序”。在关键字选项栏中<span style="color: black;">选取</span>最后一个<span style="color: black;">就可</span>完成。<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/nlqofMlozxgac9lQ1FPmusvNhhyzlvE2XgTcd0EzqJf83TZ1uYYibIDQ78NekBeOGDzw5QaZKQeVBQlb9gxYWAw/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></p>0<span style="color: black;">3</span>最后一步呢，将“一月--十二月进行复制”，如图所示将数据区域<span style="color: black;">选取</span>后，点击“<span style="color: black;">查询</span>与<span style="color: black;">选取</span>”中的“空值”，“ctrl＋v ”，<span style="color: black;">而后</span>将多余部分删掉<span style="color: black;">就可</span>。<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/nlqofMlozxgac9lQ1FPmusvNhhyzlvE2YuXiaW3NUhQQD1LRPOS1MhlHcoOia8NiarqRwU0RJqtfdPWjyObqINAxg/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></p>0<span style="color: black;">1</span><span style="color: black;">每一个</span>月发工资的时候HR都要给各个<span style="color: black;">分部</span>送工资条，<span style="color: black;">那样</span>工资条是怎么制作出来的呢？<span style="color: black;">正常<span style="color: black;">咱们</span>的工资条里面会有底薪、保险、提成等等，以下<span style="color: black;">咱们</span><span style="color: black;">根据</span>1-12月举例子说明。</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>都会的，“1，2,3，4····”<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/nlqofMlozxgac9lQ1FPmusvNhhyzlvE2x7UmNrFJZaP6UnxWaLYUfRt3AJ7mcZuic4N8ur27cnWuIdrFt3HOibqQ/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></p>0<span style="color: black;">2</span>再将排序复制一份，找到最下面，进行粘贴。最关键<span style="color: black;">过程</span>，点击“排序与筛选”选项卡中的“自定义排序”。在关键字选项栏中<span style="color: black;">选取</span>最后一个<span style="color: black;">就可</span>完成。<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/nlqofMlozxgac9lQ1FPmusvNhhyzlvE2XgTcd0EzqJf83TZ1uYYibIDQ78NekBeOGDzw5QaZKQeVBQlb9gxYWAw/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></p>0<span style="color: black;">3</span>最后一步呢，将“一月--十二月进行复制”，如图所示将数据区域<span style="color: black;">选取</span>后，点击“<span style="color: black;">查询</span>与<span style="color: black;">选取</span>”中的“空值”，“ctrl＋v ”，<span style="color: black;">而后</span>将多余部分删掉<span style="color: black;">就可</span>。<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/nlqofMlozxgac9lQ1FPmusvNhhyzlvE2YuXiaW3NUhQQD1LRPOS1MhlHcoOia8NiarqRwU0RJqtfdPWjyObqINAxg/640?wx_fmt=gif&tp=webp&wxfrom=5&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>：<span style="color: black;"><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 style="color: black;">咱们</span>，<span style="color: black;">咱们</span>会在24小时内删除处理，谢谢</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/KkKqw5ibkgnuCAueic5JIkxdibrZzEcwALEvzHEjuZy79BwPfNmZ3CCfZRlRtgeh80vB0r6E1SNpibyhkLKVYXvfHQ/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">北上广深的HR伙伴</strong></span><strong style="color: blue;">在等你，<span style="color: black;">微X</span>群加入<span style="color: black;">办法</span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">▼</strong></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;">加群主Findy<span style="color: black;">微X</span>：Findy2015，并留言：</span></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">HR群+姓名+手机（<span style="color: black;">微X</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;"><strong style="color: blue;"><span style="color: black;">公开课<span style="color: black;">举荐</span></span></strong></span></p><strong style="color: blue;"><span style="color: black;">1月2</span></strong><strong style="color: blue;"><span style="color: black;">4日 @北京珀丽酒店</span></strong><strong style="color: blue;"><span style="color: black;">人力成本分析与管控</span></strong>
<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 style="color: black;">实战派资深人力资源管理专家周老师，来结合<span style="color: black;">日前</span>的时下政策来讲述企业人力成本分析与管控方面的实用干货，欢迎<span style="color: black;">大众</span>参加。</span></span></p><img src="https://mmbiz.qpic.cn/mmbiz_jpg/QcJWWRgmHGzSQs7SW7BDhj9TSic7zDwFljtxe2XIY0BFqaZqSRfmZBeAy0icrWBov1QGQMmVuFlbaic4NCZLwySaw/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;"><strong style="color: blue;">课程咨询&报名</strong></span>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">Sally</span></strong></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;"><strong style="color: blue;">QQ：2072701821</strong></span><span style="color: black;">Tel：<span style="color: black;">15821002307</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;">event@psmmedia.com</span><span style="color: black;">扫描左侧二维码加<span style="color: black;">微X</span></span></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">↓↓↓ 点击"阅读原文" 【查看<span style="color: black;">更加多</span>课程信息】</strong></span></p>
软文发布论坛开幕式圆满成功。 http://www.fok120.com
页:
[1]