第1章 公司员工资料管理

文件1 员工工作证                                                                               2

文件2 员工个人资料登记表                                                                 5

文件3 员工资料统计表                                                                        8

文件4 各部门员工资料统计表                                                              11

文件5 员工资料查询表                                                                        13

文件6 公司人数统计                                                                            17

文件7 干部一览表                                                                               17

文件8 员工通信簿                                                                               18

文件9 员工工龄统计表                                                                        18

文件10 管理人才储备表                                                                       19

 

第2章 公司人事动态管理

文件11 人事动态及费用资料表                                                            22

文件12 人事规划表                                                                              24

文件13 人事通报表                                                                              26

文件14 人事变更报告                                                                          29

文件15 人事流动月报表                                                                       32

文件16 员工任免通知书                                                                       35

文件17 后备人员明细表                                                                       36

文件18 员工离职结算表                                                                       37

文件19 人员增加说明表                                                                       37

文件20 职务调动申请表                                                                       38

 

第3章 员工招聘

文件21 招聘申请表                                                                              40

文件22 招聘流程图                                                                              42

文件23 应聘者基本情况登记表                                                            44

文件24 招聘职位表                                                                              46

文件25 招聘进程表                                                                              48

文件26 应聘者情况表                                                                          49

文件27 招聘费用预算表                                                                       50

文件28 内部岗位竞聘报名表                                                                50

文件29 人员增补申请表                                                                       51

 

第4章 员工甄选

文件30 应聘者个人资料比较表                                                            54

文件31 面试人员名单                                                                          56

文件32 面谈记录表                                                                              57

文件33 面试、笔试成绩统计表                                                            61

文件34 新员工甄选比较表                                                                   62

文件35 应聘人员复试名单                                                                   65

文件36 应聘人员复试记录表                                                                65

文件37 新员工甄选报告表                                                                   66

文件38 面试评价表                                                                              67

文件39 面试结果推荐表                                                                       67

 

第5章 人员录用管理

文件40 员工录用通知单                                                                       70

文件41 员工报到手续表                                                                       73

文件42 新员工试用表                                                                          74

文件43 人员试用考查表                                                                       76

文件44 新员工入职登记表                                                                   77

文件45 新员工转正申请表                                                                   77

文件46 人员试用申请及核定表                                                            78

 

第6章 公司员工培训管理

文件47 员工培训计划表                                                                       80

文件48 员工培训课程安排表                                                                82

文件49 员工培训申请表                                                                       85

文件50 员工培训成绩表                                                                       87

文件51 培训成绩名单图解                                                                   90

文件52 职员培训成果检测表                                                                91

文件53 在职训练学员意见调查表                                                         92

文件54 员工培训评价表                                                                       93

文件55 员工培训成绩查询表                                                                93

文件56 在职员工培训结训报表                                                            94

 

第7章 公司办公用品管理

文件57 办公用品采购流程图                                                                96

文件58 办公用品采购申请表                                                                98

文件59 办公用品采购表                                                                       100

文件60 办公用品采购报价单                                                                102

文件61 办公用品采购记录统计表                                                         103

文件62 比较采购办公用品费用                                                            106

文件63 办公用品费用预算表                                                                106

文件64 办公用品领用申请表                                                                107

文件65 办公用品领取登记表                                                                107

文件66 办公用品库存统计表                                                                108

 

第8章 公司客户管理

文件67 客户通讯簿                                                                              110

文件68 新增客户详情表                                                                       113

文件69 客户等级分类表                                                                       115

文件70 客户分布图                                                                              118

文件71 客户排行榜                                                                              120

文件72 客户认定申请表                                                                       122

文件73 客户来电登记簿                                                                       123

文件74 潜在客户调查总结表                                                                123

文件75 新客户调查表                                                                          124

文件76 访问客户意见表                                                                       124

 

第9章 公司员工考勤管理

文件77 员工出勤记录表                                                                       126

文件78 月度考勤统计表                                                                       129

文件79 考勤结果查询表                                                                       131

文件80 员工出勤情况分析图                                                                134

文件81 员工休假流程图                                                                       138

文件82 员工签到簿                                                                              141

文件83 员工请假单                                                                              142

文件84 员工请假流程图                                                                       142

文件85 员工考勤日报表                                                                       143

文件86 特别休假请假单                                                                       143

 

第10章 员工值班与加班管理

文件87 值班安排表                                                                              146

文件88 假期值班人员安排表                                                                149

文件89 值班人员提醒表格                                                                   154

文件90 值班人员联系簿                                                                       155

文件91 值班餐费申请单                                                                       158

文件92 加班记录表                                                                              160

文件93 加班时间统计表                                                                       160

文件94 员工工时记录薄                                                                       161

文件95 工作时间记录卡                                                                       161

文件96 加班费申请单                                                                          162

 

第11章 员工出差管理

文件97 员工出差申请表                                                                       164

文件98 出差费用结算表                                                                       166

文件99 员工出差记录统计表                                                                168

文件100 业务人员出差报告表                                                              170

文件101 年度出差日数报告表                                                              172

文件102 营业出差日报表                                                                     176

文件103 长期出差报告                                                                        176

文件104 员工出差旅费报销清单                                                          177

文件105 短程旅费申请表                                                                     178

文件106 国外出差旅费计算表                                                              178

第12章 员工业绩管理

文件107 员工业绩测评流程图                                                              180

文件108 员工季度业绩排名表                                                              182

文件109 员工月度业绩比较图                                                              184

文件110 员工季度业绩评定                                                                  187

文件111 员工工作能力和态度评定表                                                    190

文件112 职员考核表                                                                            194

文件113 员工考绩登记表                                                                     195

文件114 管理人员月考核表                                                                  195

文件115 员工自评表                                                                            196

文件116 员工工作态度互评表                                                              196

 

第13章 日常费用管理

文件117 日常费用统计表                                                                     198

文件118 日常费用支出预算表                                                              201

文件119 企业部门借款单                                                                     204

文件120 各部门日常费用花销比较图                                                   206

文件121 各项费用月支出比较图                                                          209

文件122 会议费用预算表                                                                     212

文件123 水电费月结算表                                                                     213

文件124 日常费用申报表                                                                     213

文件125 日常费用季度结算表                                                              214

文件126 日常费用年结算表                                                                 214

 

第14章 费用报销管理

文件127 费用报销流程图                                                                     216

文件128 员工外勤费用报销单                                                              218

文件129 电话补助标准表                                                                     221

文件130 月度电话报销费用统计表                                                       223

文件131 午餐补助费用报销单                                                              225

文件132 节日补助申请表                                                                     227

文件133 节日补助表                                                                            227

文件134 生日津贴表                                                                            228

文件135 生活补助表                                                                            228

文件136 旅游津贴补助表                                                                     229

 

第15章 员工福利管理

文件137 公司福利体系图                                                                     232

文件138 员工社会保险登记表                                                              234

文件139 参加社会保险人员申报表                                                       238

文件140 参保人员信息更正申报表                                                       241

文件141 员工年度福利统计表                                                              242

文件142 医疗费用申报表                                                                     245

文件143 生育保险费用申报表                                                              246

文件144 失业保险申报表                                                                     246

文件145 员工补交养老保险费用申请表                                                247

文件146 参加社会保险人员增减表                                                       247

 

第16章 员工薪资管理

文件147 员工工资明细表                                                                     250

文件148 员工工资查询表                                                                     252

文件149 员工工资水平分布表                                                              255

文件150 员工工资水平分布图                                                              256

文件151 员工季度奖金表                                                                     259

文件152 岗位薪酬结构表                                                                     259

文件153 工资变更申请书                                                                     260

文件154 员工银行账户转账表                                                              261

 

第17章 员工意见调查与统计

文件155 员工意见调查单                                                                     264

文件156 记录调查结果                                                                        269

文件157 参与调查者年龄构成比图                                                       272

文件158 抽样分析员工对工作的满意度                                                277

文件159 年龄与关注面关系抽样回归分析                                            280

文件160 员工绩效考评标准意愿比图                                                   283

文件161 关注面与学历的相关性分析                                                   283

文件162 学历与工作紧迫性相关性分析                                                284

文件163 有发展前途比重                                                                     284

文件164 调查员工学历分布图                                                              285

 

