Jump into Excel. Training Course from Beginner to Intermediate in two hours - Aleksey Skorodumov

Скачать книгу

this feature is often used when working with a lot of arrays and in long formulas to shorten them. In other cases, it is not recommended to specify the names of objects without a necessity.

      The Function Wizard button is used for quick search and insertion into the active cell of any of the built-in Excel functions. We will get acquainted with the basic built-in Excel functions later.

      Function Wizard

      The Formula bar shows the contents of the Active Cell. If the active cell contains a constant, then both in the cell and in the formula bar we will see this constant, for example «2». But if the active cell contains a formula, for example "=2+2», then in the formula bar we will see the formula itself, and in the cell, we will see the result of the formula – «4». The text of the formula contained in the cell can be edited.

      Formula bar

      The labels with the Names of the sheets are at the very bottom of the window. Sheets can be renamed, added, deleted, renamed again.

      Names of the sheets

      There can be hundreds of sheets in a single Excel file. But in practice, they are usually limited to 10, maximum 20 sheets. The thing is that when there are a lot of sheets, it becomes inconvenient to search for information.

      Scrollbars allow you to see adjacent areas of the sheet that are not currently visible. The row scroll bar is on the right, and the column scroll bar is at the bottom of the sheet. We hover the mouse cursor over the viewing direction, click the left mouse button and do not let go until we find ourselves in the place that we are interested in seeing. If we scroll through several rows or columns, we stop seeing the active cell, but at the same time, we will still see which cell is active in the object name field.

      we will still see cell «A1» in the object name field

      Please note: the active cell itself does not shift at the same time. It’s still A1.

      To make another cell active, use the mouse or keyboard arrows instead of scroll bars. To select another cell with the mouse, just hover the mouse cursor over another cell, for example D1, and click the left mouse button.

      To select cell «D1», just hover the mouse cursor and left-click

      You can also move the active cell using the arrows on the keyboard, which are located in the lower right corner of the keyboard.

      Filling in the file with the initial information

      Now let’s go back to our task and start filling in the file with the initial information.

      Let’s open the first of the sent files «Information from the director’s secretary».

      As you can see, there is not complete information on the task: there is no Date of birth, no Date of employment, no Experience years and Age. But at the same time, there is information that was not required by the assignment: a Work phone and an E-mail.

      file «Information from the director’s secretary»

      We will copy all this information into our «Employees» file on a separate sheet, which we will call «Information from secretary».

      In order to rename «Sheet1» to the name «Information from secretary», hover the mouse cursor over «Sheet1», press the right mouse button, select «Rename» and type in «Information from secretary», then press the «Enter» key.

      select «Rename»

      and type in «Information from secretary», then press the «Enter» key.

      type in «Information from secretary»

      Copy operation

      Before copying, it is necessary to highlight the cell that we are going to copy. «Highlight» means to stand on a cell with a tabular cursor. This can be done using the arrows located on the keyboard in the lower right corner.

      You can also select a cell using the mouse cursor. Hover the mouse cursor, for example, on the cell «G26» and click the left mouse button. To highlight the entire copied range, we stand on its corner cell, for example «G26». Click on the left mouse button and, without releasing this button, drag the cursor to the opposite corner. And only after bringing it to the end – we release the left mouse button pressed.

      Thus, the entire block of cells is highlighted.

      the entire block of cells is highlighted

      Let’s repeat it again. We stand on the cell «A1», press the left mouse button and drag the cursor now to the lower opposite corner. When dragged – release the left mouse button.

      and drag the cursor now to the lower opposite corner

      There is another way to select the desired cells. We can select for copying. Not only the range A1:G26, which is a part of the columns A:G, that is, but all the cells of the columns A:G at once. To do this, hover the cursor over the name of column «A», above cell A1, click on the left mouse button and, without releasing it, drag the mouse cursor to the right until column G is highlighted. Release the pressed left mouse button.

      all the cells of the columns A:G at once

      After the range for copying is selected, click on the «Copy» button located on the «Home» tab.

      click on the «Copy» button located on the «Home» tab

      Instead of using the «Copy» button, we can hover the mouse cursor over the selected range, right-click and select «Copy».

      right-click and select «Copy»

      For copying, the «Ctrl» and «C» keys located on the keyboard are also often used. First, press the «Ctrl» and, without releasing it, press the «C» key with the second finger.

      Regardless of the chosen copying method, the result will be the same: a copy of the selected fragment gets to the Clipboard and is ready for insertion in any other place, both in this file and in any other file. Around the copied fragment, a temporary dynamic dotted line appears, indicating copies of which cells are currently in the Clipboard.

      Paste operation

      We stand with the tabular cursor on the cell in which we are going to insert the data on our «Information from secretary» sheet.

      Since we are going to insert not one cell, but a whole array of data, we must stand on the upper left cell of this array (in this case it is cell «A1»), below which and to the right of which the entire array will be inserted.

      we must stand

Скачать книгу