{"id":50,"date":"2021-01-12T15:03:02","date_gmt":"2021-01-12T14:03:02","guid":{"rendered":"https:\/\/efem.es\/cursos\/producto\/import-placeholder-for-58\/"},"modified":"2025-12-23T16:03:39","modified_gmt":"2025-12-23T15:03:39","slug":"tablas-dinamicas-y-analisis-de-datos","status":"publish","type":"product","link":"https:\/\/efem.es\/cursos\/tablas-dinamicas-y-analisis-de-datos\/","title":{"rendered":"Curso de Tablas Din\u00e1micas en Excel"},"content":{"rendered":"\t\t<div data-elementor-type=\"product-post\" data-elementor-id=\"50\" class=\"elementor elementor-50\" data-elementor-post-type=\"product\">\n\t\t\t\t<div class=\"elementor-element elementor-element-a696ebb e-grid e-con-boxed e-con e-child\" data-id=\"a696ebb\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-62be7d77 elementor-view-default elementor-position-block-start elementor-mobile-position-block-start elementor-widget elementor-widget-icon-box\" data-id=\"62be7d77\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-box.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-box-wrapper\">\n\n\t\t\t\t\t\t<div class=\"elementor-icon-box-icon\">\n\t\t\t\t<span  class=\"elementor-icon\">\n\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-tv\" viewBox=\"0 0 640 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M592 0H48A48 48 0 0 0 0 48v320a48 48 0 0 0 48 48h240v32H112a16 16 0 0 0-16 16v32a16 16 0 0 0 16 16h416a16 16 0 0 0 16-16v-32a16 16 0 0 0-16-16H352v-32h240a48 48 0 0 0 48-48V48a48 48 0 0 0-48-48zm-16 352H64V64h512z\"><\/path><\/svg>\t\t\t\t<\/span>\n\t\t\t<\/div>\n\t\t\t\n\t\t\t\t\t\t<div class=\"elementor-icon-box-content\">\n\n\t\t\t\t\t\t\t\t\t<h3 class=\"elementor-icon-box-title\">\n\t\t\t\t\t\t<span  >\n\t\t\t\t\t\t\tModalidad Online\t\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/h3>\n\t\t\t\t\n\t\t\t\t\t\t\t\t\t<p class=\"elementor-icon-box-description\">\n\t\t\t\t\t\tDisponible APP M\u00f3vil\t\t\t\t\t<\/p>\n\t\t\t\t\n\t\t\t<\/div>\n\t\t\t\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1d219987 elementor-view-default elementor-position-block-start elementor-mobile-position-block-start elementor-widget elementor-widget-icon-box\" data-id=\"1d219987\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-box.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-box-wrapper\">\n\n\t\t\t\t\t\t<div class=\"elementor-icon-box-icon\">\n\t\t\t\t<span  class=\"elementor-icon\">\n\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-far-calendar-check\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M400 64h-48V12c0-6.627-5.373-12-12-12h-40c-6.627 0-12 5.373-12 12v52H160V12c0-6.627-5.373-12-12-12h-40c-6.627 0-12 5.373-12 12v52H48C21.49 64 0 85.49 0 112v352c0 26.51 21.49 48 48 48h352c26.51 0 48-21.49 48-48V112c0-26.51-21.49-48-48-48zm-6 400H54a6 6 0 0 1-6-6V160h352v298a6 6 0 0 1-6 6zm-52.849-200.65L198.842 404.519c-4.705 4.667-12.303 4.637-16.971-.068l-75.091-75.699c-4.667-4.705-4.637-12.303.068-16.971l22.719-22.536c4.705-4.667 12.303-4.637 16.97.069l44.104 44.461 111.072-110.181c4.705-4.667 12.303-4.637 16.971.068l22.536 22.718c4.667 4.705 4.636 12.303-.069 16.97z\"><\/path><\/svg>\t\t\t\t<\/span>\n\t\t\t<\/div>\n\t\t\t\n\t\t\t\t\t\t<div class=\"elementor-icon-box-content\">\n\n\t\t\t\t\t\t\t\t\t<h3 class=\"elementor-icon-box-title\">\n\t\t\t\t\t\t<span  >\n\t\t\t\t\t\t\t6 Meses de Duraci\u00f3n\t\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/h3>\n\t\t\t\t\n\t\t\t\t\t\t\t\t\t<p class=\"elementor-icon-box-description\">\n\t\t\t\t\t\t20  Horas Lectivas\t\t\t\t\t<\/p>\n\t\t\t\t\n\t\t\t<\/div>\n\t\t\t\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4b6cbfc1 elementor-view-default elementor-position-block-start elementor-mobile-position-block-start elementor-widget elementor-widget-icon-box\" data-id=\"4b6cbfc1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-box.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-box-wrapper\">\n\n\t\t\t\t\t\t<div class=\"elementor-icon-box-icon\">\n\t\t\t\t<span  class=\"elementor-icon\">\n\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-user\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M224 256c70.7 0 128-57.3 128-128S294.7 0 224 0 96 57.3 96 128s57.3 128 128 128zm89.6 32h-16.7c-22.2 10.2-46.9 16-72.9 16s-50.6-5.8-72.9-16h-16.7C60.2 288 0 348.2 0 422.4V464c0 26.5 21.5 48 48 48h352c26.5 0 48-21.5 48-48v-41.6c0-74.2-60.2-134.4-134.4-134.4z\"><\/path><\/svg>\t\t\t\t<\/span>\n\t\t\t<\/div>\n\t\t\t\n\t\t\t\t\t\t<div class=\"elementor-icon-box-content\">\n\n\t\t\t\t\t\t\t\t\t<h3 class=\"elementor-icon-box-title\">\n\t\t\t\t\t\t<span  >\n\t\t\t\t\t\t\tServicio de Tutor\u00edas\t\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/h3>\n\t\t\t\t\n\t\t\t\t\t\t\t\t\t<p class=\"elementor-icon-box-description\">\n\t\t\t\t\t\tProfesionales de Reconocido Prestigio\t\t\t\t\t<\/p>\n\t\t\t\t\n\t\t\t<\/div>\n\t\t\t\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1913f953 elementor-view-default elementor-position-block-start elementor-mobile-position-block-start elementor-widget elementor-widget-icon-box\" data-id=\"1913f953\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-box.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-box-wrapper\">\n\n\t\t\t\t\t\t<div class=\"elementor-icon-box-icon\">\n\t\t\t\t<span  class=\"elementor-icon\">\n\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-certificate\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M458.622 255.92l45.985-45.005c13.708-12.977 7.316-36.039-10.664-40.339l-62.65-15.99 17.661-62.015c4.991-17.838-11.829-34.663-29.661-29.671l-61.994 17.667-15.984-62.671C337.085.197 313.765-6.276 300.99 7.228L256 53.57 211.011 7.229c-12.63-13.351-36.047-7.234-40.325 10.668l-15.984 62.671-61.995-17.667C74.87 57.907 58.056 74.738 63.046 92.572l17.661 62.015-62.65 15.99C.069 174.878-6.31 197.944 7.392 210.915l45.985 45.005-45.985 45.004c-13.708 12.977-7.316 36.039 10.664 40.339l62.65 15.99-17.661 62.015c-4.991 17.838 11.829 34.663 29.661 29.671l61.994-17.667 15.984 62.671c4.439 18.575 27.696 24.018 40.325 10.668L256 458.61l44.989 46.001c12.5 13.488 35.987 7.486 40.325-10.668l15.984-62.671 61.994 17.667c17.836 4.994 34.651-11.837 29.661-29.671l-17.661-62.015 62.65-15.99c17.987-4.302 24.366-27.367 10.664-40.339l-45.984-45.004z\"><\/path><\/svg>\t\t\t\t<\/span>\n\t\t\t<\/div>\n\t\t\t\n\t\t\t\t\t\t<div class=\"elementor-icon-box-content\">\n\n\t\t\t\t\t\t\t\t\t<h3 class=\"elementor-icon-box-title\">\n\t\t\t\t\t\t<span  >\n\t\t\t\t\t\t\tT\u00edtulo Final\t\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/h3>\n\t\t\t\t\n\t\t\t\t\t\t\t\t\t<p class=\"elementor-icon-box-description\">\n\t\t\t\t\t\tUna vez completado el curso se obtiene el certificado\t\t\t\t\t<\/p>\n\t\t\t\t\n\t\t\t<\/div>\n\t\t\t\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-70e2c877 e-flex e-con-boxed e-con e-parent\" data-id=\"70e2c877\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-4c7c168b elementor-widget elementor-widget-text-editor\" data-id=\"4c7c168b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<h3>Analiza una hoja de Excel en la que existen muchos datos y obt\u00e9n informaci\u00f3n de ella gracias al Curso de Tablas Din\u00e1micas en Excel<\/h3><p>Las tablas din\u00e1micas son una herramienta clave de <strong>Excel para el an\u00e1lisis de datos, ya que permiten resumir, filtrar y visualizar informaci\u00f3n de forma r\u00e1pida<\/strong>. Con el Curso de Tablas Din\u00e1micas en Excel puedes crear informes interactivos, detectar tendencias, segmentar datos y mejorar la productividad empresarial, optimizando la toma de decisiones basada en datos claros y actualizados en proyectos financieros, comerciales y de marketing digital.<\/p><p>Las <strong>tablas din\u00e1micas en <a href=\"https:\/\/www.microsoft.com\/es-es\/microsoft-365\/excel\" target=\"_blank\" rel=\"noopener\">Excel<\/a><\/strong>\u00a0permiten crear diferentes vistas de los datos de acuerdo a las variables que deseemos integrar. Con una tabla din\u00e1mica tendremos una gran cantidad de posibilidades de comparaci\u00f3n de manera que podremos hacer un an\u00e1lisis muy exhaustivo de la informaci\u00f3n sin necesidad de estar creando reportes individuales.<\/p><p>Las tablas din\u00e1micas de <a href=\"https:\/\/efem.es\/cursos\/curso-de-excel-365\/\" target=\"_blank\" rel=\"noopener\">excel<\/a> nos permiten resumir f\u00e1cilmente los datos y hacer comparaciones distintas entre cada uno de los resultados. Es posible tambi\u00e9n crear <strong>tablas din\u00e1micas<\/strong>\u00a0basadas en\u00a0m\u00faltiples hojas de Excel\u00a0lo cual nos permite analizar f\u00e1cilmente la informaci\u00f3n sin necesidad de integrar todos los datos en una sola tabla.<\/p><p class=\"\" data-start=\"638\" data-end=\"938\">Con el Curso de Tablas Din\u00e1micas en Excel aprender\u00e1s desde cero, a tu ritmo, con explicaciones claras, ejemplos pr\u00e1cticos y acceso a materiales descargables. Ya sea que trabajes en<strong> finanzas, marketing, recursos humanos<\/strong> o cualquier otra \u00e1rea que implique el manejo de datos, este curso te dar\u00e1 una ventaja real y aplicable desde el primer d\u00eda.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c135062 elementor-widget elementor-widget-eael-adv-tabs\" data-id=\"c135062\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"eael-adv-tabs.default\">\n\t\t\t\t\t        <div data-scroll-on-click=\"no\" data-scroll-speed=\"300\" id=\"eael-advance-tabs-c135062\" class=\"eael-advance-tabs eael-tabs-horizontal eael-tab-auto-active \" data-tabid=\"c135062\">\n            <div class=\"eael-tabs-nav \">\n                <ul class=\"eael-tab-inline-icon\" role=\"tablist\">\n                                            <li id=\"presentacin\" class=\"inactive eael-tab-item-trigger eael-tab-nav-item\" aria-selected=\"true\" data-tab=\"1\" role=\"tab\" tabindex=\"0\" aria-controls=\"presentacin-tab\" aria-expanded=\"false\">\n                            \n                                                                <svg class=\"e-font-icon-svg e-fas-check-circle\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M504 256c0 136.967-111.033 248-248 248S8 392.967 8 256 119.033 8 256 8s248 111.033 248 248zM227.314 387.314l184-184c6.248-6.248 6.248-16.379 0-22.627l-22.627-22.627c-6.248-6.249-16.379-6.249-22.628 0L216 308.118l-70.059-70.059c-6.248-6.248-16.379-6.248-22.628 0l-22.627 22.627c-6.248 6.248-6.248 16.379 0 22.627l104 104c6.249 6.249 16.379 6.249 22.628.001z\"><\/path><\/svg>                                                            \n                                                            <span class=\"eael-tab-title title-after-icon\" >PRESENTACI\u00d3N<\/span>                            \n                                                    <\/li>\n                                            <li id=\"temario\" class=\"inactive eael-tab-item-trigger eael-tab-nav-item\" aria-selected=\"false\" data-tab=\"2\" role=\"tab\" tabindex=\"-1\" aria-controls=\"temario-tab\" aria-expanded=\"false\">\n                            \n                                                                <svg class=\"e-font-icon-svg e-fas-book-open\" viewBox=\"0 0 576 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M542.22 32.05c-54.8 3.11-163.72 14.43-230.96 55.59-4.64 2.84-7.27 7.89-7.27 13.17v363.87c0 11.55 12.63 18.85 23.28 13.49 69.18-34.82 169.23-44.32 218.7-46.92 16.89-.89 30.02-14.43 30.02-30.66V62.75c.01-17.71-15.35-31.74-33.77-30.7zM264.73 87.64C197.5 46.48 88.58 35.17 33.78 32.05 15.36 31.01 0 45.04 0 62.75V400.6c0 16.24 13.13 29.78 30.02 30.66 49.49 2.6 149.59 12.11 218.77 46.95 10.62 5.35 23.21-1.94 23.21-13.46V100.63c0-5.29-2.62-10.14-7.27-12.99z\"><\/path><\/svg>                                                            \n                                                            <span class=\"eael-tab-title title-after-icon\" >TEMARIO<\/span>                            \n                                                    <\/li>\n                                            <li id=\"solicita-informacin\" class=\"inactive eael-tab-item-trigger eael-tab-nav-item\" aria-selected=\"false\" data-tab=\"3\" role=\"tab\" tabindex=\"-1\" aria-controls=\"solicita-informacin-tab\" aria-expanded=\"false\">\n                            \n                                                                <svg class=\"e-font-icon-svg e-far-envelope\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M464 64H48C21.49 64 0 85.49 0 112v288c0 26.51 21.49 48 48 48h416c26.51 0 48-21.49 48-48V112c0-26.51-21.49-48-48-48zm0 48v40.805c-22.422 18.259-58.168 46.651-134.587 106.49-16.841 13.247-50.201 45.072-73.413 44.701-23.208.375-56.579-31.459-73.413-44.701C106.18 199.465 70.425 171.067 48 152.805V112h416zM48 400V214.398c22.914 18.251 55.409 43.862 104.938 82.646 21.857 17.205 60.134 55.186 103.062 54.955 42.717.231 80.509-37.199 103.053-54.947 49.528-38.783 82.032-64.401 104.947-82.653V400H48z\"><\/path><\/svg>                                                            \n                                                            <span class=\"eael-tab-title title-after-icon\" >SOLICITA INFORMACI\u00d3N<\/span>                            \n                                                    <\/li>\n                    \n                                  <\/ul>\n            <\/div>\n            \n            <div class=\"eael-tabs-content\">\n\t\t        \n                    <div id=\"presentacin-tab\" class=\"clearfix eael-tab-content-item inactive\" data-title-link=\"presentacin-tab\">\n\t\t\t\t        <h5>OBJETIVOS<\/h5><p>Los objetivos del Curso de Tablas Din\u00e1micas en Excel son los siguientes:<\/p><ul><li>Entender el <strong>funcionamiento de las tablas din\u00e1micas<\/strong> y su utilidad en el an\u00e1lisis de datos.<\/li><li>Aprender a<strong> dise\u00f1ar y personalizar informes din\u00e1micos<\/strong> de forma eficiente.<\/li><li><strong>Automatizar procesos repetitivos<\/strong> y mejorar la productividad en Excel.<\/li><li>Desarrollar <strong>dashboards interactivos<\/strong> para la toma de decisiones.<\/li><li>Aplicar los conocimientos adquiridos a situaciones reales con ejercicios pr\u00e1cticos.<\/li><\/ul><h5>DESTINATARIOS<\/h5><p>El Curso de Tablas Din\u00e1micas y An\u00e1lisis de Datos en Excel est\u00e1 orientado a personas que requieran un manejo m\u00e1s experimentado de Microsoft Excel, en particular en el an\u00e1lisis de datos y el trabajo con tablas din\u00e1micas.<\/p><h5>CONDICIONES DE COMPRA<\/h5><p>Curso de Tablas Din\u00e1micas y An\u00e1lisis de Datos en Excel\u00a0de<strong> 20 horas lectivas<\/strong>. Dispondr\u00e1 de 3 meses para finalizar el Curso. El curso comienza una vez se reciben las claves de acceso.<\/p><ul><li>T\u00edtulo\u00a0acreditativo al finalizar el curso.<\/li><li>Compatible con cualquier sistema operativo y dispositivos m\u00f3viles.<\/li><li>Modalidad 100% online.<\/li><\/ul><p>Recibir\u00e1 las claves de acceso a la plataforma en 24\/48 horas. Compruebe la bandeja de SPAM. En caso de no recibir las claves escriba a <a href=\"mailto:info@efem.es\">info@efem.es<\/a><\/p>                    <\/div>\n\t\t        \n                    <div id=\"temario-tab\" class=\"clearfix eael-tab-content-item inactive\" data-title-link=\"temario-tab\">\n\t\t\t\t        <ul><li>Tablas Din\u00e1micas<\/li><li>Introducci\u00f3n pr\u00e1ctica<\/li><li>Filas y valores<\/li><li>Columnas, valores y filas<\/li><li>Filtros<\/li><li>Formato condicional<\/li><li>Campo valor<\/li><li>Estilos de dise\u00f1o<\/li><li>Cambios de valores<\/li><li>Agrupar<\/li><li>Recuento de porcentajes<\/li><li>Campos calculados y f\u00f3rmulas<\/li><li>Segmentaciones, escalas de tiempo<\/li><li>Unir tablas<\/li><li>Dashboard<\/li><li>Dashboard 2<\/li><li>Ejercicios<\/li><li>Manual<\/li><\/ul>                    <\/div>\n\t\t        \n                    <div id=\"solicita-informacin-tab\" class=\"clearfix eael-tab-content-item inactive\" data-title-link=\"solicita-informacin-tab\">\n\t\t\t\t        <style>.elementor-61645 .elementor-element.elementor-element-1841047{--display:flex;--flex-direction:column;--container-widget-width:100%;--container-widget-height:initial;--container-widget-flex-grow:0;--container-widget-align-self:initial;--flex-wrap-mobile:wrap;}.elementor-61645 .elementor-element.elementor-element-391a7c0{text-align:center;}.elementor-61645 .elementor-element.elementor-element-d96bacf .elementor-field-group{padding-right:calc( 10px\/2 );padding-left:calc( 10px\/2 );margin-bottom:10px;}.elementor-61645 .elementor-element.elementor-element-d96bacf .elementor-form-fields-wrapper{margin-left:calc( -10px\/2 );margin-right:calc( -10px\/2 );margin-bottom:-10px;}.elementor-61645 .elementor-element.elementor-element-d96bacf .elementor-field-group.recaptcha_v3-bottomleft, .elementor-61645 .elementor-element.elementor-element-d96bacf .elementor-field-group.recaptcha_v3-bottomright{margin-bottom:0;}body.rtl .elementor-61645 .elementor-element.elementor-element-d96bacf .elementor-labels-inline .elementor-field-group > label{padding-left:0px;}body:not(.rtl) .elementor-61645 .elementor-element.elementor-element-d96bacf .elementor-labels-inline .elementor-field-group > label{padding-right:0px;}body .elementor-61645 .elementor-element.elementor-element-d96bacf .elementor-labels-above .elementor-field-group > label{padding-bottom:0px;}.elementor-61645 .elementor-element.elementor-element-d96bacf .elementor-field-type-html{padding-bottom:0px;}.elementor-61645 .elementor-element.elementor-element-d96bacf .elementor-field-group .elementor-field:not(.elementor-select-wrapper){background-color:#ffffff;}.elementor-61645 .elementor-element.elementor-element-d96bacf .elementor-field-group .elementor-select-wrapper select{background-color:#ffffff;}.elementor-61645 .elementor-element.elementor-element-d96bacf .elementor-button{font-size:27px;}.elementor-61645 .elementor-element.elementor-element-d96bacf .e-form__buttons__wrapper__button-next{background-color:#0075C9;color:#ffffff;}.elementor-61645 .elementor-element.elementor-element-d96bacf .elementor-button[type=\"submit\"]{background-color:#0075C9;color:#ffffff;}.elementor-61645 .elementor-element.elementor-element-d96bacf .elementor-button[type=\"submit\"] svg *{fill:#ffffff;}.elementor-61645 .elementor-element.elementor-element-d96bacf .e-form__buttons__wrapper__button-previous{color:#ffffff;}.elementor-61645 .elementor-element.elementor-element-d96bacf .e-form__buttons__wrapper__button-next:hover{color:#ffffff;}.elementor-61645 .elementor-element.elementor-element-d96bacf .elementor-button[type=\"submit\"]:hover{color:#ffffff;}.elementor-61645 .elementor-element.elementor-element-d96bacf .elementor-button[type=\"submit\"]:hover svg *{fill:#ffffff;}.elementor-61645 .elementor-element.elementor-element-d96bacf .e-form__buttons__wrapper__button-previous:hover{color:#ffffff;}.elementor-61645 .elementor-element.elementor-element-d96bacf{--e-form-steps-indicators-spacing:20px;--e-form-steps-indicator-padding:30px;--e-form-steps-indicator-inactive-secondary-color:#ffffff;--e-form-steps-indicator-active-secondary-color:#ffffff;--e-form-steps-indicator-completed-secondary-color:#ffffff;--e-form-steps-divider-width:1px;--e-form-steps-divider-gap:10px;width:var( --container-widget-width, 57% );max-width:57%;--container-widget-width:57%;--container-widget-flex-grow:0;}.elementor-61645 .elementor-element.elementor-element-d96bacf.elementor-element{--align-self:center;}@media(max-width:767px){.elementor-61645 .elementor-element.elementor-element-d96bacf{width:100%;max-width:100%;}}<\/style>\t\t<div data-elementor-type=\"single-post\" data-elementor-id=\"61645\" class=\"elementor elementor-61645\" data-elementor-post-type=\"elementor_library\">\n\t\t\t<div class=\"elementor-element elementor-element-1841047 e-flex e-con-boxed e-con e-parent\" data-id=\"1841047\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-391a7c0 elementor-widget elementor-widget-heading\" data-id=\"391a7c0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h1 class=\"elementor-heading-title elementor-size-default\">SOLICITA INFORMACI\u00d3N<\/h1>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a1f96f2 elementor-widget elementor-widget-text-editor\" data-id=\"a1f96f2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p style=\"text-align: center;\">Completa el formulario y en breve nos podremos en contacto contigo v\u00eda email o whatsapp<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d96bacf elementor-button-align-center elementor-widget__width-initial elementor-widget-mobile__width-inherit elementor-widget elementor-widget-form\" data-id=\"d96bacf\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;step_next_label&quot;:&quot;Next&quot;,&quot;step_previous_label&quot;:&quot;Previous&quot;,&quot;button_width&quot;:&quot;100&quot;,&quot;step_type&quot;:&quot;number_text&quot;,&quot;step_icon_shape&quot;:&quot;circle&quot;}\" data-widget_type=\"form.default\">\n\t\t\t\t\t\t\t<form class=\"elementor-form\" method=\"post\" name=\"New Form\" aria-label=\"New Form\">\n\t\t\t<input type=\"hidden\" name=\"post_id\" value=\"61645\"\/>\n\t\t\t<input type=\"hidden\" name=\"form_id\" value=\"d96bacf\"\/>\n\t\t\t<input type=\"hidden\" name=\"referer_title\" value=\"Curso M\u00e9todo Montessori | 2 Cr\u00e9ditos ECTS, Baremable\" \/>\n\n\t\t\t\t\t\t\t<input type=\"hidden\" name=\"queried_id\" value=\"34508\"\/>\n\t\t\t\n\t\t\t<div class=\"elementor-form-fields-wrapper elementor-labels-\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-text elementor-field-group elementor-column elementor-field-group-name elementor-col-100 elementor-field-required\">\n\t\t\t\t\t\t\t\t\t\t\t\t<label for=\"form-field-name\" class=\"elementor-field-label elementor-screen-only\">\n\t\t\t\t\t\t\t\tNombre\t\t\t\t\t\t\t<\/label>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<input size=\"1\" type=\"text\" name=\"form_fields[name]\" id=\"form-field-name\" class=\"elementor-field elementor-size-md  elementor-field-textual\" placeholder=\"Nombre completo\" required=\"required\">\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-email elementor-field-group elementor-column elementor-field-group-email elementor-col-100 elementor-field-required\">\n\t\t\t\t\t\t\t\t\t\t\t\t<label for=\"form-field-email\" class=\"elementor-field-label elementor-screen-only\">\n\t\t\t\t\t\t\t\tEmail\t\t\t\t\t\t\t<\/label>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<input size=\"1\" type=\"email\" name=\"form_fields[email]\" id=\"form-field-email\" class=\"elementor-field elementor-size-md  elementor-field-textual\" placeholder=\"Email\" required=\"required\">\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-tel elementor-field-group elementor-column elementor-field-group-field_9d297ee elementor-col-100 elementor-field-required\">\n\t\t\t\t\t\t\t\t\t\t\t\t<label for=\"form-field-field_9d297ee\" class=\"elementor-field-label elementor-screen-only\">\n\t\t\t\t\t\t\t\tTelefono\t\t\t\t\t\t\t<\/label>\n\t\t\t\t\t\t\t\t<input size=\"1\" type=\"tel\" name=\"form_fields[field_9d297ee]\" id=\"form-field-field_9d297ee\" class=\"elementor-field elementor-size-md  elementor-field-textual\" placeholder=\"Tel\u00e9fono\" required=\"required\" pattern=\"[0-9()#&amp;+*-=.]+\" title=\"Only numbers and phone characters (#, -, *, etc) are accepted.\">\n\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-acceptance elementor-field-group elementor-column elementor-field-group-field_59cce7d elementor-col-100\">\n\t\t\t\t\t\t\t<div class=\"elementor-field-subgroup\">\n\t\t\t<span class=\"elementor-field-option\">\n\t\t\t\t<input type=\"checkbox\" name=\"form_fields[field_59cce7d]\" id=\"form-field-field_59cce7d\" class=\"elementor-field elementor-size-md  elementor-acceptance-field\">\n\t\t\t\t<label for=\"form-field-field_59cce7d\">Acepto las condiciones legales y la pol\u00edtica de privacidad<\/label>\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-group elementor-column elementor-field-type-submit elementor-col-100 e-form__buttons\">\n\t\t\t\t\t<button class=\"elementor-button elementor-size-md\" type=\"submit\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">ENVIAR<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/button>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/form>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t                    <\/div>\n\t\t                    <\/div>\n        <\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Una tabla din\u00e1mica <strong>sirve para resumir los datos que hay en una hoja de c\u00e1lculo de Microsoft Excel<\/strong>. Lo mejor de todo es que se puede cambiar f\u00e1cil y r\u00e1pidamente para ver los datos de una manera diferente, <strong>haciendo de \u00e9sta una herramienta muy poderosa<\/strong>. Gracias al Curso de Tablas Din\u00e1micas en Excel aprender\u00e1s un excelente modo de resumir, analizar, explorar y presentar los datos.<\/p>\n","protected":false},"featured_media":181,"comment_status":"open","ping_status":"closed","template":"","meta":{"_joinchat":[]},"product_brand":[],"product_cat":[114],"product_tag":[66,39],"class_list":{"0":"post-50","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-ofimatica","7":"product_tag-excel","8":"product_tag-ofimatica","10":"first","11":"instock","12":"sale","13":"virtual","14":"purchasable","15":"product-type-simple"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Curso de Tablas Din\u00e1micas en Excel<\/title>\n<meta name=\"description\" content=\"Gracias al Curso de Tablas Din\u00e1micas en Excel aprender\u00e1s el mejor m\u00e9todo para analizar y resumir datos en Excel. Modalidad Online.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/efem.es\/cursos\/tablas-dinamicas-y-analisis-de-datos\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Curso de Tablas Din\u00e1micas en Excel\" \/>\n<meta property=\"og:description\" content=\"Gracias al Curso de Tablas Din\u00e1micas en Excel aprender\u00e1s el mejor m\u00e9todo para analizar y resumir datos en Excel. Modalidad Online.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/efem.es\/cursos\/tablas-dinamicas-y-analisis-de-datos\/\" \/>\n<meta property=\"og:site_name\" content=\"Formaci\u00f3n Continua Efem\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/FormacionEFEM\/\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-23T15:03:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/efem.es\/cursos\/wp-content\/uploads\/2021\/01\/tablas_dinamicas_en_excel.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"560\" \/>\n\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":[\"WebPage\",\"ItemPage\"],\"@id\":\"https:\\\/\\\/efem.es\\\/cursos\\\/tablas-dinamicas-y-analisis-de-datos\\\/\",\"url\":\"https:\\\/\\\/efem.es\\\/cursos\\\/tablas-dinamicas-y-analisis-de-datos\\\/\",\"name\":\"Curso de Tablas Din\u00e1micas en Excel\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/efem.es\\\/cursos\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/efem.es\\\/cursos\\\/tablas-dinamicas-y-analisis-de-datos\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/efem.es\\\/cursos\\\/tablas-dinamicas-y-analisis-de-datos\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/efem.es\\\/cursos\\\/wp-content\\\/uploads\\\/2021\\\/01\\\/tablas_dinamicas_en_excel.jpg\",\"datePublished\":\"2021-01-12T14:03:02+00:00\",\"dateModified\":\"2025-12-23T15:03:39+00:00\",\"description\":\"Gracias al Curso de Tablas Din\u00e1micas en Excel aprender\u00e1s el mejor m\u00e9todo para analizar y resumir datos en Excel. Modalidad Online.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/efem.es\\\/cursos\\\/tablas-dinamicas-y-analisis-de-datos\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/efem.es\\\/cursos\\\/tablas-dinamicas-y-analisis-de-datos\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/efem.es\\\/cursos\\\/tablas-dinamicas-y-analisis-de-datos\\\/#primaryimage\",\"url\":\"https:\\\/\\\/efem.es\\\/cursos\\\/wp-content\\\/uploads\\\/2021\\\/01\\\/tablas_dinamicas_en_excel.jpg\",\"contentUrl\":\"https:\\\/\\\/efem.es\\\/cursos\\\/wp-content\\\/uploads\\\/2021\\\/01\\\/tablas_dinamicas_en_excel.jpg\",\"width\":560,\"height\":350,\"caption\":\"Curso de Tablas Din\u00e1micas en Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/efem.es\\\/cursos\\\/tablas-dinamicas-y-analisis-de-datos\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Inicio\",\"item\":\"https:\\\/\\\/efem.es\\\/cursos\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tienda\",\"item\":\"https:\\\/\\\/efem.es\\\/cursos\\\/tienda\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Curso de Tablas Din\u00e1micas en Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/efem.es\\\/cursos\\\/#website\",\"url\":\"https:\\\/\\\/efem.es\\\/cursos\\\/\",\"name\":\"Formaci\u00f3n Continua Efem\",\"description\":\"Cursos Online de Calidad Contrastada\",\"publisher\":{\"@id\":\"https:\\\/\\\/efem.es\\\/cursos\\\/#organization\"},\"alternateName\":\"Cursos Online EFEM\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/efem.es\\\/cursos\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/efem.es\\\/cursos\\\/#organization\",\"name\":\"EFEM Escuela de Formaci\u00f3n Empresarial\",\"alternateName\":\"EFEM\",\"url\":\"https:\\\/\\\/efem.es\\\/cursos\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/efem.es\\\/cursos\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/efem.es\\\/cursos\\\/wp-content\\\/uploads\\\/2021\\\/01\\\/logo.png\",\"contentUrl\":\"https:\\\/\\\/efem.es\\\/cursos\\\/wp-content\\\/uploads\\\/2021\\\/01\\\/logo.png\",\"width\":150,\"height\":64,\"caption\":\"EFEM Escuela de Formaci\u00f3n Empresarial\"},\"image\":{\"@id\":\"https:\\\/\\\/efem.es\\\/cursos\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/FormacionEFEM\\\/\"],\"email\":\"info@efem.es\",\"telephone\":\"91 761 19 91\",\"legalName\":\"EFEM, Escuela de Formaci\u00f3n Empresarial\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Curso de Tablas Din\u00e1micas en Excel","description":"Gracias al Curso de Tablas Din\u00e1micas en Excel aprender\u00e1s el mejor m\u00e9todo para analizar y resumir datos en Excel. Modalidad Online.","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:\/\/efem.es\/cursos\/tablas-dinamicas-y-analisis-de-datos\/","og_locale":"es_ES","og_type":"article","og_title":"Curso de Tablas Din\u00e1micas en Excel","og_description":"Gracias al Curso de Tablas Din\u00e1micas en Excel aprender\u00e1s el mejor m\u00e9todo para analizar y resumir datos en Excel. Modalidad Online.","og_url":"https:\/\/efem.es\/cursos\/tablas-dinamicas-y-analisis-de-datos\/","og_site_name":"Formaci\u00f3n Continua Efem","article_publisher":"https:\/\/www.facebook.com\/FormacionEFEM\/","article_modified_time":"2025-12-23T15:03:39+00:00","og_image":[{"width":560,"height":350,"url":"https:\/\/efem.es\/cursos\/wp-content\/uploads\/2021\/01\/tablas_dinamicas_en_excel.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":["WebPage","ItemPage"],"@id":"https:\/\/efem.es\/cursos\/tablas-dinamicas-y-analisis-de-datos\/","url":"https:\/\/efem.es\/cursos\/tablas-dinamicas-y-analisis-de-datos\/","name":"Curso de Tablas Din\u00e1micas en Excel","isPartOf":{"@id":"https:\/\/efem.es\/cursos\/#website"},"primaryImageOfPage":{"@id":"https:\/\/efem.es\/cursos\/tablas-dinamicas-y-analisis-de-datos\/#primaryimage"},"image":{"@id":"https:\/\/efem.es\/cursos\/tablas-dinamicas-y-analisis-de-datos\/#primaryimage"},"thumbnailUrl":"https:\/\/efem.es\/cursos\/wp-content\/uploads\/2021\/01\/tablas_dinamicas_en_excel.jpg","datePublished":"2021-01-12T14:03:02+00:00","dateModified":"2025-12-23T15:03:39+00:00","description":"Gracias al Curso de Tablas Din\u00e1micas en Excel aprender\u00e1s el mejor m\u00e9todo para analizar y resumir datos en Excel. Modalidad Online.","breadcrumb":{"@id":"https:\/\/efem.es\/cursos\/tablas-dinamicas-y-analisis-de-datos\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/efem.es\/cursos\/tablas-dinamicas-y-analisis-de-datos\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/efem.es\/cursos\/tablas-dinamicas-y-analisis-de-datos\/#primaryimage","url":"https:\/\/efem.es\/cursos\/wp-content\/uploads\/2021\/01\/tablas_dinamicas_en_excel.jpg","contentUrl":"https:\/\/efem.es\/cursos\/wp-content\/uploads\/2021\/01\/tablas_dinamicas_en_excel.jpg","width":560,"height":350,"caption":"Curso de Tablas Din\u00e1micas en Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/efem.es\/cursos\/tablas-dinamicas-y-analisis-de-datos\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Inicio","item":"https:\/\/efem.es\/cursos\/"},{"@type":"ListItem","position":2,"name":"Tienda","item":"https:\/\/efem.es\/cursos\/tienda\/"},{"@type":"ListItem","position":3,"name":"Curso de Tablas Din\u00e1micas en Excel"}]},{"@type":"WebSite","@id":"https:\/\/efem.es\/cursos\/#website","url":"https:\/\/efem.es\/cursos\/","name":"Formaci\u00f3n Continua Efem","description":"Cursos Online de Calidad Contrastada","publisher":{"@id":"https:\/\/efem.es\/cursos\/#organization"},"alternateName":"Cursos Online EFEM","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/efem.es\/cursos\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/efem.es\/cursos\/#organization","name":"EFEM Escuela de Formaci\u00f3n Empresarial","alternateName":"EFEM","url":"https:\/\/efem.es\/cursos\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/efem.es\/cursos\/#\/schema\/logo\/image\/","url":"https:\/\/efem.es\/cursos\/wp-content\/uploads\/2021\/01\/logo.png","contentUrl":"https:\/\/efem.es\/cursos\/wp-content\/uploads\/2021\/01\/logo.png","width":150,"height":64,"caption":"EFEM Escuela de Formaci\u00f3n Empresarial"},"image":{"@id":"https:\/\/efem.es\/cursos\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/FormacionEFEM\/"],"email":"info@efem.es","telephone":"91 761 19 91","legalName":"EFEM, Escuela de Formaci\u00f3n Empresarial"}]}},"_links":{"self":[{"href":"https:\/\/efem.es\/cursos\/wp-json\/wp\/v2\/product\/50","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/efem.es\/cursos\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/efem.es\/cursos\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/efem.es\/cursos\/wp-json\/wp\/v2\/comments?post=50"}],"version-history":[{"count":0,"href":"https:\/\/efem.es\/cursos\/wp-json\/wp\/v2\/product\/50\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/efem.es\/cursos\/wp-json\/wp\/v2\/media\/181"}],"wp:attachment":[{"href":"https:\/\/efem.es\/cursos\/wp-json\/wp\/v2\/media?parent=50"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/efem.es\/cursos\/wp-json\/wp\/v2\/product_brand?post=50"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/efem.es\/cursos\/wp-json\/wp\/v2\/product_cat?post=50"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/efem.es\/cursos\/wp-json\/wp\/v2\/product_tag?post=50"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}