Excel中动态数据区域的创建

The Creation of Dynamic Data Region in Excel

在Excel中进行数据处理和数据分析，需要考虑数据区域的变动情况，以便真实地反映实时数据。如何创建动态数据区域，并基于动态数据区域实现各种功能，对很多的Excel用户来说都是一个难题。但是，Excel新提供的Excel表功能，使这些问题迎刃而解。该文介绍了Excel表的概念以及利用Excel表的扩展功能创建动态区域的方法，并结合实例说明扩展功能的具体应用，可以帮助Excel用户解决实际问题。

During processing or analyzing data in Excel, the changes of data region must be considered to truly reflect the real-time data. How to create dynamic data region, and how to implement a variety of functions based on dynamic data region are problems for many Excel users. However, Excel table, a new feature of Excel, can solve these problems easily. This article describes the concepts of Excel table and introduces the way of dynamic region creation based on Excel tables＇ extended function. Combined with examples of detailed applications for Excel table extended function, This article can help Excel users to solve practical problems.