Why do I need work at Excel?

In order to correctly answer the question of what good work with Excel is, it is necessary to understand what this program is.

This office application specializes in working with spreadsheets and numerical values.

Main features:

1. Economic calculations.
2. Statistical calculations.
3. Drawing diagrams.
4. Automation of calculations (accounting, engineering).
5. Processing huge amounts of data.
6. Autocomplete rows, cells, columns.
7. Solving equations.
8. Analysis of the results.
9. Using programming languages to implement some non-standard functions.
10. Use of cartographic works.
11. Protect user-selected data from unauthorized use.

The work in "Excel" assumes the following preliminary settings:

• Including the main toolbars, which include "Standard" and "Formatting";
• Display the main buttons of each panel by moving the panels;
• Enable the "Full Menu" display.

Working book and its structure

Extensions of documents that work in Excel are of the type .xls. Each new created document is called "Book" by default. By default, three worksheets are always created in the workbook.

Each new sheet is a table consisting of 256 columns and 65536 lines. Each column of the document has a "name" in the form of letters of the Latin alphabet. The string is an Arabic number. Accordingly, the address of the cell (cell) at the intersection of the line and the column consists of a letter and a digit.

The activity of any cell is single, the cell involved or their range is highlighted by a dark outline.

Available operations on pages or sheets:

1. Switching. Click left mouse button or combination of buttons Ctrl + PageUp, and Ctrl + PageDown.
2. Change the order of location - the left mouse button (drag and drop).
3. Copy - Ctrl key and drag.
4. Selecting more than one sheet in a different order. Ctrl key (pressed) and left click.
5. Selecting a range from the created sheets. Shift button (clamped) and left click on the start and end sheets alternately.

Work in Excel offers the following commands of the context menu:

1. "Add". Adds a template, a graphic, a new sheet, and so on.
2. "Delete". Deleting cells, rows, columns, and then shifting the data.
3. "Rename". Change the sheet name, document, and so on.
4. "Make copies / move". You are given the option of selecting a copy or moving the sheet as a separate document, or moving the data to a separate sheet. And also the name of new sheets.
5. "Select all sheets".
6. "Label color".

Also working with Excel means changing the size of rows or columns. To do this, move the cursor to the separation between the rows / columns so that it changes the shape. When you hold down the left mouse button and move the already changed cursor, the size will be subject to change. If you select a range of rows / columns and change the size of one component, the remaining size will be changed automatically.

Another work in the Excel program assumes the function of formatting cells. Call the formatting window using the context menu. For editing are available: numerical format, cell / document protection, types (sizes, colors) of fonts, content alignment, cell border type.

Let's hope that now everyone who read this article clearly understands that the work in "Excel" is necessary for almost everyone nowadays.