摘要
本文针对实际办公环境中常出现的统计调查统计中存在的问题,有针对性的提出非专业统计人员也可以实现的方法,该方法使用的是Excel的宏和VBA技术,并具有实现简单、界面友好、操作快捷、可以重复使用的特点。本文以学员选课为例,详细介绍如何实现调查统计程序,为提高办公效率和统计的准确性提供了非常好的解决方法。
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 a very good solution.