Question 1: How does excel make the report 3lian/...2

See the link for details.

In our daily work, we often have to make various forms, sometimes using Word to make forms, but most of the time, using Word to make form adjustments is too troublesome, so it is better to use Excel as a spreadsheet, which is faster and easier to adjust. This course is an introductory course for Excel 2113, which introduces in detail the process of making general Excel tables. Before making a table, you need to conceive the general layout and style of the table in your mind so that the actual operation can be completed smoothly.

1. create a new Excel file.

2. Draw a draft on the cursive paper, and determine the table style and the number of columns and rows of the required data. For example, I need to build a table with five rows and six columns, with the title row at the top.

3. in the newly-built Excel, use the mouse to select the required number of table rows and series, then right-click and select Format Cells-Borders, and select Outer Borders and Inner Borders as needed in Presets.

4. add a border as needed. If it is the title, you can cancel the outer border and merge the horizontal or vertical tables. The method is to select the table to be set (the first row), then right-click Format Cells-Align, and then select Merge Cells.

5. adjust the title line according to the length and width of the title. If my title is "XXXXXX company table" and the title is long, widen the title line, set the "word wrap" method as shown above, then indent left and right as needed, adjust the center, and then set the font size.

Look at the chart before adjustment:

Adjust the table according to the font, as shown in the figure:

6. After the other blanks are filled in, just adjust them according to the content.

7. if you need to print, you need to set up the page. At first glance, our table is horizontal, so choose File-Page Setup, choose Horizontal, and then print and preview it. If you want to print in the center but the table is in the upper left corner of the page, adjust the margins. Adjust the position and print.

8. if you need to insert this table into a word document for other use, it's easy. First, save the Excel table just made as a file name "Equipment Table" to the desktop. Set the page of this page to landscape orientation, otherwise the table will not be fully displayed. Click the mouse where you want to insert it in the Word document, and then select Insert-Object-Create from File above, and then find the Equipment Table you just saved, insert it, confirm it, and then insert it into Word. The effect diagram is as follows:

Let's take the results of a class as an example: this is a table in which the results and items have been entered, but there is no header, and the results are not calculated. If printed, the page is not set.

first, add a header to this table:

first, insert a row as the header. Right-click the "1" on the left of the "Name" column (see the figure below). In the dialog box that appears, we click "Insert", so there is one more line above (you can insert multiple lines in the same way. Similarly, right-click the leftmost number representing the row to delete the corresponding row). You can add a header to this line (see Figure 2).

when you enter the contents of the header, you must "merge cells" first. How to merge cells? In the top cell of the "Name" column, hold down the left mouse button and pull it to the right until it reaches the top cell of the "Remarks" column (the selected cell is light blue) for neatness. Then click the "Merge Cells button" on the toolbar above, as shown in Figure (2): Then we can enter the contents of the header until we are satisfied by adjusting the font size and font selection. As shown in the figure:

Second, grade calculation:

(calculation of average score):

Now, calculate the average score of students' grades (calculate the average score of a student first) as follows:

1. Click cell F3.

2. Click the

drop-down arrow on the toolbar.

3. In the pop-up drop-down menu, we click "Average", and then we get the following figure:

It means: b ... > >

question 2: how to make tables, reports, etc. 2. how to make headers

in general, to design a table or make a table according to a table sample, we must first analyze its main structure, design the main frame of the table, and then enter specific contents. Never enter all the data at first.

for this report, after you get the sample, you can start with the header. The specific production steps are as follows:

1. Enter the key contents of the header

as shown in the following figure:

In the process of entry, try not to adjust the format of the table (don't adjust the font, don't add a border to the table in a hurry, don't merge the cells of the table title, etc.), so as to speed up the entry, and it is not easy to interrupt the thinking, and only after entering these words can we have an overall grasp of the table. Of course, you can merge cells in several small places. For example, the "purchase this month" in the 1-level column heading of the table includes 2-level headings: Total, Party A's Supply and Self-purchase, and each 2-level heading includes 2-level headings: Quantity and Amount. At this time, several cells of the 1-level heading can be merged to make them include several columns occupied by the 3-level heading.

> > Tip: In the process of editing the form, you must save it every few minutes to avoid accidental loss of the edited content.

2. Adjusting the cell format

includes: merging cells, adjusting fonts, and adding borders to tables. Achieve the effect shown in the following figure:

1) > > Basic knowledge: border the table

Select the cell range to which you want to add a border, and then click the border icon on the toolbar.

note: the original dark gray grid lines in the table are set for easy viewing, and these grid lines do not appear in printing.

2) > > Basic knowledge of merging cells

Select the range of cells you want to merge, and then click the merge cell icon on the toolbar.

the effect is as shown in the figure:

> > Basic knowledge format brush

If you want to make several identical formats in a table, you can set one first, and then use the format brush to brush other cells into the same format.

For example, the second-level headings of the table, such as Total, Party A's Supply and Self-Purchase, all combine two cells into 1. At this time, you can first combine the two cells where the first Total is located, then click the format brush on the toolbar, and then select other cells to be combined. At this time, every two cells are combined, as shown in the figure: < > Tip: Double-click the format brush

If the cells to be formatted are not together, you can double-click the format brush. At this time, the mouse will always be in the format brush state, and you can format the cells in different positions. After all, press Esc to exit the format brush state.

3) > > Basic knowledge

Shortcut method of adjusting font and centering: Because most of the contents of the table are formatted as: font size: 11, alignment: horizontally centered, vertically centered, etc., only the table title has a larger font. Therefore, you can first set the whole table to the same format as most tables, and then modify the format of individual cells. The specific method is:

Select all worksheets, set the font size to 11, and click the center icon in the toolbar. At the same time, in order to make the table more beautiful, you can set the vertical center. Then adjust individual cells: select the table title cell, set the font to bold, and set the size to 16; Select the "Unit:" cell and set it to be left-aligned; Select the cell where the report date is located and set it to right alignment. Wait a minute.

> > Shortcut: select all tables: ctrl+a; Or click the upper left of the worksheet area:

4) > > Basic knowledge setting vertical center

Select the cell area to be set, then click the right mouse button in the selected area (this is a common sense problem, and you must right-click within the selected area when you right-click a cell or cell area), and select Format Cell in the pop-up menu:

Switch to the Alignment tab and set the Vertical Alignment to Center. As shown in the following figure:

(In the later description of this article, the process is simplified as: select the cell range to be set, right-click/set cell format/alignment, set "vertical alignment" to "center", and confirm. ）

> > Shortcut: Call up the Format Cell window: c ... > >

question 3: how does Microsoft Excel make tables? those grids are network lines, which are not affected when printing. when you do, these tables can be resized and are not affected. If you don't want to see these grids, just remove the tick in front of the network line in Tools-Options. If you want to make a form, it is much more convenient than word. Just use it more often, and the basics are still easy to learn.

question 4: how does excel make a report? Excel needs to make a report at 255 minutes, depending on what kind of report you want to make, first determine whether the report should be made vertically or horizontally, and then click on the page settings in the file to select the vertical or horizontal paper direction.

question 5: how to make electronic statistical tables for statistical reports: use exce or WPS. Method: create a new workbook, fill in statistical items, and input the contents to be counted. If you want to use formulas and charts for calculation, just insert the icon in the selected area and select a style.

statistical report is a report with legal nature, which provides basic statistical data from bottom to top according to the unified form, unified submission procedures and report time. Statistical report is a survey method based on comprehensive survey. It is a survey method in which the competent department of * * * arranges from top to bottom in the form of statistical tables and administrative means according to statistical laws and regulations, and then enterprises and institutions summarize and report from bottom to top to provide basic statistical data step by step. The statistical report system is a system of top-down layout and bottom-up data collection by filling in statistical reports.

Question 6: How to make a monthly report? Just make a separate profit statement.

The balance sheet is related to the previous year.

Question 7: How to make a tax statement? These two tables are basically enough for financial statements when filing tax returns, while the cash flow statement is basically not used now, just for banking financial institutions and the tax bureau at the end of each quarter. Then take the form to be filled out by the tax authorities, such as: income tax report (quarterly report) and value-added tax report (monthly report). This is from the IRS, and the local tax bureau will report: local taxes, such as urban construction tax, education surcharge, local education tax, water conservancy fund, stamp duty, property tax, etc. It depends on which taxes are approved by the tax bureau when you apply for tax registration certificate. If you don't understand, ask the administrator.

1. Accounting quarterly statements include balance sheet, income statement and cash flow statement. 2. Tax statement: declaration of business tax, value-added tax, consumption tax, urban construction tax, education surcharge, personal income tax and enterprise income tax. (Declared according to the taxes paid by your company) Article 54 of the new Enterprise Income Tax Law stipulates:

Enterprise income tax shall be paid in advance in monthly or quarterly installments. An enterprise shall, within 15 days from the end of the month or quarter, submit a tax return for prepaying enterprise income tax to the tax authorities to pay taxes in advance. An enterprise shall, within five months from the end of the year, submit the annual enterprise income tax return to the tax authorities, make final settlement and settle the tax refund payable. When submitting enterprise income tax returns, enterprises shall attach financial and accounting reports and other relevant materials in accordance with regulations.

so: financial reports should be submitted at least every quarter now, that is, the tax statements you mentioned.

The whole process of tax declaration

1. Enterprises must declare their taxes at the designated declaration point on the morning of the 4th, 5th or 6th of each month. Enterprises applying for the first time should also choose the method of enterprise income tax collection, and they must be signed and approved by the legal person finance. Fill in the reference sample form of the appraisal form of enterprise income tax collection:

Download the sample form of enterprise applying for audit collection: Appraisal form of enterprise income tax collection. xls

Download the sample form of enterprise applying for approval collection: Appraisal form of enterprise income tax collection. xls

Second, the enterprise tax declaration must be in the form of online electronic tax return. For specific procedures and requirements, please refer to the "Electronic Declaration Promotion Notice" on this website. The paper report of the enterprise that has been declared electronically need not be submitted, just send an email to the development zone before 15 of each month, and the file is the community-specific report. xls.

3. The contents of single-user enterprises that have not yet applied for electronic declaration include electronic documents and paper reports. If the contents do not meet the requirements, they will all be rejected. If the declaration period of Shanghai declaration agency passes, the enterprises will declare their taxes in Chongming on their own, and they will be responsible for the overdue period. The requirements are detailed as follows:

1. Electronic documents:

a. The agent electronic declaration enterprise only needs one electronic document, and the document is exported through data, and the text file with the type of "text file format (code) (*.txt)" is saved

b. The manual declaration enterprise, You need three electronic documents, such as the electronic document of the institute of gs *** 311231….zip zip, the collection of supplementary data of enterprise finance (electronic template). rar, the electronic template of financial accounting statements: electronic template of financial accounting statements and instructions for filling in forms. rar, etc.

c, if an enterprise applying electronically or manually for business tax deduction, it also needs the template of business tax deduction item list. Appendix 6: List of business tax deduction items. xlsd, all electronic documents are put into a folder named after the enterprise name, saved to floppy disk or U disk and other media, and submitted together with the declared paper report materials!

Note: Please refer to the details of each declaration and detailed printing instructions in the paper report. The software and declaration instructions of each declaration can be downloaded from the "Data Download" of this website or from the Shanghai Finance and Taxation website! Index

2. Paper report: