基于Excel的企业财务分析信息化实现

The Financial Analysis Informatization of Enterprise Based on Excel

Excel包含财务函数、数据链接以及图表分析等功能,已成为现代财务工作的一种重要辅助工具。本文以企业实际财务处理流程为主线,以建模工具Excel为基础,探讨如何对会计数据进行收集并加工处理,如何对加工结果进行多角度输出,进而帮助会计人员高效地为企业管理者决策提供多元化的信息,更好地满足企业全方位、多维度的信息需求,实现企业财务分析信息化的延伸。

Excel includes the functions such as financial function, data link, chart analysis and so on, has become an important auxiliary tool in the modern financial work. In this paper, with the real financial process of enterprise as the main line, to the modeling tool Excel as the basis, explores how to collect and process accounting data, how to processing results carries out multi - angle output, and then help the accounting staff to effectively for the en- terprise managers decision provide diversified information, better meet the omnibearing and multi dimension information demand of enterprises, achieve the extension of financial analysis informatization of enterprise.