Download "Por que Evitar Células Mescladas no Excel para Fazer Análise de Dados?"

"videoThumbnail Por que Evitar Células Mescladas no Excel para Fazer Análise de Dados?

Como Criar Formulário de Cadastro no Excel (SEM VBA!)

Como Criar Formulário de Cadastro no Excel (SEM VBA!)

Channel: Hashtag Treinamentos

Segmentação de dados no Excel - Aula completa

Segmentação de dados no Excel - Aula completa

Channel: Hashtag Treinamentos

#6 - Login en Excel VBA - Excel Userform Login, formularios en Excel

#6 - Login en Excel VBA - Excel Userform Login, formularios en Excel

Channel: El Automatizador

Como Criar uma Ferramenta de Busca no Excel com ÍNDICE e CORRESP

Como Criar uma Ferramenta de Busca no Excel com ÍNDICE e CORRESP

Channel: Hashtag Treinamentos

Curso Básico de Dashboard no Excel - Aula 2/4

Curso Básico de Dashboard no Excel - Aula 2/4

Channel: Hashtag Treinamentos

Curso de Excel 2023 - Aula 3 [Dashboard, Gráficos Impressionadores e Texto Dinâmico]

Curso de Excel 2023 - Aula 3 [Dashboard, Gráficos Impressionadores e Texto Dinâmico]

Channel: Hashtag Treinamentos

Día 36 - Power Query desde cero, Agrupación de filas, excel, powerquery, power query in excel

Día 36 - Power Query desde cero, Agrupación de filas, excel, powerquery, power query in excel

Channel: El Automatizador

PROCX ou PROCV? Descubra qual é o melhor!

PROCX ou PROCV? Descubra qual é o melhor!

Channel: Hashtag Treinamentos

Gráfico de Mapa Simples e Fácil no Excel - [Funciona em Qualquer Versão]

Gráfico de Mapa Simples e Fácil no Excel - [Funciona em Qualquer Versão]

Channel: Hashtag Treinamentos

Como IMPORTAR dados da WEB para o EXCEL (Sem VBA!)

Como IMPORTAR dados da WEB para o EXCEL (Sem VBA!)

Channel: Hashtag Treinamentos

Células mescladas

Células mescladas no Excel

Análise de dados

Análise de dados no Excel

Ferramenta mesclar e centralizar

Mesclar e centralizar

Power Query

Power Query Excel

Preenchimento para baixo

Como corrigir bases mescladas

Como corrigir bases mescladas no Power Query

Corrigir bases mescladas

Corrigir bases mescladas no Power Query

microsoft excel

dicas excel

truques excel

curso excel

curso excel online

excel

hashtagtreinamentos

hashtag treinamentos

vba

00:00:00

Hey guys from YouTube,

00:00:02

welcome to another power class Gary

00:00:04

and in this class I want to say that this

00:00:06

little table here, you can see this

00:00:08

cute table that many of you love to

00:00:10

make a Sina table, making a table with a

00:00:13

merged cell is very visual, right?

00:00:15

I have the Samsung brand and then it's easy

00:00:18

to visualize here what the

00:00:19

products are and also for home products

00:00:21

What is the quantity and

00:00:23

sales revenue information, right? So

00:00:25

these merged cells are very

00:00:27

visual and a lot of people really like

00:00:29

doing this The shape is really

00:00:31

quite visual, but if I said

00:00:33

this table structure here, it could

00:00:35

harm our work in Excel

00:00:37

when we need to do

00:00:38

analysis How to use pivot table filters

00:00:41

and data segmentations and so

00:00:42

on, so this class here I'll go

00:00:44

show you why it would be

00:00:46

cool if we tried to avoid growing this type

00:00:48

of table in this structure and how

00:00:51

we can do to correct this

00:00:53

structure using powerware And

00:00:56

remember, if you want this file

00:00:58

here to practice this

00:01:00

Hello everyone, the video We've already left the

00:01:02

link for you, just explain it there,

00:01:04

receive the material by email and practice

