Download "Видео #7. Расчеты в Эксель. Курс по работе в Excel для начинающих"

"videoThumbnail Видео #7. Расчеты в Эксель. Курс по работе в Excel для начинающих

Урок 3. Формат ячеек в Excel для начинающих

Урок 3. Формат ячеек в Excel для начинающих

Channel: Езепов Дмитрий

Урок 1. Интерфейс Excel 2013 (лента, панель быстрого доступа, меню)

Урок 1. Интерфейс Excel 2013 (лента, панель быстрого доступа, меню)

Channel: Езепов Дмитрий

REMOVE Excel Sheets & Structure PROTECTION without PASSWORD – Quick & Easy

REMOVE Excel Sheets & Structure PROTECTION without PASSWORD – Quick & Easy

Channel: Билял Хасенов – Excel, VBA & More

Урок 4. Формулы Excel для начинающих

Урок 4. Формулы Excel для начинающих

Channel: Езепов Дмитрий

Видео #2. Ввод данных в Эксель. Курс по работе в Excel для начинающих

Видео #2. Ввод данных в Эксель. Курс по работе в Excel для начинающих

Channel: Андрей Сухов

Урок 2. Ввод данных на лист Excel для начинающих

Урок 2. Ввод данных на лист Excel для начинающих

Channel: Езепов Дмитрий

Урок 5. Копирование данных в Excel для начинающих

Урок 5. Копирование данных в Excel для начинающих

Channel: Езепов Дмитрий

Видео #1. Интерфейс Эксель. Курс по работе в Excel для начинающих

Видео #1. Интерфейс Эксель. Курс по работе в Excel для начинающих

Channel: Андрей Сухов

8 инструментов в Excel, которыми каждый должен уметь пользоваться

8 инструментов в Excel, которыми каждый должен уметь пользоваться

Channel: Билял Хасенов – Excel, VBA & More

формулы эксель

формулы excel

расчеты в excel

формулы в excel

excel курс

курс эксель

работа в эксель

microsoft excel

эксель для начинающих

эксель для чайников

excel с нуля

excel для чайников

excel для начинающих

эксель таблицы

электронная таблица excel

эксель с нуля

excel уроки

эксель уроки

уроки эксель

работа в excel

уроки excel

как работать в excel

таблица эксель

Андрей Сухов

эксель обучение

таблицы в excel

excel обучение

excel

эксель

00:00:03

Well, now let's move on to the most

00:00:06

interesting part - calculations using the

00:00:08

excel program. First of all, let's

00:00:11

figure out how

00:00:13

calculations are made in the program in general and

00:00:15

we'll start with the simplest example in

00:00:18

our table, we need to make

00:00:21

summary calculations, that is, for example

00:00:23

here we have there is a column for the total of this

00:00:26

income, that is, a final column for

00:00:28

income, and in this group we need to display the

00:00:32

total income for the month of January, for example,

00:00:35

for all our sources of income, that is,

00:00:38

we need to add the salary to

00:00:40

tutoring, add to the rental of the apartment,

00:00:42

and we will get some kind of total here

00:00:44

number in order for you to make

00:00:47

calculations in the excel program,

00:00:48

we need to indicate the cell in which we

00:00:51

will perform these calculations, then

00:00:53

we need to press the key that

00:00:57

leads us to the equal sign in this check as

00:01:01

soon as we entered the equal sign of things q the

00:01:03

excel program immediately understands what

00:01:06

the next thing is that the formula will be placed in this check.

00:01:08

Now we can

00:01:12

do the following: we need our

00:01:14

salary, that is, I directly write, for example, 20

00:01:16

thousand plus 10 thousand plus 11 thousand, yes, that

00:01:23

is, we need to sum up three numbers,

00:01:25

press enter and the program automatically

00:01:28

calculates our formula, that is I

00:01:30

circled three numbers, if I now select a check,

00:01:33

you see that here in the formula bar and

00:01:35

my formula 20 plus 10

00:01:38

