在线一本码道高清

Learn > Learning Computers > Tools Software > Office Software Learning > Excel Tutorials > Excel Sheets > 《Basic Operation Tutorials of Excel Sheets for Free Download》 Text

Basic Operation Tutorials for Excel Sheets Free Download

本文内容及图片来源于读者投稿,如有侵权请联系xuexila888@qq.com 若木我要投稿 Time: 2016-09-23 10:15:17 The content and pictures of this article are from readers' submissions. If there is any infringement, please contact xuexila888@qq.com Ruomu I want to submit
The " Basic Operation Tutorial for Excel Sheets " recommended to you this time has a total of 163 skills, which can be downloaded for free to learn locally. This tutorial can help those who are just getting started to quickly improve their Excel level, and also allow veterans who often use Excel to learn more skills from it, which will be very helpful for future work. It's not difficult to master the basic operation of Excel tables ! After reading the "Basic Operation Tutorial for Excel Sheets" carefully, I believe your technique is almost the same!

163 basic operating tips for Excel spreadsheets to help you have fun in the workplace !



Tutorial directory

First, the basic method of EXCEL form
1.Quickly select all worksheets
2.Quickly start Excel
3.Quickly delete selected area data
4.Rename the cells
Select entire cell range in Excel
6.Quickly move / copy cells
7. Quickly modify the unit format order
8.Clear cell contents completely
Select cells
10. Name your 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
Quickly switch between multiple Excel workbooks
18.Get help quickly
19. Shortcuts for creating 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
Select cells based on conditions
24.Copy or move cells
25.Delete cells completely in Excel
26.Delete blank lines quickly
27. Paste function of Enter key
28. Close multiple files quickly
Select multiple worksheets
30.Quickly edit multiple worksheets
31.Move and copy worksheets
32. Delete the worksheet
33.Quickly select cells
34.Quickly select an Excel area
35. Backup Workbook
36.Open workbook automatically
37.Quickly browse long workbooks
38.Quickly delete blank lines in a worksheet
39, draw the slash header
40.Draw diagonal cells
41. Select the same cell each time
Quickly find workbooks
43.Prohibit copying data in hidden rows or columns
44. Make a personality cell

Second, EXCEL form data input and editing skills
1.Enter multiple values in one cell
2. Increase the number of pages in the workbook
3.Fantastic F4 key
4.Import formatted text into Excel
5, fast wrap
6. Clever change of text to numbers
7.Enter a value of 0 in the cell
Format numbers as text
Quickly switch between cells
10.Enter multiple test values consecutively in the same cell
11.Enter numbers, text, date or time
12.Quickly enter the Euro symbol
13.Convert cell range from formula to value
14.Quickly enter ordered text
15.Enter regular numbers
16. Cleverly enter common data
17.Quickly enter special symbols
18.Quickly enter the same text
19.Add units to numbers quickly
20.Smartly enter numbers with more digits
21.Convert WPS / WORD form into Excel worksheet
22.Unlink cells
23.Quickly input pinyin
24. Insert "√"
25.Align by decimal point
26.Define different input methods for different types of cells
27.Quickly insert WORD table in EXCEL
28.Set cell font
29. Display multiple lines of text in one cell
30. Introduce data from web pages into Excel forms
31. Cancel hyperlinks
32.Edit cell content
33.Set the cell border
34. Set cell text alignment
36. Use "scatter alignment" when entering person names
37.Hide all values in cells
38.Restore hidden columns
39.Quickly hide / show the row and column of the selected cell
40.Hide cells completely
41.Use the drop-down list to quickly enter data
Quickly enter custom phrases
43.Set cell background color
44.Quickly enter the same formula in multiple cells
45.Enter the same content in multiple cells at the same time
46.Quickly enter the date and time
47. Insert copied cells safely between existing cells
48. Don't lose the display of column headers in EXCEL
49, see the value of the serial number equivalent to the date
50.Quickly copy cell contents
51.Use custom sequence sorting
52.Quick Format Excel Cells
53, fixed display of a column
54.Quickly edit cells in EXCEL
55. Use AutoFill to quickly copy formulas and formats
56. Annotate cells
57.Automatic data input
58. Quickly calculate a person's age in EXCEL
59.Quickly modify cell order
60.Introduce data from web pages into EXCEL forms

