Whether you're in Finance 、 Personnel or sales , You're going to face more than one excel The problem of the summary of documents and forms . Most students open one by one excel file , Copy and paste into a table , And then I'll summarize , If it's a monthly or daily newspaper , Repeat the work every day every month .
That's why we often work overtime , And the biggest reason , Just can't operate Excel Table skills , I worked overtime late .
today , Nini will share it with you Excel Table skills , Don't look at blood loss .
【 At the end of the article, there is a free way to get 】
17、 Just remember the name of the function , But I can't remember the parameters of the function , What do I do ？
18、 How to drag and drop one or more selected cells to a new location ？
19、 How to make the workspace on the screen bigger ？
20、 How to use Quick display menu ？
21、 How to use Quick display menu ？22、 How to prevent Excel Automatically open too many files ？
23、 How to remove gridlines ？
24、 How to quickly format reports ？
25、 How to quickly copy cell formats ？
26、 How to add a slash to a table ？
27、 How to quickly input numbers as text ？
28、 How to define your own function ？
29、 How to call a custom function in a worksheet formula that is different from a custom function book that resides in workbooks ？
30、 How to input data sequence quickly ？
Limited space , Only part of the technique is shown , Full version Excel Table skills , It's packed , No routine sharing ！
【 Please see the picture below for the collection method 】