plus 11 is displayed and the values are displayed, that is, the

00:01:41

program automatically calculates this

00:01:44

formula and the value is already displayed in the cell,

00:01:46

very convenient, but in fact,

00:01:49

since For us, this table is electronic

00:01:52

and each cell has some kind of

00:01:54

content, that is, some kind of

00:01:57

digital or text

00:02:00

text content, then we can

00:02:02

use for the formula

00:02:04

the value that we already have

00:02:06

in our table, we don’t need to

00:02:08

enter it manually every time. these are

00:02:11

the values we can do as follows: I

00:02:14

now press the ticket key, what will be

00:02:16

the value of this cell, again clicking on the

00:02:19

equal sign to tell the program

00:02:22

that now there will be a formula, and then

00:02:24

we do the following: select the first cell,

00:02:26

salary, press plus, select the second

00:02:31

cell, tutoring, press plus and

00:02:34

select 3 cell renting an apartment, I press

00:02:38

the enter key, you see that the

00:02:41

same value of 41 thousand rubles is displayed, that

00:02:44

is, if you now select this cell,

00:02:46

you see that in the line of the form I

00:02:48

display the addresses of specific cells, that

00:02:50

is, I do not display the value

00:02:52

h to their addresses if I now, for example, in

00:02:55

some cell I

00:02:56

change the value, then in my case this cell is

00:03:00

automatically recalculated according to the

00:03:03

current value, if somewhere, for

00:03:05

example, my salary for a

00:03:08

month changes, the date will automatically be

00:03:11

recalculated in all cells

00:03:13

that use this in their formulas

00:03:16

the check that I change is this;

00:03:19

this is the global advantage of

00:03:20

spreadsheets: if I use the value of a

00:03:23

cell in some

00:03:25

subsequent formulas,

00:03:26

as soon as I change the value of the cell, all

00:03:29

formulas are automatically recalculated, but

00:03:32

in fact, what we have just

00:03:34

done this, of course, makes

00:03:37

the work a lot easier, but in the excel program there is

00:03:39

another option that will do this work for us, it’s

00:03:43

just very cool on my

00:03:45

shoulders, we have now calculated

00:03:48

the formula by simply entering through the + 2 sign, is it

00:03:52

possible, in principle, to enter the cell addresses

00:03:54

my swami indicated in the work area of the

00:03:56

programs excel of a

00:03:57

specific cell and they were substituted with

00:03:59

a formula if, for example, now I call to

00:04:02

edit this cell, you see

00:04:04

that I have here, for example, 5 to

00:04:06

cell c5,

00:04:08

here it is displayed in a blue frame and

00:04:10

here I display blue numbers to

00:04:12

green frame green green frame

00:04:15

here green and the address of the cell ours are clear

00:04:17

purple purple so we

00:04:19

can see which cell is where we have it

00:04:22

if we change anything now I

00:04:25

want to tell you about one more feature

00:04:27

that program

00:04:29

x has and if we now go to calculate

00:04:32

the number of expenses for this month you

00:04:35

see how many values there are here yes

00:04:37

if We also press the equals button and

00:04:39

let us begin to select

00:04:42

all these cells in a way that is already well known to us,

00:04:45

you must agree, this is very inconvenient, which is why

00:04:47

in the Excel program there is such a

00:04:50

thing called the formula editor,

00:04:52

let's go into it, to do this,

00:04:56

click on this button on the line

00:04:58

formulas and the formula wizard appears

00:05:01

here a large number of formulas they are all

00:05:04

sorted into different categories we

00:05:08

can select the categories that

00:05:10

we need and

00:05:13

accordingly we will

00:05:14

use them by default the

00:05:17

category 10 recently used is selected here

00:05:19

this means that these are the categories we

00:05:21

used Recently, if we

00:05:23

use some formulas

00:05:26

most often, they will be

00:05:27

displayed here and we will not need to

00:05:29

select them from this list every time,

00:05:32

for example, select mathematical ones and

00:05:35

see how many different

00:05:37

formulas there are, how to understand this is the formula we

00:05:40

really need In fact, of course, it’s

00:05:43

quite difficult to do this right away,

00:05:44

usually when using the

00:05:47

Excel program in I, for example, look on the Internet for

00:05:50

information about what formula

00:05:53

could help me, just a ready-made function in the

00:05:55

Excel program and only then I use it,

00:05:58

select it from the appropriate category of

00:06:00

programs, and of course, if you need

00:06:02

some kind then a specific formula, you can

00:06:05

simply scroll through all these

00:06:08

functions and under each function it is

00:06:11

written here and what it does, yes, that is, you

00:06:15

can select the function that you

00:06:17

need, by scrolling through and reading

00:06:20

about them all,

00:06:21

but also here in the program there is a

00:06:23

help system which will allow you

00:06:27

to find the function that you need, well, I

00:06:32

try not to use the help system; it’s

00:06:33

much easier to ask a question

00:06:35

on the Internet and get a quick answer right away. You and I

00:06:38

need a function that is

00:06:40

used very often it is the

00:06:42

summation function, here it is the very

00:06:44

first one, we can

00:06:45

select it by pressing a button ok and a

00:06:49

standard window appears,

00:06:51

it may differ slightly

00:06:53

depending on the functions,

00:06:54

but the meaning here is simple, we just need to

00:06:56

select the range that we want to

00:06:58

sum up the range, as we know, these are

00:07:01

several things that we have selected

00:07:03

at the same time, to select a range,

00:07:05

click on this button and then

00:07:08

click I hold the left button on the first cell

00:07:10

pressed and drag until the last

00:07:14

cell and here we have not yet

00:07:16

planned for which we have not Willie

00:07:17

Thorne yet, they will need to be summed up, the entire

00:07:20

range is selected, we press this

00:07:23

cell again and say ok and now we were

00:07:29

given the total expenses, yes, that is

00:07:31

if we now manually sum up

00:07:33

all these columns, then we will get exactly

00:07:35

this figure, which you will agree is much

00:07:38

more convenient than reflashing all our

00:07:41

values manually, respectively, pay

00:07:44

attention to the formula line and what

00:07:47

our

00:07:49

function looks like, the name of the function is listed in brackets

00:07:52

that range, the range is

00:07:54

usually listed through a colon,

00:07:56

we sum up cells from 9 to c22,

00:08:00

here we have cell c9, here we have the last one whose

00:08:04

end is 22, respectively, in this

00:08:07

way it is not summed up for us;

00:08:15

in order to display the formula,

00:08:17

select income, press the minus sign

00:08:20

to subtract from expenses, press the

00:08:23

enter key, now we have a very

00:08:26

positive balance, that is, our income

00:08:28

far exceeds our expenses and now

00:08:32

we can, in general, then copy all our

00:08:34

rental formulas along all

00:08:38

lines, how to do this let's

00:08:40

figure this out now,

00:08:42

remember how you and I

00:08:43

copied values, we selected

00:08:46

a cell, grabbed it by the lower right

00:08:50

corner and dragged it in order to

00:08:52

copy the value of a given cell, the

00:08:55

same can be done with our formulas

00:08:59

for this we select, for example, 3 of ours and

00:09:03

grab the receipts here in this way we drag and

00:09:08

drop you see that here we have

00:09:13

all the values from copy if we

00:09:16

now go, for example, to the next

00:09:19

seagull, that is, not in a ton in the

00:09:22

cf column, columns d, please

00:09:23

note that I have already

00:09:25

summed up the cells in column d if in

00:09:31

this check I sum up columns c

00:09:33

in this, respectively columns d, this is a

00:09:36

feature of the program, that is, when

00:09:38

copying cells in this way,

00:09:41

the program automatically replaces

00:09:43

the value in these cells and thus

00:09:46

we can very easily get the formula

00:09:50

for our specific column as you

00:09:53

see everything in automatic mode the same thing

00:09:56

