Reply to the private message with the keyword [Tools] to get a collection of efficient Excel gadgets! Improve your Excel efficiency~
How does your company calculate attendance?
Some are punched in and recorded on a clocking machine;
Some check in and record directly on DingTalk APP;
Some bosses stand at the door and record manually;
And some... you can just use Excel to make a "Dynamic Attendance Sheet"!
My cousin highly recommends it, you deserve it!
01
Make an attendance sheet
♦ Date ♦
❶ Enter in date column B3
=A2
A2 represents: the date displayed on the header.
❷ Enter in C3:
=B2+1
Represents the date in B3 = the date on the left + 1
❸ Drag the fill to the right.
❹【Ctrl+1】Set cell format.
Click [Date] in "Category", select the format "March 14", OK!
♦ Day of the week ♦
❶ Enter in the day of the week column B4:
=B3
Represents the date in B4 = the date above.
❷ Drag the fill to the right.
❸【Ctrl+1】Set cell format.
Click [Date] in "Category", select the format "Wednesday", and confirm!
After setting the date and week, change the date in line 2 and the schedule will automatically update~
02
Methods for recording attendance
❶ Select the attendance area.
❷ Set the font to"windings2".
Under this font:
Capital O = X
Capital P = √
Recording attendance in this way is simple, convenient and easy to archive~
Little E immediately followed it and made a"Looking at" attendance sheet.
Reply to the private message with the keyword [Tools] to get a collection of efficient Excel gadgets! Improve your Excel efficiency~
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/bu-dao-1-fen-zhong-zuo-hao-kao-qin-biao-zhe-cai-shi-zui-jian-dan-de-fang-fa.html
评论列表(196条)
测试