| 用Excel的宏和VBA实现方便快捷的调查统计 |
| |
| 引用本文： | 王东燕. 用Excel的宏和VBA实现方便快捷的调查统计[J]. 办公自动化, 2010, 0(22): 44-47 |
| |
| 作者姓名： | 王东燕 |
| |
| 作者单位： | 天津市委党校计算机教研室; |
| |
| 摘 要： | 本文针对实际办公环境中常出现的统计调查统计中存在的问题,有针对性的提出非专业统计人员也可以实现的方法,该方法使用的是Excel的宏和VBA技术,并具有实现简单、界面友好、操作快捷、可以重复使用的特点。本文以学员选课为例,详细介绍如何实现调查统计程序,为提高办公效率和统计的准确性提供了非常好的解决方法。
|
| 关 键 词： | Excel宏VBA 办公自动化 统计 调查 |
Use of Excel of Macros and VBA Realize Convenient Investigation and Statistics |
| |
| Wang Dongyan. Use of Excel of Macros and VBA Realize Convenient Investigation and Statistics[J]. Office Automation, 2010, 0(22): 44-47 |
| |
| Authors: | Wang Dongyan |
| |
| Affiliation: | Wang Dongyan(Tianjin Municipal Party Committee Party School Computer Teaching Tianjin 300191) |
| |
| Abstract: | Based on the actual working environment of statistical investigation statistics,the existing problems are put forward the statistics personnel can also achieve non-professional,this method using the method of the macro is Excel technology,and with VBA simple and friendly interface,the operation is quick and can be reused.In this course,for example,students are introduced in detail how to realize the investigation and statistical procedure,to improve the efficiency and accuracy of statistics office provides ... |
| |
| Keywords: | Excel macro VBA Office automation Statistics Research |
| 本文献已被 CNKI 等数据库收录！ |
|
