Download "Curso de Tablas Dinámicas Desde Cero | Como hacer una Tabla Dinámica desde datos externos | Clase 18"

Please wait. We're preparing links for easy ad-free video watching and downloading.

Previous video: Curso de Tablas Dinámicas Desde Cero | cambiar origen de datos de una TABLA DINÁMICA | Clase 25 Next video: Gráfico Excel Torta (Gráfico dinámico)

Gráfico Excel Torta (Gráfico dinámico)

Gráfico Excel Torta (Gráfico dinámico)

Channel: Carlos Enrique Velaides Russo

Curso de Tablas Dinámicas Desde Cero | cambiar origen de datos de una TABLA DINÁMICA | Clase 25

Curso de Tablas Dinámicas Desde Cero | cambiar origen de datos de una TABLA DINÁMICA | Clase 25

Channel: Microsoft Excel a Todo Nivel

✅ Crear TABLAS DINÁMICAS de VARIAS TABLAS en Excel [sin complicaciones]

✅ Crear TABLAS DINÁMICAS de VARIAS TABLAS en Excel [sin complicaciones]

Channel: Saber Programas

Tablas DInámicas

curso de Tablas dinámicas

excel tablas

tablas de excel

excel a todo nivel

excel trucos

victor roman castro

segmentacion de datos en excel

filtros en Excel

tablas dinamicas

tablas dinamicas excel avanzado

tablas dinámicas avanzadas

mostrar valores como

datos como porcentajes tablas dinamicas

segmentacione de datos

fechas en excel

escalas de tiempo

CONEXIONES DE INFORME

AUTOAJUSTE DE COLUMNAS

no hagas referencias

00:00:00

On many occasions you will surely not

00:00:02

have the data to generate a

00:00:04

dynamic table, you will not have it as such

00:00:06

within Excel and this may be for

00:00:09

different reasons, among them one of the

00:00:11

most important is that many of the

00:00:14

cases are going to be tables that are in

00:00:17

a database or are in a

00:00:19

text file and have more than one million

00:00:23

46,576

00:00:25

records, that would limit us to

00:00:28

loading all the information into Excel,

00:00:30

so what we can do is create

00:00:33

the dynamic table from a

00:00:35

data source external where We do not

00:00:37

necessarily have to bring the

00:00:39

Excel data but we are

00:00:42

only going to make the table, the connection of the

00:00:45

data and the dynamic table, we

00:00:48

would do the report in Excel. Look, I am going to show you

00:00:49

how what we are going to do here is

00:00:52

use this that It says here data sheet

00:00:54

within the data sheet we are going to

00:00:57

have the Power Core editor and where

00:00:59

we are going to have extra power from different

00:01:01

data sources, I will explain it to you in

00:01:03

the update of the Power

00:01:05

query course that corresponds to the following

00:01:08

courses that we are going to Let's see

00:01:10

Inside this channel Look we are going to give it here

00:01:12

from file we are going to have some

00:01:14

data like textbooks like

00:01:18

text files like Excel

00:01:20

xml books sometimes we can even create tables

00:01:24

from a folder where we have

00:01:26

several files but the one we are going to to

00:01:28

use in this case it will be from an

00:01:31

Access database when we

00:01:33

select the Access database

00:01:35

We are going to indicate a path

00:01:39

where we have an

00:01:41

Access file in this case I am going to

00:01:43

put this one that says cities of Mexico

00:01:45

where we have more than 100,000

00:01:48

records but let's imagine that it could

00:01:51

be a table where we have 34

00:01:54

million, all of this will be possible to

00:01:57

process within a dynamic table

00:01:59

in Excel and the fact

00:02:02

of having so much information will not limit us but it must be

00:02:05

have its characteristics and must

00:02:08

have its procedure. Look, observe

00:02:09

when we already have the

00:02:11

connected Access table, here it tells me a

00:02:14

preview of all the data that

00:02:15

we can load or that is there

00:02:17

within the table and here we are not going to click on

00:02:20

loading. While forming data

00:02:22

here, what we are going to tell you, we are going to

00:02:24

tell you to load in, because the only thing we are going to

00:02:27

do is connect and

00:02:30

directly create the dynamic table or the

00:02:32

Dynamic graph, in fact, in this option it

