EXCEL7.0是MICROSOFT OFFICE大家族中的重要一员,它能灵活、方便地应用于办公、商业、财务及许多方面,是目前最优秀的电子表格软件之一。下面就是其用于财务方面的一个实例。 一、制作工资条 首先是要建立行标题。在EXCEL工作表的第一行输入工资表的项目,例如,编号、姓名、基本工资、津贴、收入小计、扣除小计、实发金额等各项,然后对该行进行修饰,产生工资条样本。选定该行进行复制,再隔行进行粘贴,通过多次的复制、粘贴,以达到所要的工资条数,(如单位有职工50人,则粘贴到100行)。 其次是要输入基本数据。把每个职工的各项基本数据输入表中,并在第一个职工的“收入小计”项 EXCEL7.0 MICROSOFT OFFICE is an important member of the family, it can be flexible and convenient for office, commercial, financial and many other aspects, is one of the best spreadsheet software. Here’s an example of how it’s used for finance. First, making payroll The first is to establish a line headline. In the first line of the EXCEL worksheet enter the salary list items, such as number, name, basic salary, allowances, subtotal income, net of subtotals, the actual amount of money, etc., and then modify the line, resulting in payroll sample. Select the line to be copied, then pasted interlaced, through multiple copy, paste, in order to achieve the desired number of wages, (such as the unit has 50 employees, then paste into 100 lines). The second is to enter the basic data. The basic data of each employee input into the table, and in the first employee’s “income subtotal” item