Why do you need work at Excel?

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

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

Key features:

1. Economic calculations.
2. Statistical calculations.
3. Building diagrams.
4. Automation of calculations (accounting, engineering).
5. Processing huge amounts of data.
6. Autofill rows, cells, columns.
7. The solution of equations.
8. Analysis of the results.
9. Using programming languages ​​to implement some functions of a non-standard form.
10. Use of cartographic work.
11. Protecting user-selected data from unauthorized use.

Work in Excel involves the following presets:

• inclusion of the main toolbars, which include "Standard" and "Formatting";
• display of the main buttons of each panel by moving the panels;
• Enabling the “Full menu” display.

Workbook and its structure

Extensions of documents that provide work in "Excel" are of type .xls. Each newly created document is called “Book” by default. By default, three sheets are always created in the workbook.

Each new sheet is a table consisting of 256 columns and 65536 rows. 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 a cell (cell) at the intersection of a line and a column consists of a letter and a number.

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

Available operations on pages or sheets:

1. Switching. Left-click or Ctrl + PageUp, as well as Ctrl + PageDown.
2. Changing the order of location - left mouse button (drag and drop).
3. Copy - Ctrl key and drag.
4. Select more than one sheet in a different order. Ctrl button (clamped) and left click.
5. Select a range from created sheets. Shift button (clamped) and left-click on the start and end sheets in turn.

Working in Excel offers the following context menu commands:

1. Add. A template, graph, new sheet, etc. are added.
2. Delete Deleting cells, rows, columns, followed by data shift.
3. "Rename". Change the name of a sheet, document, etc.
4. "Make copies / move." The choice of copying or moving a sheet as a separate document, and moving data to a separate sheet is provided. And also the name of the new sheets.
5. "Select all sheets."
6. "Label color".

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

Still work in the Excel program involves the function of formatting cells. You can call up the formatting window using the context menu. Available for editing: numerical format, cell / document protection, types (sizes, colors) of fonts, content alignment, type of cell borders.

Let's hope that now everyone who reads this article clearly understands that work in Excel is necessary for almost everyone in our time.