with the sum, you see that here

00:09:58

I have the sum of

00:09:59

cells 100 column c next became in the

00:10:04

next seagulls respectively v.d.

00:10:05

and so on up to n and the same with our

00:10:09

balance, here we have calculations for the

00:10:11

corresponding column

00:10:13

and in this way the program

00:10:16

helps us greatly to speed up the

00:10:19

process of creating tables for our

00:10:22

calculations, well, with this I propose to finish this lesson

00:10:27

and in the next one we will Let's talk about

00:10:29

some more capabilities of the program in terms of

00:10:31

calculations

Description:

👉 Курсы по Microsoft Excel - https://andreysukhov.ru// В седьмом видеоуроке по основам программы Microsoft Excel речь пойдет о самом интересном — о формулах и расчетах. Microsoft Excel имеет очень мощный инструментарий для проведения различных расчетов. Мы научимся производить простейшие вычисления с помощью электронных таблиц, затем познакомимся с мастером функций, который позволяет в значительной мере упростить процесс создания формул для проведения расчетов. ★ Авторские книги и курсы: https://andreysukhov.ru ★ Скачать курс по Excel: https://andreysukhov.ru/education/excel-free/ ★ Телеграм: https://t.me/excelmate ★ Дзен: https://zen.yandex.ru/id/5c4d8a530aaeef00ac928ac3 ★ Группа ВК: https://vk.com/public212583018 #Excel

Preparing download options

Popular

HD video

Only sound

All

* — If the video is playing in a new tab, go to it, then right-click on the video and select "Save video as..."

** — Link intended for online playback in specialized players

Questions about downloading video

How can I download "Видео #7. Расчеты в Эксель. Курс по работе в Excel для начинающих" video?

http://unidownloader.com/ website is the best way to download a video or a separate audio track if you want to do without installing programs and extensions.
The UDL Helper extension is a convenient button that is seamlessly integrated into YouTube, Instagram and OK.ru sites for fast content download.
UDL Client program (for Windows) is the most powerful solution that supports more than 900 websites, social networks and video hosting sites, as well as any video quality that is available in the source.
UDL Lite is a really convenient way to access a website from your mobile device. With its help, you can easily download videos directly to your smartphone.

Which format of "Видео #7. Расчеты в Эксель. Курс по работе в Excel для начинающих" video should I choose?

The best quality formats are FullHD (1080p), 2K (1440p), 4K (2160p) and 8K (4320p). The higher the resolution of your screen, the higher the video quality should be. However, there are other factors to consider: download speed, amount of free space, and device performance during playback.

Why does my computer freeze when loading a "Видео #7. Расчеты в Эксель. Курс по работе в Excel для начинающих" video?

The browser/computer should not freeze completely! If this happens, please report it with a link to the video. Sometimes videos cannot be downloaded directly in a suitable format, so we have added the ability to convert the file to the desired format. In some cases, this process may actively use computer resources.

How can I download "Видео #7. Расчеты в Эксель. Курс по работе в Excel для начинающих" video to my phone?

You can download a video to your smartphone using the website or the PWA application UDL Lite. It is also possible to send a download link via QR code using the UDL Helper extension.

How can I download an audio track (music) to MP3 "Видео #7. Расчеты в Эксель. Курс по работе в Excel для начинающих"?

The most convenient way is to use the UDL Client program, which supports converting video to MP3 format. In some cases, MP3 can also be downloaded through the UDL Helper extension.

How can I save a frame from a video "Видео #7. Расчеты в Эксель. Курс по работе в Excel для начинающих"?

This feature is available in the UDL Helper extension. Make sure that "Show the video snapshot button" is checked in the settings. A camera icon should appear in the lower right corner of the player to the left of the "Settings" icon. When you click on it, the current frame from the video will be saved to your computer in JPEG format.

What's the price of all this stuff?

It costs nothing. Our services are absolutely free for all users. There are no PRO subscriptions, no restrictions on the number or maximum length of downloaded videos.