项目一 Excel 基础操作 ............................................................................................ 1__eol__学习目标 ............................................................................................................................... 1__eol__任务一 创建差旅费报销单 .............................................................................................. 2__eol__任务二 编制及保护差旅费报销单说明 ........................................................................ 13__eol__任务三 绘制部门架构图 ................................................................................................ 25__eol__任务四 拓展应用——掌握快捷键 ................................................................................. 44__eol__素养修习 ............................................................................................................................. 48__eol__岗位能力测评 ..................................................................................................................... 50__eol__项目二 员工薪酬核算 ............................................................................................ 51__eol__学习目标 ............................................................................................................................. 51__eol__任务一 编制人事信息数据表 ........................................................................................ 51__eol__任务二 编制工资表和工资汇总表 ................................................................................ 68__eol__任务三 拓展应用——数据有效性 ................................................................................. 77__eol__素养修习 ............................................................................................................................. 83__eol__岗位能力测评 ..................................................................................................................... 84__eol__项目三 账务处理 ................................................................................................... 85__eol__学习目标 ............................................................................................................................. 85__eol__任务一 整理凭证明细查询表 ........................................................................................ 86__eol__任务二 编制科目汇总表 ................................................................................................ 98__eol__任务三 编制资产负债表 ............................................................................................... 111__eol__任务四 编制利润表 ....................................................................................................... 116__eol__任务五 拓展应用——条件格式 ................................................................................... 129__eol__素养修习 ........................................................................................................................... 136__eol__岗位能力测评 ................................................................................................................... 137__eol__项目四 往来账款管理 .......................................................................................... 138__eol__学习目标 ........................................................................................................................... 138__eol__任务一 编制应收账款账龄分析表 .............................................................................. 138__eol__任务二 编制应付账款付款测算表 .............................................................................. 161__eol__任务三 拓展应用——数据透视表 ............................................................................... 180__eol__素养修习 ........................................................................................................................... 199__eol__岗位能力测评 ................................................................................................................... 200__eol__项目五 固定资产管理 .......................................................................................... 201__eol__学习目标 ............................................................................................................