Current location - Recipe Complete Network - Diet recipes - How to make simple tables with EXCEL?
How to make simple tables with EXCEL?
1. Create a spreadsheet

EXCEL spreadsheet processing software is an important member of the OFFICE automation software Office developed by Microsoft Corporation of the United States, which has been improved and upgraded many times. It can easily make all kinds of spreadsheets and use formulas and functions to perform complex operations on data; Using various charts to represent data is intuitive and clear; Using hyperlink function, users can quickly open files on LAN or Internet and share workbook files with Internet users anywhere in the world.

EXCEL provides many very large blank worksheets in which rows and columns intersect to form cells. Don't underestimate that the cells on the screen are not very big. Each cell can hold 32,000 characters. Such a large worksheet can meet the business needs of most data processing; Storing paper data in EXCEL worksheet has changed the processing and management of data qualitatively, making the data change from static to dynamic, and making full use of computer to process it automatically and quickly. In EXCEL, the data in the worksheet can be searched, classified, sorted and filtered without programming, and various data can be analyzed by using the functions provided by the system.

2. Data management

After starting EXCEL, a blank form composed of horizontal lines and vertical lines will be displayed on the screen, and data can be directly filled in, thus forming various forms in real life. Such as student registration form, examination report form, salary table, price list, etc. However, there are various types of data in different columns of the table. For users, creating a table is similar to their daily habits. EXCEL will automatically distinguish between number type, text type, date type, time type and logic type without special specification. Editing tables is also very convenient. Rows, columns or cells of tables can be inserted and deleted at will. Modify the font, size, color and data in shadows.

Make a chart

EXCEL provides 14 categories 100 kinds of basic charts, including column charts, pie charts, bar charts, area charts, line charts, bubble charts, three-dimensional charts and so on. Charts can intuitively represent the complex relationship between data, and the same set of data can be easily changed by using different types of charts. Various objects in the chart, such as titles, axes, network lines, legends, data markers, backgrounds, etc. , you can edit it at will, and you can add text, graphics and images to the chart. Well-designed charts are more convincing, and charts can be made conveniently and flexibly by using the chart wizard.

4. Online data * * *

EXCEL provides us with powerful network functions. Users can create a hyperlink to obtain data on the Internet, or they can set their workbooks as * * * files and save them on the * * * sharing website of the Internet for any Internet user in the world to share.