新書推薦：
《
未来漫游指南：昨日科技与人类未来
》
售價：NT$
445.0
《
新民说·逝去的盛景：宋朝商业文明的兴盛与落幕（上下册）
》
售價：NT$
790.0
《
我从何来：自我的心理学探问
》
售價：NT$
545.0
《
失败：1891—1900 清王朝的变革、战争与排外
》
售價：NT$
390.0
《
送你一匹马（“我不求深刻，只求简单。”看三毛如何拒绝内耗，为自己而活）
》
售價：NT$
295.0
《
秦汉史讲义
》
售價：NT$
690.0
《
万千心理·我的精神分析之道：复杂的俄狄浦斯及其他议题
》
售價：NT$
475.0
《
荷马：伊利亚特（英文）-西方人文经典影印21
》
售價：NT$
490.0
|
| 內容簡介： |
|
本教材共十二章，第一章介绍了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
新書上架
