Office 0 Foundation--excel article

Office Office software is a set of tools that professionals use every day, including: PowerPoint, Word, and Excel's three main office artifacts.

Most people learn more about Word and PowerPoint (PPT), Word is text editing, PPT is a presentation; Excel? Isn't it just a form? This thing still has to be learned? Many people have a misunderstanding of Excel, think it is just a form tool, and often ignore its powerful data processing and analysis ability. When we are faced with a lot of data to be processed, the Scarlet Battalion of our hearts: "Why I did not study hard excel?! ”

Want to learn Excel, and is not overnight things, more than a reference book can be done with things. Let us start from scratch, to re-recognize this unfamiliar and familiar "old friend" it! (all sample software interfaces are office2016 versions, version 03-07, 10, 13, WPS, although the interface is different, but most functions similar; the author recommends using the latest version.) ）

I. Workbooks and worksheets;

To work with Excel, you must know the differences between workbooks and worksheets. The new Excel file that was created is called the workbook.

Excel new file is called workbook

Worksheets are editable interfaces that are edited in the workbook:

Sheets in a workbook

In the worksheet we can achieve data entry, sorting, analysis, and so on, simple and straightforward is that: the worksheet is a table in the workbook, worksheets are included in the workbook is a relationship, the workbook can create multiple worksheets.

Multiple worksheets can be created in a workbook

Second, the cell;

Worksheets are made up of countless cells (which are said to have a specific number, and how many are not counted), and are the smallest elements in a worksheet that cannot be split. Let's take a look at the Excel work interface first.

Excel work interface

In the interface diagram, we can see the line number and the column number, the line number + column number is the coordinate address of each of our cells, for example: A3 cell refers to the third row in column A cell, we can click on the cell to select it, you can also enter "A3" in the leftmost address bar of the formula bar and press " Enter key to quickly select, we usually call the selected cell "active cell".

Third, the various components of Excel;

1, title bar.

The title bar is located at the top of the work window and is used primarily to show what the name of the workbook you are editing is called.

2. Quick Access Toolbar.

By default, the Quick Access Toolbar is located at the top-left corner of the window to display features commonly used in the software, including: Save, Undo, restore, and user-customizable display tools.

3, the function area.

Functional area collection of Excel's various core functions, beautiful, concise, generous, they are the control center of Excel, the functional area mainly has tabs, groups, commands three parts. Almost all of our data operations can find the corresponding command in the Ribbon and complete the operation.

4. Edit Bar.

The formula bar is used to display and edit data or formulas in the currently active cell, consisting of a name box and a formula bar.

5, the worksheet editing area.

The worksheet editing area is the main place to work with the data, it is made up of countless cells, you can enter different types of data, the editing area is the most visual display of the editing area, including line numbers, column numbers, cells, scroll bars and so on.

6, status bar.

The status bar, located in the lower-left corner of the work window, displays information about the current worksheet or cell operation, displays ready when you prepare to accept the command or prepares input data, displays input when you are typing, and displays a brief prompt when the command is selected.

7. View Bar.

Located in the lower-right corner of the work window, it shows the view mode that the worksheet is currently using, primarily for switching view modes and adjusting the zoom scale.

In this way, we simply have to meet with Excel, make friends, the next lesson we mainly talk about workbooks and worksheets Some basic operations, interested in this course please pay attention to "Office 0 Foundation", let us step from zero.

The synchronized video course will meet you soon.

Office 0 Foundation--excel article