項目一 Excel 基礎(chǔ)操作 ..................................................................................................... 1 任務(wù)1.1 編制差旅費報銷單 ..................................................................................................... 1 任務(wù)1.2 編制及保護差旅費報銷單說明 ............................................................................... 12 任務(wù)1.3 繪制部門架構(gòu)圖 ....................................................................................................... 23 任務(wù)1.4 拓展應(yīng)用——掌握快捷鍵 ....................................................................................... 39 崗位能力測評 ............................................................................................................................. 43 項目二 員工薪酬核算 ..................................................................................................... 44 任務(wù)2.1 編制人事信息數(shù)據(jù)表 ............................................................................................... 44 任務(wù)2.2 編制員工工資表 ....................................................................................................... 63 任務(wù)2.3 拓展應(yīng)用——數(shù)據(jù)有效性 ....................................................................................... 70 崗位能力測評 ............................................................................................................................. 74 項目三 賬務(wù)處理與分析 .................................................................................................. 75 任務(wù)3.1 編制科目代碼表 ....................................................................................................... 75 任務(wù)3.2 編制憑證明細(xì)查詢表 ............................................................................................... 85 任務(wù)3.3 編制科目匯總表 ....................................................................................................... 92 任務(wù)3.4 編制成本費用分析表 ............................................................................................. 104 任務(wù)3.5 拓展應(yīng)用——VLOOKUP 函數(shù) ............................................................................. 110 崗位能力測評 ........................................................................................................................... 115 項目四 往來賬款管理 ................................................................................................... 116 任務(wù)4.1 編制應(yīng)收賬款賬齡分析表 ..................................................................................... 116 任務(wù)4.2 編制應(yīng)付賬款測算表 ............................................................................................. 138 任務(wù)4.3 拓展應(yīng)用——數(shù)據(jù)透視表 ..................................................................................... 158 崗位能力測評 ........................................................................................................................... 177 Excel 在財務(wù)中的應(yīng)用 X 項目五 固定資產(chǎn)管理 ................................................................................................... 179 任務(wù)5.1 創(chuàng)建固定資產(chǎn)清單 ................................................................................................. 179 任務(wù)5.2 拓展應(yīng)用——高級篩選 ......................................................................................... 191 崗位能力測評 ........................................................................................................................... 193 項目六 編制會計報表 ................................................................................................... 194 任務(wù)6.1 編制資產(chǎn)負(fù)債表 ..................................................................................................... 194 任務(wù)6.2 編制利潤表 ............................................................................................................. 200 任務(wù)6.3 拓展應(yīng)用——條件格式 ......................................................................................... 209 崗位能力測評 ........................................................................................................................... 217 項目七 進銷存數(shù)據(jù)分析 ................................................................................................ 218 任務(wù)7.1 編制采購成本動態(tài)分析表 ..................................................................................... 218 任務(wù)7.2 編制銷售預(yù)測分析表 ............................................................................................. 231 任務(wù)7.3 編制材料成本匯總表 ............................................................................................. 241 任務(wù)7.4 拓展應(yīng)用——SUMPRODUCT 函數(shù) ..................................................................... 251 崗位能力測評 ........................................................................................................................... 253 項目八 籌資與投資決策分析 ......................................................................................... 254 任務(wù)8.1 創(chuàng)建投資決策模型 ................................................................................................. 254 任務(wù)8.2 創(chuàng)建長期借款籌資決策分析模型 ......................................................................... 261 任務(wù)8.3 拓展應(yīng)用——圖表的制作 ..................................................................................... 274 崗位能力測評 ........................................................................................................................... 281 參考文獻 ......................................................................................................................... 282