EXCEL函数在高校薪酬管理中的应用

信息化进程的迅猛发展使得财务软件成为财务高校财务管理的主要工具，高校工资管理通常使用人力资源管理系统完成，封装完好的系统适合大批量的发放工作，零星的津贴发放还要使用Excel软件，它依然是财务管理不可或缺的工具软件。本文通过使用Vlookup函数和If函数在薪酬管理中，利用Excel函数灵活、方便的优点解决实际问题。

EXCEL function in the application of the compensation management in colleges and universities

The rapid development of informationization makes financial software become the main tool of finance in financial management of colleges and universities, the university salary management usually use complete human resources management system, fully encapsulated system suitable for the issuance of large quantities of work, sporadic allowance and the use of Excel software, it is still an integral part of financial management tools. In this paper, by using the Vlookup function and the If function in compensation management, use of Excel function advantages of flexible, convenient to solve practical problems.