第18章 公司领导日程管理

文件165 领导的日程安排表                                                                 288

文件166 领导预约记录表                                                                     290

文件167 日程检查表                                                                            293

文件168 领导预约变更记录表                                                              297

文件169 客户接洽记录表                                                                     300

文件170 个人指示·命令确认表                                                          301

文件171 上司、部属休假掌握表                                                          301

文件172 文件督办通知单                                                                     302

 

第19章 会议管理

文件173 会议室使用申请表                                                                 304

文件174 会议室使用登记表                                                                 305

文件175 会议议程安排表                                                                     308

文件176 会议出席记录表                                                                     311

文件177 会议记录表                                                                            313

文件178 会议纪要                                                                               315

文件179 月份经营会议表                                                                     315

文件180 部门经营会议表                                                                     316

文件181 员工提案评定表                                                                     316

文件182 年度行事判定会议表                                                              317

 

第20章 文件管理

文件183 收发文件登记簿                                                                     320

文件184 加密重要文件                                                                        321

文件185 以邮件发送文件                                                                     323

文件186 文件的共享与保护                                                                 326

文件187 资料销毁申请表                                                                     329

文件188 销毁文件列表                                                                        330

文件189 归档的文件表                                                                        331

文件190 整理的文件表                                                                        331

 

第21章 公司安全卫生管理

文件191 外来人员进出登记表                                                              334

文件192 清洁工作安排表                                                                     337

文件193 安全工作检查表                                                                     340

文件194 意外事故报告表                                                                     343

文件195 安全管理实施计划表                                                              348

文件196 工伤事故报告表                                                                     350

文件197 安全隐患整改通知单                                                              351

文件198 事故调查报告表                                                                     351

文件199 卫生区域划分表                                                                     352

文件200 赔偿处理调查报告书                                                              352

 

第22章 公司车辆管理

文件201 车辆资料表                                                                            354

文件202 车位月保统计表                                                                     357

文件203 油料库存月报表                                                                     362

文件204 车辆费用支出月报表                                                              365

文件205 车辆租借申请表                                                                     369

文件206 汽车驾驶日报表                                                                     369

文件207 车辆作业检点表                                                                     370

文件208 车辆使用状况报表分析                                                          370

 

第23章 函数在员工档案管理中的应用

函数1 判断员工身份证号码位数

            （LEN 、TRUE函数）                                                    372

函数2 查找员工职务和工龄

            （VLOOKUP、FALSE函数）                                           372

函数3 计算员工虚岁年龄

            （DATEDIF、TODAY函数）                                           373

函数4 计算出员工年龄

            （YEAR、TODAY函数）                                                 374

函数5 从员工身份证号码中提取出生年份

            （MID、IF、LEN函数）                                                 374

函数6 从身份证号码中提取完整的出生日期

            （MID、IF、LEN、CONCATENATE函数）                     375

函数7 从身份证号码中判别性别

            （MID、IF、LEN、MOD函数）                                     376

函数8 验证员工身份证号码的位数

            （LEN函数）                                                                  376

函数9 根据员工姓名自动提取其姓

            （LEN函数）                                                                  377

函数10 统计出男性或女性员工的人数

              （COUNTIF函数）                                                      377

函数11 员工生日到期提醒

              （DAY、MONTH、TODAY、YEAR、IF函数）            378

函数12 员工合同到期提醒

              （DAY、MONTH、TODAY、YEAR、IF函数）            379

函数13 根据员工年龄判断是否退休

              （OR、AND函数）                                                     379

函数14 根据职工性别和职务判断退休年龄

              （OR、IF函数）                                                         380

函数15 统计员工试用期到期的人数

              （COUNTIF、IF、TODAY函数）                                380

函数16 统计出指定部门、指定职务的员工人数

              （SUMPRODUCT函数）                                              381

函数17 计算生产部门人数和运输部门人数

              （SUM、NOT、ISERR、FIND函数）                          381

函数18 从员工E-mail地址中提取账号

              （MID、IF、LEN函数）                                             382

函数19 根据员工代码返回部门名称

              （IF、LEN函数）                                                        383

函数20 汇总车间女性人数

              （SUMIFS函数）                                                        383

