How to make a detailed excel report

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.

Excel is an office software that is often used in the office, he is mainly used for data analysis, viewing, comparison, etc., so that the data looks more intuitive, easier to compare, and there are many times when you need to use reports to assist, the following is my compilation of the report tutorial with excel for you to read.

How to make a report in ExcelUse Excel to make a report Step 1:Right-click the mouse in the blank space of the desktop, select "Excel Worksheet" in "New", and the Excel worksheet will be added.

Use Excel to make a report step 1

Use Excel to make a report step Figure 2Make a report with excelStep 2:Double-click the worksheet, enter the content in it, then select all the contents, right-click "Set Cell", jump out of the dialog box in Figure 3 below, select the red part, and set **

Use excel to make a report step in Figure 3

Use excel to make a report step in Figure 4

Use excel to make a report step 5Make a report with excelStep 3:Select the first column "Class 3 (2) Grade Sheet", and click on the red part to merge the words into cells, bolding, and increasing the font size (the font size is set to about 16), and beautify the title

Use excel to make a report step Figure 6Make a report with excelStep 4:Select the E4 column, click on the red part, select "Sum", =sum(b4:d4), you can calculate the total score of Zhang San, and then copy the E4 column and paste it in E5:

e10, so that the total score of e5:e10 is also calculated

Use Excel to make a report step in Figure 7

Use Excel to make a report step 8Make a report with excelStep 5:Select the B11 column, click on the red part, select "Max", =max(B4:B10), you can calculate the highest score in the language, and then copy the B11 column and paste it in C11:

d11, so that the highest score of c11:d11 is also calculated

Steps to make a report with excel Figure 9 The above is all the content of the tutorial of making a report with excel that I shared with you, I hope it will be helpful to you.

You may also like:1How to make a tree chart in Excel.

2.Excel** how to make data analysis charts.

3.Excel bar chart tutorial.

4.How to make a tutorial in Excel.

5.How to make a graph in excel.

6.Tutorial for making Gantt charts in Excel.

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 range 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 number of row heights (the same operation is true for column width).

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.

1. First of all, we open the excel software in the computer and open a ** to make a table header.

2. Enter the basic information in the second, third and fourth lines, including the name of the customer, the delivery address, the order number, the contact person, the project name, and the contact.

4. After completion, set the alignment of the following cell contents, and click to center horizontally, which looks more beautiful.

5. Then drag the cell of Select All**, click to add the border, and add a solid black line.

6. Then adjust the font size and color slightly to make a good delivery note**.