Читать книгу Jump into Excel. Training Course from Beginner to Intermediate in two hours - - Страница 4

The Excel file will open as a blank sheet looking like this. The specific view depends on the computer settings and the version of Excel.

blank sheet looking like this

Let’s get acquainted with what we see.

Control buttons for the main program window

They are located in the upper right area of the Excel window. They allow you to close a file, Minimize it, minimize it into a window, expand the window to full screen.

Control buttons for the Main Program Window

The Quick Access Toolbar is located in the upper left area of the Excel window.

If we often use the same commands, we can bring the command buttons here and run commands from here. For example, the «Save changes» command is often used. If you do not click it, then everything you have done in the file after opening it will disappear after closing the file. The «Undo last action» command is also often used. For example, if you accidentally deleted a column with the necessary information, clicking on this command will return you to the state that was before the deletion.

Quick Access Toolbar – for frequently used commands

If desired, we can add any other commands to the Quick Access Toolbar by clicking on the edit button of the Quick Access Toolbar. Select «More Commands»

Select «More Commands»

and add the necessary ones.

add the necessary commands

Tabs.

Under the quick access toolbar there is a ribbon with available tabs: Home, Insert, Page Layout, Formulas, Data, Review, View. As you can see, each tab has its own set of commands.

each tab has its own set of commands

This set of commands can be edited if desired – you can add or remove commands. I do not recommend beginners to engage in such editing – everything you need is already configured by default. But if we really need to add our own commands, then it’s easy to do: hover the mouse cursor over any point of the tabs, click the right mouse button, select «Customize the Ribbon» and get to the tab editing menu, where we can not only add any command to any tab, but also create our own tab.

select «Customize the Ribbon»

For example, select «New Tab»,

select «New Tab»

name it «Aleksey» (it’s my name),

name it «Aleksey»

and we can add any commands to this tab. Click «OK».

Now, we have a new tab with the name «Aleksey».

a new tab with the name «Aleksey»

Since we don’t actually need this tab, we Remove it.

Remove tab «Aleksey»

And it disappeared.

Tab commands are located under the ribbon with the tabs. When opening a file, we see the commands of the «Home» tab, since the «Home» tab opens by default. If we move to another tab, for example, the «Formulas», then we will see the commands of this other tab.

To access individual cells inside a spreadsheet, the Cell names are used. The Cell name is a combination of its column (denoted by the Latin letter A, B, C, D …) and its row number (1, 2, 3, 4, 5 …). In total, there are more than 16,000 columns and more than a million rows in the Excel file on one sheet, that is, more than 16 billion cells on each sheet.

Cell «A1»

Object name field.

By default, there we see the name of the active cell in which the table cursor is located therefore, the active cell is often called «Highlighted». We can select any object: a cell, a group of cells, a table, a graph and assign (by typing) any name in this field of the object name, for example «Table1», in order to further refer to the named object by its specific name.

object name «Table1»

In practice, 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.