Download "PROCV no Excel - NÃO USE MAIS | Isso é importante: Entenda aqui"

"videoThumbnail PROCV no Excel - NÃO USE MAIS | Isso é importante: Entenda aqui

NÃO USE MAIS - Entenda aqui

PROCV no Excel - NÃO USE MAIS - Entenda aqui

[Excel Avançado] PROCV DUPLO - 2 condições

[Excel Avançado] PROCV DUPLO - 2 condições

Channel: Ninja do Excel

ProcV e ProcH passo à passo em Relatórios no Excel

ProcV e ProcH passo à passo em Relatórios no Excel

Channel: Curso de Excel Online

PROCV e PROCH Passo à Passo (Sem complicação)

PROCV e PROCH Passo à Passo (Sem complicação)

Channel: Ninja do Excel

procv excel

não usar procv

como fazer procv

procx no excel

aula sobre procv excel

procv no excel

fazer procv excel

ninja do excel

índice e corresp

proch excel

não use o procv

não mescle células no excel

função procv excel

como fazer função procv excel

como fazer procx excel

fórmula procv excel

curso de excel

aprender excel

alternativa ao procv no excel

planilha lenta

procv ninja do excel

procv sem complicação

aprender procv

procx e procv

procv

00:00:04

exactly what you heard, don't

00:00:06

use the para que ver function anymore and in this

00:00:08

video lesson I'm going to show you

00:00:10

why and I'm also going to give you some

00:00:13

much better alternatives than

00:00:15

seeing yourself which will live our

00:00:17

beloved role in Excel, but today

00:00:18

your death will be declared here in

00:00:22

Excel, beauty, so after the vignette,

00:00:24

here you go, you'll understand this story tom-tim-

00:00:26

by-tim,

00:00:31

andthen,

00:00:34

folks, beauty, my name is tom

00:00:37

cavalcante, I I'm the creator of the website

00:00:39

ninjadoexcel.com.br where we have

00:00:41

hundreds of articles for you for free and

00:00:44

also here on the mente do excel channel on

00:00:46

YouTube, beauty, so if you're not yet

00:00:48

subscribed, don't subscribe, subscribe now

00:00:50

and also activate the bell notification,

00:00:51

beauty, before we start, I want to

00:00:54

invite you, as well as get to know our

00:00:56

Excel courses, we have a basic

00:00:57

intermediate advanced course, if you are from

00:00:59

scratch, no problem, we also have to see

00:01:02

power bi, oh baby, with forms, we have

00:01:05

several very interesting courses for you

00:01:07

which will definitely help you and in your

00:01:09

career, bees, the link is

00:01:10

below, everything without percent online, you

00:01:12

will have your login and password to do

00:01:14

it from the comfort of your home, ok, the

00:01:17

course link is here in the description and the

00:01:19

last one One thing I have to tell you is

00:01:20

that today you have the chance to win a

00:01:22

complete Excel course from me during the

00:01:24

video here I will release a

00:01:26

keyword if you type

00:01:28

this keyword first here in the comments

00:01:31

you will win my complete Excel course

00:01:32

It's from basics to advanced

00:01:34

Boonzi several Gomes courses so be

00:01:37

smart, be smart during this this

00:01:40

video class there will be a key word that

00:01:42

I'm going to release, maybe in a little while at the

00:01:44

end anyway, somewhere that will be there if

00:01:46

you type it first you will win

00:01:48

no there's no point in editing the comment ok it has

00:01:51

to be without editing comments in addition

00:01:54

beauty let's go without further ado

00:01:57

why am I telling you

00:01:59

not to use the guy you see anymore look at

00:02:02

what seeing is a coffin function that

00:02:04

fulfills its role very well for hey, it

00:02:06

has a lot of side effects and this is

00:02:08

a problem especially when you

00:02:10

're working with huge foundations, okay, I

00:02:13

'll give you some examples of

00:02:15

why you no longer need to use it for

00:02:17

15 beauty, one of them is, I think, the

00:02:20

most important ones in my opinion. and I

00:02:22

want you to enter your opinion, here's

00:02:24

the thing, you can only

00:02:26

do it here, see its basic form,

00:02:29

when the reference, right, the

00:02:33

common denominator,

00:02:34

the tables are from left to right, that

00:02:36

is, in this case here, for example, I

00:02:39

want to bring the codes from here to here, right

00:02:42

with the products, actually based on the

00:02:44

id, but the problem is that my id is

00:02:47

on the right side of the products column,

00:02:50

so I would have to do it because look at

00:02:53

the movement I would have to do, I

00:02:55

have to get it to Here it's one against a

00:03:10

lot of

00:03:14

people using the same spreadsheet changes, look at

00:03:15

the problem it can cause, you know,

00:03:17

it's not good to use another point that's

00:03:22

worth fixing, pay close attention to

00:03:23

performance, the blog, see it, it requires

00:03:27

you, right, within your role at the time

00:03:29

you will put it here, the blog came for

00:03:32

example to find this

00:03:34

and in this matrix this here is this

00:03:37

movement which is complicated because here

00:03:39

we have five columns but imagine

00:03:41

there are 80 columns 30 columns 50 columns

00:03:44

and 110 thousand rows down so it

00:03:47

will make a very large scan

00:03:50

looking for this here in the column that you

00:03:52

want even more if the column is there

00:03:55

at the end, you know and I won't either at the

00:03:58

beginning, that is, it loses a lot for you, it's no

00:04:00

use, you have a computer with a

00:04:03

256gb SSD, but there's no point in 1 tera of say

00:04:06

that you can have an SSD you lose

00:04:09

a lot of performance and remembering that you

00:04:10

don't need to create and shouldn't create it is

00:04:13

for the league just for you, you always have

00:04:15

to think about your eyes, final beauty, so

00:04:18

just complementing here the star, see, right,

00:04:20

I'm going to create here for example do

00:04:22

column two, right, and type of

00:04:25

exact match, that is, it will bring column 12, which is

00:04:29

here to products, which is products,

00:04:31

change the sum, fix

00:04:34

and in the intervals and I will drag it, so

00:04:37

for this case here, look, it just presented, okay,

00:04:39

okay, but Again, the same

00:04:42

thing, right, if you come here and

00:04:44

rip this column out of here,

00:04:48

look what happens, there's a big

00:04:50

reference problem here, in this case,

00:04:52

that's not good because that's why

00:04:54

I say that seeing is not very

00:04:56

interesting you use beauty so

00:04:57

let's look at the alternatives I will give you two

00:04:59

alternatives and as of today's date,

00:05:02

we are here in the month of July 2020 as of

00:05:06

today's date, the first option is recommended,

00:05:07

what are the options, the

00:05:10

first of them is the index a function and

00:05:13

index and corresp which are two functions in

00:05:19

one and the second is the clock

00:05:29

I say this

00:05:31

because pilates is not yet in everyone's reach, right?

00:05:34

It's there on Microsoft 365,

00:05:38

for a lot of people, it's not available,

00:05:39

remembering that companies use

00:05:41

leisure, right, as always, comdep, right now, in

00:05:44

2020, for example many companies,

00:05:46

the majority are migrating now to

00:05:49

2016, perhaps, but the majority are in 2013 or even

00:05:53

before, there are people who use 2007 in 2010,

00:05:56

so there is always this gap, so no name,

00:05:59

honestly, the new functions will always be

00:06:01

able to serve all audiences, you have

00:06:03

to have always keep this in mind price in

00:06:06

consideration which generally if correct

00:06:07

no it has been around for a long time it is already well

00:06:10

established in all versions so

00:06:13

it's good there as we do so the

00:06:16

index function corresponds well and then I'm

00:06:18

here x here I go try to be as

00:06:20

brief as possible so it doesn't get too

00:06:22

long, I'll leave your like, are you

00:06:23

enjoying this class and leave your

00:06:25

comment below too, right, what kind of

00:06:27

class do you want in the future, so

00:06:29

we can do it here for you, okay, so

00:06:31

bad how is it? how the index function works

00:06:34

corresponds to the first one talking about the

00:06:35

index function, I already have a class here on the channel

00:06:37

about this, which is a live that I did,

00:06:39

but here it will be more summarized, it will

00:06:40

be faster for you, the

