1, Enter content: First, enter content in the specified cell.
2. Merge Cells: Select all cells to be merged, and click Center after Merge.
3. Center it: Obviously, some contents in the table are aligned to the left, and some are not beautiful enough to be aligned to the right. Select these data and click the horizontal center alignment.
4. Application of formulas: Excel's powerful formulas should be used. Enter the necessary formulas and drop them down to fill in, which can automatically calculate and reduce the workload of tabulation.
5. Border line: Although there are grid lines in the background, it is obviously not as comfortable as the border line. Select the table area and choose the appropriate border.
6. Fill the background color: select the area to be filled and select the fill color.
7. Finish: Such a simple Excel table is ready.
Excel table basics:
Step 1: Familiarize yourself with the architecture.
First of all, I take the 20 16 version of OFFICE Excel as an example. As soon as you open Excel, you'd better open all the toolbars such as file, start, insert, page layout, formula, data, review and view to familiarize yourself with the architecture inside and know where each tool is.
When we are familiar with the tools, we can also adjust all their shortcut keys. How? In fact, it's very simple. We just need to press Alt key in the normal interface to pop up the shortcut key of the toolbar, which will be marked in gray font. Later, we can press Alt+ any gray shortcut key to jump to the required item.
Jump to the menu bar of the required item, such as the picture below me. After jumping to the start item bar, there will be a tool about editing classes and its shortcut keys will be displayed. After we are familiar with it, we can directly use this tool through Ctrl+ shortcut keys. Provide effective support for our watchmaking efficiency.
Step 2: Use of shortcut keys.
Above, we talked about familiarity with the architecture, and most of the shortcut keys are on it. There are some things that are easy to use but not marked. Let me add them to you.
Among them, ctrl+e is a shortcut key for quick filling, which is very easy to use. Since the version of Office20 13, the function combination key of Ctrl+E has been available, which makes our daily work much easier and is equivalent to the role of a format brush.
1, batch merge/extract content, add symbols:
When dealing with table files, it is usually necessary to deal with the contents of cells, such as merging data and adding symbols in batches. Let's take the following picture as an example. Names and groups exist independently of each other. You just need to enter the target value you want in the first cell and press Ctrl+E to finish it easily.
2. Replace characters in batches:
In the past, when we encountered character substitution, we always used Ctrl+H to do data substitution, or used REPLACE and SUBSTITUTE functions to complete it. But now, to use efficient Ctrl+E, just enter the target value in the first cell, and press Ctrl+E, and the words and symbols can be replaced with one key.
The third step: the application of the function.
Next, I began to learn some basic functions, such as sum, sumif, mid, left, right and vlookup. After learning these functions, I can sort out the data sources, and then I can learn the PivotTable, make a simple table and draw a graph, which can reach the primary level.