{"id":4629,"date":"2018-05-19T11:45:08","date_gmt":"2018-05-19T16:45:08","guid":{"rendered":"https:\/\/dostinhurtado.com\/site\/?p=4629"},"modified":"2025-04-02T01:13:17","modified_gmt":"2025-04-02T06:13:17","slug":"consolidar-datos","status":"publish","type":"post","link":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/consolidar-datos\/","title":{"rendered":"consolidar datos en Excel"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\" id=\"h-consolidar-datos-o-unir-diferentes-libros-y-hojas-en-excel\"><strong>Consolidar datos o unir diferentes libros y hojas en Excel<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Consolidar datos en Excel es una t\u00e9cnica \u00fatil cuando necesitamos combinar informaci\u00f3n de m\u00faltiples libros o hojas en un solo archivo. Esto es especialmente \u00fatil en empresas que manejan grandes vol\u00famenes de informaci\u00f3n y requieren an\u00e1lisis centralizados.<\/p>\n\n\n\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 title=\"Consolidar datos o unir diferentes libros y hojas en Excel - Dostin Hurtado\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/UPx7DB_F1lo?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<div class=\"wp-block-group is-layout-constrained wp-block-group-is-layout-constrained\">\n<h2 class=\"wp-block-heading has-text-align-center\" id=\"h-descargar-material-de-apoyo-0\">Descargar Material de Apoyo<\/h2>\n\n\n\n<p class=\"has-text-align-left wp-block-paragraph\"><strong>\u00bfListo para poner en pr\u00e1ctica el tutorial?<\/strong> Descarga el \u00abmaterial de apoyo\u00bb y trabaja con el mismo archivo que usamos en el video.<\/p>\n\n\n\n<div class=\"wp-block-ultimate-post-button-group ultp-block-15d8d3\"><div class=\"ultp-button-wrapper ultp-button-frontend ultp-anim-none\">\n<a class=\"wp-block-ultimate-post-button ultp-block-323bd7 ultp-button-layout1\" href=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/04\/consolidar.zip\" target=\"_self\" rel=\"noopener\" download><div class=\"ultp-btnIcon-wrap\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 48 41.6\"><g><path d=\"M30.777 0a17.252 17.252 0 0 0-15.969 10.734 12.026 12.026 0 1 0-5.2 23.479 2.084 2.084 0 0 0 .413.042 2.051 2.051 0 0 0 .409-4.06 7.924 7.924 0 0 1 1.6-15.686 7.84 7.84 0 0 1 3.231.691l2.2.986.617-2.333a13.132 13.132 0 0 1 25.821 3.372 12.993 12.993 0 0 1-4.169 9.6 2.052 2.052 0 0 0 2.8 3A17.229 17.229 0 0 0 30.779.002\"><\/path><path d=\"M34.188 29.466h-5.18V15.578a1.164 1.164 0 0 0-1.164-1.164h-3.94a1.164 1.164 0 0 0-1.164 1.164v13.888h-5.18a1.164 1.164 0 0 0-.888 1.917l8.314 9.8a1.164 1.164 0 0 0 1.775 0l8.315-9.8a1.164 1.164 0 0 0-.888-1.917\"><\/path><\/g><\/svg><\/div><div class=\"ultp-button-text\">DESCARGAR<\/div><\/a>\n<\/div><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u00bfQu\u00e9 es un consolidado de datos en Excel?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Un consolidado de datos en Excel es el proceso de reunir y organizar informaci\u00f3n de diferentes fuentes en un solo archivo. Se pueden consolidar tanto datos num\u00e9ricos como cualitativos, aunque generalmente se aplica a datos cuantificables.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Requisitos para consolidar datos en Excel<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Antes de consolidar datos en Excel, es importante cumplir con ciertos requisitos:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Las tablas deben tener el mismo formato.<\/li>\n\n\n\n<li>La informaci\u00f3n debe estar estructurada de manera similar en cada hoja o archivo.<\/li>\n\n\n\n<li>Definir si los datos ser\u00e1n combinados por suma, conteo u otra funci\u00f3n.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">\u00bfC\u00f3mo consolidar datos en Excel desde diferentes libros?<\/h2>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-dominant-color=\"dee0e3\" data-has-transparency=\"true\" style=\"--dominant-color: #dee0e3;\" fetchpriority=\"high\" decoding=\"async\" width=\"592\" height=\"388\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-18-png.avif\" alt=\"Ventana de &quot;Consolidar&quot; en Excel mostrando referencias a archivos externos (libros).\" class=\"wp-image-24299 has-transparency\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-18-png.avif 592w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-18-300x197.avif 300w\" sizes=\"(max-width: 592px) 100vw, 592px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Sigue estos pasos para consolidar datos en Excel utilizando la herramienta integrada:<\/p>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li><strong>Abrir un nuevo archivo<\/strong>: Presiona <code>Ctrl + U<\/code> para crear un nuevo libro de Excel.<\/li>\n\n\n\n<li><strong>Acceder a la herramienta de consolidaci\u00f3n<\/strong>: Dir\u00edgete a la pesta\u00f1a \u00abDatos\u00bb y selecciona \u00abConsolidar\u00bb.<\/li>\n\n\n\n<li><strong>Seleccionar la funci\u00f3n adecuada<\/strong>: Por defecto, Excel usa la funci\u00f3n de suma, pero tambi\u00e9n puedes usar conteo, promedio, m\u00e1ximo, m\u00ednimo, entre otros.<\/li>\n\n\n\n<li><strong>Agregar referencias de datos<\/strong>: Ve al archivo o hoja donde est\u00e1 la informaci\u00f3n, selecciona el rango de datos y haz clic en \u00abAgregar\u00bb.<\/li>\n\n\n\n<li><strong>Marcar opciones adicionales<\/strong>:\n<ul class=\"wp-block-list\">\n<li>\u00abFila superior\u00bb si deseas incluir encabezados.<\/li>\n\n\n\n<li>\u00abColumna izquierda\u00bb si los datos se organizan seg\u00fan una categor\u00eda.<\/li>\n\n\n\n<li>\u00abCrear v\u00ednculos\u00bb para actualizar autom\u00e1ticamente el consolidado cuando cambian los datos originales.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Aceptar y revisar<\/strong>: Una vez configurado, haz clic en \u00abAceptar\u00bb para generar el consolidado.<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">Mejorando el consolidado con tablas din\u00e1micas<\/h2>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-dominant-color=\"ebebeb\" data-has-transparency=\"true\" style=\"--dominant-color: #ebebeb;\" decoding=\"async\" width=\"302\" height=\"263\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-19-png.avif\" alt=\"Opciones de creaci\u00f3n de Tabla Din\u00e1mica en Excel: desde tabla\/rango, datos externos o modelo de datos.\" class=\"wp-image-24300 has-transparency\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-19-png.avif 302w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-19-300x261.avif 300w\" sizes=\"(max-width: 302px) 100vw, 302px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Si el consolidado de datos en Excel contiene demasiada informaci\u00f3n irrelevante, puedes mejorar la presentaci\u00f3n utilizando tablas din\u00e1micas:<\/p>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li><strong>Crear una tabla din\u00e1mica<\/strong>: Selecciona los datos, ve a \u00abInsertar\u00bb &gt; \u00abTabla din\u00e1mica\u00bb.<\/li>\n\n\n\n<li><strong>Configurar la tabla<\/strong>:\n<ul class=\"wp-block-list\">\n<li>En \u00abFilas\u00bb, agrega la categor\u00eda principal (ejemplo: sedes, productos, etc.).<\/li>\n\n\n\n<li>En \u00abValores\u00bb, selecciona los datos cuantificables a consolidar (ventas, costos, ingresos, etc.).<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Generar gr\u00e1ficos<\/strong>: Para visualizar mejor los datos, inserta un gr\u00e1fico de barras o columnas.<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img data-dominant-color=\"eaeae9\" data-has-transparency=\"true\" decoding=\"async\" width=\"1024\" height=\"263\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-20-1024x263.avif\" alt=\"Tabla din\u00e1mica en Excel consolidando datos con subtotales y la capacidad de interactuar con el nivel de detalle.\" class=\"wp-image-24301 has-transparency\" style=\"--dominant-color: #eaeae9; width:775px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-20-1024x263.avif 1024w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-20-300x77.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-20-768x198.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-20-600x154.avif 600w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-20-png.avif 1065w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u00a1\ud83d\udcca Aprende Excel desde cero y mejora tus habilidades con el <strong><a href=\"https:\/\/dostinhurtado.com\/site\/Categoria\/cursos\/excel-curso-basico-intermedio\/\" target=\"_blank\" rel=\"noreferrer noopener\">Curso de Excel B\u00e1sico e Intermedio<\/a><\/strong>! \ud83d\ude80 Si quieres dominar las hojas de c\u00e1lculo, optimizar tu trabajo y aumentar tu productividad, este curso es perfecto para ti. \u2705 Aprender\u00e1s desde funciones esenciales hasta herramientas m\u00e1s avanzadas que te permitir\u00e1n manejar datos con confianza. \u00a1No esperes m\u00e1s y empieza hoy mismo! \ud83c\udfaf<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusi\u00f3n<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Consolidar datos en Excel es una t\u00e9cnica poderosa para unir informaci\u00f3n dispersa y facilitar su an\u00e1lisis. Siguiendo los pasos adecuados, puedes combinar libros y hojas de forma sencilla y optimizar tus reportes. Si deseas un mejor control, las tablas din\u00e1micas son una excelente opci\u00f3n para mejorar la visualizaci\u00f3n y filtrado de datos.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-trucos-y-curiosidades-sobre-la-funcion-de-consolidar-en-excel\">Trucos y Curiosidades sobre la Funci\u00f3n de Consolidar en Excel<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Consolidar con Diferentes Funciones<\/strong>: No solo puedes sumar los datos, tambi\u00e9n puedes usar funciones como <em>Promedio<\/em>, <em>Contar<\/em>, <em>M\u00e1ximo<\/em> o <em>M\u00ednimo<\/em>. Esto es \u00fatil si necesitas analizar patrones o tendencias en lugar de solo totalizar los valores.<\/li>\n\n\n\n<li><strong>Consolidar con Datos de Diferentes Libros<\/strong>: Puedes consolidar datos de archivos de Excel completamente diferentes, no solo hojas dentro del mismo archivo. Esto es perfecto si trabajas con varios archivos de Excel relacionados.<\/li>\n\n\n\n<li><strong>La Opci\u00f3n de \u00abCrear V\u00ednculos\u00bb<\/strong>: Si decides marcar la opci\u00f3n <em>Crear v\u00ednculos<\/em>, tu consolidado se actualizar\u00e1 cada vez que se actualicen los archivos de origen. \u00a1Esto es perfecto si tienes un flujo de datos constante y deseas mantener todo sincronizado sin tener que hacer el trabajo manualmente!<\/li>\n\n\n\n<li><strong>Usar el Rango Din\u00e1mico<\/strong>: Si las tablas de origen tienen una cantidad variable de filas o columnas, puedes usar rangos din\u00e1micos (usando <em>Tablas de Excel<\/em>) para asegurarte de que todos los datos se consoliden autom\u00e1ticamente al agregar m\u00e1s informaci\u00f3n.<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-consigue-licencias-de-software-al-mejor-precio-con-keysfan\">\ud83d\udcbb <strong>Consigue Licencias de Software al Mejor Precio con Keysfan<\/strong> \ud83d\udd25<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Si buscas licencias de software originales a precios incre\u00edbles, <strong><a href=\"https:\/\/www.keysfan.com\/spring-sale-dh.html?ksf=jddh\">Keysfan<\/a><\/strong> es la mejor opci\u00f3n. \ud83d\udd25 Consigue Windows, Office y muchos m\u00e1s programas a un costo accesible y sin complicaciones. Adem\u00e1s, aprovecha el <strong>c\u00f3digo de descuento DH66<\/strong> para obtener un precio a\u00fan mejor. \u00a1No pierdas esta oportunidad y equipa tu PC con las mejores herramientas al mejor precio! \ud83d\udcbb\u2705<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-preguntas-frecuentes-faq\">Preguntas frecuentes (FAQ)<\/h2>\n\n\n<div class=\"wp-block-uagb-faq uagb-faq__outer-wrap uagb-block-12dc25cb uagb-faq-icon-row uagb-faq-layout-accordion uagb-faq-expand-first-true uagb-faq-inactive-other-true uagb-faq__wrap uagb-buttons-layout-wrap uagb-faq-equal-height     \" data-faqtoggle=\"true\" role=\"tablist\"><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-e0c71dee \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfQu\u00e9 pasa si mis tablas tienen formatos diferentes?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Es recomendable que todas las tablas tengan la misma estructura antes de consolidarlas. Si no es posible, puedes usar tablas din\u00e1micas para normalizar los datos.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-fc61dbba \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfSe pueden consolidar datos de m\u00faltiples hojas en un mismo libro?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>S\u00ed, el proceso es el mismo. Solo debes seleccionar las hojas adecuadas dentro del mismo archivo.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-c2b9cdcf \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfPor qu\u00e9 mi consolidado muestra n\u00fameros incorrectos?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Verifica que seleccionaste correctamente los rangos de datos y que las opciones de consolidaci\u00f3n (suma, conteo, etc.) sean las adecuadas para tu an\u00e1lisis.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-ce871025 \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfPuedo actualizar autom\u00e1ticamente el consolidado cuando cambian los datos originales?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>S\u00ed, activando la opci\u00f3n \u00abCrear v\u00ednculos\u00bb en la herramienta de consolidaci\u00f3n.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-2e9e3a82 \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfC\u00f3mo puedo consolidar datos de archivos que tienen diferentes nombres de hojas?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Si los archivos tienen nombres de hojas distintos, deber\u00e1s seleccionar manualmente cada hoja al agregar las referencias en la herramienta de consolidaci\u00f3n. Tambi\u00e9n puedes utilizar VBA para automatizar la b\u00fasqueda y consolidaci\u00f3n de datos en m\u00faltiples archivos con nombres de hojas variables.<\/p><\/div><\/div><\/div>\n\n\n<p class=\"wp-block-paragraph\">\ud83d\udcca <strong>\u00bfQuieres visualizar datos de forma r\u00e1pida y efectiva?<\/strong> Aprende a usar los <strong><em><a href=\"https:\/\/dostinhurtado.com\/site\/tutoriales\/tutoriales-excel\/graficos-miniatura\/\" target=\"_blank\" rel=\"noreferrer noopener\">Minigr\u00e1ficos o Gr\u00e1ficos Miniatura<\/a><\/em><\/strong> en Excel con nuestro tutorial. Estas peque\u00f1as representaciones visuales te ayudar\u00e1n a identificar tendencias y patrones sin ocupar demasiado espacio en tu hoja de c\u00e1lculo.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Aprende c\u00f3mo consolidar datos en Excel desde varios libros y hojas de c\u00e1lculo con este tutorial pr\u00e1ctico y f\u00e1cil de seguir.<\/p>\n","protected":false},"author":4,"featured_media":4892,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"video","meta":{"_uag_custom_page_level_css":"","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":[52],"tags":[116,186,225,486],"class_list":["post-4629","post","type-post","status-publish","format-video","has-post-thumbnail","hentry","category-tutoriales-excel","tag-base-de-datos","tag-datos","tag-excel","tag-tutorial","post_format-post-format-video"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.0 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>consolidar datos en Excel - Dostin Hurtado<\/title>\n<meta name=\"description\" content=\"Aprende c\u00f3mo consolidar datos en Excel desde varios libros y hojas de c\u00e1lculo con este tutorial pr\u00e1ctico y f\u00e1cil de seguir.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/consolidar-datos\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Consolidar datos en Excel: Consejos y Trucos\" \/>\n<meta property=\"og:description\" content=\"Aprende a consolidar datos en Excel y mejora tu an\u00e1lisis de informaci\u00f3n combinando datos de m\u00faltiples fuentes en un solo archivo.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/consolidar-datos\/\" \/>\n<meta property=\"og:site_name\" content=\"Dostin Hurtado\" \/>\n<meta property=\"article:published_time\" content=\"2018-05-19T16:45:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-02T06:13:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/consolidar_datos.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"376\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Dostin Hurtado\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Consolidar datos en Excel para mejor an\u00e1lisis\" \/>\n<meta name=\"twitter:description\" content=\"Aprende a consolidar datos en Excel y combina informaci\u00f3n de m\u00faltiples fuentes en un solo archivo f\u00e1cil y r\u00e1pido.\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dostin Hurtado\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/consolidar-datos\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/consolidar-datos\\\/\"},\"author\":{\"name\":\"Dostin Hurtado\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/95509baa94d6c69583eddaece41011cc\"},\"headline\":\"consolidar datos en Excel\",\"datePublished\":\"2018-05-19T16:45:08+00:00\",\"dateModified\":\"2025-04-02T06:13:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/consolidar-datos\\\/\"},\"wordCount\":850,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/6bc1fbb1a73635ac2e186182146d04e9\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/consolidar-datos\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/consolidar_datos.jpg\",\"keywords\":[\"Base de Datos\",\"Datos\",\"Excel\",\"Tutorial\"],\"articleSection\":[\"Tutoriales de Excel\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/consolidar-datos\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/consolidar-datos\\\/\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/consolidar-datos\\\/\",\"name\":\"consolidar datos en Excel - Dostin Hurtado\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/consolidar-datos\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/consolidar-datos\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/consolidar_datos.jpg\",\"datePublished\":\"2018-05-19T16:45:08+00:00\",\"dateModified\":\"2025-04-02T06:13:17+00:00\",\"description\":\"Aprende c\u00f3mo consolidar datos en Excel desde varios libros y hojas de c\u00e1lculo con este tutorial pr\u00e1ctico y f\u00e1cil de seguir.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/consolidar-datos\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/consolidar-datos\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/consolidar-datos\\\/#primaryimage\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/consolidar_datos.jpg\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/consolidar_datos.jpg\",\"width\":500,\"height\":376,\"caption\":\"Consolidar datos en Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/consolidar-datos\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"consolidar datos en Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#website\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/\",\"name\":\"Dostin Hurtado\",\"description\":\"\u00a1El Conocimiento Es para Todos! - Cursos Gratis\",\"publisher\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/6bc1fbb1a73635ac2e186182146d04e9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/6bc1fbb1a73635ac2e186182146d04e9\",\"name\":\"Dostin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Logo_Retina_Barras.svg\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Logo_Retina_Barras.svg\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Logo_Retina_Barras.svg\",\"width\":65,\"height\":14,\"caption\":\"Dostin\"},\"logo\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Logo_Retina_Barras.svg\"},\"sameAs\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/95509baa94d6c69583eddaece41011cc\",\"name\":\"Dostin Hurtado\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1783346535\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1783346535\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1783346535\",\"caption\":\"Dostin Hurtado\"},\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/author\\\/moderador\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"consolidar datos en Excel - Dostin Hurtado","description":"Aprende c\u00f3mo consolidar datos en Excel desde varios libros y hojas de c\u00e1lculo con este tutorial pr\u00e1ctico y f\u00e1cil de seguir.","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:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/consolidar-datos\/","og_locale":"es_ES","og_type":"article","og_title":"Consolidar datos en Excel: Consejos y Trucos","og_description":"Aprende a consolidar datos en Excel y mejora tu an\u00e1lisis de informaci\u00f3n combinando datos de m\u00faltiples fuentes en un solo archivo.","og_url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/consolidar-datos\/","og_site_name":"Dostin Hurtado","article_published_time":"2018-05-19T16:45:08+00:00","article_modified_time":"2025-04-02T06:13:17+00:00","og_image":[{"width":500,"height":376,"url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/consolidar_datos.jpg","type":"image\/jpeg"}],"author":"Dostin Hurtado","twitter_card":"summary_large_image","twitter_title":"Consolidar datos en Excel para mejor an\u00e1lisis","twitter_description":"Aprende a consolidar datos en Excel y combina informaci\u00f3n de m\u00faltiples fuentes en un solo archivo f\u00e1cil y r\u00e1pido.","twitter_misc":{"Escrito por":"Dostin Hurtado","Tiempo de lectura":"5 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/consolidar-datos\/#article","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/consolidar-datos\/"},"author":{"name":"Dostin Hurtado","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/95509baa94d6c69583eddaece41011cc"},"headline":"consolidar datos en Excel","datePublished":"2018-05-19T16:45:08+00:00","dateModified":"2025-04-02T06:13:17+00:00","mainEntityOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/consolidar-datos\/"},"wordCount":850,"commentCount":1,"publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/6bc1fbb1a73635ac2e186182146d04e9"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/consolidar-datos\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/consolidar_datos.jpg","keywords":["Base de Datos","Datos","Excel","Tutorial"],"articleSection":["Tutoriales de Excel"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/consolidar-datos\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/consolidar-datos\/","url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/consolidar-datos\/","name":"consolidar datos en Excel - Dostin Hurtado","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/consolidar-datos\/#primaryimage"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/consolidar-datos\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/consolidar_datos.jpg","datePublished":"2018-05-19T16:45:08+00:00","dateModified":"2025-04-02T06:13:17+00:00","description":"Aprende c\u00f3mo consolidar datos en Excel desde varios libros y hojas de c\u00e1lculo con este tutorial pr\u00e1ctico y f\u00e1cil de seguir.","breadcrumb":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/consolidar-datos\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/consolidar-datos\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/consolidar-datos\/#primaryimage","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/consolidar_datos.jpg","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/consolidar_datos.jpg","width":500,"height":376,"caption":"Consolidar datos en Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/consolidar-datos\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/dostinhurtado.com\/site\/"},{"@type":"ListItem","position":2,"name":"consolidar datos en Excel"}]},{"@type":"WebSite","@id":"https:\/\/dostinhurtado.com\/site\/#website","url":"https:\/\/dostinhurtado.com\/site\/","name":"Dostin Hurtado","description":"\u00a1El Conocimiento Es para Todos! - Cursos Gratis","publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/6bc1fbb1a73635ac2e186182146d04e9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dostinhurtado.com\/site\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":["Person","Organization"],"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/6bc1fbb1a73635ac2e186182146d04e9","name":"Dostin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","width":65,"height":14,"caption":"Dostin"},"logo":{"@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg"},"sameAs":["https:\/\/dostinhurtado.com\/site"]},{"@type":"Person","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/95509baa94d6c69583eddaece41011cc","name":"Dostin Hurtado","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1783346535","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1783346535","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1783346535","caption":"Dostin Hurtado"},"url":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/consolidar_datos.jpg",500,376,false],"thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/consolidar_datos-150x150.jpg",150,150,true],"medium":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/consolidar_datos-300x226.jpg",300,226,true],"medium_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/consolidar_datos.jpg",500,376,false],"large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/consolidar_datos.jpg",500,376,false],"1536x1536":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/consolidar_datos.jpg",500,376,false],"2048x2048":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/consolidar_datos.jpg",500,376,false],"ultp_layout_landscape_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/consolidar_datos.jpg",500,376,false],"ultp_layout_landscape":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/consolidar_datos.jpg",500,376,false],"ultp_layout_portrait":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/consolidar_datos.jpg",500,376,false],"ultp_layout_square":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/consolidar_datos.jpg",500,376,false],"woocommerce_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/consolidar_datos-400x376.jpg",400,376,true],"woocommerce_single":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/consolidar_datos.jpg",500,376,false],"woocommerce_gallery_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/consolidar_datos-100x100.jpg",100,100,true]},"uagb_author_info":{"display_name":"Dostin Hurtado","author_link":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"},"uagb_comment_info":1,"uagb_excerpt":"Aprende c\u00f3mo consolidar datos en Excel desde varios libros y hojas de c\u00e1lculo con este tutorial pr\u00e1ctico y f\u00e1cil de seguir.","_links":{"self":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/4629","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/comments?post=4629"}],"version-history":[{"count":3,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/4629\/revisions"}],"predecessor-version":[{"id":24752,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/4629\/revisions\/24752"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media\/4892"}],"wp:attachment":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media?parent=4629"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/categories?post=4629"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/tags?post=4629"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}