{"id":28211,"date":"2022-09-08T15:45:52","date_gmt":"2022-09-08T15:45:52","guid":{"rendered":"https:\/\/www.deltapci.com\/?p=28211"},"modified":"2022-09-08T15:45:52","modified_gmt":"2022-09-08T15:45:52","slug":"tablas-dinamicas-en-excel","status":"publish","type":"post","link":"https:\/\/recursing-dhawan.212-132-71-197.plesk.page\/index.php\/2022\/09\/08\/tablas-dinamicas-en-excel\/","title":{"rendered":"Tablas Din\u00e1micas en Excel"},"content":{"rendered":"\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"tablasdinamicas\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/4QH2VUQCfGk?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>Tablas Din\u00e1micas en Excel. Una tabla din\u00e1mica, consiste en el resumen de un conjunto de datos, atendiendo a varios criterios de agrupaci\u00f3n, representado como una tabla de doble entrada que nos facilita la interpretaci\u00f3n de dichos datos. Es din\u00e1mica porque nos permite ir obteniendo diferentes totales, filtrando datos, cambiando la presentaci\u00f3n de los datos, visualizando o no los datos origen, etc&#8230; Para aquellos que teng\u00e1is conocimientos de Access es lo m\u00e1s parecido a una consulta de referencias cruzadas, pero con m\u00e1s interactividad.<\/p>\n\n\n\n<p>Prep\u00e1rate con nuestro curso de Excel Avanzado<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img decoding=\"async\" src=\"https:\/\/recursing-dhawan.212-132-71-197.plesk.page\/wp-content\/uploads\/2022\/09\/td1.png\" alt=\"\" class=\"wp-image-28214\"\/><\/figure>\n\n\n\n<p>Podr\u00edamos crear una conexi\u00f3n con otra aplicaci\u00f3n para obtener los datos desde otra fuente diferente a Excel.<\/p>\n\n\n\n<p>En el caso de seleccionar la opci\u00f3n <strong>Selecciona una tabla o rango,<\/strong> debemos seleccionar todas las celdas que vayan a participar, incluyendo las cabeceras.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/recursing-dhawan.212-132-71-197.plesk.page\/wp-content\/uploads\/2022\/09\/td2.png\" alt=\"\" class=\"wp-image-28215\"\/><\/figure>\n\n\n\n<p>Desde este panel podemos personalizar la forma en que van a verse los datos en la tabla din\u00e1mica.<br>Con esta herramienta podr\u00edamos construir una tabla din\u00e1mica con la siguiente estructura:<br>\u2022 Una fila para cada una de las Referencias de la tabla.<br>\u2022 Una columna para cada uno de los Meses de la tabla.<br>\u2022 En el resto de la tabla incluiremos el total del Importe para cada Referencia en cada Mes.<br>Para ello simplemente tendremos que arrastrar los elementos que vemos listados a su lugar correspondiente al pie del panel.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tutorial. Una tabla din\u00e1mica, consiste en el resumen de un conjunto de datos, atendiendo a varios criterios de agrupaci\u00f3n, representado como una tabla de doble entrada que nos facilita la interpretaci\u00f3n de dichos datos.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"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-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":"","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-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":"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":""},"mobile":{"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":""}},"footnotes":""},"categories":[2],"tags":[],"class_list":["post-28211","post","type-post","status-publish","format-standard","hentry","category-tutoriales"],"_links":{"self":[{"href":"https:\/\/recursing-dhawan.212-132-71-197.plesk.page\/index.php\/wp-json\/wp\/v2\/posts\/28211","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/recursing-dhawan.212-132-71-197.plesk.page\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/recursing-dhawan.212-132-71-197.plesk.page\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/recursing-dhawan.212-132-71-197.plesk.page\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/recursing-dhawan.212-132-71-197.plesk.page\/index.php\/wp-json\/wp\/v2\/comments?post=28211"}],"version-history":[{"count":0,"href":"https:\/\/recursing-dhawan.212-132-71-197.plesk.page\/index.php\/wp-json\/wp\/v2\/posts\/28211\/revisions"}],"wp:attachment":[{"href":"https:\/\/recursing-dhawan.212-132-71-197.plesk.page\/index.php\/wp-json\/wp\/v2\/media?parent=28211"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/recursing-dhawan.212-132-71-197.plesk.page\/index.php\/wp-json\/wp\/v2\/categories?post=28211"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/recursing-dhawan.212-132-71-197.plesk.page\/index.php\/wp-json\/wp\/v2\/tags?post=28211"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}