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