Excel basics tutorial for beginners: easy to learn basic operations and skills

Even if the reader has not been exposed to Excel, a graphical introduction to the basics of Excel, its functions and operations can be easily learned and mastered.word to pdf converter free download offline The following small series to bring you a simple introduction to the basics of Excel, I hope to help you!

Excel simple input basics

Excel can do what?

As one of the important components of the Microsoft Office family, Excel can do a lot of things and is very powerful. Its basic function is to record, calculate and analyze data. In practical applications, it can be as small as a general calculator, or accounting for personal income and expenditure, calculating loans or savings, etc.; large enough to carry out professional scientific statistical calculations,pdf split and merge download online as well as through the calculation and analysis of a large amount of data for the development of the company's financial policy, to provide an effective reference.

In the actual development of the industry use, teachers, business office secretaries, government internal audit related departments, statistical departments and general work researchers and so on that time will be more or less use Excel.convert word to pdf with embedded excel files a lot of actual teaching and application of the practical experience of the data show that, if the students are able to use Excel proficiently, it will greatly improve the efficiency of our learning and work, and used in the Business information management, direct investment in China's economic and social benefits, or that, spend some time as well as learning Excel is worthwhile.

Second, the basic concepts

Before entering the specific operation of learning, here are a few basic concepts to explain, to understand these concepts is the basis for further study.

(A) file

In technical terms, the file is stored on the disk information entity. With computers, we deal with files almost every day. For us beginners, in order to understand the different types of files, we can distinguish them by its suffix. For example, in the Microsoft Office family, Word creates documents with the suffix DOC, Excel creates workbook files with the suffix XLS, PowerPoint creates presentation files with the suffix PPT, and so on.

However, the type of file, you need a different application to open it, some beginners from other computers to copy a workbook created by Excel file to their own computer, but no matter how can not open it, and later realized that the reason is that you do not have the Excel application installed on your computer.

Therefore, in order to successfully carry out the following study, please install Excel2003 on your computer now. although other versions of Excel can be imitated, but because this series of courses are based on Excel2003, it is recommended that readers try to use Excel2003 for learning.

(ii) workbook and worksheet

Learning and use of Excel, certainly we have to deal with students of two basic concepts, that is, "workbook" and "worksheet". The previous question has been said, workbook is a kind of file created by Excel, and worksheet is the composition of the social workbook as well as part. It can be understood through this corporate image, the workbook is a Chinese notebook, and worksheets are each page of this teaching notes workbook. Operation and life using Excel, the vast majority of part of the management work is carried out in the worksheet.

Excel's working environment and basic operations

(1) start Excel

Before starting Excel2003, please make sure that your computer has been installed on the software.

There are three ways to start Excel.

1, through the start menu

Steps: Click on the desktop "Start ¡ú All Programs ¡ú Microsoft Office ¡ú Microsoft Office Excel2003" command, there will be a moment of Excel2003 splash screen, then you can start Excel 2003.

2, through the desktop shortcut

Steps: If you have not established on the desktop Excel2003. Shortcut lifestyle, then double-click the shortcut to pay the way the icon can be started.

3, Excel workbook files

Steps:If the computer is stored in the workbook file created by Excel, you can double-click the file to start Excel.

(2) to understand the working environment of Excel.

After starting Excel 2003, we will see the working window of Excel. If you are a complete novice, then the working environment may feel a little complicated. If you have experience using applications such as Word in the Office family, you should feel a bit of déjà vu. That's because they have roughly the same layout of menus, toolbars, task panes, and editing windows.

Here's what we'll do to introduce you to this social work and living environment. Understand the various parts of the call (name), such as menus, toolbars, task panes, and so on issues are a necessity, because for our later operations will be used through these calls.

(1) The title bar here shows 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 commands. excel will be similar commands categorized into the same menu item, easy for users to remember, the menu can be customized according to their own habits.

(3) Toolbar can send commands to Excel by clicking the corresponding button. The toolbar can be customized according to your preferences.

(4) formula bar in the cell after entering data or formulas, here will display the input. It is quite convenient to edit the input data or formulas here.

(5) Column Headings 256 letters from A to IV. Each student letter as a representative of the enterprise worksheet 256 columns in a column, from according to the English learning alphabet teaching order A began to Z, Z is followed by AA, AB, AC, and so on to AZ. AZ is followed by BA, BB, BC, and so on to BZ, the last to carry out a column is IV. click on the column headings we can be selected by checking the car the whole column.

(6) active unit indicator black box indicator indicates the current active unit, called active, that is, the currently selected unit.

(7) Row headings are numbers from 1 to 65536, each representing a row of the worksheet. Click the row header to select the entire row of cells. At the same time, since there are 256 columns, the total number of cells in the Excel worksheet is 256 × 65536 = 16777216. we can identify a cell by using the column headings and row headings, for example, A4, which represents the cell in the first column, the cell in the fourth row and so on.

(8)Task PaneThis is a new feature in the 2002 version, which makes it easy to quickly select relevant tasks, such as creating a new workbook, using the clipboard, and so on.

(9) Vertical Scroll BarUse this scroll bar to scroll vertically through the worksheet.

(10) Horizontal scroll bar Use this scroll bar to develop the level for scrolling worksheets.

(11) Sheet TabsEach tab represents a different sheet in the workbook and the name of each sheet is displayed on the tab. Select the tab to switch to the appropriate worksheet. A workbook can contain any number of worksheets, but for ease of management, it is best not to have too many worksheets.

3) Using Excel Menus and Toolbars

Menus and toolbars are essential for proficiency in using Excel to accomplish tasks.

