Microsoft Excel is one of the components of Microsoft's office software, Microsoft Office, a spreadsheet program written and run by Microsoft for Windows and Apple Macintosh operating systems. Excel is an important part of Microsoft Office Suite software. It can perform various data processing, statistical analysis and decision-making operations. It is widely used in management, statistics, finance, finance and many other fields. Chapter 1 Common Operation 1. Shift+Ctrl+Direction Key In many cases, we need to select the data in the table. In general, we use the method of dragging the mouse, but when the amount of data is relatively large, it is more difficult to control. , often return multiple choices or less elections. This problem can be avoided by using the above combination of keys. The functions they implement are: starting with the current cell, selecting data in the selected direction, and ending when the first empty cell is encountered. As shown below: 2, quickly select the first and last cells of each column or each row. In many cases, we need to select the cell at the end of a column, or the first cell. If there is less data, we can slide the mouse axis to select, but when the amount of data is large, it is very time consuming. We can select any cell in the corresponding column or row, then double-click the top border of the cell to select the cell with the first digit of the column. Similarly, double-click the bottom border of the cell to select the last cell. Similarly, you can double-click the left or right border. As shown below: 3, CTRL + left mouse button drag (copy cell content to the specified range) Sometimes, you need to copy the current cell content to other cells, there are two cases: numeric cells and non-numeric Cells, for numeric cells, there are two cases: one is incremental copying, and the other is equivalent copying. Use CTRL + left mouse button to drag between the two cases. As shown in the figure below: Numeric cell incremental copy: numeric cell equivalent copy: non-numeric cell: You can also select multiple cells, hold down CTRL and move the mouse to the lower right corner of the cell, when the cross shape appears Start dragging the mouse to release the mouse at the selected position. Sometimes we can directly double the + word in the lower right corner of the cell so that we can directly fill the cells below. Then click the button to select “copy cells” or “fill in a sequence. As shown below: 4. Flexible use of the status bar In the lower left corner of Excel, there is a status bar that provides a number of useful functions and functions to handle the selected range, such as: counting, summing, averaging, Find the maximum/minimum value, etc. On the status bar, right click on the mouse button to bring up this function. As shown below: 5, the filtering function EXSL can filter the data, the screening is divided into automatic screening and advanced screening. We often use these two features to filter some data. Automatic filtering function: Shortcut key: Alt+D+F+F, after selecting automatic filtering, the button will be displayed in the selected cell or the top row, then click this button, the corresponding dialog box will appear, we can choose The corresponding options, as shown below: Advanced filtering function: Shortcut: Alt+D+F+A. Sometimes we will filter out non-repeating data from some duplicate data. For example, we count the traffic of one cell of a certain BSC (on an hourly basis). At this time, there will be 24 traffic per hour per cell, but we need to count the statistics of this cell. Traffic, at this time we need to carry out advanced screening of these cells, filter them out repeatedly, and then use the SUMIF function to sum them, as shown below: 6, conditional format function Sometimes, we need according to the data Features distinguish them so that they can be seen at a glance, such as whether a cell has EDGE enabled, or whether there is a repeater, etc. Method: First select the cell you want to use the conditional format (can be a range), then select the format -à ; conditional format, as shown below: