WPS Office 2010 Create a Happy bookkeeping life

WPS Office 2010 opens up a new network office experience and uses the Web to share rich and colorful templates. It is always an important way for us to learn to take the long of the house. The author of this article will give you a real example of how to use WPS Office 2010来 to accomplish one thing in life. It's not big, but if you look at the perfect combination of software and life, you know how thoughtful you are with the WPS Office you use every day.

This time the main character is the WPs form, does not involve the complex data processing, this example background is the daily bookkeeping. A lot of newly graduated students and friends in the city with friends and colleagues to rent, two people together or a number of people's daily expenses and common daily necessities how to deal with. For example, a bag of washing powder, a dining out and so on. Who should give who how much money, how to remember this account? Every time we settle down, I'm sorry for the money. Usually not only a person consumption, time is long, you pay me also pay, accumulated more, inevitably confused. As the saying goes, brother, Ming accounts, there is no good solution to it?

Then the WPS table comes in handy.

You may disdain, bookkeeping as long as there is paper on the pen can, why do not use software. In fact, the function of the software is only you do a good job recording, the rest of it to complete. It would be much better to know who owes whom and how much, if you remember a sum. The role of the WPS table is so played out, take a look.

1. Make full use of online templates to create documents and develop ideas

To see the first feature of WPS2010, use a large number of templates to create documents. In the face of a new task, the first time is the most difficult, often without ideas. The role of the template is here, and it's impossible to expect a document that fits perfectly. WPS Online Template provides several major categories of thousands of excellent templates, there will be suitable for your processing, which is the crystallization of collective wisdom. According to our specific requirements, this example belongs to financial transactions, after comparison, we choose the "Cash journal", on this basis to modify.

2. The use of electronic forms to realize the intelligent accounting Automatic Processing

Here's how to work with the document, which is another feature of WPS Office 2010, software Intelligence. That is, the part of the software that needs to be "helped" by our calculations. This is a very attractive place for beginners. First, do some processing on the table header.

We need to know how much each of us spends on this daily expense, for example, the head inside the "a cost", but also know how much the two people spend, such as "Total expenses", the following is also the most important, is the individual accounts payable, in the end who owes who, who should give how much, all should be reflected in the head of the table.

The table is set up, how does it work? Let's look at some of the types of accounts we encounter.

(1) Public goods single expenses, such as: a day to buy vegetables cost 12.3 yuan. B Pay the electricity bill 152 yuan a day. This item can be counted separately, or it can be listed in a row, without affecting each other.

(2) Private expenses paid by others. For example, a purchase of food 3.5 yuan, by B Advance, then in B a list of "spending *2" can, that is, 7 yuan.

(3) for the cost of mixing, included in the pay side, the common items expenses are recorded truthfully, personal items *2, use the formula to complete. In the figure ">{banned} shopping" is actually "=2.5+3.4*2+110*2".

At the same time, the table immediately calculates the total expenses of the individual, the total cost of the double and the expenses payable to each other.

At a certain moment when the need to clear the account, only to be based on the individual payable fee bar at the same time, this item is clear zero, is very convenient.

3. Store documents online, share others, work together

Since it is a public ledger, then put on everyone can visit at any time convenient for both sides to record, then this is the third major feature of WPS2010, online document sharing.

You see, if you take a few easy steps, you and your friend's common account will be clear and the two of you can look at the expenses at any time. The first step in financial management is to know where you spend your money, this web-based way of financial management, you also want to try it?

The use of WPS Office 2010 is not just for bookkeeping, looking at how much we spend, we use this example to make you not only familiar with the solution of the formula in the WPS table, but also familiar with the idea of using online templates and the method of online document sharing, and mix them together is a good helper of our life, let's try it. !