Excel 2007高级筛选功能的应用  

Application of Excel 2007 Advanced Filter Function

作　　者：陈瑛[1] 郑毅[2] 

机构地区：[1]武汉冶金管理干部学院信息部,湖北武汉430080 [2]武汉钢铁工程技术集团自动化有限责任公司,湖北武汉430080

出　　处：《武汉工程职业技术学院学报》2010年第3期42-46,共5页Journal of Wuhan Engineering Institute

摘　　要：通过对Excel 2007"数据"菜单中"高级筛选"命令的分析,设置高级筛选中条件区域的构造方法,能够弥补目前Excel 2007教材中对高级筛选功能过于简单的不足。介绍如何掌握高级筛选的应用技巧,便于有效地解决一些实际问题。Through analysis of ＂advanced filter＂ order in Excel 2007 ＂data＂ menu,criteria range creating method is set up in advanced filter,with which the drawback that advanced filter function was too simple in Excel 2007 textbooks can be compensated. Meanwhile,some practical skills in the application of advanced filter are introduced so as to solve some practical problems.

关 键 词：EXCEL 2007 高级筛选 条件区域 

分 类 号：TP315[自动化与计算机技术—计算机软件与理论]