项目一 Excel 基础操作 ..................................................................................................... 1__eol__任务1.1 编制差旅费报销单 ..................................................................................................... 1__eol__任务1.2 编制及保护差旅费报销单说明 ............................................................................... 12__eol__任务1.3 绘制部门架构图 ....................................................................................................... 23__eol__任务1.4 拓展应用——掌握快捷键 ....................................................................................... 39__eol__岗位能力测评 ............................................................................................................................. 43__eol__项目二 员工薪酬核算 ..................................................................................................... 44__eol__任务2.1 编制人事信息数据表 ............................................................................................... 44__eol__任务2.2 编制员工工资表 ....................................................................................................... 63__eol__任务2.3 拓展应用——数据有效性 ....................................................................................... 70__eol__岗位能力测评 ............................................................................................................................. 74__eol__项目三 账务处理与分析 .................................................................................................. 75__eol__任务3.1 编制科目代码表 ....................................................................................................... 75__eol__任务3.2 编制凭证明细查询表 ............................................................................................... 85__eol__任务3.3 编制科目汇总表 ....................................................................................................... 92__eol__任务3.4 编制成本费用分析表 ............................................................................................. 104__eol__任务3.5 拓展应用——VLOOKUP 函数 ............................................................................. 110__eol__岗位能力测评 ........................................................................................................................... 115__eol__项目四 往来账款管理 ................................................................................................... 116__eol__任务4.1 编制应收账款账龄分析表 ..................................................................................... 116__eol__任务4.2 编制应付账款测算表 ............................................................................................. 138__eol__任务4.3 拓展应用——数据透视表 ..................................................................................... 158__eol__岗位能力测评 ........................................................................................................................... 177__eol__Excel 在财务中的应用__eol__X__eol__项目五 固定资产管理 ................................................................................................... 179__eol__任务5.1 创建固定资产清单 ................................................................................................. 179__eol__任务5.2 拓展应用——高级筛选 ......................................................................................... 191__eol__岗位能力测评 ........................................................................................................................... 193__eol__项目六 编制会计报表 ................................................................................................... 194__eol__任务6.1 编制资产负债表 ..................................................................................................... 194__eol__任务6.2 编制利润表 ............................................................................................................. 200__eol__任务6.3 拓展应用——条件格式 ......................................................................................... 209__eol__岗位能力测评 .......................................................................................................................