Excel在财务数据处理中的应用技巧探究

Applied Techniques of Excel in Handling the Financial Data

在财务处理中我们经常要面对大量数据,要从中总结出一些数据规律和报表元素,虽然现在大多都有财务软件支持,但也有很多数据需要我们自行处理,excel给了我们一个很好的平台,笔者根据多年的经验,对其常用函数在会计中的应用进行总结。

It is necessary to summarize of the data and report entities in financial transaction which involves the vast amount of data. Even there are aceounting software supports, manual handling is still commonly used . Excel provided a good platform to deal with the data. Based on authnr＇s experience, common mathenmtical functions of Excel in accounting are summarized.