How to use excel bookkeeping, what points to pay attention to

1.First of all, open the sample table of a working branch as an example.

2.Click the File tab in the toolbar.

3.Click the New option.

Taking a simple income and expenditure ** bookkeeping as an example, the method of excel bookkeeping is:

1. First of all, open an Excel blank file and use this ** to record time, income, expenditure and balance and other elements;

2. Click on the A1 blank grid with the mouse, at this time, a blank "value" appears behind the toolbar A1, and the input content here will appear in the A1 box, which we call the key value of A1, for example, define the A1 column as a time column, in other words, the time of income and expenditure;

3. Then define B1 as "income", C1 as "expenditure", D1 as "balance", and then you can define the function, then click on the D2 box, and then fill in the D2 key value content with "equal to B2 minus C2", which is a simple function and the most practical function in Excel; Bridge excitation.

4. According to the actual income and expenditure as the basis, and then calculate the balance should be equal to the difference between income and expenditure of the day plus the previous balance, so define the key value of d3 "equal to b3 minus c3 plus d2", and then use the mouse to click on the d3 grid, pull down the mouse, and all the blank grids in the d column will follow the function of d3 for calculation;

5. When applying this table, you only need to fill in the entry time, and enter the income and expenditure at the time, so that other data will be automatically generated.

The question is too general. To the professional ** can find ready-made templates.

1.Start by opening a sample sheet.

2.Click the File tab in the toolbar.

3.Click the New option.

How do you make an accounting sheet in Excel? This video or Zen frequency tells you! Practical tips for office software.

1. Take a simple accounting of income and expenditure as an example. Let's start by opening an Excel blank file. Use this card to record factors such as time, income, expenses, and balances.

2. We use the mouse to click on the A1 blank box, at this time, a blank "value" appears behind the toolbar A1, and the input here will appear in the A1 box, which we call the key value of A1. Here we define a1 as a time column.

3, and then we define b1 as "income", c1 as "expenditure", d1 as "balance", and then we can define the function, which is more interesting and important. Let's click on the d2 box and fill in the d2 key content with "=b2-c2".

4. According to the actual situation, we know that our balance should be equal to the difference between income and expenditure of the day plus the previous balance, so we define the key value of d3 "=b3-c3+d2", and then use the mouse to click on the d3 grid, pull down the mouse, and all the blank grids in the d column will follow the function of d3 for calculation.

5. When we apply this table, we only need to fill in the entry time, and enter the income and expenditure at the time, so that our ** will automatically generate other data. The diagram below is a more complete example.

Bookkeeping is a good habit, but it must be supported. If you can use a simple and convenient tool, it will be like a tiger with wings. So, how do you use excel to keep accounts?

1) First of all, after turning on your computer, find the excel icon and double-click to open it.

2) Set up your journal format according to your personal habits. For example, write the date, income, expenses.

4) Then under the Income & Expenses column, write down the amount of income and expenses for the day.

5) Finally, select the date, income, and expenditure columns, change them to red or your favorite color, and make them bold in font.

This question is rather cage-like.

If it's just simple bookkeeping, it is recommended to find a free bookkeeping software or **, which is very good.

Bookkeeping should be done according to your needs:

If you want to keep accounts, you still use the silver melon software to keep accounts, and you can also export to excel

Excel is not only a production, it has a powerful calculation function, and it is still more convenient in simple bookkeeping.

Your question is relatively general, if you are not familiar with Excel, you need to start from the basics.

The bookkeeping system needs to be redeveloped according to the actual situation, and if you don't understand, you can send me a private message.

Bookkeeping with cousins. It's better, it's convenient and fast.

It can be represented by different colors, which is easy to find and locate.