天气预报 > 科技 > excel如何做考勤表
excel如何做考勤表
更新时间: 2021-02-17 11:59:27  

1、首先新建一个空白excel表格,输入内容,考勤类型可以自己定义。

2、设置出勤类型下拉菜单,点击“数据验证”,接着选择“序列”。

3、设置好序列后添加日期等员工姓名即可。

4、根据以上步骤就可以制作出员工考勤表了。

关键词: excel 如何 考勤

excel如何做考勤表相关经验

天气预报

最新推荐

页面:/news/view-948230/ | 耗时:0.3435 s | 内存:2.11 MB | 查询:4 | 缓存读取:3 写入:0 | 加载文件:25
select * from tbl_Articles WHERE ArticleID=948230 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=948230 LIMIT 0,1
select * from tbl_Articles_sphinx where id=948230 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(2057917,2843086,582596,3234529,2876866,2146016,2779385,3003446,975622,3326851,2108980,729421,3122978,3389897,1565566,1482987,754600,3247716,2924399,3510146,3780639,1338083,979781,3226996,852031,1020057,872152,3208521,2673782,1381470) ORDER BY field (ArticleID,2057917,2843086,582596,3234529,2876866,2146016,2779385,3003446,975622,3326851,2108980,729421,3122978,3389897,1565566,1482987,754600,3247716,2924399,3510146,3780639,1338083,979781,3226996,852031,1020057,872152,3208521,2673782,1381470)