Excel在財務(wù)中的應(yīng)用（第2版）

目 錄
前言緒論.......................................................................................................................1
項目一 Excel制作財務(wù)會計表格 .................................................................................................17
任務(wù)一創(chuàng)建并保存工作表.........................................................................................................17
任務(wù)二保護及打印工作表.........................................................................................................18
任務(wù)三單元格操作 ..............................................................................................................22
任務(wù)四提取職工出生年月和計算工齡............................................................................................28
任務(wù)五制定薪金等級 .........................................................................................................31
實訓(xùn)一......................................................................................................................34
項目二 Excel在賬務(wù)處理中的應(yīng)用 ............................................................................................37
任務(wù)一建立賬套..............................................................................................................43
任務(wù)二設(shè)置會計科目 .........................................................................................................44
任務(wù)三設(shè)置“201811憑證”工作表..............................................................................................50
任務(wù)四科目匯總及生成總賬....................................................................................................57
任務(wù)五總賬匯總表的系列操作 .................................................................................................60
實訓(xùn)二......................................................................................................................65
項目三 Excel在財務(wù)報表中的應(yīng)用 ............................................................................................69
任務(wù)一編制資產(chǎn)負債表 .......................................................................................................71
任務(wù)二編制利潤表和損益類科目匯總表........................................................................................81
實訓(xùn)三......................................................................................................................87
項目四 Excel在職工薪資管理中的應(yīng)用 ....................................................................................89
任務(wù)一建立工資管理系統(tǒng)表格 .................................................................................................89
任務(wù)二計算“職工工資匯總表” ...............................................................................................96
任務(wù)三薪資的查詢與工資條制作 ...............................................................................................104
實訓(xùn)四......................................................................................................................116
項目五 Excel在固定資產(chǎn)管理中的應(yīng)用 .................................................................................. 119
任務(wù)一固定資產(chǎn)臺賬的編制......................................................................................................... 120
任務(wù)二固定資產(chǎn)的折舊計提......................................................................................................... 127
任務(wù)三固定資產(chǎn)卡片的編制......................................................................................................... 140
任務(wù)四固定資產(chǎn)的調(diào)整管理......................................................................................................... 143
任務(wù)五固定資產(chǎn)分析 ...............................................................................................................147
實訓(xùn)五 ........................................................................................................................... 154
項目六 Excel在進銷存管理中的應(yīng)用 .....................................