【正文】 財(cái)務(wù)精英俱樂部更多資料免費(fèi)下載 Excel 財(cái)務(wù)管理中的應(yīng)用 —— 常用函數(shù) 篇 Excel 財(cái)務(wù)管理中的應(yīng)用 —— 常用函數(shù)篇 2 目 錄 一、函數(shù)應(yīng)用基礎(chǔ) ......................................................................................................................................... 1 （一）函數(shù)和公式 ......................................................................................................................................... 1 ................................................................................................................................................. 1 ................................................................................................................................................. 1 （二）函數(shù)的參數(shù) ..........................................................................................................................................1 ............................................................................................................................................................. 1 ......................................................................................................................................................... 1 ............................................................................................................................................................. 1 誤值 ......................................................................................................................................................... 1 ................................................................................................................................................. 1 ..................................................................................................................................................... 2 ................................................................................................................................................. 2 （三）函數(shù)輸入方法 ..................................................................................................................................... 2 1.“插入函數(shù)”對話框 ................................................................................................................................. 2 ................................................................................................................................................. 3 二、函數(shù)速查一覽 ..........................................................................................................................................3 (一 )數(shù)據(jù)庫函數(shù) .............................................................................................................................................. 3 ..................................................................................................................................................... 3 ......................................................................................................................................................... 3 ....................................................................................................................................................... 3 ............................................................................................................................................................. 3 ............................................................................................................................................................. 3 ............................................................................................................................................................. 3 ..................................................................................................................................................... 3 ......................................................................................................................................................... 3 ....................................................................................................................................................... 4 ........................................................................................................................................................... 4 ........................................................................................................................................................... 4 Excel 財(cái)務(wù)管理中的應(yīng)用 —— 常用函數(shù)篇 3 ......................................................................................................................................................... 4 ......................................................................................................................................... 4 (二 )日期與時(shí)間函數(shù) ...................................................................................................................................... 4 ............................................................................................................................................................. 4 ................................................................................................................................................. 4 ............................................................................................................................................................... 4 ....................................................................................................................................................... 5 ........................................................................................................................................................... 5 ....................................................................................................................................................... 5 .................................................................................................