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
本章实训 ··················································································
查看详情
-
全新
北京市朝阳区
平均发货13小时
成功完成率96.02%
-
全新
北京市朝阳区
平均发货13小时
成功完成率94.37%
-
全新
广东省广州市
平均发货7小时
成功完成率94.68%
-
全新
北京市通州区
平均发货9小时
成功完成率89.02%
-
全新
北京市海淀区
平均发货9小时
成功完成率93.31%
-
全新
广东省广州市
平均发货17小时
成功完成率88.25%
-
全新
湖北省武汉市
平均发货21小时
成功完成率75.27%
-
全新
河北省保定市
平均发货32小时
成功完成率84.56%
-
全新
-
全新
江苏省南京市
平均发货6小时
成功完成率98.48%
-
全新
江苏省无锡市
平均发货8小时
成功完成率96.19%
-
全新
河北省保定市
平均发货27小时
成功完成率87.36%
-
全新
四川省成都市
平均发货21小时
成功完成率89.37%
-
全新
北京市朝阳区
平均发货13小时
成功完成率96.02%
-
全新
北京市朝阳区
平均发货13小时
成功完成率96.02%
-
全新
北京市朝阳区
平均发货12小时
成功完成率96.2%
-
全新
江苏省宿迁市
平均发货20小时
成功完成率89.08%
-
全新
北京市通州区
平均发货9小时
成功完成率94.79%
-
全新
河北省保定市
平均发货14小时
成功完成率91.51%
-
全新
北京市房山区
平均发货34小时
成功完成率83.89%
-
全新
河北省保定市
平均发货32小时
成功完成率87.12%
-
全新
湖北省武汉市
平均发货23小时
成功完成率82.55%
-
全新
浙江省嘉兴市
平均发货12小时
成功完成率94.69%
-
全新
广东省广州市
平均发货9小时
成功完成率87.34%
-
全新
浙江省嘉兴市
平均发货9小时
成功完成率94.8%
-
全新
北京市东城区
平均发货10小时
成功完成率95.43%
-
全新
江苏省无锡市
平均发货9小时
成功完成率94.72%
-
全新
北京市房山区
平均发货10小时
成功完成率56.52%
-
全新
北京市房山区
平均发货10小时
成功完成率56.52%
-
全新
山东省泰安市
平均发货7小时
成功完成率86.55%
-
全新
上海市黄浦区
平均发货10小时
成功完成率94.97%
-
全新
河北省保定市
平均发货18小时
成功完成率82.58%
-
全新
北京市丰台区
平均发货7小时
成功完成率92.02%
-
全新
湖北省武汉市
平均发货23小时
成功完成率91.74%
-
全新
北京市通州区
平均发货9小时
成功完成率91.12%
-
全新
山东省泰安市
平均发货12小时
成功完成率94.52%
-
全新
北京市丰台区
平均发货25小时
成功完成率84.99%
-
全新
河北省保定市
平均发货18小时
成功完成率89.96%
-
全新
河北省保定市
平均发货16小时
成功完成率91.38%
-
全新
河北省廊坊市
平均发货19小时
成功完成率93.31%
-
全新
河北省保定市
平均发货9小时
成功完成率87.31%
-
全新
河北省保定市
平均发货9小时
成功完成率84.21%
-
全新
天津市东丽区
平均发货19小时
成功完成率90.82%
-
全新
山东省泰安市
平均发货12小时
成功完成率94.52%
-
全新
河北省保定市
平均发货16小时
成功完成率80.48%
-
Excel在财务中的应用
所有图书均为正版新书,库存书,ISBN匹配图片偶尔会有误差,订单以ISBN码为准,套装@合集价格低的实为单本,版本有疑问先咨询下再下单
全新
河南省开封市
平均发货18小时
成功完成率79.52%
-
全新
江西省九江市
平均发货10小时
成功完成率78.52%
-
全新
北京市海淀区
平均发货42小时
成功完成率69.7%
-
全新
浙江省嘉兴市
平均发货11小时
成功完成率92.81%
-
全新
湖北省武汉市
平均发货20小时
成功完成率89.9%