00:01:06

here with me too and before we

00:01:07

talk, don't forget to leave a

00:01:09

like on the video, it's too dirty, we'll make

00:01:11

more and more accounts for you and Also

00:01:13

remember to subscribe to the channel if you

00:01:15

are not subscribed and activate the

00:01:17

notification bell so you can receive notifications of

00:01:18

all the videos we make for

00:01:20

you from Monday to Monday Alright, so

00:01:23

that's it and let's go to class, good next time

00:01:24

guys, as I said to you, it would be really

00:01:27

cool If we could avoid this

00:01:29

type of table structure with

00:01:31

merged cells, a lot of people like to do it

00:01:34

this way because it really looks

00:01:36

very visual. I agree, looking at

00:01:39

this table here, I have an

00:01:41

easier time identifying it for the

00:01:43

Samsung brand, what are the Samsung brand products

00:01:45

and in addition for each product

00:01:47

with quantity information there and

00:01:49

billing, right, then merged cells

00:01:51

it already increases, they make it easier to visualize

00:01:53

but we depend on another application within

00:01:56

Excel It could be that these

00:01:58

merged cells harm there

00:02:00

Ah, so for example how I

00:02:03

could know if it's a table, right?

00:02:19

or

00:02:21

billing of the product and what is the

00:02:23

value information, in principle there are

00:02:25

these four pieces of information and imagine if I

00:02:27

wanted to show in this table only the

00:02:30

Delta information, do an analysis,

00:02:32

a report with just the

00:02:34

ideal information, how could I do that?

00:02:36

try to use the filter, so to

00:02:38

create the filter I already have these

00:02:40

little buttons here but if you don't have them, just

00:02:42

select this line and there in the data tab

00:02:46

and come here to filter, it's showing for me, but

00:02:48

you can explain by clicking

00:02:50

elliott, mark it, it will go put the

00:02:52

filter for you Okay, so let's go, I'm going to

00:02:54

try to apply a filter to this table

00:02:55

to show only Dell's information

00:02:57

and notice that Dell has 4

00:03:00

Yes, everyone feels ethical products and

00:03:03

product eight, let's go, let's try to

00:03:04

apply a filter here, mark unmark the

00:03:07

select everything I'm going to mark del Ok and it's

00:03:10

for that one, it became a single line, right,

00:03:12

just product five, obviously

00:03:15

this is wrong here because we saw

00:03:16

that del has four products but he

00:03:19

only brought one Because that just

00:03:21

happened, just happened exactly

00:03:23

because from the merge we had

00:03:26

more cells, so I went back to the

00:03:28

original table and let's see here what

00:03:31

Excel sees behind a

00:03:34

merged cell, notice here that I

00:03:36

have this cell, this cell merged

00:03:38

than the union of the cells of my 10

00:03:41

up to line 17 there are not several cells

00:03:44

merged cleanly and what I

00:03:46

repeat sees behind I will

00:03:48

select this mark this cell of action I

00:03:50

will go to the home tab and I will come

00:03:53

here in merge is to center apply

00:03:55

this learn remove the merge and to

00:03:58

that when I do this, look at what,

00:04:00

and not even reaching the back and you can see

00:04:02

the word del only on line 10, on

00:04:06

line 11, everything is blank, so that's why

00:04:09

when we apply the

00:04:10

filter we can't see

00:04:12

the information because and it's not

00:04:14

written here, so that's why he

00:04:17

only brought one line. So what would be

00:04:18

the ideal here? The ideal would be for us to

00:04:21

have a hotel in all these lines. It's

00:04:23

in all the cells.

00:04:26

del it

00:04:28

would show all these lines here

00:04:30

corresponding to the brand Dell Okay,

00:04:33

we can say ah, but this way it does

00:04:36

n't look pretty, everything is repeated, etc. and

00:04:39

so on, and really guys, it doesn't look as

00:04:41

pretty when a

00:04:44

cell is merged. There's going to be

00:04:46

a little problem there when using the

00:04:48

tools, so it's important that

