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
本章实训 ··················································································
查看详情
-
全新
山东省泰安市
平均发货25小时
成功完成率90.45%
-
全新
河北省保定市
平均发货27小时
成功完成率90.38%
-
全新
河北省保定市
平均发货27小时
成功完成率90.38%
-
全新
河北省保定市
平均发货29小时
成功完成率89.6%
-
全新
河北省保定市
平均发货28小时
成功完成率92.19%
-
全新
北京市海淀区
平均发货16小时
成功完成率88.88%
-
全新
河北省廊坊市
平均发货26小时
成功完成率87.33%
-
全新
河北省保定市
平均发货27小时
成功完成率90.38%
-
全新
北京市朝阳区
平均发货13小时
成功完成率96.35%
-
全新
河北省保定市
平均发货27小时
成功完成率90.38%
-
全新
河北省保定市
平均发货24小时
成功完成率90.21%
-
全新
河北省保定市
平均发货25小时
成功完成率87.89%
-
全新
北京市通州区
平均发货17小时
成功完成率90.2%
-
全新
广东省广州市
平均发货10小时
成功完成率95.21%
-
全新
浙江省嘉兴市
平均发货12小时
成功完成率94.87%
-
全新
河北省保定市
平均发货16小时
成功完成率91.65%
-
全新
天津市东丽区
平均发货19小时
成功完成率91.26%
-
全新
河北省保定市
平均发货17小时
成功完成率91.82%
-
全新
四川省成都市
平均发货54小时
成功完成率84.6%
-
全新
河北省保定市
平均发货12小时
成功完成率88.6%
-
全新
山东省泰安市
平均发货15小时
成功完成率94.31%
-
全新
河北省保定市
平均发货20小时
成功完成率88.81%
-
全新
北京市朝阳区
平均发货11小时
成功完成率96.28%
-
全新
北京市朝阳区
平均发货13小时
成功完成率94.08%
-
全新
四川省成都市
平均发货21小时
成功完成率89.77%
-
全新
北京市海淀区
平均发货40小时
成功完成率70.88%
-
全新
广东省广州市
平均发货15小时
成功完成率91.22%
-
全新
河北省保定市
平均发货25小时
成功完成率87.5%
-
全新
四川省成都市
平均发货32小时
成功完成率84.57%
-
全新
北京市朝阳区
平均发货29小时
成功完成率81.31%
-
全新
河北省保定市
平均发货28小时
成功完成率91.19%
-
全新
河北省保定市
平均发货17小时
成功完成率91.82%
-
全新
浙江省嘉兴市
平均发货9小时
成功完成率95.32%
-
全新
北京市朝阳区
平均发货16小时
成功完成率85.69%
-
全新
河北省保定市
平均发货25小时
成功完成率93.57%
-
全新
北京市朝阳区
平均发货13小时
成功完成率96.35%
-
全新
江苏省南京市
平均发货6小时
成功完成率98.53%
-
全新
河北省保定市
平均发货23小时
成功完成率89.91%
-
全新
河北省保定市
平均发货20小时
成功完成率88.81%
-
全新
河北省保定市
平均发货33小时
成功完成率85.26%
-
全新
广东省广州市
平均发货17小时
成功完成率93.76%
-
全新
广东省广州市
平均发货16小时
成功完成率91.73%
-
全新
江苏省南京市
平均发货6小时
成功完成率95.11%
-
全新
河北省廊坊市
平均发货19小时
成功完成率93.92%
-
全新
北京市丰台区
平均发货28小时
成功完成率87.01%
-
全新
山东省泰安市
平均发货21小时
成功完成率91.32%
-
全新
河北省保定市
平均发货12小时
成功完成率88.6%
-
全新
河北省保定市
平均发货26小时
成功完成率86.67%
-
全新
河北省保定市
平均发货27小时
成功完成率88.62%
-
全新
天津市津南区
平均发货13小时
成功完成率86.56%