Excel table basic Operation 163 strokes skill

Maybe you're a very sophisticated office officer, perhaps you are a novice beginner, the basic operation of Excel table recommended in this report has 163 techniques, which can help newly-started friends to quickly improve their Excel level, and also let the veteran who often use Excel to learn more skills. , for the future work has a very big help. It's not difficult to master the basic operation of Excel tables! Learn to read the basic operation of Excel forms, and believe that your technology is almost already!

Click to download the basic operation of Excel table

Directory

　　First, the Basic method

1. Quickly select all worksheets
2. Quick Start Excel
3. Delete selected area data quickly
4, rename the cell
5. Select the entire range of cells in Excel
6. Fast Move/Copy cells
7, quickly modify the order of the cell format
8, completely clear cell contents
9, select the cell
10. Name the worksheet
11. Open multiple workbooks at once
12. Quickly switch workbooks
13. Select Hyperlink text
14. Quick Find
15, modify the default file save path
16, specify the open folder
17. Quickly switch between multiple Excel workbooks
18. Get help quickly
19, create a shortcut to help files
20, double-click a cell to move the selected cell
21, double-click a cell to select a range of cells
22. Quickly select discontinuous cells
23. Select cells according to the conditions
24. Copy or move a cell
25, completely delete the cells in Excel
26, quick Delete blank line
27, the Return key paste function
28. Quickly close multiple files
29. Select multiple Worksheets
30. Quick edit on multiple worksheets
31. Move and copy Worksheets
32, the deletion of the worksheet
33. Select cells quickly
34. Quickly select Excel Area
35, back up the workpiece book
36, automatically open the workbook
37. Quickly browse long workbooks
38. Quickly delete blank lines in a worksheet
39. Draw Slash Head
40. Draw Slash Cell
41. Select the same cell at a time
42. Find workbooks quickly
43. Prevent copying of data in hidden rows or columns
44. Make individual cell

　　Ii. data entry and editing skills

1, enter multiple values in a cell
2, increase the number of pages in the workbook
3, the peculiar F4 key
4, import formatted text into Excel
5, Quick wrap
6, change text to number
7, enter 0 value in cell
8, Set number to text Format
9, fast switch between cells
10, enter multiple test values in the same cell continuously
11, enter number, text, date or time
12, enter the euro sign
13, convert a range of cells from a formula to a value
14, fast input ordered text
15, enter a regular number
16, clever input commonly used data
17, quick input special symbols
18, fast input the same text
19, quick to number plus unit
20, clever input number of digits
21 , convert the Wps/word table to Excel worksheet
22, Cancel cell links
23, quickly enter phonetic
24, insert "√"
25, Align decimal point
26, define different input methods for different types of cells
27, Quickly insert a Word table
28, set cell font
29 in Excel, display multiple lines of text in one cell
30, introduce data from a Web page to an Excel table
31, Cancel hyperlinks
32, edit cell contents
33, Set the cell border
34, set the cell text alignment
36, enter a person's name with "Distribute Align"
37, hide all values in a cell
38, restore hidden columns
39, quickly hide/show selected cells in rows and columns
40, Completely hide cell
41, use Drop-down list to enter data quickly
42, fast enter custom phrase
43, set cell background color
44, quickly enter the same formula in multiple cells
45, and enter the same content in multiple cells
46, Quick Enter date and time
47, safely insert copied cells between existing cells
48, display column headers in Excel
49, view values for serial numbers equivalent to dates
50, quickly copy cell contents
51, Use custom sequences to sort
52, quickly format Excel cells
53, display a column
54, quickly edit cells in Excel
55, use AutoFill to quickly copy formulas and formatting
56. Add annotations for cells
57, data Auto input
58, quickly calculate a person's age in Excel
59, quickly modify cell order
60, introduce data from a Web page to an Excel table

　　Third, graphics and graphic editing techniques

1, published in the online Excel generated graphics
2. Create Chart connectors
3. Insert Excel cells into Word by converting them into pictures
4, the word content as a picture into the Excel table
5. Insert the content in Word as a picture link into an Excel table
6. Handle inline charts in a separate window
7. Show hidden data in the chart
8. Add text boxes to the chart
9, establish the text and chart text box link
10. Add new data series to the chart
11. Quickly modify the format of chart elements
12. Create a composite chart
13. Use different axes for measuring different data series
14. Set your own satisfaction chart to the custom chart type
15. Copy Custom chart type
16. Rotate three-dimensional chart
17, drag the chart data points to change the values in the worksheet
18, merge the picture into your chart
19, the use of graphic landscaping work table
20, let the text box and work table grid line
21. Create a default chart quickly
22. Create inline charts quickly
23. Change the default chart type
24. Quickly convert inline chart and new worksheet chart
25, use the chart toolbar to quickly set the chart
26. Quickly select chart elements
27. Create an Excel chart with one key
28. Draw Straight Line

　　Four, function and formula editing techniques

1. Use the IF function to clear 0 of Excel worksheets
2, Batch Sum
3, to the adjacent cells of the sum of data
4, the data of nonadjacent cells sum
5, using the formula to set the weighted average
6, Automatic summation
7. Edit the formula with Notepad
8, prevent the formula bar from displaying formulas
9, solve the SUM function parameters in the quantity limit
10. Toggle between absolute and relative unit references
11. Quickly view all worksheet formulas
12, the realization condition display

　　V. Data analysis and management skills

1. Manage Add-ins
2. Use a super connection between worksheets
3, Fast link online data
4. Cross-table operation data
5. View two columns of data that are far apart in Excel
6. How to eliminate the calculation error after the contraction position
7, the use of selective pasting command to complete a number of special calculations
8. Web Query
9, in Excel in the rapid calculation
10, automatic screening of the top 10
11, the simultaneous operation of multiple cells
12, let Excel appear error data tips
13, with "super connection" quickly jump to other files

　　VI. Setting skills

1. Customizing menu commands
2. Set Menu separator Line
3. Back up custom toolbars
4. Share Custom toolbars
5. Use single document interface to quickly switch workbooks
6, custom toolbar buttons

For more details, please download and watch!