函数21 计算车间男性与女性员工的差

              （SUM 、SUMIFS函数）                                            384

函数22 计算员工参保人数

              （SUMPRODUCT函数）                                              384

函数23 汇总生产一车间男性参保人数

              （SUMPRODUCT函数）                                              384

函数24 根据员工身份证统计男性人数

              （SUM、MOD、LEFT、RIGHT函数）                        385

函数25 计算女员工最大年龄

              （MAX函数）                                                             385

函数26 将员工身份证号码转换为出生日期序号

              （DATE 、MID 、LEN函数）                                     386

函数27 计算员工转正时间

              （DATE 、YEAR 、MONTH、DAY函数）                  386

函数28 提示员工合同续约

              （TEXT 、EDATE、TODAY函数）                             387

函数29 计算员工可休假天数

              （MIN 、IF、DATEDIF、TODAY函数）                     387

函数30 根据员工姓名查找身份证号码

              （LOOKUP）                                                               388

函数31 计算生产部人数和非生产部人数

              （SUM、NOT、ISERR、FIND函数）                          388

函数32 根据员工身份证号码汇总男、女员工人数

              （SUM、ISODD、ISEVEN、MID函数）                      389

函数33 计算出员工工龄（YEAR、MID函数）                                     390

函数34 计算年假占全年工作日的百分比

              （NETWORKDAYS函数）                                           390

函数35 求25岁以上男性人数

              （SUMPRODUCT 函数）                                             391

函数36 汇总销售部男性参保人数

              （SUMPRODUCT函数）                                              391

 

第24章 函数在员工考评中的应用

函数37 计算员工工作品行考核总分

              （SUM函数）                                                              394

函数38 对员工的技能考核进行星级评定

              （IF函数）                                                                  394

函数39 考评员工成绩是否达标

              （IF函数）                                                                  395

函数40 对员工考核成绩进行综合评定

              （OR、AND函数）                                                     395

函数41 计算每位员工的总考核成绩

              （SUM函数）                                                              396

函数42 计算每位员工的平均考核成绩

              （AVERAGE函数）                                                      396

函数43 对员工考核成绩进行名次排名

              （RANK函数）                                                            397

函数44 同时满足多个条件求员工考核平均成绩

              （AVERAGE、IF函数）                                               397

函数45 隔列来计算各员工的平均考核成绩

              （AVERAGE、IF、MOD、COLUMN函数）                  398

函数46 使用“★"为考评结果标明等级

              （REPT函数）                                                            398

函数47 考评销售员的销售等级

              （CHOOSE、IF函数）                                                 399

函数48 统计特定考评平均分

              （DAVERAGE函数）                                                   400

函数49 根据员工的销售量进行业绩考核

              （IF函数）                                                                  400

函数50 统计前5名员工的平均成绩

              （LARGE、AVERAGE函数）                                       401

函数51 根据业绩计算需要发放多少奖金

              （SUM、IF函数）                                                       401

函数52 统计出指定部门获取奖金的人数

              （SUMPRODUCT函数）                                              401

函数53 统计出指定部门奖金大于固定值的人数

              （SUMPRODUCT函数）                                              402

函数54 计算周末奖金补贴

              （SUMPRODUCT、ROW、INDIRECT函数）              403

函数55 汇总行政部员工获奖次数

              （SUMPRODUCT函数）                                              403

函数56 计算员工年终奖

              （TEXT函数）                                                            404

函数57 根据达标率计算员工奖金

              （TEXT函数）                                                            404

函数58 计算生产部所有人员的平均获奖率

              （TEXT函数）                                                            405

函数59 计算超产奖

              （TEXT函数）                                                            405

函数60 根据工程的难度系数计算奖金

              （MIN函数）                                                              406

 

第25章 函数在员工考勤和工资统计中的应用

函数61 判断员工是否已签到

              （IF、ISNONTEXT函数）                                          408

函数62 自动返回考勤表标题

              （MONTH、TODAY函数）                                         408

函数63 根据当前日期数返回对应的考勤星期数

              （CHOOSE、WEEKDAY函数）                                    408

函数64 从卡机数据提取员工打卡时间

              （MID函数）                                                              409

