搜索结果: 1-7 共查到“法学 Excel”相关记录7条 . 查询时间(0.062 秒)
Excel SQL在工资数据统计和汇总中的应用
Excel SQL 工资 汇总 统计
2015/5/28
企业财务人员在处理工资汇总等问题时,如果单独使用Excel统计汇总功能会非常烦琐并且容易出错。本文结合实例,将Excel SQL和Excel统计汇总功能如数据透视表等结合起来,快速准确处理了工资汇总、先筛选后汇总等问题。其最大的优点是,当数据源改变时只需点击刷新按钮即可得到重新计算的结果,非常准确和方便。
持有至到期投资计算的Excel建模
Excel 持有至到期投资 计算模型
2015/7/24
企业会计准则对持有至到期投资这类金融资产的核算引入了摊余成本的概念,并在收益计算时要求采用实际利率法。摊余成本和实际利率是持有至到期投资会计核算的两大难点,其数据计算过程十分复杂,给广大会计实务工作者处理此类业务带来了困难。本文利用Excel的财务建模建立计算模型,实现数据计算的自动化,简化了相关的会计核算工作。
固定资产更新决策的EXCEL模型
固定资产更新 年金成本 决策 模型
2015/7/6
固定资产使用年限长、投资数额大等特点使得其更新决策尤需谨慎,而且固定资产更新的计算方法也较为复杂。本文运用Excel对固定资产更新决策模型进行设计,旨在提高决策制定效率和准确性。
An Excel spreadsheet for the decomposition of a difference between two values of an aggregate demographic measure by stepwise replacement running from young to old ages
Excel spreadsheet aggregate demographic measure old ages
2014/3/21
A general algorithm for the decomposition of differences between two values of an aggregate demographic measure of age and other dimensions is realized as Excel/VBA. It assumes that the aggregate meas...
Reshaping of Human Fertility Database data from long to wide format in Excel
Human Fertility Database data format Excel
2014/3/21
In the Human Fertility Database (HFD, 2012), age-specific data are presented in the long format, with both the years (or the years of the mothers’ births) and the mothers’ ages at birth in descending ...
Age-decomposition of a difference between two populations for any life-table quantity in Excel
Age-decomposition difference two populations any life-table quantity Excel
2014/3/21
We provide a simple VBA/Excel program that decomposes by age a difference between two values of a life-table based quantity. For example, one might want to know what are contributions of different age...