00:04:50

we had this configuration here, okay,

00:04:52

so I read the original table again

00:04:56

and the idea will be for us

00:04:57

to correct this, so, okay, it's

00:05:00

important for the purpose of the room, isn't

00:05:02

it? Z that this table structure is

00:05:04

wrong, it depends on the application

00:05:07

we are doing, try to do

00:05:09

analysis with this table, right, use

00:05:11

formulas, data segmentation,

00:05:14

dynamic tables, filters, etc. We

00:05:15

need to do this freely, the table

00:05:17

needs to have a correct structure that

00:05:19

will be what we're going to show here

00:05:21

in this class, now if you created the

00:05:23

table to show a presentation or

00:05:25

it's a table that won't change a

00:05:26

fixed table then there's no problem

00:05:28

leaving it that way, okay because you're going to

00:05:30

change the table, it's just to visualization,

00:05:32

so in terms of visualization,

00:05:35

the merged cells are much

00:05:37

better, okay, but if you need this

00:05:39

table to be easy to analyze, to

00:05:42

use filters, etc., it is important

00:05:44

that we have the correct structure that

00:05:46

we will see, right? So,

00:05:49

I understand that this structure is not wrong,

00:05:51

it is just not suitable for analyzing

00:05:54

Excel and as we are always having to

00:05:55

normalize the tables in Excel, so it is

00:05:58

important that we take

00:06:00

this care then And in addition to that, they

00:06:03

will still be installed, there is another

00:06:05

problem here when we created

00:06:07

this table brand Samsung product here

00:06:10

we have for product two pieces of information

00:06:12

quantity and billing of something

00:06:14

that people also do, put it there in the

00:06:17

column identifying two

00:06:19

completely different pieces of information and here in the

00:06:21

value column this information all together

00:06:24

What is the problem with that and

00:06:26

imagine if I wanted, for example, to make

00:06:28

a total of this column, select all

00:06:30

this data and add up these

00:06:32

values and so that at the bottom

00:06:33

the total of 346 1907 will appear, but what

00:06:38

does this value mean and it doesn't mean

00:06:40

anything, right? I'm sweating quantity

00:06:43

with billing So if here's also the

00:06:45

other problem that ends up happening

00:06:46

because we move or the cells, right?

00:06:48

Because it really is, that gives an idea

00:06:50

of a flow, right? There's Samsung here, which is

00:06:53

more macro, right? Then there's the product there at the

00:06:57

smaller level. and it must be a product in two pieces of

00:06:59

information,

00:07:00

I was putting it this way but here it

00:07:02

will also harm it when we

00:07:03

need to do calculations, right, if I add

00:07:05

this column I don't have any

00:07:07

results, it's because I'm taking

00:07:08

quantity with revenue, so ideal

00:07:10

would be someone who has two things here one

00:07:13

for value one for quantity and one for

00:07:15

billing so we can separate the

00:07:17

information So that's it then we will

00:07:18

correct it in power Now let's

00:07:21

stop messing around and let's start

00:07:23

correcting this table So I will

00:07:25

select this table The First step that

00:07:27

would be a way of doing it, ok And then I go

00:07:30

to the data tab and the data tab and I'm going to

00:07:33

come here to get transformed there on the

00:07:35

left side of the tab and then I

00:07:38

come here to sheet which will be an option

00:07:40

that will allow me to understand that

00:07:44

range there right, Excel will interpret it and want to

00:07:46

click here on sheet, it will already

00:07:49

identify that range for

00:07:51

us, it's important to leave this option here

00:07:54

on table has headers checked and now

00:07:56

click on OK, okay, now it

00:08:00

will be directed to another

00:08:02

table, okay? we were freely directed

00:08:05

to another Excel environment What is

00:08:07

powerware to put inside Power Perry

00:08:10

we are going to make exactly those

00:08:12

corrections there, ok and notice here,

00:08:15

here inside Power Berry it does not

00:08:17

show those merged cells and pays up

00:08:19

to here Oh, I have Samsung

00:08:21