函数65 根据卡机数据判断员工部门

              （CHOOSE、MATCH、RIGHT函数）                          410

函数66 计算员工的总加班时间

              （SUM函数）                                                              410

函数67 返回值班安排表中日期对应的星期数

              （WEEKDAY函数）                                                     411

函数68 罗列值班日期

              （MIN、IF、WEEKDAY、DATE、ROW函数）            411

函数69 累积员工每日得分（N、IF函数）                                           412

函数70 自动追加工龄工资

              （DATEDIF、TODAY函数）                                        413

函数71 根据工作时间计算12月工资

              （SUM、IF函数）                                                       413

函数72 计算每日工时工资

              （IF、WEEKDAY函数）                                              414

函数73 计算本日工时工资

              （HOUR SUM、TIMEVALUE 、ROUNDUP函数）        414

函数74 统计各部门工资总额

              （SUMIF函数）                                                          415

函数75 计算一车间女职工的平均工资

              （AVERAGE、IF函数）                                               416

函数76 计算一车间和三车间女职工的平均工资

              （AVERAGE、IF函数）                                               416

函数77 生成工资结算日期

              （TEXT、EOMONTH函数）                                       416

函数78 计算员工年资

              （MIN、DATEDIF、TODAY函数）                             417

函数79 计算所有员工的基本工资合计额

              （SUM函数）                                                              418

函数80 对销售部男性员工的工资求和

              （SUM函数）                                                              418

函数81 对2000到3000之间的工资求和

              （SUM、SUMIF函数）                                                418

函数82 求前三名和后三名的工资之和

              （LARGE、SMALL、SUMIF函数）                             419

函数83 对所有车间员工的工资求和

              （SUMIF函数）                                                          419

函数84 计算平均工资

              （ROUND、AVERAGEA函数）                                    419

函数85 根据员工工龄计算年资

              （CEILING、INT函数）                                              420

函数86 统计两倍工资的加班小时数（SUMPRODUCT、TEXT、

               ROW、INDIRECT、EOMONTH函数）                      420

函数87 计算个人所得税

              （IF、SUM函数）                                                       421

 

第26章 函数在客户资料管理中的应用

函数88 设置客户类型

              （IF函数）                                                                  424

函数89 划分客户受信等级

              （IF 函数）                                                                 424

函数90 自动生成客户称呼

              （LEFT 函数）                                                            425

函数91 更改客户公司名称

              （SUBSTITUTE 函数）                                               425

函数92 区分客户联系区号与号码

              （RIGHT 函数）                                                         426

函数93 从客户编码中提取合同号

              （RIGHT、LEN、SEARCH 函数）                               426

函数94 返回客户订单编号

              （N 函数）                                                                 427

函数95 找出消费次数最多的客户

              （MAX 、COUNTIF函数）                                         428

函数96 统计客户会员卡到期的人数

              （TODAY函数）                                                         428

函数97 统计来访公司或部门代表的总人数

              （DCOUNTA函数）                                                     428

函数98 给金卡和银卡客户按消费额派发赠品

              （IF函数）                                                                  429

函数99 对客户销售额进行排名

              （RANK 函数）                                                           430

函数100 创建客户E-Mail电子邮件链接地址

              （HYPERLINK 函数）                                                 430

 

第27章 函数在日常办公和费用管理中的应用

函数101 提取办公物品采购月份

              （MONTH函数）                                                        434

函数102 返回请购设备的应到日期

              （IF 函数）                                                                 434

函数103 计算公司借阅资料是否到期

              （IF 、TODAY函数）                                                 435

函数104 计算公司借阅资料过期天数

              （IF 、TODAY函数）                                                 435

函数105 统计所有办公物品的采购金额

              （SUMPRODUCT函数）                                              436

函数106 判断领用物品是否到期

              （IF、NOW函数）                                                      436

函数107 计算员工报销费用总额

              （SUM函数）                                                              437

函数108 求每季度办公费用支出金额

              （AVERAGE函数）                                                      437

 

【暂无此信息】

本书主要针对Excel在公司行政管理中的应用，在详细介绍了常用函数的同时，还提供了208个文件供读者使用。本书不仅是一本工具书，更是读者遇到困难寻求帮助时的模板提供者。