background top icon
background center wave icon
background filled rhombus icon
background two lines icon
background stroke rhombus icon

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

input logo icon
Video tags
|

Video tags

формулы эксель
формулы excel
расчеты в excel
формулы в excel
excel курс
курс эксель
работа в эксель
microsoft excel
эксель для начинающих
эксель для чайников
excel с нуля
excel для чайников
excel для начинающих
эксель таблицы
электронная таблица excel
эксель с нуля
excel уроки
эксель уроки
уроки эксель
работа в excel
уроки excel
как работать в excel
таблица эксель
Андрей Сухов
эксель обучение
таблицы в excel
excel обучение
excel
эксель
Subtitles
|

Subtitles

subtitles menu arrow
  • ruRussian
Download
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 icon
Popular
hd icon
HD video
audio icon
Only sound
total icon
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

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

  • 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.

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

  • 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.

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

  • 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.

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

  • 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.

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

  • 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.

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

  • 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.

mobile menu iconWhat's the price of all this stuff?mobile menu icon

  • 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.