ComputersFile Types

How to learn how to work in Excel yourself: program description, recommendations and feedback

Anyone who uses a computer in their daily work, one way or another encountered an office Excel application, included in the standard package of Microsoft Office. It is available in any version of the package. And quite often, starting the introduction to the program, many users are wondering how to learn how to work in Excel yourself?

What is Excel?

First, let's define what is Excel, and what this application is for. Probably, many heard that the program is a table editor, but the principles of its operation are fundamentally different from the same tables that are created in Word.

If in Word the table acts more as an element in which text or graphic information is displayed , then the sheet with the Excel table is, in essence, a unified mathematical machine that is capable of performing a wide variety of calculations based on the data types and formulas that will be produced. Or another mathematical or algebraic operation.

How to learn how to work in Excel yourself and can it be done?

As the heroine of the film "Office Romance" said, you can also teach a hare to smoke. In principle, nothing is impossible. Let's try to understand the elementary principles of the functioning of the application and dwell on an understanding of its basic capabilities.

Of course, the feedback of people who understand the specifics of the application, say that you can, say, download some self-instruction work in Excel, however, as practice shows and especially the comments of novice users, such materials are often presented in a very abstruse form, and To understand is quite difficult.

It seems that the best option for learning is learning the main features of the program, and then applying them, so to speak, "the method of scientific poking." Needless to say, you first need to consider the basic functional elements of Microsoft Excel (the lessons of the program show exactly this), in order to make a complete picture of the principles of work.

The main elements to look at

The very first thing that a user pays attention to when starting an application is a sheet in the form of a table in which the cells are numbered in different ways, depending on the version of the application itself. In earlier versions, the columns were denoted by letters, and the lines were denoted by numbers and numbers. In other releases, all markings are presented exclusively in digital form.

What is it for? Yes, only to always be able to determine the cell number for specifying a certain calculation operation by the type of how coordinates are set in a two-dimensional system for a point. Later it will be clear how to work with them.

Another important component is the formula line - a special field, with the "f x " on the left. It is here that all operations are set. In this case, the mathematical actions themselves are indicated in the same way as is accepted in the international classification (equality sign "=", multiplication "*" division "/", etc.). Trigonometric values also correspond to international designations (sin, cos, tg, etc.). But this is the simplest. It is more difficult to master operations using the help system or specific examples, since some formulas may look rather specific (exponential, logarithmic, tensor, matrix, etc.).

Above, as in other office programs, there is a main panel and the main menu sections with the main operations items and buttons for quick access to a particular function.

Data types and the simplest operations with them

Consideration of the question of how to work in an Excel program is impossible without a key understanding of the types of data entered in the cells of the table. Just note that after prescribing some information, you can press the enter button, Esc key or simply move the rectangle from the desired cell to another - the data will be saved. Editing a cell is called by double clicking or pressing the F2 key, and when the data entry is completed, the saving is done only when the Enter key is pressed.

Now a few words about what you can enter into each cell. The format menu is called by right clicking on the active cell. On the left there is a special column indicating the type of data (common, numeric, textual, percentage, date, etc.). If a common format is chosen, the program, roughly speaking, itself determines what exactly the entered value looks like (for example, if you enter 01/01/16, the date will be recognized on January 1, 2016).

When entering a number, you can use the indication of the number of decimal places (by default, one character is displayed, although when you enter two, the program simply rounds the visible value, although the true one does not change).

If you use, say, a text-based data type, whatever the user enters, it will be displayed exactly as typed on the keyboard, unchanged.

Here's what's interesting: if you move the cursor to the selected cell, a cross appears in the lower right corner, pulling it with the left mouse button clamped, you can copy the data to the next for the desired cells in order. But the data will change. If we take the same example with a date, the next value will be indicated on January 2, etc. Such copying is useful when specifying the same formula for different cells (sometimes even with cross-computations).

If we talk about formulas, we can use a two-pronged approach for the simplest operations. For example, for the sum of the cells A1 and B1, which should be computed in cell C1, you need to place the rectangle in the field C1 and specify the calculation using the formula "= A1 + B1". You can do otherwise by setting the equality "= SUM (A1: B1)" (this method is more used for large gaps between cells, although you can use the automatic summation function, as well as the English version of the SUM sum command).

Excel program: how to work with Excel sheets

When working with sheets, you can perform many actions: add sheets, change their name, delete unnecessary ones, etc. But the most important thing is that any cells on different sheets can be interconnected by certain formulas (especially when large arrays of information of different types are entered).

How to learn how to work in Excel independently in terms of using cross-references and calculations? Here, not everything is so simple. As the feedback from users who once mastered this spreadsheet editor shows, it will be quite difficult to do this without help. You need to read at least the help system of the program itself. The simplest way is to enter cells in the same formula by selecting them (you can do this on one sheet and at different ones.) Again, if you enter the sum of several fields, you can write "= SUM", and then simply alternate with the Ctrl key pressed But this is the most primitive example.

Additional Features

But in the program you can not only create tables with different types of data. On their basis for a couple of seconds, you can build all sorts of graphs and diagrams by setting either a selected range of cells to automatically build, or to specify it in manual mode when you enter the appropriate menu.

In addition, the program has the ability to use special add-ons, executable scripts based on Visual Basic. You can insert any objects in the form of graphics, video, audio or something else. In general, there are enough opportunities. And here only a small part of all that this unique program is capable of is affected.

But what can I say, with the right approach, it can calculate matrices, solve all sorts of equations of any complexity, find extremums of functions, create databases and associate them with other applications like Microsoft Access and much more - you just can not enumerate everything.

The result

Now, probably, it is already clear that the question of how to learn how to work in Excel yourself is not so easy to consider. Of course, if you master the basic principles of working in the editor, you will not be able to specify the simplest operations of labor. User feedback testifies that you can learn this maximum for a week. But if you need to use more complex calculations, and even more so, work with database binding, no matter how much you want, without special literature or courses, you just can not do. Moreover, it is very likely that we will have to pull up even our knowledge of algebra and geometry from the school course. Without this, you can not even dream of using the spreadsheet fully.

Similar articles

 

 

 

 

Trending Now

 

 

 

 

Newest

Copyright © 2018 en.unansea.com. Theme powered by WordPress.