Official Download Screenshot of Excel 2020 Free Edition 1
1, Office Assistant-Tell me
First of all, we need to know that Office Assistant-tell me it is a brand-new Office Assistant. Users can enter the help they need in the "Tell me what you want to do …" text box. As shown in the figure below, Tell Me can guide to related commands and use the intelligent search function supported by Bing to view the data. For example, if you enter the keyword "table", you will see insert table, apply table style and table style in the drop-down menu. Tell me that for beginners of Excel, they can quickly find the required command operations and also strengthen their learning of Excel.
Excel 2020 Free Edition Official Download Screenshot 2
2. The era of big data-strengthening the function of data analysis
Nowadays, big data has long been a hot technology and topic, and Excel is also adapting to the development of the era of big data and constantly strengthening the function of data analysis.
Excel2020 has added a variety of charts, such as a tree diagram showing the mutual structural relationship, a rising sun diagram analyzing the horizontal proportion of data, a histogram judging whether the production is stable, a box diagram showing the dispersion degree of a group of data, a waterfall diagram expressing the quantitative change relationship between several specific values, and so on.
3. Cross platform application
Since Office 20 13, Microsoft has realized the cooperative work of computers and mobile phones, and users can realize mobile office anytime and anywhere. In Office 2020, Microsoft has strengthened the cross-platform application of Office, and users can view, edit, analyze and demonstrate Office 2020 documents on many electronic devices.
Excel 2020 Free Edition Official Download Screenshot 3
1. Download the free version of Microsoft Excel 2020 to the local area, decompress and run the installation program. As follows:
Excel 2020 Free Edition Official Download Screenshot 4
2. Select Custom Installation to set the installation information of Microsoft Excel 2020. If you don't need it, you can directly choose Express Installation to skip the setup steps.
3. Select the specific installation steps of browse setting Microsoft Excel 2020, which can be set as required.
4. Finally, enter the installation steps of Microsoft Excel 2020 free edition, and follow the prompts in the following steps.
Excel 2020 Free Edition Official Download Screenshot 5
Common shortcuts
1. Arrow keys: move one cell up, down, left or right.
2.Ctrl+ Arrow keys: Move to the edge of the current data area.
3.Home: move to the beginning of the line.
4.Ctrl+A: Select the entire worksheet.
5.Alt+Enter: wrap a line in a cell.
6.Ctrl+D: Fill down
7、Ctrl+； (Semicolon): Enter the date.
8.Ctrl+shift+: (colon): Enter the time.
9.Ctrl+Z: Undo the last operation.
How to open the tutorial of 1 and Microsoft Excel 2020 for free?
A: 1. Open the official version of excel2020. In the recommended template, select Welcome to Excel, and then click Enter.
2. Click Help-Help to open the help bar on the right.
3. Click Help to display the training content and open it.