If we want Excel to do things, we must issue commands to it. There are usually four ways to issue commands: using menus, using shortcuts, using shortcut menus and using toolbars.

Below is a problem through a specific task of the operating system to illustrate.

Task: In cell A1, enter the characters "Language" and copy the contents to cell A5.

1 Using the menu

Steps:

(1) Select cell A1, enter "Chinese". You can see that the cursor of the insertion point in the cell is still blinking. excel is waiting for us to enter something else. Because the input is confirmed, press the keyboard's Enter key, you can see the active cell indicator jumps to cell B1.

(2) Now click on cell A1 with the mouse and you can see the active cell indicator return to cell A1, click on the Edit menu and select the Copy command from the extended menu options. You can see black and white scroll bars around cell A1 indicating that the copy command has been executed.

(3) Then select cell A5, click Edit in the menu and select Paste from the expanded menu options. You can see the contents of cell A1 is copied to cell A5, press Enter to complete the operation.

Note: In the first step, why we enter "language", press Enter, and then re-select cell A1 it? This is the enterprise because, when entering the "language", the insertion point cursor in the cell flashing, then the students if you can directly affect the system menu management through the implementation of the copy command, then the command is for these cells in the insertion point cursor, because the cursor what has not been selected, therefore, China is equivalent to their own copy no other Any work content. And press enter after redesigning the selection of cell A1, you can see at the same time in cell A1 did not use the insertion point cursor, so the teacher at this point they are through the learning menu to execute the copy command, is a kind of copy of the contents of cell A1 "language".

A significant difference is that clicking on cell A1 activates it, making it an active cell where you can enter data or formulas to perform commands such as copy and paste, while double-clicking on cell A1 to edit it allows you to modify the data or formulas internally. Other organizations have followed suit.

2Use shortcut keys

If you find it cumbersome to expand layer-by-layer menu operations, you can use shortcut keys. Most common commands have shortcut keys. For example, the shortcut key to copy is "Ctrl + C", Excel will be commonly used command shortcuts in the menu list on the right side of the corresponding command.

Steps:

(1) first in cell A5 to delete the "Language", and then click on cell A1 with the mouse, press the keyboard key "Ctrl + C". The same as before, cell A1 will appear around a black and white scroll bar, said to have executed the copy command.

(2) Select cell A5, press the keyboard key combination "Ctrl + V", you can see the "Chinese" has been pasted into the A5 cell, press the Enter key to complete the operation.

3 use the shortcut menu

Steps:

(1) first delete cell A5 in the "language", and then select cell A1, and click the right mouse button, in the pop-up menu management options, select "Copy" command.

Then select cell A5, right-click, select "Paste" from the pop-up menu, press the Enter key to complete the operation.

4 use the toolbar

operation steps:

(1) first delete cell A5 in the "Chinese", and then select cell A1, click the toolbar in the "Copy" icon.

(2) select cell A5, click the toolbar "Paste" icon, and then press the Enter key to complete the operation.

(3)Through a simple task, introduced to Excel to issue commands commonly used methods. Do not underestimate the learning of these basic skills, you have to rely on them to complete more complex tasks.

(4) understand the dialog box

If you are careful enough, you should find that they have management menu options in the command with an ellipsis (three small black dots), when you click on this control command, will be carried out to show a system dialog box.

The purpose of this dialog box is that Excel can use it to get more information in order to complete more complex commands. For example, we choose "File ¡ú Page Setup" command to display the "Page Setup" dialog box, where you can set the page direction, scale, page size and other parameters, Excel through this dialog box to receive this information, Excel can be accurate! Excel receives this information through this dialog box, and Excel can accurately execute our commands. It is very convenient to operate through the dialog box.

The details of using the dialog box will be described in detail in the following specific tasks. In practice to master the operation of the dialog box is a very good way.

5 create a new workbook

To use Excel, you must first create a workbook. Start Excel, it will automatically create a workbook called Book1. By default, it contains three worksheets named Sheet1, Sheet2 and SHEET3. If you want to start a new project, there are three ways to create a new workbook.

Method 1: Use the menu

Method of operation: Select the menu "File ¡ú New" command, Excel will open the window on the right side of the "New Workbook" task pane, just click the appropriate option.

Method 2: the use of toolbars

operation and management methods: Click the common toolbar on the "New" button, you can build a new enterprise a social workbook.

Method 3: Use shortcut keys

Method: Press the key combination "Ctrl + N" to create a new workbook.

6 open the existing workbook.

In practice, we must often open the existing workbook, modify, add, etc., so learn to open the existing workbook is very necessary.

There are five ways to open the existing workbook.

Method One: the use of task pane

operation and management methods: in the "start work" task pane panel on the "open" area click to open the workbook.

Method 2: Use the File menu list

Method: Click the "File" menu, select the workbook you want to open in the list below.

Note: The above two methods are applicable to open the last few used workbook cases.

Method 3: Use the File menu to open the command.

Operation and management methods: Click the start menu "File ¡ú Open" command, pop-up "Open" dialog box, through the dialog box to locate the location of the storage space to workbook files, select the workbook to open the file, click the "Open" button. "Open" button system can be.

Method 4: Use toolbar buttons

Method of operation: Click the common toolbar "Open" button, pop-up "Open" dialog box, other operations with the third method.

Method 5: Use shortcut keys

Method: Press the keyboard key combination "Ctrl + O", pop-up "Open" dialog box, the rest of the operation and the same three methods.

This article introduces the learning and use of Excel necessary for the most basic knowledge, even if there is no contact with Excel readers can easily learn. However, the shortcomings of this section is not the introduction of practical tasks, inevitably make the learning process a little boring.