Third, EXCEL graphics and chart editing skills
1.Publish the graphics generated by EXCEL online
Create chart connectors
3.Convert EXCEL cells into pictures and insert them into WORD
4.Insert WORD content into EXCEL form as a picture
5.Insert the contents of WORD into the Excel form as a picture link
6.Process embedded charts in separate windows
Show hidden data in charts
8.Add text boxes to the chart
9. Create a link between text and chart text box
10.Add new data series to the chart
11.Quickly modify the format of chart elements
12.Create composite charts
13.Use different axes for data series with different measures
14. Set your own chart as a custom chart type
15.Copy custom chart types
16.Rotate 3D charts
17.Drag chart data points to change values in the worksheet
18.Merge pictures into your chart
19. Beautify worksheets with graphics
20. Make text boxes and worksheet grid lines into one
21.Quickly create default charts
22.Quickly create embedded charts
23.Change the default chart type
24.Quickly convert embedded charts and new worksheet charts
25.Quickly set up charts using the chart toolbar
26.Quickly select chart elements
27.Create an Excel chart with a single keystroke
28.Draw straight lines

EXCEL 函数和公式编辑技巧 Fourth, EXCEL function and formula editing skills
1.Cleverly use the IF function to clear 0 in the Excel worksheet
2.Batch Sum
3.Sum data from adjacent cells
Sum the data of non-adjacent cells
5.Use formula to set weighted average
6, automatic sum
7.Edit formulas with Notepad
8. Prevent formulas from being displayed in the edit bar
9.Solve the limit on the number of SUM function parameters
10.Switch between absolute and relative unit references
11.Quickly view all worksheet formulas
12. Achieve condition display

EXCEL 数据分析和管理技巧 Five, EXCEL data analysis and management skills
1.Manage add-ons
2.Using hyperlinks between worksheets
3.Quickly link data online
4.Manipulate data across tables
5.View two columns of data that are far apart in EXCEL
6.How to eliminate the calculation error after abbreviation
7. Use the Paste Special command to complete some special calculations
8.Web query
9.Fast calculations in EXCEL
10.Auto-screen the top 10
11. Perform operations on multiple cells at the same time
12, let EXCEL appear wrong data prompt
13. Use "Super Connection" to quickly jump to other files
EXCEL 设置技巧 Six, EXCEL setting skills
1.Custom menu commands
2.Set menu divider
3.Back up custom toolbars
4.Share custom toolbar
5.Quickly switch workbooks using single document interface
6.Customize toolbar buttons



Tips : Due to too much content, this article only lists the contents of the "Basic Operation Tutorial for Excel Sheets", which can be equivalent to a small book. Please click the link below to download the full text to watch it locally! The greatest convenience is the purpose of [learning] ! Satisfied please like it!

Excel表格的基本操作教程Click to download the " Basic Operation Tutorial for Excel Sheets " for free


Other related recommendations:

  • 35 tips for Excel spreadsheets

    Maybe you have already completed hundreds of financial statements in Excel, maybe you have used Excel functions to achieve thousands of complex operations, maybe you think that Excel is just the same, or even nothing new. But we have countless days ...

操作教程大全 Excel table operation tutorial

Tutorial for using absolute references in excel tables

Tutorial on Excel's table widening operation

Basic Operation Tutorials for Excel Sheets Free Download

excel table division operation tutorial

Excel table data summary tutorial

Basic operation tutorial of excel table

Macro operation tutorial for excel table

Excel how to make a table

    [Excel表格的基本操作教程免费下载]相关的文章

      Copyright @ 2006-2018 Learn All Rights Reserved

      Learn it Copyright 粤 ICP 备 15032933 号 -1

      The works we use, including the content and pictures, are all submitted by Internet users and readers. We are not sure that the users of the submissions enjoy full copyright. According to the Regulations on the Protection of the Right to Dissemination of Information Networks, if you violate your rights, please contact: xuexila888 @ qq. com, my site will be deleted in time.

      Study Study

      back to the top