Excel在财务中的应用

图书标准信息

• 作者 高晓林
• 出版社 电子工业出版社
• 出版时间 2023-03
• 版次 1
• ISBN 9787121451034
• 定价 59.00元
• 装帧 其他
• 开本 其他
• 纸张 胶版纸
• 页数 264页
• 字数 422.4千字

【内容简介】

本教材共十二章，第一章介绍了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 

一、创建记账凭证·························································································.27 

二、编辑记账凭证·························································································.32 

三、优化凭证号····························································································.35 

四、输入后续凭证数据 ···················································································.37 

第二节 日记账的生成 ·························································································.38 

一、设置现金日记账格式 ················································································.38 

二、登记现金日记账 ······················································································.39 

第三节 科目汇总表的生成 ···················································································.42 

一、设置科目汇总表格式 ················································································.42 

二、获取本期发生额 ······················································································.42 

第四节 总分类账的生成 ······················································································.48 

一、设置总分类账格式 ···················································································.48 

二、录入期初数····························································································.50 

三、计算总账科目本期发生额 ··········································································.50 

四、计算期末数····························································································.51 

本章实训 ···········································································································.52 

第三章 Excel 在财务报表中的应用········································································.53 

第一节 资产负债表的编制 ···················································································.54 

一、设置资产负债表格式 ················································································.54 

二、获取一级科目期初数 ················································································.56 

三、计算资产负债表期初数 ·············································································.59 

四、获取发生额····························································································.61 

五、计算资产负债表期末数 ·············································································.64 

第二节 利润表的编制 ·························································································.66 

一、设置利润表格式 ······················································································.66 

二、获取本期发生额 ······················································································.66 

三、计算利润表本期金额 ················································································.69 

本章实训 ··················································································