only appearing in the first line and then it's all

00:08:23

in it's all blank, same thing

00:08:26

here for Dell, same thing as for

00:08:27

Apple and for the products,

00:08:29

we also had merged the products

00:08:31

to be able to divide there, right, quantity of

00:08:35

revenue So here it appears

00:08:36

produces one and here it appears in the ok so

00:08:39

ideally it would be that here everything was

00:08:42

Samsung here everything was Téo and here everything

00:08:45

was Apple it's the same thing here for

00:08:47

product these two were product these

00:08:49

two here from the two months: did and So,

00:08:52

okay, the first step is to

00:08:54

register here in the audio, it's very

00:08:56

simple to correct this problem because

00:09:00

I'm making tables, Neto structure,

00:09:03

Microsoft has already created a tool that already

00:09:06

makes the correction here automatically, okay, so

00:09:08

we can correct this.

00:09:10

right click on the column that we want

00:09:12

to correct then we come here in fill down

00:09:14

fill

00:09:16

choose this option down and see what

00:09:19

it will do it will go to each

00:09:22

cell there put Samsung and when it

00:09:24

finds a new value a new text

00:09:27

it will adapt and fill the work that

00:09:29

it text and when it finds the new

00:09:31

value it will also adapt itself,

00:09:34

so I noticed that very

00:09:35

quickly we already corrected this, so the

00:09:38

same goes for the product column

00:09:41

right button comes here, enterprise and then

00:09:44

down, so there's a product, one

00:09:46

appeared twice, produces two products,

00:09:48

three and so on, it's good, it's not visual, it

00:09:53

's not good, it's all repeated Well,

00:09:56

man, everything is actually repeated, but

00:09:58

having the table in this structure

00:10:00

is very very easy to work in Excel

00:10:03

and to close here we will

00:10:06

correct this column here, give value and what

00:10:08

type it is because in this value group I

00:10:10

have two completely

00:10:12

different pieces of information quantity and revenue, the

00:10:15

ideal would be to separate this into two

00:10:17

columns to do this So it's also very

00:10:19

simple, one more thing that people have

00:10:21

always done in spreadsheets and

00:10:24

Microsoft has already created a tool that to

00:10:27

correct this is also very easy. The

00:10:29

first step here is for us to select

00:10:31

the column that identifies the two pieces of

00:10:33

information, right quantity and billing

00:10:36

then select this column And in this case it

00:10:38

will be community of type go to the

00:10:40

transform tab and come here to column and

00:10:43

dynamics dynamic column which Coelho in

00:10:46

dynamic column

00:10:47

and he will open this box and what

00:10:50

the idea will be he will say what Next,

00:10:52

use the names in the type column to create

00:10:54

new columns, that is, it will look at

00:10:56

the values that are there within the

00:10:58

type colony and will divide it into different columns,

00:11:01

like I have 22 values, right, billing

00:11:04

quantity, it will divide it into two

00:11:05

columns if I had

00:11:07

billings. amount of returns, it

00:11:09

divides it into three columns, okay, that's done,

00:11:12

it will ask what the

00:11:13

value column will be, which I have to

00:11:15

consider, in this case, the value column, and

00:11:17

it will be this value column here,

00:11:19

so here, I'm going to change brands for

00:11:22

value I will click on Ok And there it is, he already

00:11:25

corrected it for us and here it is,

00:11:27

the three brands, three products from the

00:11:30

Japan brand, right, all 10 men and 9 and

00:11:33

here, the quantity and with revenue is so

00:11:36

that now it is a lot Better, right?

00:11:38

These two separate columns, I can

00:11:40

take care of the quantity to have a

00:11:42

total quantity and some of the billing

00:11:44

to have a total billing. Now,

00:11:46

my table is in the structure. The next

00:11:51

step is to go back

00:11:53

to Excel, for this I go to the

00:11:55

home page tab and here I come to close

00:11:59

and load, close and load and

00:12:02

now it will load this table into

00:12:04

my Excel, it is for him that

00:12:07

