财政部门的经费预算指标及拨款的管理是财务管理工作的一项基础性工作,长期以来我们用手工记帐进行管理,如果想对数据再加工处理,供分析决策之用,则费时、费力,也不容易计算正确。现在我们应用计算机电子表格软件——Excel对我市市直文教行政经费预算指标及拨款进行管理,感到既实用,又简捷灵活,提高了工作效率。 Excel97是目前非常流行的Microsoft Office97软件包中的一个应用软件,它具有友好的界面、强大的数据计算处理分析功能,是一个出色的电子表格软件。在将有关指标及拨款的信息输入并进行处理后,可产生所需的报表,为日常管理决策提供依据。下面具体谈一下应用方法: 首先,在Excel电子表格中建立一个命名为“流水帐”的工作表(工作表的命名根据自己的需要确 The budgetary indicators of the financial sector and the management of appropriations are a basic work of financial management. For a long time, we have used manual accounting to manage them. If we want to reprocess the data for analysis and decision-making, it takes time, laboriousness, It is not easy to calculate correctly. Now we use computer spreadsheet software - Excel on the city’s direct education budget and administrative budget funding management, feel both practical, simple and flexible, and improve work efficiency. Excel 97 is a very popular application software in the Microsoft Office97 package, it has a friendly interface, powerful data processing analysis capabilities, is an excellent spreadsheet software. After entering and processing information on the indicators and allocations, the required statements can be generated to provide a basis for day-to-day management decisions. Here to talk about the application of specific methods: First, create a spreadsheet in the Excel spreadsheet named “running account” of the worksheet (worksheet named according to their own needs