Introduction to the Excel interface

Excel is the most simple, visual data manipulation software, if able to skillfully use, Excel can help us deal with the vast majority of data statistics problems, even through the production of functions and graphs, we dig the data behind a lot of secrets, help us to staff and planning the future of the company's enterprises.

Excel is not only the necessary skills of financial personnel, production, sales, planning and other departments of the personnel also need to master the basic operation, if they can complete the simple operation of some relatively confidential issues, you do not have to worry about the leakage of the problem.

Starting today, we systematically learn the basics of Excel tables, we take the most popular excel2003 as an example, and then we introduce the basic operations of Excel 2007.

Let's start with a simple experience, a quick start, and today is an introduction to the Excel interface that lets you get to know basic Excel elements.

Click the "Start" program "Office 2003" Excel 2003 to open the program, such as the following interface:

(Tip: If you haven't installed the software, you can search and download a office2003 program on your own web site, or simply let a colleague who knows a little bit of computers download and install the software for you)

The diagram above lists the interface of the Excel table (excel2003), from the top down, followed by:

First, "filename", where the professional term is called title bar, in fact, the most important thing is to show what we are opening the file, the previous English letter Micosoft Excel is to show that this file is Microsoft's Excel software, and most useful is closely followed by the name, If you do not open any Excel file, this shows Book1, we will let it change later, please note.

Second, "menu" area, this is our common Word document editing software similar menu, but also different, as our follow-up experience, you will gradually find more different, if you are familiar with Word.

The bottom of the menu is "Toolbars", the toolbar provides quick formatting, data generation, icon creation, and so on, they can be closed or opened by right-clicking the "menu" area.

The formula bar, which is an important editing area when we use functions later, especially the more complex formulas and functions.

Five, row, column. 1 on the left of the work area, 2, 3, 4, etc. called lines, above A, B, C, D is called column, and the name of the row is called a cell, such as A1 refers to the 1th row of a cell, and C10, is the C column 10th cell.

Vi. worksheets. The bottom of the workspace, where the Sheet1 and Sheet2 are displayed, is the worksheet. Each Excel file can contain more than one worksheet, and we can change the name, delete, or add a new worksheet by right-clicking on a sheet (which can also be done on the Edit menu or the Insert menu). In order for you to see that different sheet are indeed different worksheets, you can enter 111 in the A1 cell in the Sheet1 table, and in the Sheet2 table A1 cell Enter 222 and return to the Sheet1 table, you will find that the two tables are not the same.

Outside: Let's introduce the menu a little bit.

We can now try to save the file (click "File" "save" in turn), just put it on the desktop, the name is "Excel Practice 1", then you will find the name of the area of the filename changed to "Excel Exercise 1", the File menu with the most is "save" "Saved as" "Page Setup" three menus. As the operation of the data, we have a good habit is to try not to operate on raw data, and to save a copy (of course, you can also use File replication to achieve), page Setup menu in addition to common settings paper, margin, there is a "worksheet" item, you can set the print area and the top title, In particular, a large amount of data, a page can not finish printing, "Top header row", so that each page out of a same title, this will be very useful, we have an example experience behind.

The Edit menu is a common copy, paste and other menus, you need to pay special attention to the menu is "undo" (very often, shortcut key ctrl+z), "clear" (both can clear all content, but also can only clear fonts, colors, etc.), "find" (in the face of a large number of data, we can not find each Better use Ctrl+f to help).

With more "Insert", the more commonly used in the Insert menu is the "row" "Worksheet" "Chart" function, we have a lot of case experience.

Powerful data operation is no more than the "Data" menu, where the "sorting" "Filter" "Subtotals" and "chart" "function", is the basis for Excel, but also the most embodiment of Excel real powerful features of the place.

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join