How to make a video tutorial of excel tables?

This course is an introductory course of excel, and the process of making general Excel tables is introduced in detail. Before making a table, you need to conceive the general layout and style of the table in your mind, so as to successfully complete the actual operation.

1. Create a new excel file.

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

3. In the newly-built excel, use the mouse to select the required number of table row sequences, then click the right mouse button to set the cell format-border, and select the outer border and the inner border as needed in the preset.

4. Add borders as needed. If it is a title, you can cancel the outer border and merge the horizontal or vertical tables. To do this, select the table (the first row) you want to set, 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 very long, I will 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.

Please look at the chart before adjustment:

According to the font adjustment table, as shown in figure:

6. Fill in the other blanks and adjust them according to the content.

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

8. If you need to insert this table into a word document for other use, it is also very simple. First, save the Excel table just made to the desktop with the file name of "Equipment Table". Set the page of this page to landscape.

Otherwise, the form will be incomplete. Click the mouse where you want to insert in the Word document, then select Insert-Object-Create from File above, and then find the one you just saved.

Device list, insert, confirm, and then insert into Word. The effect diagram is as follows: