{"id":3861,"date":"2022-12-21T17:13:42","date_gmt":"2022-12-21T17:13:42","guid":{"rendered":"https:\/\/www.filetechn.com\/?p=3861"},"modified":"2022-12-21T17:13:42","modified_gmt":"2022-12-21T17:13:42","slug":"como-crear-tablas-dinamicas-en-excel","status":"publish","type":"post","link":"http:\/\/34.227.63.65\/en\/tutorials\/%e2%96%b7-how-to-create-pivot-tables-in-excel\/","title":{"rendered":"\u25b7 How to Create Pivot Tables in Excel"},"content":{"rendered":"<p>To create <strong>pivot tables in excel<\/strong>&nbsp;es importante conocer que esta es una herramienta de excel muy utilizada para organizar, resumir, agrupar y analizar la informaci\u00f3n de forma r\u00e1pida y sencilla, &nbsp;desde las opciones que brinda de la lista de campos de la tabla din\u00e1micas para organizar como: <strong>filters, columns, rows, values.<\/strong><\/p>\n<p>When you have a very large amount of information in excel, spread over several columns and\/or rows, data that is repeated and you want to simplify the information, you can use pivot tables, even generate graphs with the results of the report.<\/p>\n<p>They can also customize the display of the information, changing the font, size, layout of the pivot table and use other options such as \"analyze pivot table\" to create graphs.<\/p>\n<p>The information fields, which are the titles of the information contained in the columns, are organized in the following areas in order to create the pivot tables:<\/p>\n<h3 style=\"text-align: justify;\">AREAS OF THE PIVOT TABLE:&nbsp;&nbsp;<\/h3>\n<ul style=\"font-family: Roboto, sans-serif; font-variant-caps: normal; font-size: 20px; font-style: normal; margin-bottom: 19.796875px; margin-left: 33px; caret-color: #090909; color: #090909; text-align: justify;\">\n<li style=\"font-size: 20px;\">FILTERS: This area contains the information that you want to display in the pivot table and also the information that is excluded.<\/li>\n<li style=\"font-size: 20px;\">COLUMNS: Contains the table headings horizontally.<\/li>\n<li style=\"font-size: 20px;\">ROWS: Contains the information that appears in the cells vertically.<\/li>\n<li style=\"font-size: 20px;\">VALORES: &nbsp;Datos que sean agregados o llevan alg\u00fan calculo.&nbsp;<\/li>\n<\/ul>\n<p style=\"font-family: Roboto, sans-serif; font-variant-caps: normal; font-size: 20px; font-style: normal; caret-color: #090909; color: #090909; text-align: justify;\">To create a pivot table, you must have a base information in an excel sheet, this can be contained in a table or not, it must be coherent according to the organization in cells and columns so that at the moment of organizing it in the pivot table it is much simpler.&nbsp;<\/p>\n<p style=\"font-family: Roboto, sans-serif; font-variant-caps: normal; font-size: 20px; font-style: normal; caret-color: #090909; color: #090909; text-align: justify;\">In this case, we will use as an example the information on the population in Colombia from 2014 to 2021:<\/p>\n<p>\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"585\" height=\"509\" src=\"http:\/\/98.81.225.148\/wp-content\/uploads\/2022\/12\/informacion-tabla-dinamica.png\" alt=\"INFORMACION PARA LA TABLA DINAMICA\" srcset=\"https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/informacion-tabla-dinamica.png 585w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/informacion-tabla-dinamica-300x261.png 300w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/informacion-tabla-dinamica-14x12.png 14w\" sizes=\"(max-width: 585px) 100vw, 585px\"><\/p>\n<p>As we can see, the information contained in the date column, gender (Female\/Male) and sector (North, South, East), is repeated to such an extent that at first glance we cannot analyze, for example, the amount of population over the years, or according to the sector of Colombia, how many men or women there are, etc. With the dynamic table we can analyze the information extensively and conclude your own observations.&nbsp;<\/p>\n<p><em>The excel template containing the developed pivot table can be downloaded from the following link:<\/em><\/p>\n<p><a href=\"http:\/\/98.81.225.148\/wp-content\/uploads\/2022\/12\/EJERCICIO-TABLA-DINAMICA-ESPAnOL.xlsx\">DOWNLOAD - DYNAMIC TABLE EXERCISE ENGLISH<\/a><\/p>\n<p>RELATED POST:<\/p>\n<ul>\n<li><a href=\"https:\/\/www.filetechn.com\/tutoriales\/validacion-de-datos-en-excel-como-validar-celdas\/\">Data validation in excel<\/a><\/li>\n<li><a href=\"https:\/\/www.filetechn.com\/tutoriales\/como-convertir-texto-a-columnas-en-excel\/\">Convert text to columns<\/a>&nbsp;<\/li>\n<li><a href=\"https:\/\/www.filetechn.com\/tutoriales\/\u25b7-como-crear-tablas-dinamicas-en-excel\/\">Dynamic tables&nbsp;<\/a><\/li>\n<li><a href=\"https:\/\/www.planillaexcel.com\/blog\/tablas-dinamicas-excel-ejemplos\">Excel templates with pivot table examples<\/a><\/li>\n<\/ul>\n<h2>Steps to create pivot tables in excel:<\/h2>\n<ol>\n<li>Select all the information that will be included in the pivot table:<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"492\" height=\"448\" src=\"http:\/\/98.81.225.148\/wp-content\/uploads\/2022\/12\/paso-uno-informacion-tabla-dinamica.png\" alt=\"\" srcset=\"https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/paso-uno-informacion-tabla-dinamica.png 492w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/paso-uno-informacion-tabla-dinamica-300x273.png 300w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/paso-uno-informacion-tabla-dinamica-13x12.png 13w\" sizes=\"(max-width: 492px) 100vw, 492px\"><\/p>\n<p>2. &nbsp;Ir al menu de herramientas &gt; Insertar &gt; Tablas&gt; Tabla din\u00e1mica &gt; aparece una ventana de configuraci\u00f3n:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"317\" height=\"172\" src=\"http:\/\/98.81.225.148\/wp-content\/uploads\/2022\/12\/menu-insertar-tabla-dinamica.png\" alt=\"\" srcset=\"https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/menu-insertar-tabla-dinamica.png 317w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/menu-insertar-tabla-dinamica-300x163.png 300w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/menu-insertar-tabla-dinamica-18x10.png 18w\" sizes=\"(max-width: 317px) 100vw, 317px\"><\/p>\n<p>3. &nbsp;En la ventana de configuraci\u00f3n puedes <strong>select a table or range<\/strong> (in this case in step 1 we have already selected the information) or you can <strong>use an external data source.<\/strong><\/p>\n<p>4. &nbsp;Seleccionar d\u00f3nde desea ubicar la tabla din\u00e1mica, puede ser en una <strong>New spreadsheet<\/strong> inside the book you are using or in a <strong>Existing spreadsheet &gt; <\/strong>accept.&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"473\" height=\"337\" src=\"http:\/\/98.81.225.148\/wp-content\/uploads\/2022\/12\/crear-tabla-dinamica.png\" alt=\"CREAR TABLA DINAMICA\" srcset=\"https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/crear-tabla-dinamica.png 473w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/crear-tabla-dinamica-300x214.png 300w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/crear-tabla-dinamica-18x12.png 18w\" sizes=\"(max-width: 473px) 100vw, 473px\"><\/p>\n<p>5. Select the fields of the <strong>list of pivot table fields<\/strong> and arrange in the boxes. In this case we will organize the information by dragging the fields between the areas as follows:&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"310\" height=\"404\" src=\"http:\/\/98.81.225.148\/wp-content\/uploads\/2022\/12\/Captura-de-Pantalla-2022-12-21-a-las-11.50.23-a.-m.png\" alt=\"Areas de la tabla dinamica\" srcset=\"https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/Captura-de-Pantalla-2022-12-21-a-las-11.50.23-a.-m..png 310w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/Captura-de-Pantalla-2022-12-21-a-las-11.50.23-a.-m.-230x300.png 230w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/Captura-de-Pantalla-2022-12-21-a-las-11.50.23-a.-m.-9x12.png 9w\" sizes=\"(max-width: 310px) 100vw, 310px\"><\/p>\n<p>The pivot table will be displayed on the right side like this:&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"753\" height=\"109\" src=\"http:\/\/98.81.225.148\/wp-content\/uploads\/2022\/12\/resultado-tabla-dinamica.png\" alt=\"\" srcset=\"https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/resultado-tabla-dinamica.png 753w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/resultado-tabla-dinamica-300x43.png 300w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/resultado-tabla-dinamica-18x3.png 18w\" sizes=\"(max-width: 753px) 100vw, 753px\"><\/p>\n<h3>Other Tips when inserting pivot tables:<\/h3>\n<p>You can organize the information in any way you wish to discover different ways of analyzing the information contained in the pivot table, for example:<\/p>\n<p>By adding the&nbsp;<strong>Sector<\/strong> in the area of <strong>FILTERS<\/strong>You can filter the information to know the population according to the sector of Colombia (North, South, East) and separated by gender (Male\/Female) over the years.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"525\" height=\"310\" src=\"http:\/\/98.81.225.148\/wp-content\/uploads\/2022\/12\/sector-de-la-tabla-dinamica.png\" alt=\"Sector en la tabla dinamica\" srcset=\"https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/sector-de-la-tabla-dinamica.png 525w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/sector-de-la-tabla-dinamica-300x177.png 300w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/sector-de-la-tabla-dinamica-18x12.png 18w\" sizes=\"(max-width: 525px) 100vw, 525px\"><\/p>\n<p>Like this previous example, you can organize the information to obtain the results you want, depending on the purpose of the pivot table.<\/p>\n<p>6. To change the design of the pivot table, two new tools are generated in the upper part: automate and Acrobat, according to the excel select the following symbol <strong>&gt;&gt;<\/strong> Here, two options are displayed, select <strong>Design.<\/strong><strong style=\"font-size: 20px;\">&nbsp;<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"480\" height=\"212\" src=\"http:\/\/98.81.225.148\/wp-content\/uploads\/2022\/12\/DISE-de-la-tabla.png\" alt=\"\" srcset=\"https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/DISE-de-la-tabla.png 480w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/DISE-de-la-tabla-300x133.png 300w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/DISE-de-la-tabla-18x8.png 18w\" sizes=\"(max-width: 480px) 100vw, 480px\"><\/p>\n<p>Here you can discover tools such as: subtotals, <strong>Grand totals, Report layout, Blank rows,<\/strong> You can also select how you want the colors to be displayed in the table and choose the color and layout of the table.&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"836\" height=\"210\" src=\"http:\/\/98.81.225.148\/wp-content\/uploads\/2022\/12\/MENU-DE-DISE.png\" alt=\"\" srcset=\"https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/MENU-DE-DISE.png 836w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/MENU-DE-DISE-300x75.png 300w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/MENU-DE-DISE-768x193.png 768w, https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/MENU-DE-DISE-18x5.png 18w\" sizes=\"(max-width: 836px) 100vw, 836px\"><\/p>\n<p>If you want to change the font style, color, size, modify the number format of the values, you can select the cells to be modified and do it with the tool <strong>Home, <\/strong>pues no hay limitaciones de las otras herramientas al crear tablas&nbsp;din\u00e1micas.<\/p>\n<h2 style=\"text-align: center;\">VIDEO: COMO INSERTAR TABLA DIN\u00c1MICA &nbsp;PASO A PASO<\/h2>\n<p><br \/>\n<iframe width=\"839\" height=\"472\" src=\"https:\/\/www.youtube.com\/embed\/C6aHH0DLF7A\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen=\"\"><\/iframe><br \/>\n<\/p>","protected":false},"excerpt":{"rendered":"<p>How to create pivot tables in excel<\/p>","protected":false},"author":2,"featured_media":3863,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[63,92,174,175],"class_list":["post-3861","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutoriales","tag-crear-tablas-dinamicas-en-excel","tag-excel","tag-tabla-dinamica","tag-tabla-dinamica-en-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7\u00a0Como Crear Tablas Din\u00e1micas en Excel - FileTech Emprendimiento digital, Tutoriales y Tecnolog\u00eda<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.filetechn.com\/en\/tutorials\/\u25b7-how-to-create-pivot-tables-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7\u00a0Como Crear Tablas Din\u00e1micas en Excel - FileTech Emprendimiento digital, Tutoriales y Tecnolog\u00eda\" \/>\n<meta property=\"og:description\" content=\"Como crear tablas dinamicas en excel\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.filetechn.com\/en\/tutorials\/\u25b7-how-to-create-pivot-tables-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"FileTech Emprendimiento digital, Tutoriales y Tecnolog\u00eda\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-21T17:13:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/DYNAMIC-TABLE-WEB-.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"filetechn\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"filetechn\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.filetechn.com\/en\/tutorials\/%e2%96%b7-how-to-create-pivot-tables-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.filetechn.com\/en\/tutorials\/%e2%96%b7-how-to-create-pivot-tables-in-excel\/\"},\"author\":{\"name\":\"filetechn\",\"@id\":\"http:\/\/34.227.63.65\/#\/schema\/person\/0bd69a1cc53562d2a69b03fac859a55b\"},\"headline\":\"\u25b7\u00a0Como Crear Tablas Din\u00e1micas en Excel\",\"datePublished\":\"2022-12-21T17:13:42+00:00\",\"dateModified\":\"2022-12-21T17:13:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.filetechn.com\/en\/tutorials\/%e2%96%b7-how-to-create-pivot-tables-in-excel\/\"},\"wordCount\":860,\"commentCount\":0,\"publisher\":{\"@id\":\"http:\/\/34.227.63.65\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.filetechn.com\/en\/tutorials\/%e2%96%b7-how-to-create-pivot-tables-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/34.227.63.65\/wp-content\/uploads\/2022\/12\/DYNAMIC-TABLE-WEB-.jpg\",\"keywords\":[\"crear tablas din\u00e1micas en excel\",\"excel\",\"tabla dinamica\",\"tabla dinamica en excel\"],\"articleSection\":[\"Tutoriales\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.filetechn.com\/en\/tutorials\/%e2%96%b7-how-to-create-pivot-tables-in-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.filetechn.com\/en\/tutorials\/%e2%96%b7-how-to-create-pivot-tables-in-excel\/\",\"url\":\"https:\/\/www.filetechn.com\/en\/tutorials\/%e2%96%b7-how-to-create-pivot-tables-in-excel\/\",\"name\":\"\u25b7\u00a0Como Crear Tablas Din\u00e1micas en Excel - FileTech Emprendimiento digital, Tutoriales y Tecnolog\u00eda\",\"isPartOf\":{\"@id\":\"http:\/\/34.227.63.65\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.filetechn.com\/en\/tutorials\/%e2%96%b7-how-to-create-pivot-tables-in-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.filetechn.com\/en\/tutorials\/%e2%96%b7-how-to-create-pivot-tables-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/34.227.63.65\/wp-content\/uploads\/2022\/12\/DYNAMIC-TABLE-WEB-.jpg\",\"datePublished\":\"2022-12-21T17:13:42+00:00\",\"dateModified\":\"2022-12-21T17:13:42+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.filetechn.com\/en\/tutorials\/%e2%96%b7-how-to-create-pivot-tables-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.filetechn.com\/en\/tutorials\/%e2%96%b7-how-to-create-pivot-tables-in-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.filetechn.com\/en\/tutorials\/%e2%96%b7-how-to-create-pivot-tables-in-excel\/#primaryimage\",\"url\":\"http:\/\/34.227.63.65\/wp-content\/uploads\/2022\/12\/DYNAMIC-TABLE-WEB-.jpg\",\"contentUrl\":\"http:\/\/34.227.63.65\/wp-content\/uploads\/2022\/12\/DYNAMIC-TABLE-WEB-.jpg\",\"width\":1280,\"height\":720,\"caption\":\"Como crear tablas dinamicas en excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.filetechn.com\/en\/tutorials\/%e2%96%b7-how-to-create-pivot-tables-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/34.227.63.65\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u25b7\u00a0Como Crear Tablas Din\u00e1micas en Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/34.227.63.65\/#website\",\"url\":\"http:\/\/34.227.63.65\/\",\"name\":\"FileTech Emprendimiento digital, Tutoriales y Tecnolog\u00eda\",\"description\":\"Emprendimiento Digital, Tutoriales, Tecnolog\u00eda, Hosting, Wordpress\",\"publisher\":{\"@id\":\"http:\/\/34.227.63.65\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/34.227.63.65\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"http:\/\/34.227.63.65\/#organization\",\"name\":\"FileTech Emprendimiento digital, Tutoriales y Tecnolog\u00eda\",\"url\":\"http:\/\/34.227.63.65\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/34.227.63.65\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.filetechn.com\/wp-content\/uploads\/2024\/09\/cropped-cropped-logo-circle.png\",\"contentUrl\":\"https:\/\/www.filetechn.com\/wp-content\/uploads\/2024\/09\/cropped-cropped-logo-circle.png\",\"width\":512,\"height\":512,\"caption\":\"FileTech Emprendimiento digital, Tutoriales y Tecnolog\u00eda\"},\"image\":{\"@id\":\"http:\/\/34.227.63.65\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"http:\/\/34.227.63.65\/#\/schema\/person\/0bd69a1cc53562d2a69b03fac859a55b\",\"name\":\"filetechn\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/34.227.63.65\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/2.gravatar.com\/avatar\/ba7172296fdc6c99a739fb82b6c8fd88?s=96&d=mm&r=g\",\"contentUrl\":\"http:\/\/2.gravatar.com\/avatar\/ba7172296fdc6c99a739fb82b6c8fd88?s=96&d=mm&r=g\",\"caption\":\"filetechn\"},\"url\":\"http:\/\/34.227.63.65\/en\/author\/filetechn\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7\u00a0Como Crear Tablas Din\u00e1micas en Excel - FileTech Emprendimiento digital, Tutoriales y Tecnolog\u00eda","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.filetechn.com\/en\/tutorials\/\u25b7-how-to-create-pivot-tables-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"\u25b7\u00a0Como Crear Tablas Din\u00e1micas en Excel - FileTech Emprendimiento digital, Tutoriales y Tecnolog\u00eda","og_description":"Como crear tablas dinamicas en excel","og_url":"https:\/\/www.filetechn.com\/en\/tutorials\/\u25b7-how-to-create-pivot-tables-in-excel\/","og_site_name":"FileTech Emprendimiento digital, Tutoriales y Tecnolog\u00eda","article_published_time":"2022-12-21T17:13:42+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/www.filetechn.com\/wp-content\/uploads\/2022\/12\/DYNAMIC-TABLE-WEB-.jpg","type":"image\/jpeg"}],"author":"filetechn","twitter_card":"summary_large_image","twitter_misc":{"Written by":"filetechn","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.filetechn.com\/en\/tutorials\/%e2%96%b7-how-to-create-pivot-tables-in-excel\/#article","isPartOf":{"@id":"https:\/\/www.filetechn.com\/en\/tutorials\/%e2%96%b7-how-to-create-pivot-tables-in-excel\/"},"author":{"name":"filetechn","@id":"http:\/\/34.227.63.65\/#\/schema\/person\/0bd69a1cc53562d2a69b03fac859a55b"},"headline":"\u25b7\u00a0Como Crear Tablas Din\u00e1micas en Excel","datePublished":"2022-12-21T17:13:42+00:00","dateModified":"2022-12-21T17:13:42+00:00","mainEntityOfPage":{"@id":"https:\/\/www.filetechn.com\/en\/tutorials\/%e2%96%b7-how-to-create-pivot-tables-in-excel\/"},"wordCount":860,"commentCount":0,"publisher":{"@id":"http:\/\/34.227.63.65\/#organization"},"image":{"@id":"https:\/\/www.filetechn.com\/en\/tutorials\/%e2%96%b7-how-to-create-pivot-tables-in-excel\/#primaryimage"},"thumbnailUrl":"http:\/\/34.227.63.65\/wp-content\/uploads\/2022\/12\/DYNAMIC-TABLE-WEB-.jpg","keywords":["crear tablas din\u00e1micas en excel","excel","tabla dinamica","tabla dinamica en excel"],"articleSection":["Tutoriales"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.filetechn.com\/en\/tutorials\/%e2%96%b7-how-to-create-pivot-tables-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.filetechn.com\/en\/tutorials\/%e2%96%b7-how-to-create-pivot-tables-in-excel\/","url":"https:\/\/www.filetechn.com\/en\/tutorials\/%e2%96%b7-how-to-create-pivot-tables-in-excel\/","name":"\u25b7\u00a0Como Crear Tablas Din\u00e1micas en Excel - FileTech Emprendimiento digital, Tutoriales y Tecnolog\u00eda","isPartOf":{"@id":"http:\/\/34.227.63.65\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.filetechn.com\/en\/tutorials\/%e2%96%b7-how-to-create-pivot-tables-in-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.filetechn.com\/en\/tutorials\/%e2%96%b7-how-to-create-pivot-tables-in-excel\/#primaryimage"},"thumbnailUrl":"http:\/\/34.227.63.65\/wp-content\/uploads\/2022\/12\/DYNAMIC-TABLE-WEB-.jpg","datePublished":"2022-12-21T17:13:42+00:00","dateModified":"2022-12-21T17:13:42+00:00","breadcrumb":{"@id":"https:\/\/www.filetechn.com\/en\/tutorials\/%e2%96%b7-how-to-create-pivot-tables-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.filetechn.com\/en\/tutorials\/%e2%96%b7-how-to-create-pivot-tables-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.filetechn.com\/en\/tutorials\/%e2%96%b7-how-to-create-pivot-tables-in-excel\/#primaryimage","url":"http:\/\/34.227.63.65\/wp-content\/uploads\/2022\/12\/DYNAMIC-TABLE-WEB-.jpg","contentUrl":"http:\/\/34.227.63.65\/wp-content\/uploads\/2022\/12\/DYNAMIC-TABLE-WEB-.jpg","width":1280,"height":720,"caption":"Como crear tablas dinamicas en excel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.filetechn.com\/en\/tutorials\/%e2%96%b7-how-to-create-pivot-tables-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/34.227.63.65\/"},{"@type":"ListItem","position":2,"name":"\u25b7\u00a0Como Crear Tablas Din\u00e1micas en Excel"}]},{"@type":"WebSite","@id":"http:\/\/34.227.63.65\/#website","url":"http:\/\/34.227.63.65\/","name":"FileTech Emprendimiento digital, Tutoriales y Tecnolog\u00eda","description":"Emprendimiento Digital, Tutoriales, Tecnolog\u00eda, Hosting, Wordpress","publisher":{"@id":"http:\/\/34.227.63.65\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/34.227.63.65\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"http:\/\/34.227.63.65\/#organization","name":"FileTech Emprendimiento digital, Tutoriales y Tecnolog\u00eda","url":"http:\/\/34.227.63.65\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/34.227.63.65\/#\/schema\/logo\/image\/","url":"https:\/\/www.filetechn.com\/wp-content\/uploads\/2024\/09\/cropped-cropped-logo-circle.png","contentUrl":"https:\/\/www.filetechn.com\/wp-content\/uploads\/2024\/09\/cropped-cropped-logo-circle.png","width":512,"height":512,"caption":"FileTech Emprendimiento digital, Tutoriales y Tecnolog\u00eda"},"image":{"@id":"http:\/\/34.227.63.65\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"http:\/\/34.227.63.65\/#\/schema\/person\/0bd69a1cc53562d2a69b03fac859a55b","name":"filetechn","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/34.227.63.65\/#\/schema\/person\/image\/","url":"http:\/\/2.gravatar.com\/avatar\/ba7172296fdc6c99a739fb82b6c8fd88?s=96&d=mm&r=g","contentUrl":"http:\/\/2.gravatar.com\/avatar\/ba7172296fdc6c99a739fb82b6c8fd88?s=96&d=mm&r=g","caption":"filetechn"},"url":"http:\/\/34.227.63.65\/en\/author\/filetechn\/"}]}},"_links":{"self":[{"href":"http:\/\/34.227.63.65\/en\/wp-json\/wp\/v2\/posts\/3861"}],"collection":[{"href":"http:\/\/34.227.63.65\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/34.227.63.65\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/34.227.63.65\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/34.227.63.65\/en\/wp-json\/wp\/v2\/comments?post=3861"}],"version-history":[{"count":0,"href":"http:\/\/34.227.63.65\/en\/wp-json\/wp\/v2\/posts\/3861\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/34.227.63.65\/en\/wp-json\/wp\/v2\/media\/3863"}],"wp:attachment":[{"href":"http:\/\/34.227.63.65\/en\/wp-json\/wp\/v2\/media?parent=3861"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/34.227.63.65\/en\/wp-json\/wp\/v2\/categories?post=3861"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/34.227.63.65\/en\/wp-json\/wp\/v2\/tags?post=3861"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}