活用函数在EXCEL中实现数据库应用

Utilize the Function to Implement Database Applications in EXCEL

Excel软件在当今社会中已经成为一种必备工具。它除了可以用来制作各种表格与图表、进行简单的运算之外,还可以管理数据,并以此为基础进行数据分析。但是大部分人在使用Excel时,只是简单使用了软件菜单提供的排序、自动筛选等常用功能,以及求和等数学计算函数,在处理最简单的数据表格时相当方便快捷,然而当实际工作对数据的处理提出更复杂的要求时就束手无策了,转而求助于他人或其他软件工具。该文将结合自己在工作中的实践,探讨通过灵活应用函数在Excel中实现数据库应用,解决复杂数据处理问题的一些方法和技巧。

Excel software in today's society has become a necessary tool.It can be used in addition to the production of tables and charts, simple operation,but also to manage the data,and as a basis for data analysis.But most people use Excel,simply use the menu offers the sort of software to automatically filter and other commonly used functions,and mathematical functions such as sum,in dealing with the simplest form of data very fast and convenient,but when the actual work data processing requirements to be more complex to do nothing, and turned to other people or other software tools.This article will work in conjunction with their practice,through the flexible application of the function is implemented in the Excel database applications to solve complex problems in a number of data processing methods and techniques.