巧用Excel数据透视表实现学籍数据的分类统计

摘要

The university student management work often need to statistic data classification. Counting function of the traditional way is to use the Excel or Countif function, although these methods can achieve, but a little trouble. Starting from the practice in the school roll management, summed up the use pivot table to complete the student status data classification statistical method, simple and quick, greatly improve the efficiency and accuracy.%高校学籍管理工作经常需要分类统计各种数据.传统的方法是利用excel的计数功能或Countif函数,这些方法虽能实现,但略显麻烦.从学籍管理工作实践出发,总结出利用数据透视表来完成学籍数据的分类统计方法,简单快捷,极大提高效率及准确度.