Excel accounting book

Excel Accounting Book is a simple and easy-to-use electronic accounting software. The interface is almost the same as Microsoft Excel spreadsheet. Excel accounting book is suitable for businesses, individuals, families, etc. It is a very good accounting tool. The Excel accounting book is very convenient to operate. In addition to the editing view, the information in the other four views is automatically generated, making it easier for you to analyze your accounts.

Features of Excel accounting book:

1. Excel accounting book can easily record and analyze expenses, income and other customized journals

2. Excel accounting book can conveniently classify and summarize data and provide digital warnings

3. Formulas, highlighting, auto-complete

4. Powerful search and replace, multiple undo/redo

5. Spell check, mouse gestures, mouse drag and drop, and more

Excel accounting software installation steps:

1. Download the Excel accounting software directly from this page, unzip and run it. (Documents circled in red)

2. This software requires no installation and can be opened and used directly.

How to use Excel accounting book:

1. Take a simple accounting form of income and expenditure as an example. We first open a blank excel file. Use this spreadsheet to record elements such as time, income, expenses, and balances

2. We use the mouse to click on the blank cell of A1. At this time, a blank "value" appears behind the toolbar A1. The content entered here will appear in the A1 cell, which we call the key value of A1. Here the editor defines A1 as a time column

3. Then we define B1 as "income", C1 as "expenditure", and D1 as "balance", and then we can define the function. This is more interesting and important. We click on the D2 box, and then fill in "=b2-c2" in the D2 key value content.

4. Based on the actual situation, we know that our balance should be equal to the difference between the day's income and expenditure plus the previous balance, so we define the key value of D3 "=b3-c3+d2", then click on the D3 cell with the mouse and pull down. Clicking the mouse will cause all blank cells in column D to follow the function of D3 for calculation. As shown below

5. When we use this form, we only need to fill in the entry time, income and expenditure at the time of entry, so that our form will automatically generate other data. The following figure is a more complete example

Excel accounting book update log:

1. Enhance the revenue and expenditure statistics function.

2. When the mouse hovers over the total expenses and total income, the totals of each table will be listed.

3. Other details have been corrected.