2025浙江省EXCEL统计基础
2025年考勤表-自动统计 - Sheet1 Unnamed: 0 Unnamed: 1 部门：星期 日期 姓名张三李四备注：1、“√”为正常出勤，“病”为病假，“事”为事假，“年”为年假，“婚”为婚假，“产”产假。2、病假需提供三甲医院的诊断证明。3、年假需提前一个月向主管领导申请并在人力资源部备份。4、婚假需要提供结婚证，且婚假必须在结婚证的前后6个月之内，产假需要提供诊断证明Unnamed: 2 上下加上下加上下加上下加上下加上下加上下加上下加上下加Unnamed: 3 一1Unnamed: 4 二2√3.5√Unnamed: 5 三32√Unnamed: 6 四4√√1Unnamed: 7 五5√4√√2Unnamed: 8 六6√3Unnamed: 9 日7√4Unnamed: 10 一8病病√5Unname
2025年面试平均分统计表-(去除最高最低分) - Sheet1 面试平均分统计表-(去除最高最低分) 序号1234567891011121314Unnamed: 1 姓名张三赵四李四赵四王五赵四赵六赵四孙七赵四周八赵四吴九赵四Unnamed: 2 评委一19898989898989898989898989898Unnamed: 3 评委二8798109120131142153164175186197208219230Unnamed: 4 评委三8988878685848382818079787776Unnamed: 5 评委四7877767574737271706968676665Unnamed: 6 评委五8987858381797775737169676563Unnamed: 7 评委六8967452389888786858483828180Unnamed: 8 评委七789102115128141154167180193206219232245Unnamed: 9......
2025年员工考勤表统计 - Sheet1 员工考勤表统计 公司名称： 日期： 年 月 日部门市场部Unnamed: 1 姓名李明Unnamed: 2 工号3214Unnamed: 3 迟到4Unnamed: 4 早退0Unnamed: 5 旷工0Unnamed: 6 请假1Unnamed: 7 出差0Unnamed: 8 休假0Unnamed: 9 本月法定工作天数22Unnamed: 10 实际出勤天数21000000000000000Unnamed: 11 备注Sheet2 Sheet3
2025年考勤表(自动统计，自定义考勤符号) - Sheet1 Unnamed: 0 Unnamed: 1 考勤表2019序号12345678910Unnamed: 2 年姓名张晓丽Unnamed: 3 62019-06-01 00:00:0043617√Unnamed: 4 2019-06-02 00:00:0043618Unnamed: 5 月2019-06-03 00:00:0043619╳Unnamed: 6 2019-06-04 00:00:0043620╳Unnamed: 7 2019-06-05 00:00:0043621╳Unnamed: 8 2019-06-06 00:00:0043622Unnamed: 9 2019-06-07 00:00:0043623▲Unnamed: 10 2019-06-08 00:00:0043624▲Unnamed: 11 2019-06-09 00:00:0043625Unnamed: 12 2019-06-10 00:00:0043626Unnamed: 13 2019-06-11 00:00:0043627Unnamed: 14 2019-06-12 00
2025年考勤表（自动统计点亮行列） - Sheet1 Unnamed: 0 Unnamed: 1 2月通用考勤表注：上班√ 休假：休 病假：○ 旷工：X 事假：△ 迟到：迟姓名 张三李四Unnamed: 2 工号930001930002Unnamed: 3 438622020-02-01 00:00:00√√√√√√√√√√√√√√√√√√√√√√√Unnamed: 4 438632020-02-02 00:00:00X√√√√√√√√√√√√√√√√√√√√√√Unnamed: 5 438642020-02-03 00:00:00√休√√√√√√√√√√√√√√√√√√√√√Unnamed: 6 438652020-02-04 00:00:00迟√√√√√√√√√√√√√√√√√√√√√√Unnamed: 7 438662020-02-05 00:00:00√X√√√√√√√√√√√√√√√√√√√√√Unnamed: 8
2025年考勤表-自动统计表 - Sheet1 Unnamed: 0 考勤表 上班√姓名李花桂花Unnamed: 2 休假○部门Unnamed: 3 请假△1√√Unnamed: 4 2√√Unnamed: 5 旷工x3√√Unnamed: 6 4√√Unnamed: 7 出差出5√√Unnamed: 8 6√√Unnamed: 9 外调外7√√Unnamed: 10 8√√Unnamed: 11 9√√Unnamed: 12 10√√Unnamed: 13 查询姓名：李花11√√Unnamed: 14 12√√Unnamed: 15 13√√Unnamed: 16 14√√Unnamed: 17 出勤天数：3115√√Unnamed: 18 16√√Unnamed: 19 17√√Unnamed: 20 18√√Unnamed: 21 19√√Unnamed: 22 部 门： 负责人：制表人：
2025年年人工成本统计表 - Sheet1 Unnamed: 0 Unnamed: 1 全 年 人 工 成 本 统 计 表统计期间：分类销售基础薪资销售业绩薪资管理人员薪资财务部薪资行政部薪资物流部薪资技术部薪资生产部薪资临时人员薪资合计Unnamed: 2 1月0Unnamed: 3 2月0Unnamed: 4 3月0Unnamed: 5 4月0Unnamed: 6 5月0Unnamed: 7 6月0Unnamed: 8 7月0Unnamed: 9 8月0Unnamed: 10 9月0Unnamed: 11 10月0Unnamed: 12 11月0Unnamed: 13 12月0Unnamed: 14 合计0000000000Unnamed: 15 占比---------0
2025年考勤表-自动统计标记 - Sheet1 Unnamed: 0 Unnamed: 1 月份：姓名 张三李四王五考勤表科目Unnamed: 2 部门Unnamed: 3 436471√√√上班√Unnamed: 4 436482×√√休假○Unnamed: 5 436493出√√请假△Unnamed: 6 436504出√√旷工xUnnamed: 7 436515外√√出差出Unnamed: 8 436526√√√外调外Unnamed: 9 436537√√√迟到迟Unnamed: 10 436548√√√Unnamed: 11 436559出√√Unnamed: 12 4365610√√√Unnamed: 13 4365711√√√Unnamed: 14 姓名：4365812√√√Unnamed: 15 4365913√√√Unnamed: 16 4366014√√xUnnamed: 17 张三4366115√√xUnnamed: 18 4366216√√xUnnamed: 19 4366317√√xUnn2025浙江省EXCEL统计基础
2025年考勤表（自动统计，自动点亮行列） - Sheet1 Unnamed: 0 Unnamed: 1 考勤表注：上班√ 休假：休 病假：○ 旷工：X 事假：△ 序号123456789101112Unnamed: 2 姓名 Unnamed: 3 时间上午下午上午下午上午下午上午下午上午下午上午下午上午下午上午下午上午下午上午下午上午下午上午下午Unnamed: 4 1√√√休Unnamed: 5 2休√√Unnamed: 6 3√√Unnamed: 7 4.0Unnamed: 8 5.0Unnamed: 9 6.0Unnamed: 10 7.0Unnamed: 11 8.0Unnamed: 12 9.0Unnamed: 13 10.0Unnamed: 14 11.0Unnamed: 15 12.0Unnamed: 16 13.0Unnamed: 17 14.0Unnamed: 18 15.0Unnamed: 19
2025年考勤表-自动统计-标记 - Sheet1 Unnamed: 0 Unnamed: 1 月份：姓名 张三李四考勤表科目Unnamed: 2 时间上午下午上午下午上午下午上午下午上午下午上午下午上午下午上午下午上午下午上午下午上午下午Unnamed: 3 435861√√√√上班√Unnamed: 4 435872×√√√休假○Unnamed: 5 435883出√√√请假△Unnamed: 6 435894出√√√旷工xUnnamed: 7 435905外√√√出差出Unnamed: 8 435916√√√√外调外Unnamed: 9 435927√√√√迟到迟Unnamed: 10 435938√√√√Unnamed: 11 435949√√√√Unnamed: 12 4359510√√√√Unnamed: 13 4359611√√√√Unnamed: 14 4359712√√√√Unnamed: 15 4359813√√√√Unna
2025年考勤表自动统计 - Sheet1 二0一 年 月份考勤表 部门： 考勤员： 主管领导签字：姓名注：出勤√ 事假△ 迟到× 旷工* 探亲假☆ 公休# 补休þUnnamed: 1 日期星期上午下午上午下午上午下午上午下午上午下午上午下午上午下午上午下午上午下午上午下午Unnamed: 2 1.0Unnamed: 3 2.0Unnamed: 4 3.0Unnamed: 5 4.0Unnamed: 6 5.0Unnamed: 7 6.0Unnamed: 8 7.0Unnamed: 9 8.0Unnamed: 10 9.0Unnamed: 11 10.0Unnamed: 12 11.0Unnamed: 13 12.0Unnamed: 14 13.0Unnamed
2025年考勤表-自动统计 - Sheet1 Unnamed: 0 Unnamed: 1 姓名：姓名 张敏黎明陶笛章航Unnamed: 2 437092019-09-01 00:00:00√√○√Unnamed: 3 张敏437102019-09-02 00:00:00×√迟√Unnamed: 4 437112019-09-03 00:00:00√√√√Unnamed: 5 437122019-09-04 00:00:00√√√√Unnamed: 6 437132019-09-05 00:00:00√√√√Unnamed: 7 考勤天数：437142019-09-06 00:00:00√√√√Unnamed: 8 437152019-09-07 00:00:00√√√√Unnamed: 9 437162019-09-08 00:00:00√√√√Unnamed: 10 437172019-09-09 00:00:00√√√√Unnamed: 11 26437182019-09-10 00:00:00√√√√Unnamed: 12 437192019-09-
2025年考勤表自动统计 - Sheet1 Unnamed: 0 Unnamed: 1 月份：姓名 员工1员工2员工3考勤表科目Unnamed: 2 九月部门Unnamed: 3 日期2019-11-01 00:00:00√√√上班√Unnamed: 4 2019-11-02 00:00:00×√√休假○Unnamed: 5 2019-11-03 00:00:00出√√请假△Unnamed: 6 2019-11-04 00:00:00出√√旷工xUnnamed: 7 2019-11-05 00:00:00外√√出差出Unnamed: 8 2019-11-06 00:00:00√√√外调外Unnamed: 9 2019-11-07 00:00:00√√√迟到迟Unnamed: 10 2019-11-08 00:00:00√√√Unnamed: 11 2019-11-09 00:00:00出√√Unnamed: 12 2019-11-10 00:00:00√√√Unnamed: 13 2019-11-11 00:
2025年考勤表（自动统计） - Sheet1 Unnamed: 0 Unnamed: 1 请选择日期2018年11月考勤表姓 名小管左左多多Unnamed: 2 √星期部门财务部运营部行政部Unnamed: 3 2018出勤五2018-11-02 00:00:00Unnamed: 4 六2018-11-03 00:00:00√√√Unnamed: 5 ●日2018-11-04 00:00:00√√√Unnamed: 6 年休假一2018-11-05 00:00:00√√√Unnamed: 7 11二2018-11-06 00:00:00●√√Unnamed: 8 ○三2018-11-07 00:00:00√√√Unnamed: 9 月事假四2018-11-08 00:00:00Unnamed: 10 五2018-11-09 00:00:00Unnamed: 11 ☆六2018-11-10 00:00:00Unnamed: 12 病假日2018-11-11 00:00:00Unnamed: 13 一2018-
2025年考勤表-自动统计 - Sheet1 Unnamed: 0 考勤表 部门：姓名 日期 批准:Unnamed: 2 Unnamed: 3 出 勤 情 况 1√√√√√√√√√√√√√√√√√○△╳①G②□Unnamed: 4 2√√√√√√√√√√√√√√√√Unnamed: 5 3√√√√√√√√√√√√√√√√Unnamed: 6 4△√√√√√√√√√√√√√√√Unnamed: 7 5√√√√√√√√√√√√√√√√Unnamed: 8 6√√√√√√√√√√√√√√√√Unnamed: 9 7√√√√√√√√√√√√√√√√Unnamed: 10 8√√√√√√√√√√√√√
2025年考勤表-自动统计-自动显示当日 - Sheet1 Unnamed: 0 Unnamed: 1 Unnamed: 2 Unnamed: 3 姓名出-缺-休-差-年-迟主管：Unnamed: 4 2019-06-01 00:00:00出出Unnamed: 5 2019-06-02 00:00:00缺出Unnamed: 6 2019-06-03 00:00:00迟出Unnamed: 7 2019-06-04 00:00:00出出Unnamed: 8 2019-06-05 00:00:00出出Unnamed: 9 2019-06-06 00:00:00出出Unnamed: 10 2019-06-07 00:00:00出出Unnamed: 11 2019-06-08 00:00:00出出Unnamed: 12 2019-06-09 00:00:00出出Unnamed: 13 2019-06-10 00:00:00出出Unnamed: 14 2019-06-11 00:00:00出出Unnamed: 15 2019-06-12 00:00:00出出Unnamed: 2025浙江省EXCEL统计基础
2025年工资表（自动统计） - Sheet1 Unnamed: 0 Unnamed: 1 工资表编号Unnamed: 2 姓名Unnamed: 3 部门Unnamed: 4 工号Unnamed: 5 应发基本工资Unnamed: 6 全勤奖Unnamed: 7 岗位补助Unnamed: 8 节假补助Unnamed: 9 加班费Unnamed: 10 工资合计00000000000000000000000Unnamed: 11 应扣个人所得税Unnamed: 12 社保Unnamed: 13 迟到罚款Unnamed: 14 其他扣款Unnamed: 15 实发工资00000000000000000000000Unnamed: 16 签字
2025年万年历自动统计考勤表 - 考勤表 Unnamed: 0 Unnamed: 1 考 勤 表姓名Unnamed: 2 项目上午下午加班上午下午加班上午下午加班上午下午加班上午下午加班上午下午加班上午下午加班上午下午加班上午下午加班上午下午加班Unnamed: 3 1一〇〇3Unnamed: 4 2二√√4Unnamed: 5 3三√√4Unnamed: 6 4四√√4Unnamed: 7 5五√√Unnamed: 8 6六√√4Unnamed: 9 7日√√Unnamed: 10 8一〇〇Unnamed: 11 9二√√Unnamed: 12 10三√√Unnamed: 13 11四√√Unnamed: 14 12五√√Unnamed: 15 13六√√Unnamed: 16 14日√√Unnamed: 17 15一☐☐Unnamed: 18 16二☐☐Unnamed: 19 17三√√Unnamed: 20 18四√√Unnamed:
2025年工资表-自动统计带查询 - Sheet1 Unnamed: 0 Unnamed: 1 Unnamed: 2 查询区域：姓名张三李四Unnamed: 3 部门Unnamed: 4 姓名岗位Unnamed: 5 工号Unnamed: 6 张三底薪30005000Unnamed: 7 加班工资Unnamed: 8 应发工资全勤奖金Unnamed: 9 3000节假补助Unnamed: 10 岗位补贴Unnamed: 11 实发工资应发工资30005000000000000000000000000Unnamed: 12 3000扣 款 部 分个税Unnamed: 13 伙食费Unnamed: 14 个税住宿费Unnamed: 15 社保Unnamed: 16 0水电费Unnamed: 17 预支Unnamed: 18 实发工资30005000000000000000000000000
