{"id":18766,"date":"2025-02-20T06:30:14","date_gmt":"2025-02-20T09:30:14","guid":{"rendered":"https:\/\/excelfull.com\/excel\/?p=18766"},"modified":"2025-03-01T18:46:16","modified_gmt":"2025-03-01T21:46:16","slug":"power-pivot-en-excel","status":"publish","type":"post","link":"https:\/\/excelfull.com\/excel\/power-pivot-en-excel\/","title":{"rendered":"POWER PIVOT: CONVIERTE EXCEL EN UN POTENTE MOTOR DE AN\u00c1LISIS"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>Si trabajas con datos en Excel, seguramente has encontrado limitaciones al manejar grandes vol\u00famenes de informaci\u00f3n. Aqu\u00ed es donde entra <strong>Power Pivot en Excel<\/strong>, una herramienta avanzada que te permite gestionar y analizar datos de manera eficiente.<\/p><div id=\"excel-2167489430\" class=\"excel-contenido_3 excel-entity-placement\"><section id=\"temario-blog\" class=\"py-8 bg-white\">\r\n    <div class=\"max-w-4xl mx-auto px-4\">\r\n        <div class=\"relative overflow-hidden bg-slate-900 rounded-[2rem] p-8 md:p-12 shadow-xl\">\r\n            \r\n            <div class=\"absolute top-0 right-0 -translate-y-1\/2 translate-x-1\/2 w-64 h-64 bg-[#136E42] opacity-20 blur-[80px] rounded-full\"><\/div>\r\n            <div class=\"absolute bottom-0 left-0 translate-y-1\/2 -translate-x-1\/2 w-48 h-48 bg-emerald-500 opacity-10 blur-[60px] rounded-full\"><\/div>\r\n\r\n            <div class=\"relative z-10 flex flex-col gap-8\">\r\n                \r\n                <div class=\"text-center\">\r\n                    <div class=\"inline-flex items-center gap-2 bg-white\/10 border border-white\/20 px-3 py-1.5 rounded-full mb-4\">\r\n                        <i class=\"fa-solid fa-file-pdf text-emerald-400 text-xs\"><\/i>\r\n                        <span class=\"text-white text-[9px] font-black uppercase tracking-[0.2em]\">Recurso Gratuito 2026<\/span>\r\n                    <\/div>\r\n                    <h2 class=\"text-2xl md:text-3xl font-extrabold text-white leading-tight mb-3\">\r\n                        \u00bfTe gustar\u00eda dominar <span class=\"text-emerald-400\">Excel como un Pro?<\/span>\r\n                    <\/h2>\r\n                    <p class=\"text-slate-300 text-base font-medium max-w-xl mx-auto\">\r\n                        Suscr\u00edbete para recibir tips exclusivos y descarga el temario completo de nuestro curso profesional en PDF.\r\n                    <\/p>\r\n                <\/div>\r\n\r\n                <div class=\"w-full max-w-md mx-auto bg-white\/5 backdrop-blur-sm border border-white\/10 p-6 rounded-2xl\">\r\n                    \r\n                    <div id=\"form-content-blog\">\r\n                        <form id=\"excel-form-blog\" class=\"space-y-4\">\r\n                            <div>\r\n                                <label for=\"email-blog\" class=\"block text-white\/70 text-[10px] font-bold uppercase tracking-widest mb-2 ml-1\">Tu mejor correo electr\u00f3nico<\/label>\r\n                                <input type=\"email\" id=\"email-blog\" name=\"email\" placeholder=\"ejemplo@correo.com\" required \r\n                                    class=\"w-full bg-white\/10 border border-white\/20 rounded-xl px-4 py-3.5 text-white placeholder:text-slate-500 focus:outline-none focus:ring-2 focus:ring-emerald-500\/50 transition-all text-sm\">\r\n                            <\/div>\r\n                            \r\n                            <button type=\"submit\" id=\"submit-btn-blog\"\r\n                                class=\"w-full bg-[#136E42] hover:bg-emerald-600 text-white py-4 rounded-xl text-xs font-black uppercase tracking-widest transition-all shadow-lg active:scale-95 flex items-center justify-center gap-3\">\r\n                                <span>Descargar Temario y Suscribirme<\/span>\r\n                                <i class=\"fa-solid fa-paper-plane text-[10px]\"><\/i>\r\n                            <\/button>\r\n                        <\/form>\r\n                        <p class=\"text-slate-500 text-[9px] text-center mt-4 font-bold uppercase tracking-widest\">\r\n                            <i class=\"fa-solid fa-shield-halved mr-1\"><\/i> Sin spam. Solo contenido de valor.\r\n                        <\/p>\r\n                    <\/div>\r\n\r\n                    <div id=\"success-message-blog\" class=\"hidden text-center py-4\">\r\n                        <div class=\"w-12 h-12 bg-emerald-500\/20 text-emerald-400 rounded-full flex items-center justify-center mx-auto mb-3 border border-emerald-500\/30\">\r\n                            <i class=\"fa-solid fa-check text-xl\"><\/i>\r\n                        <\/div>\r\n                        <h3 class=\"text-white text-lg font-bold mb-1\">\u00a1Registro completado!<\/h3>\r\n                        <p class=\"text-slate-400 text-xs leading-relaxed\">\r\n                            Revisa tu bandeja de entrada; el temario ya va en camino.\r\n                        <\/p>\r\n                    <\/div>\r\n                <\/div>\r\n\r\n            <\/div>\r\n        <\/div>\r\n    <\/div>\r\n<\/section>\r\n\r\n<script>\r\ndocument.getElementById('excel-form-blog').addEventListener('submit', function(e) {\r\n    e.preventDefault();\r\n    const btn = document.getElementById('submit-btn-blog');\r\n    const email = document.getElementById('email-blog').value;\r\n    const btnText = btn.querySelector('span');\r\n    \r\n    btn.disabled = true;\r\n    btn.classList.add('opacity-50', 'cursor-not-allowed');\r\n    btnText.innerText = 'PROCESANDO...';\r\n\r\n    fetch('https:\/\/n8n.george.com.py\/webhook\/registro-excel-full', {\r\n        method: 'POST',\r\n        headers: { 'Content-Type': 'application\/json' },\r\n        body: JSON.stringify({ \r\n            email: email,\r\n            origen: 'descarga_temario_blog'\r\n        })\r\n    })\r\n    .then(response => {\r\n        if(response.ok) {\r\n            \/\/ Empujamos el evento a GTM para medir conversiones desde el blog\r\n            window.dataLayer = window.dataLayer || [];\r\n            window.dataLayer.push({\r\n                event: 'form_blog_success',\r\n                form_name: 'captacion_blog',\r\n                email: email,\r\n                origen: 'descarga_temario_blog'\r\n            });\r\n\r\n            document.getElementById('form-content-blog').classList.add('hidden');\r\n            document.getElementById('success-message-blog').classList.remove('hidden');\r\n        } else {\r\n            throw new Error();\r\n        }\r\n    })\r\n    .catch(error => {\r\n        alert('Hubo un inconveniente. Intenta de nuevo.');\r\n        btn.disabled = false;\r\n        btn.classList.remove('opacity-50', 'cursor-not-allowed');\r\n        btnText.innerText = 'Descargar Temario y Suscribirme';\r\n    });\r\n});\r\n<\/script><\/div>\n<p>Con Power Pivot en Excel, puedes conectar m\u00faltiples tablas, usar c\u00e1lculos avanzados con DAX y optimizar el rendimiento de tus hojas de c\u00e1lculo. En esta gu\u00eda, te explicamos qu\u00e9 es, para qu\u00e9 sirve y c\u00f3mo empezar a utilizarlo.<\/p>\n<p>&nbsp;<\/p>\n<h2>\u00bfQU\u00c9 ES POWER PIVOT?<\/h2>\n<p>Power Pivot es un complemento avanzado de Excel que permite gestionar y analizar grandes cantidades de datos de manera m\u00e1s eficiente que las herramientas tradicionales.<\/p>\n<p>A diferencia de las tablas din\u00e1micas est\u00e1ndar, Power Pivot permite:<\/p>\n<ul>\n<li>Manejar millones de filas sin afectar el rendimiento.<\/li>\n<li>Relacionar m\u00faltiples tablas sin usar BUSCARV.<\/li>\n<li>Utilizar el lenguaje DAX para c\u00e1lculos avanzados.<\/li>\n<li>Crear modelos de datos sin necesidad de bases de datos externas.<\/li>\n<\/ul>\n<p>Power Pivot es una de las tres herramientas de an\u00e1lisis de datos disponibles en Excel:<\/p>\n<p><strong>\u00a0 \u00a0 <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-18597\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/icono-flecha.png\" alt=\"\" width=\"20\" height=\"20\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/icono-flecha.png 512w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/icono-flecha-150x150.png 150w\" sizes=\"auto, (max-width: 20px) 100vw, 20px\" \/> Power Pivot<\/strong><\/p>\n<p><strong>\u00a0 \u00a0 <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-18597\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/icono-flecha.png\" alt=\"\" width=\"20\" height=\"20\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/icono-flecha.png 512w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/icono-flecha-150x150.png 150w\" sizes=\"auto, (max-width: 20px) 100vw, 20px\" \/> Power Query<\/strong><\/p>\n<p><strong>\u00a0 \u00a0 <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-18597\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/icono-flecha.png\" alt=\"\" width=\"20\" height=\"20\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/icono-flecha.png 512w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/icono-flecha-150x150.png 150w\" sizes=\"auto, (max-width: 20px) 100vw, 20px\" \/> Power View<\/strong><\/p>\n<p>Gracias a Power Pivot, los analistas pueden transformar datos sin necesidad de software especializado como SQL o Power BI.<\/p>\n<p>&nbsp;<\/p>\n<h2>\u00bfPARA QU\u00c9 SIRVE POWER PIVOT?<\/h2>\n<p><strong>Power Pivot<\/strong> es ideal para trabajar con conjuntos de datos de gran tama\u00f1o, establecer amplias relaciones y crear c\u00e1lculos complejos (o simples), todo en un entorno de alto rendimiento, y dentro de la experiencia familiar de Excel.<\/p>\n<p>&nbsp;<\/p>\n<h2>FUNCIONALIDADES CLAVE DE POWER PIVOT<\/h2>\n<ul>\n<li><strong>Modelado de datos avanzado:<\/strong> Relaciona m\u00faltiples tablas sin necesidad de f\u00f3rmulas complejas.<\/li>\n<li><strong>Optimizaci\u00f3n del rendimiento:<\/strong> Maneja grandes bases de datos sin ralentizar Excel.<\/li>\n<li><strong>An\u00e1lisis con DAX:<\/strong> Usa funciones avanzadas para c\u00e1lculos personalizados.<\/li>\n<li><strong>Mayor flexibilidad:<\/strong> Permite importar datos desde SQL, Access, archivos CSV, entre otros.<\/li>\n<\/ul>\n<p><span style=\"color: #136e42;\"><strong>Ejemplo de uso:<\/strong><\/span> Un analista financiero puede combinar datos de ventas, gastos y tendencias del mercado en un solo modelo de Power Pivot para obtener reportes m\u00e1s detallados y automatizados.<\/p>\n<p>&nbsp;<\/p>\n<h2>\u00bfEN QU\u00c9 VERSIONES DE OFFICE EST\u00c1 DISPONIBLE POWER PIVOT?<\/h2>\n<p>Power Pivot no est\u00e1 disponible en todas las versiones de Excel. Aseg\u00farate de que tu versi\u00f3n lo incluya antes de intentar usarlo.<\/p>\n<h3>VERSIONES DE EXCEL QUE INCLUYEN POWER PIVOT<\/h3>\n<ul>\n<li>Microsoft 365 (Plan Empresarial y Profesional).<\/li>\n<li>Excel 2016, 2019 y 2021 (Ediciones Profesionales y Empresariales).<\/li>\n<li>Excel 2013 Professional Plus.<\/li>\n<li>Excel 2010 (Con Power Pivot como complemento descargable).<\/li>\n<\/ul>\n<p><span style=\"color: #136e42;\"><strong><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-18787\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/icono-no-disponible.png\" alt=\"\" width=\"25\" height=\"25\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/icono-no-disponible.png 512w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/icono-no-disponible-150x150.png 150w\" sizes=\"auto, (max-width: 25px) 100vw, 25px\" \/> No disponible en:<\/strong> <\/span>Excel para Mac, Excel en versiones Home &amp; Student y Excel Online.<\/p>\n<p>&nbsp;<\/p>\n<h2>\u00bfC\u00d3MO OBTENER POWER PIVOT?<\/h2>\n<p>Power Pivot no est\u00e1 habilitado de forma predeterminada, as\u00ed que primero debes activarlo:<\/p>\n<h3>PASOS PARA ACTIVAR POWER PIVOT EN EXCEL<\/h3>\n<ol>\n<li>Abre Excel y dir\u00edgete a <strong>Archivo &gt; Opciones<\/strong>.<\/li>\n<li>En la ventana emergente, selecciona <strong>Complementos<\/strong>.<\/li>\n<li>Busca <strong>Power Pivot para Excel<\/strong> en la lista.<\/li>\n<li>En la parte inferior de la ventana, en el campo <strong>\u00abAdministrar\u00bb<\/strong>, selecciona <strong>\u00abComplementos COM\u00bb<\/strong> y haz clic en <strong>\u00abIr\u00bb<\/strong>.<\/li>\n<li>Marca la casilla <strong>\u00abMicrosoft Power Pivot for Excel\u00bb<\/strong> y haz clic en <strong>\u00abAceptar\u00bb<\/strong>.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-18776 size-full\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/PV-1.png\" alt=\"Power Pivot en Excel\" width=\"1481\" height=\"847\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/PV-1.png 1481w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/PV-1-1000x572.png 1000w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/PV-1-768x439.png 768w\" sizes=\"auto, (max-width: 1481px) 100vw, 1481px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-18788\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/icono-de-actualizado.png\" alt=\"\" width=\"30\" height=\"30\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/icono-de-actualizado.png 512w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/icono-de-actualizado-150x150.png 150w\" sizes=\"auto, (max-width: 30px) 100vw, 30px\" \/> Ahora deber\u00edas ver la pesta\u00f1a <strong>Power Pivot<\/strong> en la cinta de opciones.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-18791\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/icono-de-atencion.png\" alt=\"\" width=\"30\" height=\"30\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/icono-de-atencion.png 512w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/icono-de-atencion-150x150.png 150w\" sizes=\"auto, (max-width: 30px) 100vw, 30px\" \/> Si <strong>Power Pivot<\/strong> no aparece en tu versi\u00f3n de Excel, es posible que necesites actualizar a una edici\u00f3n superior o suscribirte a <strong>Microsoft 365<\/strong>.<\/p>\n<p>&nbsp;<\/p>\n<h2>\u00bfC\u00d3MO EMPEZAR A USAR POWER PIVOT?<\/h2>\n<p>Ahora que ya activaste Power Pivot, es momento de aprender a usarlo.<\/p>\n<h3><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-18731\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/icono-1.png\" alt=\"\" width=\"25\" height=\"25\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/icono-1.png 512w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/icono-1-150x150.png 150w\" sizes=\"auto, (max-width: 25px) 100vw, 25px\" \/> IMPORTAR DATOS<\/h3>\n<p>Una vez habilitado, sigue estos pasos para importar datos:<\/p>\n<ol>\n<li>Abre una nueva hoja de c\u00e1lculo en Excel.<\/li>\n<li>Haz clic en la pesta\u00f1a <strong>\u00abPower Pivot\u00bb<\/strong> que ahora deber\u00eda estar visible en la cinta de opciones.<\/li>\n<li>Selecciona <strong>\u00abAdministrar\u00bb<\/strong> para abrir la ventana de Power Pivot.<\/li>\n<li>En la ventana de Power Pivot, haz clic en <strong>\u00abObtener Datos Externos\u00bb<\/strong> y selecciona la fuente de datos que deseas importar (por ejemplo, base de datos, archivo CSV, etc.).<\/li>\n<li>Sigue los pasos del asistente para importar los datos.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-18777 size-full aligncenter\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/PV-2.png\" alt=\"Power Pivot en Excel\" width=\"1137\" height=\"766\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/PV-2.png 1137w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/PV-2-1000x674.png 1000w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/PV-2-768x517.png 768w\" sizes=\"auto, (max-width: 1137px) 100vw, 1137px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-18732\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/icono-2.png\" alt=\"\" width=\"25\" height=\"25\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/icono-2.png 512w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/icono-2-150x150.png 150w\" sizes=\"auto, (max-width: 25px) 100vw, 25px\" \/>\u00a0CREAR RELACIONES ENTRE TABLAS<\/h3>\n<p>Para aprovechar al m\u00e1ximo Power Pivot, es esencial crear relaciones entre las tablas importadas:<\/p>\n<p>Cuando seleccionas <b class=\"ocpLegacyBold\">Administrar<\/b>, aparece la ventana de\u00a0<b class=\"ocpLegacyBold\">Power Pivot<\/b>, que es donde puedes ver y administrar el modelo de datos, agregar c\u00e1lculos, establecer relaciones y ver los elementos de tu <i class=\"ocpItalic\">modelo de datos<\/i>\u00a0de Power Pivot. Un\u00a0<b class=\"ocpLegacyBold\">modelo de datos<\/b>\u00a0es una colecci\u00f3n de tablas o de cualquier otro dato, generalmente con relaciones establecidas entre ellos. La imagen siguiente muestra la\u00a0<b class=\"ocpLegacyBold\">ventana de Power Pivot<\/b>\u00a0con una tabla mostrada.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-18781 aligncenter\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/PV-6.png\" alt=\"power pivot en excel\" width=\"782\" height=\"592\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/PV-6.png 782w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/PV-6-768x581.png 768w\" sizes=\"auto, (max-width: 782px) 100vw, 782px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-18728\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/icono-3.png\" alt=\"\" width=\"25\" height=\"25\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/icono-3.png 512w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/icono-3-150x150.png 150w\" sizes=\"auto, (max-width: 25px) 100vw, 25px\" \/> REPRESENTAR RELACIONES GRAFICAMENTE<\/h3>\n<ol>\n<li>En la ventana de Power Pivot, selecciona la pesta\u00f1a <strong>\u00abVista de Diagrama\u00bb\u00a0<\/strong><\/li>\n<li>Arrastra y suelta campos entre las tablas para crear relaciones. Por ejemplo, arrastra el campo de ID de cliente de una tabla a otra tabla que tambi\u00e9n contenga el campo de ID de cliente.<\/li>\n<li>Usa la barra de desplazamiento para cambiar el tama\u00f1o del diagrama para poder ver todos los objetos. Reorganiza las tablas arrastrando la barra de t\u00edtulo para que est\u00e9n visibles y colocadas una junto a la otra.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-18780 size-full aligncenter\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/PV-5.png\" alt=\"power pivot en excel\" width=\"815\" height=\"870\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/PV-5.png 815w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/PV-5-768x820.png 768w\" sizes=\"auto, (max-width: 815px) 100vw, 815px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-18730\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/icono-4.png\" alt=\"\" width=\"25\" height=\"25\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/icono-4.png 512w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/icono-4-150x150.png 150w\" sizes=\"auto, (max-width: 25px) 100vw, 25px\" \/> CREAR C\u00c1LCULOS Y MEDIDAS<\/h3>\n<p>Power Pivot permite crear c\u00e1lculos avanzados utilizando DAX (Data Analysis Expressions):<\/p>\n<ol>\n<li>Haz clic en la pesta\u00f1a <strong>\u00abHome\u00bb<\/strong> en la ventana de Power Pivot.<\/li>\n<li>Selecciona <strong>\u00abVista de Datos\u00bb<\/strong>.<\/li>\n<li>En la secci\u00f3n <strong>\u00abC\u00e1lculos\u00bb<\/strong>, selecciona <strong>\u00abNueva Medida\u00bb<\/strong>.<\/li>\n<li>Define tu medida utilizando f\u00f3rmulas DAX. DAX es un lenguaje de f\u00f3rmulas para Power Pivot y tablas din\u00e1micas, dise\u00f1ado para los datos relacionales y el an\u00e1lisis contextual disponibles en Power Pivot. Puedes crear f\u00f3rmulas de DAX en una nueva columna de Power Pivot y en el \u00e1rea de c\u00e1lculo de Power Pivot. Por ejemplo, puedes crear una nueva columna con la funci\u00f3n CONCATENAR que combina dos o m\u00e1s campos en uno solo.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-18782 size-full\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/PV-8.png\" alt=\"Power Pivot en Excel\" width=\"593\" height=\"654\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-18729\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/icono-5.png\" alt=\"\" width=\"25\" height=\"25\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/icono-5.png 512w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/icono-5-150x150.png 150w\" sizes=\"auto, (max-width: 25px) 100vw, 25px\" \/> INSERTAR TABLAS DIN\u00c1MICAS<\/h3>\n<p>Para visualizar tus datos:<\/p>\n<ol>\n<li>Regresa a la hoja de c\u00e1lculo principal de Excel.<\/li>\n<li>Haz clic en <strong>\u00abInsertar\u00bb<\/strong> y selecciona <strong>\u00abTabla Din\u00e1mica\u00bb<\/strong>.<\/li>\n<li>En el cuadro de di\u00e1logo, selecciona <strong>\u00abUsar un modelo de datos de este libro\u00bb<\/strong> y haz clic en <strong>\u00abAceptar\u00bb<\/strong>.<\/li>\n<li>Arrastra los campos desde el panel de Power Pivot a la tabla din\u00e1mica para crear tus informes y an\u00e1lisis.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-18783 aligncenter\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/PV-9.png\" alt=\"Power Pivot en Excel\" width=\"875\" height=\"720\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/PV-9.png 952w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/PV-9-768x632.png 768w\" sizes=\"auto, (max-width: 875px) 100vw, 875px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2>EJEMPLOS Y PR\u00c1CTICAS RECOMENDADAS<\/h2>\n<ul>\n<li><strong>An\u00e1lisis de Ventas<\/strong>: Crea una tabla din\u00e1mica que muestre las ventas por regi\u00f3n y producto.<\/li>\n<li><strong>Seguimiento de Inventario<\/strong>: Utiliza Power Pivot para monitorizar niveles de inventario y predecir la demanda futura.<\/li>\n<\/ul>\n<p><strong>\u00a0<\/strong><\/p>\n<h2>PREGUNTAS FRECUENTES (FAQ) SOBRE POWER PIVOT EN EXCEL<\/h2>\n<p><strong>1. \u00bfPower Pivot es lo mismo que una tabla din\u00e1mica?<\/strong><\/p>\n<ul>\n<li>No. Aunque ambos permiten analizar datos, Power Pivot es mucho m\u00e1s potente, ya que permite manejar millones de filas, crear modelos de datos y usar DAX para c\u00e1lculos avanzados.<\/li>\n<\/ul>\n<p><strong>2. \u00bfPuedo usar Power Pivot en Excel para Mac?<\/strong><\/p>\n<ul>\n<li>No, Power Pivot solo est\u00e1 disponible en Excel para Windows.<\/li>\n<\/ul>\n<p><strong>3. \u00bfPower Pivot es gratuito?<\/strong><\/p>\n<ul>\n<li>Depende de la versi\u00f3n de Excel. En Microsoft 365 y versiones profesionales de Excel, est\u00e1 incluido sin costo adicional.<\/li>\n<\/ul>\n<p><strong>4. \u00bfNecesito saber programaci\u00f3n para usar Power Pivot?<\/strong><\/p>\n<ul>\n<li>No es necesario, pero conocer DAX puede ayudarte a realizar an\u00e1lisis m\u00e1s avanzados.<\/li>\n<\/ul>\n<p><strong>5. \u00bfNecesito conocimientos previos para usar Power Pivot?<\/strong><\/p>\n<ul>\n<li>No se requieren conocimientos previos avanzados, pero es \u00fatil tener una comprensi\u00f3n b\u00e1sica de Excel y de c\u00f3mo funcionan las tablas din\u00e1micas.<\/li>\n<\/ul>\n<p><strong>6. \u00bfPower Pivot est\u00e1 disponible en todas las versiones de Excel?<\/strong><\/p>\n<ul>\n<li>No, est\u00e1 disponible en las versiones mencionadas anteriormente (Microsoft 365, Office 2021, Office 2019, etc.).<\/li>\n<\/ul>\n<p>\u00bfListo para comenzar? Power Pivot es una herramienta poderosa que puede transformar la forma en que manejas y analizas tus datos. Si tienes alguna pregunta adicional, no dudes en dec\u00edrmelo. \u00a1Estoy aqu\u00ed para ayudarte!<\/p>\n<p>&nbsp;<\/p>\n<h2>CONCLUSI\u00d3N<\/h2>\n<p><strong>Power Pivot en Excel<\/strong> es una herramienta poderosa que transforma la manera en que manejas datos. Con su capacidad para procesar grandes vol\u00famenes de informaci\u00f3n, crear modelos de datos y utilizar DAX, puedes mejorar significativamente tu an\u00e1lisis y reportes.<\/p>\n<p>Si a\u00fan no has probado Power Pivot en Excel, ahora es el momento de activarlo y descubrir todas las ventajas que ofrece para optimizar tu trabajo con datos.<\/p>\n<hr \/>\n<p><strong><span style=\"color: #136e42;\">\u00bb<\/span> Si te gustan nuestros blogs, comp\u00e1rtelo con tus amigos. Puedes seguirnos en <span style=\"color: #3366ff;\"><a style=\"color: #3366ff;\" href=\"https:\/\/www.facebook.com\/excelfull7\">Facebook<\/a><\/span> e <span style=\"color: #ff00ff;\"><a style=\"color: #ff00ff;\" href=\"https:\/\/www.instagram.com\/excelfull_oficial\/\">Instagram<\/a>.<\/span><\/strong><\/p>\n<p><strong><span style=\"color: #136e42;\">\u00bb<\/span> D\u00e9janos tu comentario al final de esta p\u00e1gina.<\/strong><\/p>\n<p><strong><span style=\"color: #136e42;\">\u00bb<\/span> Explora m\u00e1s sobre nosotros directo aqu\u00ed: <a href=\"https:\/\/excelfull.com\/\">Curso de Excel Online<\/a><\/strong><\/p>\n<hr \/>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Si trabajas con datos &#8230; <a title=\"POWER PIVOT: CONVIERTE EXCEL EN UN POTENTE MOTOR DE AN\u00c1LISIS\" class=\"read-more\" href=\"https:\/\/excelfull.com\/excel\/power-pivot-en-excel\/\" aria-label=\"Leer m\u00e1s sobre POWER PIVOT: CONVIERTE EXCEL EN UN POTENTE MOTOR DE AN\u00c1LISIS\">Leer m\u00e1s<\/a><\/p>\n","protected":false},"author":3,"featured_media":18786,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[328,539,1138],"tags":[1140,1139],"class_list":["post-18766","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-excel-avanzado","category-power-pivot","tag-dax","tag-power-pivot","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>POWER PIVOT EN EXCEL: INTRODUCCI\u00d3N PARA PRINCIPIANTES<\/title>\n<meta name=\"description\" content=\"Aprende qu\u00e9 es Power Pivot en Excel, para qu\u00e9 sirve y c\u00f3mo usarlo. Descubre sus funciones y optimiza tu an\u00e1lisis de datos f\u00e1cilmente.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/excelfull.com\/excel\/power-pivot-en-excel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"POWER PIVOT EN EXCEL: INTRODUCCI\u00d3N PARA PRINCIPIANTES\" \/>\n<meta property=\"og:description\" content=\"Aprende qu\u00e9 es Power Pivot en Excel, para qu\u00e9 sirve y c\u00f3mo usarlo. Descubre sus funciones y optimiza tu an\u00e1lisis de datos f\u00e1cilmente.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/excelfull.com\/excel\/power-pivot-en-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog de Excelfull\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/excelfull7\" \/>\n<meta property=\"article:published_time\" content=\"2025-02-20T09:30:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-01T21:46:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/POWER-PIVOT-EN-EXCEL.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Excelfull\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Excelfull\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/excelfull.com\/excel\/power-pivot-en-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/power-pivot-en-excel\/\"},\"author\":{\"name\":\"Excelfull\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\"},\"headline\":\"POWER PIVOT: CONVIERTE EXCEL EN UN POTENTE MOTOR DE AN\u00c1LISIS\",\"datePublished\":\"2025-02-20T09:30:14+00:00\",\"dateModified\":\"2025-03-01T21:46:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/power-pivot-en-excel\/\"},\"wordCount\":1377,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/power-pivot-en-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/POWER-PIVOT-EN-EXCEL.png\",\"keywords\":[\"dax\",\"power pivot\"],\"articleSection\":[\"Excel\",\"Excel Avanzado\",\"Power Pivot\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/excelfull.com\/excel\/power-pivot-en-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/excelfull.com\/excel\/power-pivot-en-excel\/\",\"url\":\"https:\/\/excelfull.com\/excel\/power-pivot-en-excel\/\",\"name\":\"POWER PIVOT EN EXCEL: INTRODUCCI\u00d3N PARA PRINCIPIANTES\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/power-pivot-en-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/power-pivot-en-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/POWER-PIVOT-EN-EXCEL.png\",\"datePublished\":\"2025-02-20T09:30:14+00:00\",\"dateModified\":\"2025-03-01T21:46:16+00:00\",\"description\":\"Aprende qu\u00e9 es Power Pivot en Excel, para qu\u00e9 sirve y c\u00f3mo usarlo. Descubre sus funciones y optimiza tu an\u00e1lisis de datos f\u00e1cilmente.\",\"breadcrumb\":{\"@id\":\"https:\/\/excelfull.com\/excel\/power-pivot-en-excel\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/excelfull.com\/excel\/power-pivot-en-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/power-pivot-en-excel\/#primaryimage\",\"url\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/POWER-PIVOT-EN-EXCEL.png\",\"contentUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/POWER-PIVOT-EN-EXCEL.png\",\"width\":1280,\"height\":720,\"caption\":\"POWER PIVOT EN EXCEL\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/excelfull.com\/excel\/power-pivot-en-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Inicio\",\"item\":\"https:\/\/excelfull.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel\",\"item\":\"https:\/\/excelfull.com\/excel\/excel\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Excel Avanzado\",\"item\":\"https:\/\/excelfull.com\/excel\/excel\/curso-de-excel\/excel-avanzado\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Power Pivot\",\"item\":\"https:\/\/excelfull.com\/excel\/excel\/excel-avanzado\/power-pivot\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"POWER PIVOT: CONVIERTE EXCEL EN UN POTENTE MOTOR DE AN\u00c1LISIS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/excelfull.com\/excel\/#website\",\"url\":\"https:\/\/excelfull.com\/excel\/\",\"name\":\"Blog de Excelfull\",\"description\":\"Todo lo que necesitas saber sobre Excel\",\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"alternateName\":\"Blog Excel Online\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/excelfull.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\",\"name\":\"Nlog Excelfull\",\"alternateName\":\"Blog Excel En L\u00ednea\",\"url\":\"https:\/\/excelfull.com\/excel\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png\",\"contentUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png\",\"width\":1342,\"height\":341,\"caption\":\"Nlog Excelfull\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/excelfull7\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\",\"name\":\"Excelfull\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"caption\":\"Excelfull\"},\"url\":\"https:\/\/excelfull.com\/excel\/author\/ema\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"POWER PIVOT EN EXCEL: INTRODUCCI\u00d3N PARA PRINCIPIANTES","description":"Aprende qu\u00e9 es Power Pivot en Excel, para qu\u00e9 sirve y c\u00f3mo usarlo. Descubre sus funciones y optimiza tu an\u00e1lisis de datos f\u00e1cilmente.","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:\/\/excelfull.com\/excel\/power-pivot-en-excel\/","og_locale":"es_ES","og_type":"article","og_title":"POWER PIVOT EN EXCEL: INTRODUCCI\u00d3N PARA PRINCIPIANTES","og_description":"Aprende qu\u00e9 es Power Pivot en Excel, para qu\u00e9 sirve y c\u00f3mo usarlo. Descubre sus funciones y optimiza tu an\u00e1lisis de datos f\u00e1cilmente.","og_url":"https:\/\/excelfull.com\/excel\/power-pivot-en-excel\/","og_site_name":"Blog de Excelfull","article_publisher":"https:\/\/www.facebook.com\/excelfull7","article_published_time":"2025-02-20T09:30:14+00:00","article_modified_time":"2025-03-01T21:46:16+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/POWER-PIVOT-EN-EXCEL.png","type":"image\/png"}],"author":"Excelfull","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Excelfull","Tiempo de lectura":"10 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/excelfull.com\/excel\/power-pivot-en-excel\/#article","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/power-pivot-en-excel\/"},"author":{"name":"Excelfull","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801"},"headline":"POWER PIVOT: CONVIERTE EXCEL EN UN POTENTE MOTOR DE AN\u00c1LISIS","datePublished":"2025-02-20T09:30:14+00:00","dateModified":"2025-03-01T21:46:16+00:00","mainEntityOfPage":{"@id":"https:\/\/excelfull.com\/excel\/power-pivot-en-excel\/"},"wordCount":1377,"commentCount":0,"publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"image":{"@id":"https:\/\/excelfull.com\/excel\/power-pivot-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/POWER-PIVOT-EN-EXCEL.png","keywords":["dax","power pivot"],"articleSection":["Excel","Excel Avanzado","Power Pivot"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/excelfull.com\/excel\/power-pivot-en-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/excelfull.com\/excel\/power-pivot-en-excel\/","url":"https:\/\/excelfull.com\/excel\/power-pivot-en-excel\/","name":"POWER PIVOT EN EXCEL: INTRODUCCI\u00d3N PARA PRINCIPIANTES","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/excelfull.com\/excel\/power-pivot-en-excel\/#primaryimage"},"image":{"@id":"https:\/\/excelfull.com\/excel\/power-pivot-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/POWER-PIVOT-EN-EXCEL.png","datePublished":"2025-02-20T09:30:14+00:00","dateModified":"2025-03-01T21:46:16+00:00","description":"Aprende qu\u00e9 es Power Pivot en Excel, para qu\u00e9 sirve y c\u00f3mo usarlo. Descubre sus funciones y optimiza tu an\u00e1lisis de datos f\u00e1cilmente.","breadcrumb":{"@id":"https:\/\/excelfull.com\/excel\/power-pivot-en-excel\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/excelfull.com\/excel\/power-pivot-en-excel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/power-pivot-en-excel\/#primaryimage","url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/POWER-PIVOT-EN-EXCEL.png","contentUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2025\/02\/POWER-PIVOT-EN-EXCEL.png","width":1280,"height":720,"caption":"POWER PIVOT EN EXCEL"},{"@type":"BreadcrumbList","@id":"https:\/\/excelfull.com\/excel\/power-pivot-en-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Inicio","item":"https:\/\/excelfull.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel","item":"https:\/\/excelfull.com\/excel\/excel\/"},{"@type":"ListItem","position":3,"name":"Excel Avanzado","item":"https:\/\/excelfull.com\/excel\/excel\/curso-de-excel\/excel-avanzado\/"},{"@type":"ListItem","position":4,"name":"Power Pivot","item":"https:\/\/excelfull.com\/excel\/excel\/excel-avanzado\/power-pivot\/"},{"@type":"ListItem","position":5,"name":"POWER PIVOT: CONVIERTE EXCEL EN UN POTENTE MOTOR DE AN\u00c1LISIS"}]},{"@type":"WebSite","@id":"https:\/\/excelfull.com\/excel\/#website","url":"https:\/\/excelfull.com\/excel\/","name":"Blog de Excelfull","description":"Todo lo que necesitas saber sobre Excel","publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"alternateName":"Blog Excel Online","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/excelfull.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/excelfull.com\/excel\/#organization","name":"Nlog Excelfull","alternateName":"Blog Excel En L\u00ednea","url":"https:\/\/excelfull.com\/excel\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/","url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png","contentUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png","width":1342,"height":341,"caption":"Nlog Excelfull"},"image":{"@id":"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/excelfull7"]},{"@type":"Person","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801","name":"Excelfull","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","caption":"Excelfull"},"url":"https:\/\/excelfull.com\/excel\/author\/ema\/"}]}},"_links":{"self":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/18766","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/comments?post=18766"}],"version-history":[{"count":8,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/18766\/revisions"}],"predecessor-version":[{"id":18794,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/18766\/revisions\/18794"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media\/18786"}],"wp:attachment":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media?parent=18766"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/categories?post=18766"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/tags?post=18766"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}