00:06:42

index was posted with its own name, she says search for

00:06:44

the index, right here, in this case we have

00:06:48

here one that the product I want to

00:06:49

bring, right, so you'll think about

00:06:52

bringing it directly here or the result

00:06:55

you want, so in this case I want to

00:06:57

bring the product to the products column, so

00:07:00

I'll go in it here, ok and now I'm going to give a

00:07:02

semicolon and I'm going to, for example,

00:07:04

put the number 4 here until the

00:07:09

line number, you can see that it asks for the

00:07:10

line number 4 and I'm going to close it here, I'm going to find a

00:07:12

way

00:07:13

or whatever which is number 4 he will

00:07:16

count, right, the first line, second line,

00:07:18

third, fourth, this is line four, I

00:07:22

'll even do it here for you

00:07:25

and it will be easier here, right, and

00:07:29

here, oh, four, I also brought it here,

00:07:32

if I'll have it here I don't know at 7 o'clock

00:07:35

you're going to bring what line 7 the beauty

00:07:38

is that's what the in function does now what does

00:07:41

the corresp function do I'll even do it

00:07:42

down here so it doesn't get in the way so I'll

00:07:45

do it here that's the [ __ ] and then

00:07:46

we'll go put it all together, right? Corresp, I'll

00:07:49

see here what the value is looking for,

00:07:51

so I had to look for this value here, the

00:07:53

4843 semicolon where in which the

00:07:57

actress I want in the inter matrix, that's why there

00:08:00

's a great benefit here

00:08:02

because it will look for only in two

00:08:04

intervals, right, see itself, no, it will

00:08:07

search in all, right, all

00:08:09

full matrices, so here you already gain a lot of

00:08:12

performance, beauty, so semicolons,

00:08:15

I want zero correspondence, which is an

00:08:17

exact match, in other words, it will

00:08:19

search for this value in this matrix, here I will

00:08:22

give it An enter brought up number 4, that is,

00:08:25

this number 4 843

00:08:29

is one two three four whenever here

00:08:32

we put number 4 here, it was the

00:08:34

first option I put and it wasn't

00:08:36

for nothing, look then, that is the correct one and it

00:08:39

automatically brought up number 4

00:08:41

according to this code and here I

00:08:44

manually put number 4 it

00:08:46

also brought so now any

00:08:48

logic just replace this number

00:08:50

4 with the correct integer because it will

00:08:53

do it automatically great so

00:08:54

here the result 14 cool so I'm going to

00:08:57

open it here I'm going to copy the corresp I'm going to

00:09:00

give you the opposite, I'm going to come here and delete

00:09:03

this room from here and I'm going to paste here the

00:09:06

entire correct result and look at the

00:09:08

inter, just look at how much easier it is to

00:09:10

do this without remembering, of course over

00:09:12

time it's much better for you to do it all

00:09:14

together, right, you're going to get the hang of

00:09:15

it and you're going to do it in a quick

00:09:18

and practical way, just like you do a block,

00:09:20

see now we're just going to fix the

00:09:22

intervals here, right, an f-4, and you can double-

00:09:26

click here or drag it down and So,

00:09:28

yes, and now,

00:09:29

and for that question there, I'm going to do a

00:09:31

control-x here, I'm going to change the place here,

00:09:34

my column and his, look at what

00:09:36

happened, he followed it, you see, he

00:09:38

followed the result here, so in

00:09:40

his own case, he got an error here, he he,

00:09:43

he continues, right, he continues, so

00:09:45

here it is, my already excellent, okay, so I'll

00:09:48

send it here, I'll put it on top and

00:09:51

with the rest, okay, guys, let's go, look, the

00:09:55

key word here is the following,

00:10:00

I'm not going to use it anymore', look, see In Excel, if you

00:10:03

type this sentence exactly the way it

00:10:05

appears on the screen here in the

00:10:07

comments and it was the first or the

00:10:08

first one, you will win mine, which is

00:10:11

complete, beauty, so it's worth typing and

00:10:13

you will be

00:10:15

automatically participating, beauty, let's continue

00:10:17

class, ask here now let's do it with the

00:10:20

proxes here on the side beauty

00:10:21

and let me get it here, bring it I'm here

00:10:24

this is really cool I've been using it

00:10:25

a lot but always with this

00:10:27

observation that I said there it is so here

00:10:29

I'm going to put the block x which is

00:10:35

x itself = 4x remembering that it

00:10:37

is available for the Microsoft

00:10:39

365 version, fine, I'm bad, I want to search for

00:10:43

this value, it will almost be the same as the one so

00:10:46

that you can see the semicolon in which

00:10:50

matrix with the search where this here,

00:10:52

I'm going to search for it here, beauty and then

00:10:56

semicolon which the return matrix is

00:10:59

almost the same as we know each other I want to

00:11:00

return what is this one here and the cool thing is

00:11:04

that now it's a reminder, right when it's in

00:11:07

square brackets here you don't need to answer

00:11:11

cool, you don't need to

00:11:12

actually put it like this taxi because it is not

00:11:14

obligatory you could not just

00:11:16

stop here but it is your first option

00:11:18

which is excellent you already bring it that it is

00:11:21

and not found you will give an error

00:11:24

fine so I can put it here for

00:11:26

example as a warning so that these are the same

00:11:28

It's a function of joining if I'm

00:11:30

not toxic already, so if it's not

00:11:32

found, I can put it here, not

00:11:34

found,

00:11:36

and I'm going to stop here, okay, I'm going to give the

00:11:38

inter here and then I'm just going to set the

00:11:41

intervals here, right,

00:11:43

hi, and then I'm going to give it

00:11:45

the two clicks here, dragging it

00:11:47

down is the same, if I change it

00:11:50

here, for example, the location is maintained,

00:11:53

it remains as well as many incorrect and

00:11:56

also the block x, but here the detail is as

00:11:58

follows, our people invent 1 number

00:12:00

ak888 it said nd here and here it said

00:12:04

not found because I put not

00:12:06

found or I can put the

00:12:08

text I don't want it doesn't have for example

00:12:11

look how cool this is that it is already

00:12:14

here with medison but I don't have a

00:12:15

proxy what is it like that I can have the same

00:12:17

result here you can call a function

00:12:19

called if there is an error, that is, if there is an error, it does

00:12:24

what if it was an error it will bring a

00:12:27

value

00:12:31

and you can put a comma here, oh

00:12:35

there isn't either

00:12:37

and no oops there isn't and then it works in the same way

00:12:43

but in itself it already has this by

00:12:45

default it already has this native, right so you

00:12:47

want it really cool for you beauty so

00:12:50

these were the main differences there

00:12:53

between praxis index corresp and the

00:12:56

see itself I hope you understood and

00:12:58

you are from a company that works

00:13:00

company please replace the

00:13:03

x itself in excel test

00:13:05

employment service also uses stronger ones

00:13:08

here is my reservation use other

00:13:10

things other than are that it has a

00:13:12

much better performance and is much more

00:13:13

advanced beauty and reminding

00:13:16

you once again here check if you are

00:13:18

subscribed subscribe to the channel activate the

00:13:20

notification bell and also

00:13:23

find out about our courses they cost here

00:13:24

below in the description basic cost

00:13:26

intermediate advanced if you liked

00:13:28

this class, you will definitely like it even

00:13:30

more the courses that have classes there, not even

00:13:33

step by step with a booklet, my support

00:13:35

here on YouTube, I can't provide support

00:13:36

for everyone,

00:13:37

the website supports 100 percent of

00:13:40

those who ask, so it's a

00:13:41

totally experience different beauty well I think that

00:13:43

's it here I hope you

00:13:45

enjoyed this class and understood the

00:13:47

reasons why you should no longer

00:13:48

use your own see it's good to use these

00:13:51

two here which is much better here you

00:13:52

know me or proxies remembering one more

00:13:55

once the proxy's caveat is ok and look if

00:13:58

you got here to the end it's because

00:13:59

you like this material I like

00:14:01

my work I want to thank you for

00:14:04

that so comment below ok

00:14:05

put an increase here oh I'll finish what

00:14:07

I do for myself knowing that you finished

00:14:09

with this video, you made it to the end,

00:14:12

you really are differentiated,

00:14:13

differentiated because a lot of people give up

00:14:15

halfway through, right?

00:14:21

description a

00:14:23

booklet is a demonstration of the booklet

00:14:26

a sample of the booklet that we have

00:14:27

courses that you will really like

00:14:29

so here is a small one, right a

00:14:32

small one a small tasting of what

00:14:34

our course booklet is like you will like

00:14:35

a lot, okay, it's below

00:14:37

the from the video a big hug and

00:14:40

see you next time

Description:

PROCV no Excel - NÃO USE MAIS - Entenda aqui Curso de Excel Gratuito: https://ninjadoexcel.com.br/curso-excel-gratuito | Cursos de Excel https://cursos.ninjadoexcel.com.br/ Nesta aula, você vai aprender como Fazer o PROCV, mas principalmente você vai entender os motivos pelos quais você deve ABANDONAR o PROCV no Excel. Eu sou um grande fã da função PROCV, afinal, já me foi muito útil por muito tempo. Porém, quando se olha com mais detalhes e também se compara com outras funções de referência, o PROCV deixa muito a desejar. Por isso, criei esse vídeo para te mostrar os motivos para NÃO USAR mais o PROCV. Mas não se preocupe, eu vou te dar algumas alternativas. Em alternativa ao PROCV no Excel, temos as funções: - ÍNDICE E CORRESP NO EXCEL: É a opção que mais indico atualmente, pois é compatível em todas as versões do Excel. O desempenho essas duas funções torna tudo mais fácil, rápido e prático - PROCX no Excel: Essa é uma função que com certeza veio para substituir o PROCV. É realmente incrível e tem uma performance bem interessante! Só não recomendo com tanto afindo ainda, por conta de ser uma função nova no Microsoft 365 (Office 365). Então, nem todas as versões do Excel vão possuir esta função. BAIXE A APOSTILA EM PDF (AMOSTRA): https://bit.ly/3gEqkeV CURSO DE EXCEL GRATUITO: https://ninjadoexcel.com.br/curso-excel-gratuito DOWNLOAD DA PLANILHA DESTA AULA: https://1drv.ms/x/s!AmMwzGRjZm49gf9KD4r3ihU2x-vGhw?e=HP6SSu Link desta aula: PROCV no Excel - NÃO USE MAIS - Entenda aqui https://www.youtube.com/watch?v=ji03M1CRZAQ 00:00 Se inscreva no Canal Já é inscrito no canal? Clique aqui e inscreva-se: https://www.youtube.com/user/ninjadoexcel?sub_confirmation=1 ----------------------- CURSOS DE EXCEL Curso de Excel Básico: https://cursos.ninjadoexcel.com.br/page/curso-de-excel-para-empresas Curso de Excel Avançado: https://ninjadoexcel.com.br/curso-excel-avancado-4-aulas-avancadas/ Curso de Excel Completo: https://ninjadoexcel.com.br/curso-excel-completo Curso de VBA Excel: https://ninjadoexcel.com.br/curso-vba-excel Curso de Excel Gratuito (por 7 dias): https://ninjadoexcel.com.br/curso-excel-gratuito Curso de Power BI: https://ninjadoexcel.com.br/curso-power-bi/ ----------------------- MEUS CONTATOS ▶ www.ninjadoexcel.com.br ▶ Grupo de Estudos no Facebook: https://www.facebook.com/unsupportedbrowser ▶ Facebook: https://www.facebook.com/unsupportedbrowser ▶ https://www.linkedin.com/in/edsoncavalcantejunior ▶ Email: [email protected]

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 "PROCV no Excel - NÃO USE MAIS | Isso é importante: Entenda aqui" 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 "PROCV no Excel - NÃO USE MAIS | Isso é importante: Entenda aqui" 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 "PROCV no Excel - NÃO USE MAIS | Isso é importante: Entenda aqui" 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 "PROCV no Excel - NÃO USE MAIS | Isso é importante: Entenda aqui" 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 "PROCV no Excel - NÃO USE MAIS | Isso é importante: Entenda aqui"?

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 "PROCV no Excel - NÃO USE MAIS | Isso é importante: Entenda aqui"?

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.