he has already loaded our table for us

00:12:09

Apple alcohol Samsung and now it's

00:12:12

much easier, right? What can I

00:12:14

do here before making the wires?

00:12:16

First, if I want, I can change the

00:12:19

formatting of this table, so by clicking

00:12:21

inside it, I go to

00:12:23

Table design and it came here in style. you can

00:12:26

choose a different style of

00:12:28

table there, for example these little lights here

00:12:30

and now I can make the filters

00:12:33

very easily here I can make homes

00:12:35

much easier with this structure

00:12:37

so if I now want to come here in

00:12:39

brand and filter only for the products

00:12:41

of Dell Dell Okay, it will show

00:12:45

all its products there,

00:12:47

Hi guys, Apple products Apple Okay, I

00:12:51

just want some products there Samsung Okay,

00:12:54

that beauty is much easier, I can go even

00:12:58

further, right, I can see here, inside this

00:13:00

table and there Table design, put it

00:13:03

here, Navy, Total, there's a

00:13:05

total line. If I check the option, it will

00:13:08

show us, a last

00:13:10

line there, like the total of those columns,

00:13:12

so billing, here I can

00:13:14

view the total for the Samsung brand, if

00:13:16

I want to view it the quantity

00:13:18

I can also get that total sum of quantity

00:13:20

come here in this little arrow and put what it

00:13:23

adds up to, I want to add that quantity

00:13:25

sold here if I want to know the

00:13:27

quantity of different products I

00:13:29

have I can come to this column here and

00:13:31

put for example Count then there is

00:13:33

there for the Samsung brand there are four

00:13:35

products 56 are products sold and the

00:13:39

total revenue was 136,000, that's

00:13:43

it here it goes for any brand

00:13:45

that I went after for the brand is the door

00:13:47

the products the result 52 and the

00:13:50

revenue I have 17 thousand and here is the

00:13:53

ideal product for us to finalize,

00:13:55

also great guys, so notice

00:13:57

that with this table structure it is

00:13:59

much easier for us to be able to

00:14:01

carry out analysis using filters and I

00:14:04

went through the table, if I were to use

00:14:07

filters in the table, I can use

00:14:09

any tool there that heaven has already

00:14:11

created for us, right, dynamic table,

00:14:13

data segmentation, timeline and

00:14:15

so on, so it's just so we can

00:14:18

finish the class, one important thing

00:14:20

is what has to be in the

00:14:23

direction of that merged table, it's not

00:14:26

wrong, it's it's just not suitable if

00:14:28

we need to do analysis with it,

00:14:30

so if you need a table that

00:14:32

is functional and practical to do

00:14:35

filter calculations, right, there are six

00:14:37

analysis tables, but it is important that the

00:14:39

table is in this structure that can

00:14:41

facilitate the our calculation now

00:14:43

if it's a table we won't

00:14:45

change another table

00:14:47

the nation for presentation then the

00:14:50

merge will actually be better so it all

00:14:52

depends on the application ok guys

00:14:54

so I hope you

00:14:56

liked it if you liked the room don't

00:14:58

forget like the video and

00:15:00

also don't forget to subscribe to the

00:15:01

channel if you are not yet subscribed, don't

00:15:03

write there and activate the bell

00:15:05

forever and receive notifications Our

00:15:07

Videos Beauty, so a big

00:15:08

hug, see you in the square

Description:

CLIQUE AQUI PARA SABER MAIS SOBRE O CURSO COMPLETO EXCEL IMPRESSIONADOR: https://lp.hashtagtreinamentos.com/esperaexcelimpressionador?origemurl=hashtag_yt_org_listaesperaexcel_8evZ0CNmcyw -------------------------------------------------------------------- BAIXAR O MINICURSO GRATUITO BÁSICO DE EXCEL: https://excelparaestagio.klickpages.com.br/inscricao-basico-cta-att?origemurl=hashtag_yt_org_minibasico2_8evZ0CNmcyw Para receber conteúdo diário de Microsoft Excel, VBA e Power BI gratuitamente, entre em nosso grupo do Telegram: https://t.me/joinchat/AAAAAFVJr0C7Il-tVurdUw Em nossos vídeos ensinamos diversas dicas excel e truques excel para que você consiga se desenvolver nessa ferramenta! ----------------------------------------------------------------------- ► Para Baixar o Arquivo Utilizado na Aula, Acesse: https://pages.hashtagtreinamentos.com/planilha-1hd16wtBdH0IvktjLQ8R49GybTpngcKIY?origemurl=hashtag_yt_org_planilha_8evZ0CNmcyw ----------------------------------------------------------------------- Hashtag Treinamentos ► Inscreva-se em nosso canal: https://www.youtube.com/hashtagtreinamentos?sub_confirmation=1 ► Ative as notificações (clica no sininho)! ► Curta o nosso vídeo! ----------------------------------------------------------------------- Redes Sociais ► Blog: http://hashtagtreinamentos.com/blog ► YouTube: https://www.youtube.com/hashtagtreinamentos?sub_confirmation=1 ► Instagram: https://www.facebook.com/unsupportedbrowser ► Facebook: https://www.facebook.com/unsupportedbrowser ► Telegram: https://t.me/joinchat/AAAAAFVJr0C7Il-tVurdUw ► Tik Tok: https://www.tiktok.com/@hashtagtreinamentos ----------------------------------------------------------------------- TOP Vídeos: ► As 5 FÓRMULAS BÁSICAS do Excel que você TEM QUE APRENDER antes do PROCV https://www.youtube.com/watch?v=Ufmem0LjubI ► PROCV - Passo a Passo Completo (sem complicação) https://www.youtube.com/watch?v=DgDWchaS34w ► Tabela Dinâmica - Como fazer Tabela Dinâmica Excel em 5 passos! https://www.youtube.com/watch?v=IFTJbEVYnO8 ► PLANILHA EXCEL para IMPRESSIONAR QUALQUER UM https://www.youtube.com/watch?v=2LmM0yWJjkw ► Aprenda TUDO sobre como criar GRÁFICOS no EXCEL https://www.youtube.com/watch?v=P_SnCOqMYqQ ----------------------------------------------------------------------- Fala Galera! Na aula de hoje nós vamos te mostrar por que você deve evitar células mescladas no Excel quando for fazer análise de dados! A análise de dados no Excel é algo muito comum e muita das vezes as pessoas gostam de utilizar a ferramenta mesclar e centralizar para melhorar o visual da planilha. Isso não está errado, no entanto quando formos fazer uma análise de dados não recomendamos que você utilize essa ferramenta, pois você vai ver uma série de problemas dentro das suas análises. O principal deles é que apenas a primeira célula dessa mesclagem é que fica com a informação de fato, então todas as outras ficam vazias. Já imaginou você fazendo um filtro com 10 células mescladas e seu filtro só retornar 1 único resultado? Tem algo errado não é mesmo? Então nessa aula nós vamos te mostrar como corrigir bases mescladas no Power Query que já tem uma ferramenta que vai te ajudar com isso. É a ferramenta de preenchimento para baixo, então é como se o invés de mesclar você fizesse a repetição dessa informação em todas as células. Dessa forma você garante que todas as células terão as informações corretas e quando for fazer sua análise de dados os resultados fiquem corretos sem a omissão de nenhuma informação! Bora pra aula que esse conteúdo é muito importante quando tratamos de análise de dados no 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 "Por que Evitar Células Mescladas no Excel para Fazer Análise de Dados?" 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 "Por que Evitar Células Mescladas no Excel para Fazer Análise de Dados?" 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 "Por que Evitar Células Mescladas no Excel para Fazer Análise de Dados?" 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 "Por que Evitar Células Mescladas no Excel para Fazer Análise de Dados?" 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 "Por que Evitar Células Mescladas no Excel para Fazer Análise de Dados?"?

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 "Por que Evitar Células Mescladas no Excel para Fazer Análise de Dados?"?

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.