Excel在财务中的应用

本教材共十二章，章介绍了Excel基础知识，第二章和第三章结合会计工作的账务处理程序，第四章介绍了Excel在薪酬管理中的应用第五章介绍了Excel在应收账款管理中的应用，第六章介绍了Excel在存货管理中的应用，第七章介绍了Excel在固定资产管理中的应用，第八章介绍了Excel在成本费用管理中的应用，第九章介绍了Excel在本量利分析中的应用，第十章介绍了Excel在投资决策中的应用，第十一章介绍了Excel在筹资决策中的应用，第十二章介绍了Excel在财务分析中的应用。

本教材共十二章，第一章介绍了Excel基础知识，第二章和第三章结合会计工作的账务处理程序，第四章介绍了Excel在薪酬管理中的应用第五章介绍了Excel在应收账款管理中的应用，第六章介绍了Excel在存货管理中的应用，第七章介绍了Excel在固定资产管理中的应用，第八章介绍了Excel在成本费用管理中的应用，第九章介绍了Excel在本量利分析中的应用，第十章介绍了Excel在投资决策中的应用，第十一章介绍了Excel在筹资决策中的应用，第十二章介绍了Excel在财务分析中的应用。

高晓林 女，西安财经大学商学院会计系教授，陕西省审计厅特约审计员。主持或参与国家社科基金项目、中国总会计师协会、陕西省教育厅、陕西财政厅、陕西省社科联重大理论和现实问题研究等多项课题，在《中南财经政法大学学报》、《生产力研究》、《财会月刊》等学术期刊发表论文30余篇，作为主编在西安交通大学出版社、立信会计出版总社等出版《高级财务会计》教材数版。

目 录 
章 Excel 基础知识 ··························································································.1 
节 Excel 认知·······························································································.2 
一、数据输入与编辑 ·······················································································.2 
二、数据管理与分析 ·······················································································.6 
第二节 Excel 常用公式与函数 ···············································································.14 
一、Excel 常用公式 ·······················································································.14 
二、数学与统计函数 ······················································································.18 
三、逻辑与文本函数 ······················································································.19 
四、日期与时间函数 ······················································································.20 
本章实训 ···········································································································.21 
第二章 Excel 在凭证与账簿中的应用 ····································································.23 
节 记账凭证的编制 ······················································································.24 
一、创建记账凭证··············································································