Shulou(Shulou.com)06/01 Report--

In this issue, the editor will bring you about the five useful Excel skills, which are rich in content and analyzed and described from a professional point of view. I hope you can get something after reading this article.

Here are some tips for dealing with excel, which I hope will be useful to you, as outlined below.

F11 quickly generate charts

If you have such a batch of data, how can you use keyboard shortcuts to generate a chart at once? Of course, after one click is generated, will it be much more convenient for us to adjust the format of the chart?

Step 1: select the entire data area; step 2: press the F11 shortcut key on the computer to help us generate charts intelligently; step 3: adjust the format of the table according to your own needs

Ctrl+T quickly generates Super Table

In practice, the super table is actually very useful, for example, the drop-down data can still see the header, and after using the super table, the PivotTable can also be refreshed after extending the data source to the original table. Of course, these are just a few of the common operations, you can go down to study this super watch.

Step 1: select the data source; step 2: use the key combination Ctrl+T to generate the super table directly

Ctrl+Shift+1 quickly goes to the decimal point.

Step 1: select only the data area; step 2: use the key combination Ctrl+Shift+ 1` to quickly remove the decimal point

Alt + = Quick Summary

The first step: select all the data areas, plus the rows and columns of the data summary; the second step: use the key combination alt + = sign to complete the summary line and calculate quickly

Ctrl + e completes data splitting operation

Sometimes some data is mixed into a cell and we need to separate it. You may think of using the excel function at this time, but there is also a good way to read on.

Note: only for the first row of data processing. The first step: copy the name to the last name column and the score to the score column; the second step: place the cursor on the second row of each column and use the key combination ctrl+e to complete the fast filling operation

These are the five useful Excel techniques that Xiaobian shared with you. If you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.