未读消息消息

购物车

我的订单

个人中心

店铺

我的订单收藏

拍卖

拍卖交易我的竞拍收藏

我的好友资金账户

卖家中心

客服 |

帮助中心 9:00-20:30 在线留言

客服电话

010-89648155

服务时间

客服咨询 8:00-21:00

纠纷处理 9:00-21:00

图书审核 9:00-18:00

监督与建议

请选择

手机孔网

Excel在财务中的应用

作者: 高晓林

出版社: 电子工业出版社

出版时间: 2023-03

版次: 1

ISBN: 9787121451034

定价: 59.00

装帧: 其他

开本: 其他

纸张: 胶版纸

页数: 264页

分类: 教材教辅考试>教材>大学教材>经济

2人买过

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

本章实训 ··················································································
内容简介:
本教材共十二章，第一章介绍了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

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

查看详情

Excel在财务中的应用

内容简介:

作者简介:

目录: