How to use Excel to create various business reports? 5

Operating Equipment: Dell Computer.

Operating system: win10

Operating software: excel

1. First of all, in Excel, select the required rows and columns, such as 6 columns and 10 rows, as shown in the following figure:

2. After selecting, right-click and select Set Format Cells, as shown in the following figure:

3. Click on the border option, as shown in the figure below

4. Select the outer border, select the desired line style, and confirm it, as shown in the following figure

5. Select the first row in **, as shown in the following figure:

6. Click Merge Center above, as shown in the figure below

7. Enter the data in **, and a ** will be done, as shown in the following figure:

In word—**—insert**—enter a few rows and columns,in excel—directly select the **,format—cell—border (add inner border, outer border,,

Excel is easy to use and many people use it, but now most of them have to look at the results in the browser, so Excel is not so common now.

Generally, a special report tool is used, our company now mainly uses the dry report, which is very cost-effective, the simple report can be dragged and dropped, and the complex also has corresponding examples, just change it on the line, and there is professional support, just ask if you don't understand.

If you plan to use a professional reporting tool, then you can consider using a dry report.

Runqian report is an Excel-like design page, and there are a lot of built-in functions that can be used, for obtaining data from different data, secondary calculation, and graphical display settings are supported, relatively speaking, it is relatively easy to start, and the maintenance is also very convenient and simple, and there are many technical consultation entrances.

Create**.

Open a blank word document for making exercises. Creating can usually be done in two main steps: creating and entering into it.

1) Establish**.

There are three ways to create **: menu, toolbar buttons, and free tabulation. Note: The location where the document table is located is located. Let's go through the ** establishment method exercise one by one:

Create with a menu to open"**"menu, point to"**", select"Insert"Item; Make the necessary setting selections in the dialog box (it is recommended that the settings for rows and columns be moderate), and then press"OK"。Observe the resulting ** situation.

Click directly on the toolbar"Insert"button, use the mouse to select the appropriate rows and columns in the ** box that appears, and then click the left mouse button; Observe the established **.

Click on the toolbar"** and borders", or right-click on the toolbar and select it from the Tools menu"** and borders", open"** and borders"Toolbar; After selecting the appropriate line on this toolbar, and then clicking the brush button on the far left of the toolbar, the mouse logo will be converted into a brush, and you can draw freely in the document.

Hold down the left mouse button to move the mouse, then release the mouse to get a rectangular box or a straight line. The thickness of the line can be selected or selected"Bezel-less"Line format (the drawn line is gray and colorless when printed).

Drawing the wrong line can be used"Erase"Button erase.

Please practice drawing a four-row, four-column ** using the free tabulation method.

You can also add or erase lines in the built ** with the free tabulation method, please practice on your own.

2) Enter the content into **.

Once ** is created, each cell defaults to a paragraph. When you enter content into **, move the document cursor to the box where you want to enter content before you enter it.

Please practice typing in the established ** and observe the changes after entering different amounts of content.

3) Delete.

Move the document cursor to any cell in ** to open it"**"menu, select"Selected"；Turn it on again"**"menu, select"Delete the row", you can delete **.

Please use the above method to delete all the ** you just created one by one.

In our daily life, we occasionally encounter some problems that we don't know how to solve, such as making excel reports. So how should we solve this situation that we don't know how to make excel reports? So let me introduce the steps of making an excel report.

Step 1:

Open Excel2013, the search and scrambling software Huishan, and then click on the file, and then select Open, and select the ** file you want to process in the required disk.

Step 2:

Once opened, we select any of the cells and click Insert Shopping Card.

Step 3:

Find the Insert tab in the Excel2013 options bar, then we continue to find the pivot table, and then click the left mouse button to select itStep 4:

Then the box will pop up to create a pivot table, we can directly select its default form and click OK.

Step 5:

Then in the right option bar of **, we check the area and order amount, so that the data statistics will appear in the ** on the left.

Step 6:

At the same time, double-click on the sum item, and the dialog box will pop up, and select the count below, so that we can continue to analyze the data.

Prepare the software Sail Flux: Excel**.

1. First open Excel**, then select the top row, then right-click and select Merge.

2. After the merger, enter the appropriate content, and you can refer to the figure below for the specific content.

3. After the content is entered, select all the content except the top row, and then select the horizontal center.

4. After the text is centered, select all content in the checkbox, and then click Add All Frames.

5. Finally, save the prepared financial statements.

1. Open the excel sheet, select the range you want to make**, and click the right-click menu "Set Format Cell". Click the border, then select the Outer Border > Inside icon.

2. Select the scope of the title. Click the right-click menu "Format Cells". Then select "Align", select Align "Center" horizontally, and hit "" in front of the text control "Merge Cells".

3. From the leftmost number of the excel sheet, hold down the left mouse button and drag to select the range of row height that needs to be set, click the right-click menu "row height", and press "OK" after setting the row height number (the same is true for column width).

2Then select the blank workbook in the new section, and then select all the cells you want to use.

3. Click the ** icon at the font in the toolbar and select all the border options.

4. Finally, enter ** content, click the save icon, and then click the save button.

1. Open the excel sheet, select the range you want to make**, and click the right-click menu "Set Format Cell". Click the border, then select the Outer Border > Inside icon.

2. Select the scope of the title. Click the right-click menu "Format Cells". Then select "Align", select Align "Center" horizontally, and hit "" in front of the text control "Merge Cells".

3. From the leftmost number of the excel sheet, hold down the left mouse button and drag to select the range of row height that needs to be set, click the right-click menu "row height", and press "OK" after setting the row height number (the same is true for column width).