00:02:34

tells you that you are going to import the data if you

00:02:37

leave that option that says there table Well,

00:02:39

yes you would bring practically all the

00:02:42

Excel information And if there were more than a

00:02:44

million records, which is the limit of

00:02:46

Excel Well, we would be getting into a

00:02:49

problem, we would not achieve the objective,

00:02:52

however the only thing we can do is

00:02:53

create that connection and create a

00:02:56

pivot table report and we didn't have We

00:02:58

wouldn't have any major problems

00:03:00

generating the pivot table as such. You

00:03:03

also have the option of using a

00:03:05

Dynamic chart or doing nothing and

00:03:08

practically only creating the

00:03:10

connection to be able to use the data

00:03:12

later, you could do everything. That

00:03:15

in addition to adding this data to a

00:03:17

data model, if you were

00:03:19

generating a data model, in this

00:03:21

case we are going to tell you that we want the

00:03:23

data to make a dynamic table report, we

00:03:26

accept and

00:03:28

practically what is generated is a

00:03:30

connection to the data and

00:03:33

a way in which we are going to

00:03:35

generate a dynamic table Look, observe, we

00:03:38

already have the corresponding data there,

00:03:41

we already have all

00:03:44

the concepts here and for example, look if I

00:03:46

would like to generate a table where I

00:03:48

put the area, for example, how many of

00:03:51

these concepts are semi-

00:03:55

urban and urban rural areas, well we are going to be able to

00:03:57

do, for example, there I want to know that we are

00:03:59

also going to be able to put it for

00:04:01

example area here and I would tell it. And I would

00:04:04

practically already have the area, I have

00:04:08

practically

00:04:09

89,000 rural locations in Mexico

00:04:12

50,000 urban and semi-urban

00:04:16

6,575 concepts For example, if I

00:04:19

wanted to make an additional report,

00:04:21

I can copy the dynamic table in the

00:04:24

part below and as soon as I

00:04:26

change the concepts instead of zone,

00:04:28

I tell it that I want by state in the

00:04:31

rows part and there I will having the

00:04:34

concepts and the locations

00:04:36

corresponding to each of these, what we

00:04:38

observe here is that in the

00:04:40

dynamic table in the concept that we

00:04:42

have

00:04:44

there, yes,

00:04:46

145,000

00:04:48

973 records within that table that

00:04:52

we have here How can I review it In

00:04:54

fact, here if I go to the

00:04:57

data sheet And I click here on queries and

00:05:00

connections I can practically see the

00:05:03

information How can I review the

00:05:05

information if I double click here

00:05:07

I can open the Power query editor and

00:05:10

review the data that is in this case

00:05:12

look here for example It tells me type of

00:05:14

settlement we have all these types

00:05:16

of settlements neighborhoods camps

00:05:18

colonies condominiums subdivisions

00:05:21

residential towns etc. all of

00:05:24

these that are surely in many

00:05:27

municipalities of Mexico City or

00:05:30

the different states that we have here

00:05:32

in Mexico

00:05:33

we have the city we have the state

00:05:36

office and some

00:05:38

demographic concepts that we handle within the

00:05:41

Mexican country Well, we are

00:05:43

going to have all the data here, observe at the

00:05:45

bottom that here it tells me that we have

00:05:47

more than 999 rows when We have many

00:05:52

concepts that that legend appears But

00:05:55

if I start to go down Well, surely I

00:05:57

will find many many why

00:06:00

because we have 145,000 here I could

00:06:04

transform the information if

00:06:07

necessary change the format create

00:06:09

new columns from all these

00:06:11

but if not then I can go again And

00:06:15

close on load close and load the

00:06:18

connection again generates and

00:06:20

I could modify the data to continue

00:06:22

building Practically the

00:06:24

dynamic table from the changes that I

00:06:27

make in Power crem in the event that I

00:06:28

added more columns or more

00:06:30

valuable information that could give us a

00:06:34

broader analysis then already from here

00:06:36

I could be, for example, a graph, we

00:06:38

give you to analyze here, that's not true.

00:06:41

Let's insert, we say

00:06:43

Dynamic graph. I'm going to tell you that I want a

00:06:45

graph for these concepts of how it is,

00:06:49

for example,

00:06:50

rural, semi-urban and urban, how they are

00:06:53

distributed, look, there we have the

00:06:55

pie chart if I right click on it and

00:06:58

tell it

00:06:59

label labels control 1 and tell it to

00:07:02

give me instead of the value it gives me the

00:07:04

percentage I already have another one this value

00:07:07

something that causes more value to my graph is

00:07:11

having 61% Of the localities in

00:07:15

Mexico are Rural, 5% are 11,000

00:07:18

urban and I have 34%, and

00:07:22

so for each of the concepts there

00:07:24

could be a dashboard and the

00:07:27

important thing here is that you should know

00:07:29

that all of these concepts are being

00:07:32

generated through a dynamic table

00:07:34

without the need to dump

00:07:37

all the data into an

00:07:39

Excel sheet, especially when they are concepts

00:07:42

that have more than a million

00:07:45

records where Well, the

00:07:47

Excel limit was due with respect to that

00:07:49

information here We could have

00:07:53

five or six million within that table and be able to work on

00:07:55

a dynamic table and make a dashboard and

00:07:58

the best of all is that all the

00:08:00

information and performance of the

00:08:03

Excel workbook would be quite good because

00:08:04

all the data will be found in

00:08:07

this case with the Access database

00:08:10

So with this we can just know

00:08:13

that from the data tab

00:08:16

we can choose the different

00:08:19

data sources that we can connect

00:08:21

regardless of the number of records because

00:08:23

we are only going to connect and

00:08:25

generate the dynamic table

Description:

Aprende como podemos conectarnos a BD con millones de registros sin tener la información en Excel y a partir de esta crear la Tabla Dinámica Descarga el Archivo | https://metn-my.sharepoint.com/personal/victorroman1605_metn_onmicrosoft_com/_layouts/15/onedrive.aspx?id=%2Fpersonal%2Fvictorroman1605%5Fmetn%5Fonmicrosoft%5Fcom%2FDocuments%2FCurso%20de%20Tablas%20Din%C3%A1micas%20Youtube%2FCiudades%20de%20M%C3%A9xico%2Eaccdb&parent=%2Fpersonal%2Fvictorroman1605%5Fmetn%5Fonmicrosoft%5Fcom%2FDocuments%2FCurso%20de%20Tablas%20Din%C3%A1micas%20Youtube&ga=1 ✅ ÚNETE A LOS MIEMBROS VIP Y ACCEDE A CONTENIDO EXCLUSIVO https://www.youtube.com/channel/UCh7H5QEvSVPmzwGBI_y8jBA/join Sígueme en mis redes sociales ✅ https://www.facebook.com/unsupportedbrowser ✅ Todo en un solo lugar | https://flow.page/metn ✅Tiktok | https://www.tiktok.com/@excelatodonivel?language=es&share_app_name=musically&timestamp=1610380652 ✅https://www.facebook.com/unsupportedbrowser ✅Sitio web | http://www.microsoftexcelatodonivel.com/ ✅Suscríbete a este canal | https://www.youtube.com/channel/UCh7H5QEvSVPmzwGBI_y8jBA?sub_confirmation=1 ✅Victor Roman Castro | https://www.facebook.com/unsupportedbrowser ✅FanPage Facebook | https://www.facebook.com/unsupportedbrowser ✅Grupo de Ayuda en Facebook | https://www.facebook.com/unsupportedbrowser ✅LinkedIn | https://www.linkedin.com/in/victorroman1605

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 "Curso de Tablas Dinámicas Desde Cero | Como hacer una Tabla Dinámica desde datos externos | Clase 18" 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 "Curso de Tablas Dinámicas Desde Cero | Como hacer una Tabla Dinámica desde datos externos | Clase 18" 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 "Curso de Tablas Dinámicas Desde Cero | Como hacer una Tabla Dinámica desde datos externos | Clase 18" 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 "Curso de Tablas Dinámicas Desde Cero | Como hacer una Tabla Dinámica desde datos externos | Clase 18" 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 "Curso de Tablas Dinámicas Desde Cero | Como hacer una Tabla Dinámica desde datos externos | Clase 18"?

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 "Curso de Tablas Dinámicas Desde Cero | Como hacer una Tabla Dinámica desde datos externos | Clase 18"?

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.