{"id":12801,"date":"2022-12-02T09:22:52","date_gmt":"2022-12-02T09:22:52","guid":{"rendered":"https:\/\/pre.kingscorner.es\/?p=5930"},"modified":"2023-09-12T11:09:54","modified_gmt":"2023-09-12T09:09:54","slug":"que-son-las-tablas-dinamicas-en-excel-y-por-que-debes-utilizarlas","status":"publish","type":"post","link":"https:\/\/kingscorner.es\/en\/que-son-las-tablas-dinamicas-en-excel-y-por-que-debes-utilizarlas\/","title":{"rendered":"\u00bfQu\u00e9 son las tablas din\u00e1micas en Excel y por qu\u00e9 debes utilizarlas?"},"content":{"rendered":"<p class=\"wp-block-paragraph\">Hoy desde nuestra <a href=\"https:\/\/pre.kingscorner.es\/\">academia de formaci\u00f3n presencial y online<\/a> queremos hablarte de <strong>una potente herramienta que forma parte de <a href=\"https:\/\/kingscorner.es\/en\/cursos-gratis\/informatica-y-comunicaciones\/\">MS Excel<\/a>, como son las tablas din\u00e1micas.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Vamos a tratar de aportar luz sobre una de las herramientas m\u00e1s potentes que dispone el citado software para que las puedas utilizar en tus proyectos personales o profesionales. Si eres novato y todav\u00eda no tienes demasiada idea sobre Excel o tablas din\u00e1micas, disponemos de <a href=\"https:\/\/kingscorner.es\/en\/cursos-gratis\/\">cursos de formaci\u00f3n<\/a> tanto online como presenciales para que te hagas un experto en la materia. \u00bfEmpezamos?<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Tablas din\u00e1micas. Qu\u00e9 son y cual es su uso<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Una <strong>tabla din\u00e1mica<\/strong> es un resumen de datos estad\u00edsticos que se obtienen de otro conjunto de datos de mayor tama\u00f1o. Sobre este conjunto de datos se pueden realizar c\u00e1lculos&#8230; (suma, multiplicaciones, promedios, etc&#8230; que se obtendr\u00e1n de forma autom\u00e1tica en el momento que los agrupemos con los datos de origen.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Se les llama tablas din\u00e1micas porque no tienen una estructura fija<\/strong>, sino que podemos organizarlas de una u otra manera hasta encontrar informaci\u00f3n \u00fatil en los datos. Es una herramienta avanzada para calcular, resumir y analizar datos que le permite ver comparaciones, patrones y tendencias en ellos. Es decir, una manera m\u00e1s sencilla de realizar un reporte de manera flexible.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Este tipo de tablas (pivot tables) <strong>nos permiten cambiar f\u00e1cilmente las columnas y las filas que queremos visualizar en pantalla<\/strong> y elegir el tipo de c\u00e1lculo que se realizar\u00e1 sobre los datos de origen y todo eso sin la necesidad de escribir una sola f\u00f3rmula.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u00bfCu\u00e1ndo debemos utilizar una tabla din\u00e1mica?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Imagina una situaci\u00f3n en la que has creado un reporte que resume las ventas de cursos dentro de Espa\u00f1a. Despu\u00e9s te piden crear otro reporte donde se muestran las ventas de cada curso por regiones dentro de un pa\u00eds determinado. Y por \u00faltimo, te piden un tercer reporte donde se puedan visualizar las ventas de curso, pero en cada ciudad en lugar de la regi\u00f3n.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Por el m\u00e9todo tradicional aunque los reportes est\u00e1n basado en los mismos datos, deber\u00e1s invertir tiempo en la creaci\u00f3n de las f\u00f3rmulas y en la aplicaci\u00f3n del formato adecuado a cada reporte.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Las tablas din\u00e1micas en este caso, son la herramienta perfecta para crear cada uno de los reportes sin la necesidad de crear una sola f\u00f3rmula, por lo que podemos deducir que <strong>las pivot tables son de gran ayuda para aquellos usuarios de Excel que invierten gran cantidad de tiempo en la creaci\u00f3n de reportes que est\u00e1n basados en los mismos datos de origen.<\/strong><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Informaci\u00f3n sobre los gr\u00e1ficos din\u00e1micos<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Los gr\u00e1ficos din\u00e1micos son las representaciones gr\u00e1ficas de los datos en las tablas din\u00e1micas asociadas. <strong>Este tipo de gr\u00e1ficos son interactivos.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Cuando se crea un gr\u00e1fico din\u00e1mico, aparece el panel de filtro de gr\u00e1fico din\u00e1mico. Puedes usar este panel de filtro para ordenar y filtrar los datos subyacentes del gr\u00e1fico din\u00e1mico. <strong>Los cambios que se realicen en el dise\u00f1o y en los datos de una tabla din\u00e1mica asociada se reflejan inmediatamente en el dise\u00f1o y en los datos del gr\u00e1fico din\u00e1mico y viceversa.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Los gr\u00e1ficos din\u00e1micos muestran series de datos, categor\u00edas, marcadores de datos y ejes, al igual que los gr\u00e1ficos est\u00e1ndar. Tambi\u00e9n puedes cambiar el tipo de gr\u00e1fico y otras opciones como los t\u00edtulos, la ubicaci\u00f3n de la leyenda, las etiquetas de datos, la ubicaci\u00f3n del gr\u00e1fico, etc.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Como ves, las tablas din\u00e1micas son de gran utilidad si en tu d\u00eda a d\u00eda tienes que realizar reportes con datos repetitivos. Si todav\u00eda no los conoces, pero ves un gran potencial en ello para tu trabajo, ven a nuestros <strong>cursos de Excel<\/strong> o de <strong>Tablas Din\u00e1micas y An\u00e1lisis de Datos<\/strong> y aprende con nosotros.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u00a1\u00a1\u00a1Nos vemos en la pr\u00f3xima!!!<\/p>","protected":false},"excerpt":{"rendered":"<p>Hoy desde nuestra academia de formaci\u00f3n presencial y online queremos hablarte de una potente herramienta que<\/p>","protected":false},"author":1,"featured_media":12802,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[383],"tags":[],"class_list":["post-12801","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-informatica"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u00bfQu\u00e9 son las tablas din\u00e1micas en Excel y por qu\u00e9 debes utilizarlas? - Kings Corner Formaci\u00f3n<\/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:\/\/kingscorner.es\/en\/que-son-las-tablas-dinamicas-en-excel-y-por-que-debes-utilizarlas\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfQu\u00e9 son las tablas din\u00e1micas en Excel y por qu\u00e9 debes utilizarlas? - Kings Corner Formaci\u00f3n\" \/>\n<meta property=\"og:description\" content=\"Hoy desde nuestra academia de formaci\u00f3n presencial y online queremos hablarte de una potente herramienta que\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kingscorner.es\/en\/que-son-las-tablas-dinamicas-en-excel-y-por-que-debes-utilizarlas\/\" \/>\n<meta property=\"og:site_name\" content=\"Kings Corner Formaci\u00f3n\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-02T09:22:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-09-12T09:09:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kingscorner.es\/wp-content\/uploads\/2022\/12\/Tablas-dinamicas-en-Microsoft-Excel.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"960\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"desarrollokingscorner@gmail.com\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"desarrollokingscorner@gmail.com\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kingscorner.es\\\/que-son-las-tablas-dinamicas-en-excel-y-por-que-debes-utilizarlas\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kingscorner.es\\\/que-son-las-tablas-dinamicas-en-excel-y-por-que-debes-utilizarlas\\\/\"},\"author\":{\"name\":\"desarrollokingscorner@gmail.com\",\"@id\":\"https:\\\/\\\/kingscorner.es\\\/#\\\/schema\\\/person\\\/691a7e9185a6dfb94140db32bfc61823\"},\"headline\":\"\u00bfQu\u00e9 son las tablas din\u00e1micas en Excel y por qu\u00e9 debes utilizarlas?\",\"datePublished\":\"2022-12-02T09:22:52+00:00\",\"dateModified\":\"2023-09-12T09:09:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kingscorner.es\\\/que-son-las-tablas-dinamicas-en-excel-y-por-que-debes-utilizarlas\\\/\"},\"wordCount\":698,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/kingscorner.es\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/kingscorner.es\\\/que-son-las-tablas-dinamicas-en-excel-y-por-que-debes-utilizarlas\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kingscorner.es\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/Tablas-dinamicas-en-Microsoft-Excel.jpg\",\"articleSection\":[\"Inform\u00e1tica\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/kingscorner.es\\\/que-son-las-tablas-dinamicas-en-excel-y-por-que-debes-utilizarlas\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kingscorner.es\\\/que-son-las-tablas-dinamicas-en-excel-y-por-que-debes-utilizarlas\\\/\",\"url\":\"https:\\\/\\\/kingscorner.es\\\/que-son-las-tablas-dinamicas-en-excel-y-por-que-debes-utilizarlas\\\/\",\"name\":\"\u00bfQu\u00e9 son las tablas din\u00e1micas en Excel y por qu\u00e9 debes utilizarlas? - Kings Corner Formaci\u00f3n\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kingscorner.es\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kingscorner.es\\\/que-son-las-tablas-dinamicas-en-excel-y-por-que-debes-utilizarlas\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kingscorner.es\\\/que-son-las-tablas-dinamicas-en-excel-y-por-que-debes-utilizarlas\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kingscorner.es\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/Tablas-dinamicas-en-Microsoft-Excel.jpg\",\"datePublished\":\"2022-12-02T09:22:52+00:00\",\"dateModified\":\"2023-09-12T09:09:54+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kingscorner.es\\\/que-son-las-tablas-dinamicas-en-excel-y-por-que-debes-utilizarlas\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kingscorner.es\\\/que-son-las-tablas-dinamicas-en-excel-y-por-que-debes-utilizarlas\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/kingscorner.es\\\/que-son-las-tablas-dinamicas-en-excel-y-por-que-debes-utilizarlas\\\/#primaryimage\",\"url\":\"https:\\\/\\\/kingscorner.es\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/Tablas-dinamicas-en-Microsoft-Excel.jpg\",\"contentUrl\":\"https:\\\/\\\/kingscorner.es\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/Tablas-dinamicas-en-Microsoft-Excel.jpg\",\"width\":1280,\"height\":960},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kingscorner.es\\\/que-son-las-tablas-dinamicas-en-excel-y-por-que-debes-utilizarlas\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/kingscorner.es\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfQu\u00e9 son las tablas din\u00e1micas en Excel y por qu\u00e9 debes utilizarlas?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kingscorner.es\\\/#website\",\"url\":\"https:\\\/\\\/kingscorner.es\\\/\",\"name\":\"Kings Corner Formaci\u00f3n\",\"description\":\"Kings Corner. Tu centro de formaci\u00f3n con cursos gratuitos y subvencionados en Zaragoza\",\"publisher\":{\"@id\":\"https:\\\/\\\/kingscorner.es\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/kingscorner.es\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/kingscorner.es\\\/#organization\",\"name\":\"Kings Corner Formaci\u00f3n\",\"url\":\"https:\\\/\\\/kingscorner.es\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/kingscorner.es\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/kingscorner.es\\\/wp-content\\\/uploads\\\/2023\\\/05\\\/logo-kings-corner-formacion.svg\",\"contentUrl\":\"https:\\\/\\\/kingscorner.es\\\/wp-content\\\/uploads\\\/2023\\\/05\\\/logo-kings-corner-formacion.svg\",\"caption\":\"Kings Corner Formaci\u00f3n\"},\"image\":{\"@id\":\"https:\\\/\\\/kingscorner.es\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/kingscorner.es\\\/#\\\/schema\\\/person\\\/691a7e9185a6dfb94140db32bfc61823\",\"name\":\"desarrollokingscorner@gmail.com\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/edb9176dd6bfb37a8119116418c1921dc94ad9038224387d11676c1ddf47717a?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/edb9176dd6bfb37a8119116418c1921dc94ad9038224387d11676c1ddf47717a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/edb9176dd6bfb37a8119116418c1921dc94ad9038224387d11676c1ddf47717a?s=96&d=mm&r=g\",\"caption\":\"desarrollokingscorner@gmail.com\"},\"sameAs\":[\"https:\\\/\\\/pre.kingscorner.es\"],\"url\":\"https:\\\/\\\/kingscorner.es\\\/en\\\/author\\\/desarrollokingscornergmail-com\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfQu\u00e9 son las tablas din\u00e1micas en Excel y por qu\u00e9 debes utilizarlas? - Kings Corner Formaci\u00f3n","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:\/\/kingscorner.es\/en\/que-son-las-tablas-dinamicas-en-excel-y-por-que-debes-utilizarlas\/","og_locale":"en_GB","og_type":"article","og_title":"\u00bfQu\u00e9 son las tablas din\u00e1micas en Excel y por qu\u00e9 debes utilizarlas? - Kings Corner Formaci\u00f3n","og_description":"Hoy desde nuestra academia de formaci\u00f3n presencial y online queremos hablarte de una potente herramienta que","og_url":"https:\/\/kingscorner.es\/en\/que-son-las-tablas-dinamicas-en-excel-y-por-que-debes-utilizarlas\/","og_site_name":"Kings Corner Formaci\u00f3n","article_published_time":"2022-12-02T09:22:52+00:00","article_modified_time":"2023-09-12T09:09:54+00:00","og_image":[{"width":1280,"height":960,"url":"https:\/\/kingscorner.es\/wp-content\/uploads\/2022\/12\/Tablas-dinamicas-en-Microsoft-Excel.jpg","type":"image\/jpeg"}],"author":"desarrollokingscorner@gmail.com","twitter_card":"summary_large_image","twitter_misc":{"Written by":"desarrollokingscorner@gmail.com","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kingscorner.es\/que-son-las-tablas-dinamicas-en-excel-y-por-que-debes-utilizarlas\/#article","isPartOf":{"@id":"https:\/\/kingscorner.es\/que-son-las-tablas-dinamicas-en-excel-y-por-que-debes-utilizarlas\/"},"author":{"name":"desarrollokingscorner@gmail.com","@id":"https:\/\/kingscorner.es\/#\/schema\/person\/691a7e9185a6dfb94140db32bfc61823"},"headline":"\u00bfQu\u00e9 son las tablas din\u00e1micas en Excel y por qu\u00e9 debes utilizarlas?","datePublished":"2022-12-02T09:22:52+00:00","dateModified":"2023-09-12T09:09:54+00:00","mainEntityOfPage":{"@id":"https:\/\/kingscorner.es\/que-son-las-tablas-dinamicas-en-excel-y-por-que-debes-utilizarlas\/"},"wordCount":698,"commentCount":0,"publisher":{"@id":"https:\/\/kingscorner.es\/#organization"},"image":{"@id":"https:\/\/kingscorner.es\/que-son-las-tablas-dinamicas-en-excel-y-por-que-debes-utilizarlas\/#primaryimage"},"thumbnailUrl":"https:\/\/kingscorner.es\/wp-content\/uploads\/2022\/12\/Tablas-dinamicas-en-Microsoft-Excel.jpg","articleSection":["Inform\u00e1tica"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kingscorner.es\/que-son-las-tablas-dinamicas-en-excel-y-por-que-debes-utilizarlas\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kingscorner.es\/que-son-las-tablas-dinamicas-en-excel-y-por-que-debes-utilizarlas\/","url":"https:\/\/kingscorner.es\/que-son-las-tablas-dinamicas-en-excel-y-por-que-debes-utilizarlas\/","name":"\u00bfQu\u00e9 son las tablas din\u00e1micas en Excel y por qu\u00e9 debes utilizarlas? - Kings Corner Formaci\u00f3n","isPartOf":{"@id":"https:\/\/kingscorner.es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kingscorner.es\/que-son-las-tablas-dinamicas-en-excel-y-por-que-debes-utilizarlas\/#primaryimage"},"image":{"@id":"https:\/\/kingscorner.es\/que-son-las-tablas-dinamicas-en-excel-y-por-que-debes-utilizarlas\/#primaryimage"},"thumbnailUrl":"https:\/\/kingscorner.es\/wp-content\/uploads\/2022\/12\/Tablas-dinamicas-en-Microsoft-Excel.jpg","datePublished":"2022-12-02T09:22:52+00:00","dateModified":"2023-09-12T09:09:54+00:00","breadcrumb":{"@id":"https:\/\/kingscorner.es\/que-son-las-tablas-dinamicas-en-excel-y-por-que-debes-utilizarlas\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kingscorner.es\/que-son-las-tablas-dinamicas-en-excel-y-por-que-debes-utilizarlas\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/kingscorner.es\/que-son-las-tablas-dinamicas-en-excel-y-por-que-debes-utilizarlas\/#primaryimage","url":"https:\/\/kingscorner.es\/wp-content\/uploads\/2022\/12\/Tablas-dinamicas-en-Microsoft-Excel.jpg","contentUrl":"https:\/\/kingscorner.es\/wp-content\/uploads\/2022\/12\/Tablas-dinamicas-en-Microsoft-Excel.jpg","width":1280,"height":960},{"@type":"BreadcrumbList","@id":"https:\/\/kingscorner.es\/que-son-las-tablas-dinamicas-en-excel-y-por-que-debes-utilizarlas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/kingscorner.es\/"},{"@type":"ListItem","position":2,"name":"\u00bfQu\u00e9 son las tablas din\u00e1micas en Excel y por qu\u00e9 debes utilizarlas?"}]},{"@type":"WebSite","@id":"https:\/\/kingscorner.es\/#website","url":"https:\/\/kingscorner.es\/","name":"Kings Corner Formaci\u00f3n","description":"Kings Corner. Tu centro de formaci\u00f3n con cursos gratuitos y subvencionados en Zaragoza","publisher":{"@id":"https:\/\/kingscorner.es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kingscorner.es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/kingscorner.es\/#organization","name":"Kings Corner Formaci\u00f3n","url":"https:\/\/kingscorner.es\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/kingscorner.es\/#\/schema\/logo\/image\/","url":"https:\/\/kingscorner.es\/wp-content\/uploads\/2023\/05\/logo-kings-corner-formacion.svg","contentUrl":"https:\/\/kingscorner.es\/wp-content\/uploads\/2023\/05\/logo-kings-corner-formacion.svg","caption":"Kings Corner Formaci\u00f3n"},"image":{"@id":"https:\/\/kingscorner.es\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/kingscorner.es\/#\/schema\/person\/691a7e9185a6dfb94140db32bfc61823","name":"desarrollokingscorner@gmail.com","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/secure.gravatar.com\/avatar\/edb9176dd6bfb37a8119116418c1921dc94ad9038224387d11676c1ddf47717a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/edb9176dd6bfb37a8119116418c1921dc94ad9038224387d11676c1ddf47717a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/edb9176dd6bfb37a8119116418c1921dc94ad9038224387d11676c1ddf47717a?s=96&d=mm&r=g","caption":"desarrollokingscorner@gmail.com"},"sameAs":["https:\/\/pre.kingscorner.es"],"url":"https:\/\/kingscorner.es\/en\/author\/desarrollokingscornergmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/kingscorner.es\/en\/wp-json\/wp\/v2\/posts\/12801","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kingscorner.es\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kingscorner.es\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kingscorner.es\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kingscorner.es\/en\/wp-json\/wp\/v2\/comments?post=12801"}],"version-history":[{"count":3,"href":"https:\/\/kingscorner.es\/en\/wp-json\/wp\/v2\/posts\/12801\/revisions"}],"predecessor-version":[{"id":16559,"href":"https:\/\/kingscorner.es\/en\/wp-json\/wp\/v2\/posts\/12801\/revisions\/16559"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kingscorner.es\/en\/wp-json\/wp\/v2\/media\/12802"}],"wp:attachment":[{"href":"https:\/\/kingscorner.es\/en\/wp-json\/wp\/v2\/media?parent=12801"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kingscorner.es\/en\/wp-json\/wp\/v2\/categories?post=12801"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kingscorner.es\/en\/wp-json\/wp\/v2\/tags?post=12801"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}