Sorting in Excel. Work in Excel. Excel in the examples

The program Microsoft Excel is indispensable for working with figures and tables. It allows you to easily produce complex calculations, build charts and diagrams. Working with tables that have a list view, Microsoft Excel makes it possible to select the necessary values and sort the columns. Data can be sorted in ascending or descending order according to the values that are located in the cells. The same manipulations can be done with text material, it will either be in alphabetical order or in reverse alphabetical order. Sorting in Excel is necessary for the information to be accessible to perception and easy to read.

Creating your own sort order

Sometimes there are situations when you need to sort the data in the order that differs from those already existing. In this case, you can create your own order, which is necessary for further work.

To create your own order, go to the "Tools" tab, and then select the "Options" item. There there is a menu "Line" where on the left part of a window there are already existing lists used for sorting. To create your own order, select the "New list" option. All the necessary values and parameters must be set in the "List items" field.

Separate input values with the "Enter" key. Enter all the data in the same order, according to which the future list will be sorted. When all the values are set, you need to click the "Add" button. To import a list that has already been typed on the desktop, you should use the "Import list from cells" option, specifying the addresses of certain cells. But this can only be done if the existing list contains the elements in the order that is required to further sort the values. Finally, click "Import".

Now you can easily organize the information so that work in Excel is comfortable. To do this, go to the "Data" menu, then select the "Sort" tab. In the "Sort by ..." field, you must specify specific parameters and click the appropriate button. The "Sorting parameters" window will appear on the screen, where you need to specify the sort order of the data.

After that, select your own sorting order and confirm the selection by clicking OK.

In order to be sorted in Excel, you need to place the cursor in a certain cell and click on the corresponding sort button: in ascending or descending order. They are located on the toolbar.

Sorting by surname and salary

Often at the enterprises there is a situation when it is necessary to sort the data according to the surnames of the employees. This is convenient because the data relating to a particular employee will be in one line.

For clarity, information is sorted not only by last name, but also depending on the amount of salary. In this case, one of the sort buttons is indispensable. If you need to sort the data, Excel offers the following output:

• You need to activate the "Data" command, and then "Sort".
• In the "Sort range" window that opens, select "Sort by ..." and specify a specific column. Then move the pointer to the desired position: in ascending or descending order.

For the second field, sorting is similar. The program will sort by name only those employees who have the same salary.

If the amount of information is very large, you can create your lists to organize the data. This will help to avoid mistakes when working with the material, in addition it will be easier to handle.

Sort alphabetically

To sort the information in alphabetical order, you need to go to the "Data" menu. Previously, you need to select the column to which the function should be applied. The data will be sorted after clicking the icon "from A to Z" or vice versa. After that, a window will appear on the screen, which will contain the question: "Is it necessary to extend the data range automatically?" It is necessary to agree and press the "Save" button. However, the shared document will not lose its meaning, and the data of the remaining columns will correspond to the changed one.

Sorting in Excel can be done in another way. Selecting a specific cell, you need to click on the icon. But in this case the issue of expanding the range will not appear, it expands automatically.

Multilevel sorting

When working with documents, you may also need a multi-level sorting in Excel. To use this function, you need to select a cell in the list and click on the "Sort" item under it. One level will already be there, and you can choose the next one, for example by date. To do this, click "Add level". For convenience, it is possible to make the list of levels sorting by topic.

If necessary, the levels move down or up, which changes their priority. To do this, select the level and click on the arrow icon. Also, levels are easily copied or deleted.

Formulas in Microsoft Excel

Formulas in Excel are expressions that start with an equal sign, consist of numeric values, cell addresses, names or functions. All of them are connected by signs of arithmetic operations: multiplication, division, subtraction or exponentiation.

The operations in the formula are divided according to the priorities:

• Expression in brackets and exponentiation.
• Division and multiplication.
• Subtraction and addition.

The cell displays only the result, and the formula itself is located in the formula bar. When you change the values, the end result changes automatically.

How do I make a change to the formula?

If there is a need to change the formula, you need to click the mouse in the formula bar or press the F2 button. After all adjustments, you must press "Enter" or the input icon in the line. You can also make changes directly in the cell. To do this, click on the selected area twice.

References to cells and the movement of formulas

Studying Excel, in the examples you can often see links. The use of references makes it possible to apply data in the formula that are in different places on the sheet. It is possible to use references to cells located in other workbooks or applications.

After entering the formula in the cell, you can transfer it or copy it to another location. In this case, the cell where the formula was located becomes free. Only relative references are changed, and absolute ones are kept constant.

To move the formula, you need to move the cursor to the corner of the cell, so that a double-headed arrow appears. While holding the mouse button, you can drag it to the desired location.