新書推薦：
《
大宋理财：青苗法与王安石的金融帝国（全彩插图本）
》
售價：HK$
109.8
《
安全感是内心长出的盔甲
》
售價：HK$
67.0
《
快人一步：系统性能提高之道
》
售價：HK$
110.9
《
我们为什么会做梦：让梦不再神秘的新科学
》
售價：HK$
77.3
《
算法图解（第2版）
》
售價：HK$
78.2
《
科学的奇幻之旅
》
售價：HK$
77.3
《
画艺循谱：晚明的画谱与消闲
》
售價：HK$
143.4
《
新民说·现实政治史：从马基雅维利到基辛格
》
售價：HK$
99.7
|
| 內容簡介： |
|
本教材共十二章，第一章介绍了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
本章实训 ··················································································
|
|
購物車/收銀台(0) | 在線留言板
| 付款方式
| 運費計算
| 聯絡我們
| 幫助中心 |
加入書簽
HOME
新書上架
