{"id":20840,"date":"2023-12-15T12:30:00","date_gmt":"2023-12-15T17:30:00","guid":{"rendered":"https:\/\/dostinhurtado.com\/site\/?p=20840"},"modified":"2025-04-02T01:12:47","modified_gmt":"2025-04-02T06:12:47","slug":"crear-un-inventario-en-excel","status":"publish","type":"post","link":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/crear-un-inventario-en-excel\/","title":{"rendered":"Formulario de inventario en Excel"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\" id=\"h-formulario-de-inventario-en-excel-con-control-de-stock-automatico\">Formulario de Inventario en Excel con Control de Stock Autom\u00e1tico<\/h1>\n\n\n\n<p>\u00bfNecesitas llevar un control preciso de tu inventario pero te sientes abrumado? \u00a1No te preocupes m\u00e1s! Con este sencillo sistema que aprender\u00e1s a crear en Excel, podr\u00e1s gestionar las entradas y salidas de tus productos de forma autom\u00e1tica, optimizando tu tiempo y evitando errores. Olv\u00eddate de los c\u00e1lculos manuales y descubre c\u00f3mo un formulario de inventario en Excel puede transformar la manera en que administras tu stock.<\/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=\"Aprende a Crear un Inventario en Excel \u2705 Control de Stock (Entradas y Salidas)\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/GYlHvC_ESgU?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\" style=\"padding-top:var(--wp--preset--spacing--20);padding-bottom:var(--wp--preset--spacing--20)\">\n<h2 class=\"wp-block-heading has-text-align-center\" id=\"h-descargar-material-de-apoyo\">Descargar Material de Apoyo<\/h2>\n\n\n\n<p class=\"has-text-align-left\">\u00bfListo para poner en pr\u00e1ctica el tutorial? 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-dcc049\"><div class=\"ultp-button-wrapper ultp-button-frontend ultp-anim-none\">\n<a class=\"wp-block-ultimate-post-button ultp-block-625287 ultp-button-layout1\" href=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/Material-de-Apoyo.xlsx\" 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\">\u00bfC\u00f3mo Crear un Formulario de Inventario en Excel?<\/h2>\n\n\n\n<p><strong>La creaci\u00f3n<\/strong>\u00a0de un formulario de inventario efectivo\u00a0<strong>requiere<\/strong>\u00a0dos componentes clave:\u00a0<strong>por un lado<\/strong>, una estructura de datos bien organizada,\u00a0<strong>y por otro<\/strong>, el uso estrat\u00e9gico de funciones avanzadas\u00a0<strong>capaces de<\/strong>\u00a0gestionar c\u00e1lculos de entradas, salidas\u00a0<strong>y sobre todo<\/strong>, el stock disponible.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1. Configurar Tablas en Excel<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img data-dominant-color=\"dfe1e5\" data-has-transparency=\"true\" fetchpriority=\"high\" decoding=\"async\" width=\"566\" height=\"636\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/image-14-png.avif\" alt=\"\" class=\"wp-image-24629 has-transparency\" style=\"--dominant-color: #dfe1e5; width:331px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/image-14-png.avif 566w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/image-14-267x300.avif 267w\" sizes=\"(max-width: 566px) 100vw, 566px\" \/><\/figure>\n\n\n\n<p>Antes de comenzar con las funciones, es importante convertir los datos en tablas para facilitar los c\u00e1lculos:<\/p>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li>Selecciona los datos de tu inventario.<\/li>\n\n\n\n<li>Presiona <code>Ctrl + T<\/code> para convertirlos en una tabla.<\/li>\n\n\n\n<li>Aseg\u00farate de marcar la opci\u00f3n \u00abLa tabla tiene encabezados\u00bb.<\/li>\n\n\n\n<li>Renombra las tablas de la siguiente manera:\n<ul class=\"wp-block-list\">\n<li><strong>Inventario<\/strong>: Contiene la informaci\u00f3n de los productos.<\/li>\n\n\n\n<li><strong>Entradas<\/strong>: Registra las cantidades ingresadas al inventario.<\/li>\n\n\n\n<li><strong>Salidas<\/strong>: Registra las cantidades vendidas o retiradas.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">Uso de Funciones en Excel para Automatizar el Inventario<\/h2>\n\n\n\n<p>Una vez creadas las tablas, utilizaremos funciones avanzadas para automatizar el control de stock.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2. Buscar Productos con BuscarV o BuscarX<\/h3>\n\n\n\n<p>Para traer la descripci\u00f3n del producto al ingresar un c\u00f3digo, usamos la funci\u00f3n <strong>BUSCARX<\/strong> (si usas Excel 2021 o superior) o <strong>BUSCARV<\/strong> (para versiones anteriores).<\/p>\n\n\n\n<p><strong>Ejemplo con BUSCARX:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-dominant-color=\"a5afa2\" data-has-transparency=\"true\" style=\"--dominant-color: #a5afa2;\" decoding=\"async\" width=\"567\" height=\"85\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/image-15-png.avif\" alt=\"F\u00f3rmula BUSCARX en Excel para buscar el nombre de un producto en un formulario de inventario.\" class=\"wp-image-24633 has-transparency\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/image-15-png.avif 567w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/image-15-300x45.avif 300w\" sizes=\"(max-width: 567px) 100vw, 567px\" \/><figcaption class=\"wp-element-caption\">Uso de la funci\u00f3n BUSCARX para buscar nombres de productos en un formulario de inventario.<\/figcaption><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>=BUSCARX(A2, Inventario&#91;C\u00f3digo], Inventario&#91;Nombre], \"No existe\")<\/code><\/pre>\n\n\n\n<p><strong>Ejemplo con BUSCARV:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-dominant-color=\"b2917a\" data-has-transparency=\"true\" style=\"--dominant-color: #b2917a;\" decoding=\"async\" width=\"406\" height=\"130\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/image-16-png.avif\" alt=\"\" class=\"wp-image-24634 has-transparency\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/image-16-png.avif 406w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/image-16-300x96.avif 300w\" sizes=\"(max-width: 406px) 100vw, 406px\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>=BUSCARV(A2, Inventario, 2, FALSO)<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">3. Calcular Entradas y Salidas Autom\u00e1ticamente<\/h3>\n\n\n\n<p>Para calcular el total de entradas y salidas de cada producto, utilizaremos la funci\u00f3n <strong>SUMAR.SI<\/strong>:<\/p>\n\n\n\n<p><strong>Entradas:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-dominant-color=\"a7b1c0\" data-has-transparency=\"true\" style=\"--dominant-color: #a7b1c0;\" loading=\"lazy\" decoding=\"async\" width=\"924\" height=\"56\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/image-17-png.avif\" alt=\"\" class=\"wp-image-24635 has-transparency\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/image-17-png.avif 924w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/image-17-300x18.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/image-17-768x47.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/image-17-600x36.avif 600w\" sizes=\"(max-width: 924px) 100vw, 924px\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>=SUMAR.SI(Entradas&#91;C\u00f3digo], A2, Entradas&#91;Cantidad])<\/code><\/pre>\n\n\n\n<p><strong>Salidas:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-dominant-color=\"9da9b9\" data-has-transparency=\"true\" style=\"--dominant-color: #9da9b9;\" loading=\"lazy\" decoding=\"async\" width=\"922\" height=\"48\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/image-18-png.avif\" alt=\"\" class=\"wp-image-24636 has-transparency\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/image-18-png.avif 922w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/image-18-300x16.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/image-18-768x40.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/image-18-600x31.avif 600w\" sizes=\"(max-width: 922px) 100vw, 922px\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>=SUMAR.SI(Salidas&#91;C\u00f3digo], A2, Salidas&#91;Cantidad])<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Validaci\u00f3n de Datos y Formato Condicional en el Formulario de Inventario en Excel<\/h2>\n\n\n\n<p>Para mejorar la fiabilidad del formulario de inventario en Excel, aplicamos validaciones y formato condicional:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Evitar c\u00f3digos duplicados:<\/strong>\n<ol start=\"1\" class=\"wp-block-list\">\n<li>Selecciona la columna de c\u00f3digos.<\/li>\n\n\n\n<li>Ve a \u00abFormato condicional\u00bb > \u00abResaltar valores duplicados\u00bb.<\/li>\n<\/ol>\n<\/li>\n\n\n\n<li><strong>Resaltar stock negativo:<\/strong>\n<ol start=\"1\" class=\"wp-block-list\">\n<li>Selecciona la columna de stock.<\/li>\n\n\n\n<li>Aplica una regla de formato condicional para que los valores negativos se resalten en rojo.<\/li>\n<\/ol>\n<\/li>\n<\/ul>\n\n\n\n<p>\u26a0\ufe0f \u00a1No m\u00e1s errores en tus hojas de c\u00e1lculo! Con el <strong><a href=\"https:\/\/dostinhurtado.com\/site\/cursos\/excel-curso-basico-intermedio\/validacion-de-datos\/\" target=\"_blank\" rel=\"noreferrer noopener\">Cap\u00edtulo 9 del curso de Excel<\/a><\/strong>, aprender\u00e1s a aplicar <strong>validaci\u00f3n de datos<\/strong> de forma sencilla. As\u00ed, podr\u00e1s crear listas desplegables, establecer restricciones y definir reglas personalizadas para mantener tu informaci\u00f3n siempre precisa y ordenada. \ud83d\udcca\u2705<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Ventajas de Usar un Formulario de Inventario en Excel<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Elimina errores:<\/strong>\u00a0Al automatizar los c\u00e1lculos de stock,\u00a0<strong>evitas<\/strong>\u00a0discrepancias manuales.<\/li>\n\n\n\n<li><strong>Accesible:<\/strong>\u00a0<strong>Pese a<\/strong>\u00a0su potencia, mantiene una interfaz sencilla\u00a0<strong>que<\/strong>\u00a0cualquier usuario puede dominar r\u00e1pidamente.<\/li>\n\n\n\n<li><strong>Personalizable:<\/strong>\u00a0<strong>Si bien<\/strong>\u00a0viene configurado por defecto,\u00a0<strong>podr\u00e1s<\/strong>\u00a0ajustar campos y f\u00f3rmulas\u00a0<strong>conforme<\/strong>\u00a0tus necesidades cambien.\u00bb<\/li>\n<\/ul>\n\n\n\n<p>\u00a1\ud83d\ude80 Aprende Excel de una vez por todas y lleva tus habilidades al siguiente nivel! \ud83d\udcca Si quieres dominar desde lo b\u00e1sico hasta funciones avanzadas, un curso de Excel es la mejor inversi\u00f3n en tu productividad. \u23f3 No pierdas m\u00e1s tiempo haciendo c\u00e1lculos manuales o buscando soluciones en internet. \ud83d\udca1 Inscr\u00edbete ahora y convi\u00e9rtete en un experto en Excel. \u00a1Tu futuro te lo agradecer\u00e1! \ud83c\udfaf<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusi\u00f3n<\/h2>\n\n\n\n<p>Un <strong>formulario de inventario en Excel<\/strong> bien estructurado permite llevar un control preciso de los productos en almac\u00e9n. Usando funciones como <strong>BUSCARX, BUSCARV y SUMAR.SI<\/strong>, podemos automatizar el proceso y minimizar errores.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udd25 \u00a1Consigue Windows y Office al mejor precio! \ud83d\udd25<\/h3>\n\n\n\n<p>\u00a1No gastes de m\u00e1s en licencias de software! En <strong><a href=\"https:\/\/www.keysfan.com\/spring-sale-dh.html?ksf=jddh\">Keysfan<\/a><\/strong>, puedes conseguir claves 100 % originales para Windows y Office a precios incre\u00edblemente bajos. Adem\u00e1s, si usas el c\u00f3digo de descuento <strong>DH66<\/strong>, obtendr\u00e1s un precio a\u00fan mejor. No dejes pasar esta oportunidad y consigue tu licencia al mejor precio hoy mismo.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-donde-puedo-obtener-una\">\u00bfD\u00f3nde puedo obtener una <\/h3>\n\n\n\n<h2 class=\"wp-block-heading\">Preguntas Frecuentes (FAQ)<\/h2>\n\n\n<div class=\"wp-block-uagb-faq uagb-faq__outer-wrap uagb-block-d363a738 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-7fe13d72 \" 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>\u00bfNecesito una versi\u00f3n especial de Excel para hacer esto?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud Puedes usar cualquier versi\u00f3n de Excel, pero algunas funciones como <strong>BUSCARX<\/strong> solo est\u00e1n disponibles en Excel 2021 o Microsoft 365.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-56eb504b \" 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 evitar que se repitan c\u00f3digos en el inventario?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Puedes aplicar \u00abValidaci\u00f3n de Datos\u00bb en la columna de c\u00f3digos para evitar duplicados.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-ab44076e \" 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 automatizar el c\u00e1lculo de stock en mi formulario de inventario en Excel?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>S\u00ed, puedes usar funciones como <strong>SUMAR.SI<\/strong> o <strong>BUSCARX<\/strong> para que Excel calcule autom\u00e1ticamente el stock disponible bas\u00e1ndose en las entradas y salidas de productos.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-da7aa3e2 \" 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 evitar que se repitan c\u00f3digos de producto en el formulario de inventario en Excel?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Puedes usar la herramienta de <strong>Validaci\u00f3n de datos<\/strong> en Excel para restringir valores duplicados en la columna de c\u00f3digos y asegurarte de que cada producto tenga un identificador \u00fanico.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-6e920bf9 \" 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>\u00bfEs posible integrar un formulario de inventario en Excel con otras herramientas?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>S\u00ed, puedes conectar Excel con bases de datos externas, Power BI o incluso Google Sheets para gestionar el inventario de manera m\u00e1s eficiente y en tiempo real.<\/p><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Crea un formulario de inventario en Excel con entradas y salidas autom\u00e1ticas. Aprende trucos y funciones clave para optimizarlo.<\/p>\n","protected":false},"author":4,"featured_media":20841,"comment_status":"open","ping_status":"closed","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":[562,225,2529,530,365,2531],"class_list":["post-20840","post","type-post","status-publish","format-video","has-post-thumbnail","hentry","category-tutoriales-excel","tag-curso","tag-excel","tag-excel-para-principiantes","tag-hoja-de-calculo","tag-office","tag-tutorial-de-excel","post_format-post-format-video"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Formulario de inventario en Excel - Dostin Hurtado<\/title>\n<meta name=\"description\" content=\"Crea un formulario de inventario en Excel con entradas y salidas autom\u00e1ticas. Aprende trucos y funciones clave para optimizarlo.\" \/>\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\/crear-un-inventario-en-excel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Formulario de inventario en Excel para principiantes\" \/>\n<meta property=\"og:description\" content=\"Aprende a crear un formulario de inventario en Excel y controla tus entradas y salidas de productos f\u00e1cilmente.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/crear-un-inventario-en-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Dostin Hurtado\" \/>\n<meta property=\"article:published_time\" content=\"2023-12-15T17:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-02T06:12:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/miniatura-inventario-en-Excel-11.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"375\" \/>\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=\"Formulario de inventario en Excel: Gu\u00eda completa\" \/>\n<meta name=\"twitter:description\" content=\"Aprende a crear un formulario de inventario en Excel y lleva el control de tu stock de manera eficiente y sencilla.\" \/>\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\\\/crear-un-inventario-en-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/crear-un-inventario-en-excel\\\/\"},\"author\":{\"name\":\"Dostin Hurtado\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/95509baa94d6c69583eddaece41011cc\"},\"headline\":\"Formulario de inventario en Excel\",\"datePublished\":\"2023-12-15T17:30:00+00:00\",\"dateModified\":\"2025-04-02T06:12:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/crear-un-inventario-en-excel\\\/\"},\"wordCount\":702,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/6bc1fbb1a73635ac2e186182146d04e9\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/crear-un-inventario-en-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/miniatura-inventario-en-Excel-11.jpg\",\"keywords\":[\"Curso\",\"Excel\",\"excel para principiantes\",\"Hoja de Calculo\",\"office\",\"tutorial de excel\"],\"articleSection\":[\"Tutoriales de Excel\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/crear-un-inventario-en-excel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/crear-un-inventario-en-excel\\\/\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/crear-un-inventario-en-excel\\\/\",\"name\":\"Formulario de inventario en Excel - Dostin Hurtado\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/crear-un-inventario-en-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/crear-un-inventario-en-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/miniatura-inventario-en-Excel-11.jpg\",\"datePublished\":\"2023-12-15T17:30:00+00:00\",\"dateModified\":\"2025-04-02T06:12:47+00:00\",\"description\":\"Crea un formulario de inventario en Excel con entradas y salidas autom\u00e1ticas. Aprende trucos y funciones clave para optimizarlo.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/crear-un-inventario-en-excel\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/crear-un-inventario-en-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/crear-un-inventario-en-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/miniatura-inventario-en-Excel-11.jpg\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/miniatura-inventario-en-Excel-11.jpg\",\"width\":500,\"height\":375,\"caption\":\"Inventario en Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/crear-un-inventario-en-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Formulario de inventario 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=1780322344\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1780322344\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1780322344\",\"caption\":\"Dostin Hurtado\"},\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/author\\\/moderador\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Formulario de inventario en Excel - Dostin Hurtado","description":"Crea un formulario de inventario en Excel con entradas y salidas autom\u00e1ticas. Aprende trucos y funciones clave para optimizarlo.","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\/crear-un-inventario-en-excel\/","og_locale":"es_ES","og_type":"article","og_title":"Formulario de inventario en Excel para principiantes","og_description":"Aprende a crear un formulario de inventario en Excel y controla tus entradas y salidas de productos f\u00e1cilmente.","og_url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/crear-un-inventario-en-excel\/","og_site_name":"Dostin Hurtado","article_published_time":"2023-12-15T17:30:00+00:00","article_modified_time":"2025-04-02T06:12:47+00:00","og_image":[{"width":500,"height":375,"url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/miniatura-inventario-en-Excel-11.jpg","type":"image\/jpeg"}],"author":"Dostin Hurtado","twitter_card":"summary_large_image","twitter_title":"Formulario de inventario en Excel: Gu\u00eda completa","twitter_description":"Aprende a crear un formulario de inventario en Excel y lleva el control de tu stock de manera eficiente y sencilla.","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\/crear-un-inventario-en-excel\/#article","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/crear-un-inventario-en-excel\/"},"author":{"name":"Dostin Hurtado","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/95509baa94d6c69583eddaece41011cc"},"headline":"Formulario de inventario en Excel","datePublished":"2023-12-15T17:30:00+00:00","dateModified":"2025-04-02T06:12:47+00:00","mainEntityOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/crear-un-inventario-en-excel\/"},"wordCount":702,"commentCount":0,"publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/6bc1fbb1a73635ac2e186182146d04e9"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/crear-un-inventario-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/miniatura-inventario-en-Excel-11.jpg","keywords":["Curso","Excel","excel para principiantes","Hoja de Calculo","office","tutorial de excel"],"articleSection":["Tutoriales de Excel"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/crear-un-inventario-en-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/crear-un-inventario-en-excel\/","url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/crear-un-inventario-en-excel\/","name":"Formulario de inventario en Excel - Dostin Hurtado","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/crear-un-inventario-en-excel\/#primaryimage"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/crear-un-inventario-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/miniatura-inventario-en-Excel-11.jpg","datePublished":"2023-12-15T17:30:00+00:00","dateModified":"2025-04-02T06:12:47+00:00","description":"Crea un formulario de inventario en Excel con entradas y salidas autom\u00e1ticas. Aprende trucos y funciones clave para optimizarlo.","breadcrumb":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/crear-un-inventario-en-excel\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/crear-un-inventario-en-excel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/crear-un-inventario-en-excel\/#primaryimage","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/miniatura-inventario-en-Excel-11.jpg","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/miniatura-inventario-en-Excel-11.jpg","width":500,"height":375,"caption":"Inventario en Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/crear-un-inventario-en-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/dostinhurtado.com\/site\/"},{"@type":"ListItem","position":2,"name":"Formulario de inventario 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=1780322344","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1780322344","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1780322344","caption":"Dostin Hurtado"},"url":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/miniatura-inventario-en-Excel-11.jpg",500,375,false],"thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/miniatura-inventario-en-Excel-11-150x150.jpg",150,150,true],"medium":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/miniatura-inventario-en-Excel-11-300x225.jpg",300,225,true],"medium_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/miniatura-inventario-en-Excel-11.jpg",500,375,false],"large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/miniatura-inventario-en-Excel-11.jpg",500,375,false],"1536x1536":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/miniatura-inventario-en-Excel-11.jpg",500,375,false],"2048x2048":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/miniatura-inventario-en-Excel-11.jpg",500,375,false],"ultp_layout_landscape_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/miniatura-inventario-en-Excel-11.jpg",500,375,false],"ultp_layout_landscape":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/miniatura-inventario-en-Excel-11.jpg",500,375,false],"ultp_layout_portrait":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/miniatura-inventario-en-Excel-11.jpg",500,375,false],"ultp_layout_square":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/miniatura-inventario-en-Excel-11.jpg",500,375,false],"woocommerce_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/miniatura-inventario-en-Excel-11-400x375.jpg",400,375,true],"woocommerce_single":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/miniatura-inventario-en-Excel-11.jpg",500,375,false],"woocommerce_gallery_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/12\/miniatura-inventario-en-Excel-11-100x100.jpg",100,100,true]},"uagb_author_info":{"display_name":"Dostin Hurtado","author_link":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"},"uagb_comment_info":0,"uagb_excerpt":"Crea un formulario de inventario en Excel con entradas y salidas autom\u00e1ticas. Aprende trucos y funciones clave para optimizarlo.","_links":{"self":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/20840","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=20840"}],"version-history":[{"count":3,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/20840\/revisions"}],"predecessor-version":[{"id":24638,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/20840\/revisions\/24638"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media\/20841"}],"wp:attachment":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media?parent=20840"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/categories?post=20840"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/tags?post=20840"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}