摘要
Excel电子表格作为目前应用最广泛的办公软件之一,功能全面、操作方便,具有高度自动化、运算准确等特点,在表格处理、数据分析、图表制作等方面应用广泛。该文以招生工作中遇到的数据分析处理等问题为例,介绍如何利用Excel的自动筛选、分类汇总、数据透视及常用函数等功能,提高工作人员对信息自动化处理能力,提升工作效率。
As one of the most widely used office software,Excel spreadsheet has comprehensive functions,convenient operation,high automation and accurate calculation.It is widely used in table processing,data analysis,chart making and so on.This paper takes the data analysis and processing problems encountered in the recruitment work as examples,and introduces how to improve the staff’s automatic information processing ability and work efficiency by using the automatic screening,classification and summary,data perspective and common functions of Excel.
作者
王鸿鹏
WANG Hongpeng(Gansu Forestry Polytechnic,Tianshui,Gansu Province,741020 China)
出处
《科技资讯》
2021年第33期8-10,共3页
Science & Technology Information
