【每日必学Excel】简单粗暴的工资条制作办法！
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz_gif/ps7aicV1UVcibTWnxxeLITqViaYWKkj5rZMTR09KXvkn3IEoc2icfnvje9GgBVWHtL3RG1nAGgyKoJicc7cNOfa9a3Q/0?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;"><img src="http://mmbiz.qpic.cn/mmbiz/ps7aicV1UVc8HMvBgf6RET27uLvLNLbjZTCf1liaP7xXMq0U6umlKkiaN0ibOOerOkAqOP0Xhskghictjf2MiaHzoCyg/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&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>过你的工资条吗？况且你的<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>实现工资条的制作。只需短短5分钟，你就懂得<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;">第1</span>步：在H4单元格里输入1，之后往下填充序列，<span style="color: black;">由于</span>只是借组4条数据，选中填充数列，<span style="color: black;">而后</span>在H8中复制一下，之后H12中再次复制下</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz_png/ps7aicV1UVc8K2Ps5PezYLzexvNh63PUzicDeJas2RaB8aKrLibFVKcia0v6yzUR1sfyLK0pEMqVqfqyEqpd2wYPXw/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&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;">第二步：复制标题栏，在A12里面<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="http://mmbiz.qpic.cn/mmbiz_png/ps7aicV1UVc8K2Ps5PezYLzexvNh63PUzGeQ2jt22E00dFqQZyVUOYibID0SibOAPibiblVQSN6kdwczumvL6G0xKBw/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&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;">第三步：单击E列，<span style="color: black;">选取</span>排序，之后清除E列就<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="http://mmbiz.qpic.cn/mmbiz_png/ps7aicV1UVc8K2Ps5PezYLzexvNh63PUz4PHia6DAKLMVLQUbLxxlU3OTvzomFwZasJPsX4BNrTEwh6NSzY75CNQ/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&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>很适合小企业，<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="http://mmbiz.qpic.cn/mmbiz_gif/ps7aicV1UVcibTWnxxeLITqViaYWKkj5rZMcxXhT2CcMxYfJle4OThDPjjbC5j9LSicuZj7Bt3auibc2QdTvibInmfiaw/0?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"><img src="http://mmbiz.qpic.cn/mmbiz_jpg/ps7aicV1UVc8H9m3KSQ0uUr2icCw6cPXbfBND4yYuv06wLctyc9MvSIiczEEoxopkFNHwFslo0enIkH9hpJqBCf1w/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
外链论坛的成功举办，是与各位领导、同仁们的关怀和支持分不开的。在此，我谨代表公司向关心和支持论坛的各界人士表示最衷心的感谢！
页:
[1]