| 统计工作中几个Excel常用函数的使用体会 |
| |
| 引用本文： | 李晓辉. 统计工作中几个Excel常用函数的使用体会[J]. 经济研究导刊, 2014, 0(2): 235-236 |
| |
| 作者姓名： | 李晓辉 |
| |
| 作者单位： | 新疆天业股份有限公司,新疆 石河子,832000 |
| |
| 摘 要： | 在基层统计的日常工作中,经常遇到加权求和的计算,如在计算企业能源消费量或工业产值时,还经常需要在会计报表或其他统计表中查找满足条件的数据。为提高基层统计工作效率,主要阐述使用SUMPRODUCT、HLOOKUP和MATCH函数提高工作效率的体会。
|
| 关 键 词： | Excel 函数 能源消费统计 加权求和 |
Experience from the use of the Excel function in the statistical work |
| |
| LI Xiao-hui. Experience from the use of the Excel function in the statistical work[J]. Economic Research Guide, 2014, 0(2): 235-236 |
| |
| Authors: | LI Xiao-hui |
| |
| Affiliation: | LI Xiao-hui (Xinjiang Tianye Limited by Share Ltd, Shihezi 832000, China) |
| |
| Abstract: | At the grassroots level statistical work,often encounter calculating weighted sum,as in the calculation of enterprise energy con-sumption or industrial production,often need to in the accounting statements or other statistical table to find a satisfying the condition data. In order to improve the work efficiency of basic statistics,mainly describes the use of SUMPRODUCT,HLOOKUP and MATCH function to improve the work efficiency. |
| |
| Keywords: | Excel Excel function energy consumption statistics weighted sum |
| 本文献已被 CNKI 维普 等数据库收录！ |
|
