浅谈Excel中VBA的操作及在企业管理中的应用

On VBA Operation in Excel and the Application in Business Management

Excel可以广泛地应用于财务、行政、金融、经济、统计和审计等众多领域,它是一个强有力的信息分析和处理工具。利用其所提供的功能,财务管理人员可以按自动方式执行日常的管理、分析、决策任务,还可按需要加入某些自定义功能,直至建立一个完整的财务管理应用系统。

Excel can be widely used in many fields, such as financial affairs, administration, finance, economy, statistics and auditing etc., and it is a powerful tool with information analysis and processing. Using its functions, financial management staff can perform day-to- day management, analytical, decision-making tasks in accordance with automatic mode, but also can add some custom function as needed, until establishing a complete financial management application system.