Excel easy to get started

As one of the most important components of the Microsoft Office family, Excel can do a lot and function very well.

Its basic function is to record, compute and analyze the data. In practical applications, it is small to be able to act as a general calculator, or accounting for personal income and expenditure, calculation of loans or savings and so on, large to be able to carry out professional scientific statistics, and through the calculation of a large number of data analysis for the formulation of corporate fiscal policy, to provide an effective reference

Perhaps you have heard of Excel's name, but have hardly used it, so have been wandering in front of it; maybe you already know the basics of Excel, but you don't know how to learn it; maybe you need Excel for your work You need to quickly understand many of the details of Excel. Whether that's the case, this series of courses can give you some useful help and inspiration.

This course graphically introduces the basics of Excel's knowledge, functions, and operations, and can be easily learned, even if you have no access to Excel readers at all. Later we will use a large number of practical examples to guide learning, the use of operational learning to transition to the example of learning, such a step-by-step learning process will be full of fun, while more easily to solve practical problems of the ability. Look forward to your attention!

One, what Excel can do?

As one of the most important components of the Microsoft Office family, Excel can do a lot and function very well. Its basic function is to record, compute and analyze the data. In practical applications, it is small to be able to act as a general calculator, or accounting for personal income and expenditure, calculation of loans or savings and so on, large to be able to carry out professional scientific statistics, and through the calculation of a large number of data analysis for the formulation of corporate fiscal policy, to provide an effective reference

In the actual use of the industry, teachers, corporate office secretarial staff, Government audit Department, Statistical Department and the General Staff, etc. that will be more or less used in Excel. A lot of practical experience shows that if you can skillfully use Excel, will greatly improve the efficiency of our study and work, the use of business management, the direct result is the increase in economic efficiency, or that sentence, spend some time learning Excel is worthwhile.

Ii. Basic Concepts

Before entering into the specific operational learning, here is a few basic concepts, understanding this concept is the basis for further study.

(i) document

In terms of terminology, a file is an information entity that is stored on disk. With a computer, it can be said that we are dealing with documents almost every day. To us beginners, to understand that the file is of different types, we can distinguish it by its suffix name. Take the Microsoft Office family, Word creates a file-file suffix named Doc,excel creates a workbook file with a filename suffix named xls,powerpoint. The suffix for the presentation file created is ppt.

However, the type of file requires a different application to open it, some beginners from another computer to copy a workbook created in Excel to their computer, but can not open it anyway, later understand that the reason is not installed on their own computer Excel application.

So, to successfully follow the study, please install Excel 2003 on your computer now, while other versions of Excel can imitate the operation, but since this series of courses are based on Excel 2003, it is recommended that your readers try to use Excel 2003 for learning.

(ii) Workbook and worksheets

To learn and use Excel, you have to deal with two concepts, that is, "Workbook" and "Worksheet." As already mentioned, the workbook is a file created by Excel, and the worksheet is part of the workbook. Can be such an image of the understanding that the workbook is a notebook, and the worksheet is the notebook of every sheet of paper. Most of the work is done on the worksheet, using Excel.

Three, Excel's working environment and basic operation

(i) Start Excel

Before starting Excel2003, make sure that it is already installed on your computer.

We can start Excel in three different ways.

1, through the Start menu

To do this: Click the start → all programs →mircosoft office→microsoft Office Excel 2003 command on the desktop (Figure 1), and a splash screen of Excel 2003 will appear, and then you can start Excel 2003.

(Figure 1 Larger picture, please pull the scroll bar to watch)

2, through the desktop shortcuts

Action step: If you have created a shortcut to Excel 2003 on your desktop, double-click the icon for the shortcut to start (Figure 2).

Figure 2

3, through the work of Excel workbook file

Procedure: If your computer has a workbook that is created by Excel, double-click the file to start Excel.

(b) Understanding the working Environment of Excel

After you start Excel 2003, we'll see the work window for Excel. If you're a complete beginner, it might be a bit complicated. If you have experience with applications such as word in the Office family, you should feel a bit familiar. Because their menus, toolbars, task panes, and edit windows are roughly the same layout.

Let's take a look at the situation of this working environment. It is necessary to understand the names of the parts, such as menus, toolbars, task panes, and so on, because the following actions will use these names (Figure 3).

(Figure 3 Larger picture, please pull the scroll bar to watch)

(1) The title bar displays the name of the program and the name of the current workbook file.

(2) The menu bar can send commands to Excel by selecting the appropriate menu command. Excel makes it easy for users to remember and put similar commands into the same menu item, and menus can be customized according to their own custom.

(3) The toolbar can send the appropriate command to Excel by clicking the appropriate button. Toolbars can be customized according to their own custom.

(4) When the formula bar enters data or a formula in a cell, the input is displayed here. Edits to input data or formulas are quite handy here.

(5) The 256 letters of the column heading from a to IV. Each letter represents a column in the worksheet 256 column, starting with the English alphabetical order of A to z,z, followed by Aa,ab,ac, and so on to AZ. After AZ is BA,BB,BC, and so on to BZ, and the last column is IV. Click the column heading to select the entire column.

(6) Active cell indicator This black border indicator represents the currently active cell, called activity, which is the currently selected cell.

(7) The number of row headings from 1 to 65536, and each number represents one row of the worksheet. Click a row heading to select the entire row of cells. Also, because there are 256 columns, the total number of cells in the Excel worksheet is 256x65536=16777216, and we can use column headings and row headings to determine a cell, such as A4, representing column A, the cell in line 4th, and so on.

(8) task pane This is the new feature that starts with version 2002, which makes it easy to quickly select related tasks, such as creating a new workbook, using the Clipboard, and so on.

(9) Vertical scroll bar Use this scroll bar to scroll the worksheet vertically.

(10) Horizontal scroll bar Use this scroll bar to scroll the worksheet horizontally.

(11) Sheet tabs each label represents a different worksheet in the workbook, and each worksheet name is displayed on the label, and you can switch to the worksheet by clicking the label. A workbook can contain any number of worksheets, but for ease of administration, the number of worksheets is best not too much.

(iii) using Excel menus and toolbars

Menus and toolbars must be mastered if you want to use Excel to accomplish your tasks skillfully.

If we want Excel to do things, we have to give it a command. There are usually four ways to emit commands: using menus, using shortcuts, using shortcut menus, and using toolbars.

The following is explained by the operation of a specific task.

Task: Enter the character "language" in cell A1 and copy the content to A5 cell.

1 Using the Menu

Operation Steps:

(1) Select the A1 cell in which to enter the "language", you can see the insertion point cursor in the cell is still in a flashing state, Excel waits for us to enter other content, because the confirmation input is complete, then press the keyboard enter, you can see the active cell indicator jumps to B1 cell.

(2) Now click A1 cell with the mouse, you can see the active cell indicator return to cell A1, when you click Edit, select the Copy command in the expanded menu option (Figure 4), and you can see a black-and-white scroll bar around the A1 cell, indicating that the copy command has been executed.

Figure 4