The Application Of Excel In Accounting Work

　　 First, Excel Scope of application

Excel is a commonly used office software. This kind of office software has many functions such as calculation, arrangement, marking and so on. It is used to process some simple data. Accountants are the ones who deal with data every day. The content of their work is to deal with a large amount of data: accounting for wages, accounting for subsidies, reimbursement of employees, etc. Data processing software is a useful software for accounting work. It can help accountants to process data quickly and handle them more conveniently and understandable. In order to meet the needs of the market, computer technicians have developed financial software suitable for accounting work, which is based on the daily work of accountants and has many professional functions. This kind of software is good, but it is not suitable for all enterprises. Some large enterprises have many financial problems, and the use of such software is handy. However, some small businesses themselves do not have many financial problems. The daily work of Accountants is mainly about the calculation of wages and the reimbursement of employees. The use of specialized financial software for such small businesses is not only inconvenient, but also brings some trouble. Therefore, in some small and medium-sized enterprises, accountants choose Excel. Excel does not have many complicated functions, but handling some daily data is enough.

　　 Two, Excel in accounting Use in daily work

One wages Accounting

The accounting of employees' wages in accounting is an important content, which involves the interests of employees and the interests of the company. If there is any mistake, it will cause great trouble. To this end, the accounting of wages must be accurate and clear. The use of Excel to make payroll can help you browse and avoid mistakes in calculation. The basic format has been set up in Excel, and accountants can adjust their work content according to their own content. For example, in the first line, the word "payroll" is used to select three words, then select the first row form, and then choose "merge center" in the toolbar above. These small frames can be merged into a large one, and the Chinese character "payroll" can be knocked inside, and these three words will automatically center. Then, in the form below, you can write down the names of employees, the number of days worked, the total amount of wages and so on. Most employees work full-time, but there are also some employees who may ask for leave, which is different from other employees. For the sake of easy viewing, they can use the "red" to indicate the working days of these employees. The specific steps are to select the cells to be marked, and then choose the font color to be "red" in the toolbar above. Using Excel, the contents of the payroll can be tagged, which is good for accounting and there will be no mistakes.

2. accounting of reimbursement list

Another powerful function of Excel is to calculate the data. After data input, the operation of the tool can get the sum or difference of several numbers. This calculation method avoids the possibility that manual computation may calculate more or less. When employees are reimbursed, accountants are required to account for reimbursement. At this point, Excel can be used. After entering the name of the reimbursement, enter the amount of each reimbursement item. Notice that the amount to be reimbursed should be entered in the same row or the same column. After entering the data, use the left mouse button to select all the data, then click the "summation" sign in the toolbar, and the data will appear in the next cell of these data. The data calculated by Excel are fast and accurate.

　　 Three. The attentions of Accountants in using Excel

Excel is easy to operate, but if you are not familiar with computers, it is not easy to use Excel. Some input rules, marking rules, calculation methods and so on in Excel require certain computer operation basis. In recent years, graduates of accounting profession usually do not have problems in the operation of Excel. But some older accountants are not familiar with computers, and their Excel skills are almost zero. These old accountants will find it troublesome to use them. Enterprises should train these old accountants, so that they can master the operation skills of Excel. We can adopt a centralized training method to hire experts to explain the operation of Excel. In addition, young employees in enterprises can help old accountants to learn the operation of Excel as soon as possible. This will not only improve work efficiency, but also improve the relationship between colleagues.

At the same time, computer technology is developing rapidly, and new technologies and new inventions emerge one after another. The upgrading of Excel is also very fast. The new version of Excel will add some functions or improve its functions on the basis of the original so as to facilitate people's operation. Therefore, accountants should update their Excel version in time and learn to apply the latest version of Excel in time, so that Excel can serve their work, improve work efficiency and improve the quality of work.

Finally, it is reminded that accountants who use Excel must pay attention to the preservation of documents. In the process of computer operation, sometimes there will be automatic shutdown or sudden power failure. If there is an accident, the files in the computer will disappear, and the effort will be wasted. Therefore, in the course of Excel operation, we must save it in time, or save it in the computer to avoid the loss of important documents.

　　 epilogue

Society is developing and technology is progressing. The advent of computers and the advent of the Internet have greatly changed people's way of life, making people's lives and work more convenient. The function of computer is very powerful. It can process text, data and pictures quickly, and can also produce video, animation, widely used and various fields. There are many softwares dealing with data in computers, among which there are many specialized softwares, such as supermarket processing data, special cash registers, and financial departments dealing with large amounts of data will have specialized financial software. The invention and application of these softwares shorten people's working time and improve their work efficiency. At present, Excel is widely used in accounting departments of small and medium-sized enterprises, which provides a lot of convenience for the work of these accountants. Of course, Excel can not solve all the problems in accounting work, there are also some operational drawbacks. But with the progress of science and technology and the continuous improvement of computer functions, the function of Excel will be further improved to provide users with better services. Science and technology is the first productive force, and the development of science will bring economic development and bring about changes in life.