{"id":22926,"date":"2024-10-23T12:30:00","date_gmt":"2024-10-23T17:30:00","guid":{"rendered":"https:\/\/dostinhurtado.com\/site\/?p=22926"},"modified":"2025-04-04T15:38:22","modified_gmt":"2025-04-04T20:38:22","slug":"como-crear-un-control-de-asistencia-dinamico-en-excel","status":"publish","type":"post","link":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/como-crear-un-control-de-asistencia-dinamico-en-excel\/","title":{"rendered":"Registro de asistencia din\u00e1mico en Excel"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\" id=\"h-registro-de-asistencia-dinamico-en-excel-paso-a-paso\">Registro de asistencia din\u00e1mico en Excel paso a paso<\/h1>\n\n\n\n<p>Llevar el control de asistencia en un archivo de Excel no tiene por qu\u00e9 ser complicado o limitado. En este tutorial aprender\u00e1s a crear un <strong>registro de asistencia din\u00e1mico en Excel<\/strong>, totalmente editable y compatible con cualquier versi\u00f3n del programa, incluyendo Excel Online o incluso Google Sheets.<\/p>\n\n\n\n<p>\u00bfLo mejor? Este archivo es gratuito y puedes descargarlo desde la descripci\u00f3n del video original. Aqu\u00ed te mostramos c\u00f3mo crearlo desde cero y adaptarlo a tus necesidades.<\/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=\"Registro de Asistencia Din\u00e1mico en Excel \ud83d\udcc5 GRATIS Paso a Paso  (Control de Asistencia)\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/yqvlcpYS_B4?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-19509f\"><div class=\"ultp-button-wrapper ultp-button-frontend ultp-anim-none\">\n<a class=\"wp-block-ultimate-post-button ultp-block-d93013 ultp-button-layout1\" href=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Control-de-Asistencia.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 registro de asistencia din\u00e1mico en Excel?<\/h2>\n\n\n\n<p>Se trata de una hoja de c\u00e1lculo personalizada que permite registrar, contar y visualizar asistencias, faltas, justificaciones y llamados de atenci\u00f3n de forma autom\u00e1tica y visual. Gracias al uso de f\u00f3rmulas, validaci\u00f3n de datos y formato condicional, puedes tener un control claro, est\u00e9tico y muy funcional.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-paso-1-estructura-basica-del-registro-de-asistencia-dinamico-en-excel\">Paso 1: Estructura b\u00e1sica del Registro de asistencia din\u00e1mico en Excel<\/h2>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img data-dominant-color=\"f0f0f0\" data-has-transparency=\"true\" fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"635\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-15-1024x635.avif\" alt=\"Tabla de Excel que muestra una estructura b\u00e1sica para un registro de asistencia din\u00e1mico, con columnas para el nombre y la asistencia diaria durante cuatro semanas.\" class=\"wp-image-25143 has-transparency\" style=\"--dominant-color: #f0f0f0; width:440px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-15-1024x635.avif 1024w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-15-300x186.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-15-768x477.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-15-600x372.avif 600w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-15-png.avif 1165w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Comienza por colocar los nombres de las personas y los d\u00edas de la semana en la parte superior: lunes, martes, mi\u00e9rcoles, etc. Luego, ajusta el ancho de las columnas (por ejemplo, a 3) para que el dise\u00f1o sea compacto y visualmente limpio.<\/p>\n\n\n\n<p>Si necesitas registrar solo algunos d\u00edas por semana (por ejemplo, en universidades), puedes personalizar f\u00e1cilmente las fechas en lugar de los d\u00edas.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Dise\u00f1o recomendado:<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Celdas peque\u00f1as y ordenadas<\/li>\n\n\n\n<li>T\u00edtulos como \u201cSemana 1\u201d, \u201cSemana 2\u201d\u2026 para organizar por mes<\/li>\n\n\n\n<li>Bordes y colores para una mejor visualizaci\u00f3n<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-paso-2-validacion-de-datos-para-evitar-errores-en-registro-de-asistencia-dinamico-en-excel\">Paso 2: Validaci\u00f3n de datos para evitar errores en Registro de asistencia din\u00e1mico en Excel<\/h2>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img data-dominant-color=\"e5e9eb\" data-has-transparency=\"true\" decoding=\"async\" width=\"1024\" height=\"658\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-14-1024x658.avif\" alt=\" Registro de asistencia din\u00e1mico en Excel con validaci\u00f3n de datos, mostrando la tabla con marcas de asistencia y la columna de nombres.\" class=\"wp-image-25142 has-transparency\" style=\"--dominant-color: #e5e9eb; width:456px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-14-1024x658.avif 1024w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-14-300x193.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-14-768x494.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-14-600x386.avif 600w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-14-png.avif 1139w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Una de las claves del registro de asistencia din\u00e1mico en Excel es evitar errores al ingresar datos. Para eso, se usa la <strong>validaci\u00f3n de datos<\/strong> con una lista personalizada que solo permite ciertos valores:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>X<\/strong>: Asistencia<\/li>\n\n\n\n<li><strong>F<\/strong>: Falta<\/li>\n\n\n\n<li><strong>J<\/strong>: Justificaci\u00f3n<\/li>\n\n\n\n<li><strong>A<\/strong>: Atenci\u00f3n<\/li>\n<\/ul>\n\n\n\n<p>As\u00ed, si alguien intenta escribir un valor no permitido, Excel lo bloquea autom\u00e1ticamente.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>\u00a1\ud83d\udea8 No te pierdas el<a href=\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/funciones-basicas\/\" target=\"_blank\" rel=\"noreferrer noopener\"> <strong>Cap\u00edtulo 4: FUNCIONES B\u00c1SICAS<\/strong><\/a> del curso de Excel! Si est\u00e1s comenzando o quieres reforzar tus conocimientos, este cap\u00edtulo es clave para dominar funciones esenciales como <strong>SUMA, PROMEDIO, MAX, MIN y SI<\/strong>, entre otras. \ud83d\udcca Aprender\u00e1s a aplicarlas de forma pr\u00e1ctica para automatizar tareas y ahorrar tiempo en tu trabajo o estudios. \u23f1\ufe0f<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Paso 3: Estad\u00edsticas autom\u00e1ticas por persona<\/h2>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img data-dominant-color=\"87a9bc\" data-has-transparency=\"true\" style=\"--dominant-color: #87a9bc;\" decoding=\"async\" width=\"1024\" height=\"81\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-16-1024x81.avif\" alt=\"\" class=\"wp-image-25144 has-transparency\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-16-1024x81.avif 1024w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-16-300x24.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-16-768x61.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-16-600x48.avif 600w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-16-png.avif 1420w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Con las f\u00f3rmulas adecuadas, puedes calcular autom\u00e1ticamente:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Cantidad de asistencias (<code>CONTARA<\/code> \u2013 Faltas)<\/li>\n\n\n\n<li>Faltas (<code>CONTAR.SI<\/code>)<\/li>\n\n\n\n<li>Justificaciones (<code>CONTAR.SI<\/code>)<\/li>\n\n\n\n<li>Llamados de atenci\u00f3n (<code>CONTAR.SI<\/code>)<\/li>\n\n\n\n<li>Porcentaje de asistencia<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img data-dominant-color=\"7fa3b8\" data-has-transparency=\"true\" style=\"--dominant-color: #7fa3b8;\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"75\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-17-1024x75.avif\" alt=\"\" class=\"wp-image-25145 has-transparency\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-17-1024x75.avif 1024w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-17-300x22.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-17-768x56.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-17-600x44.avif 600w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-17-png.avif 1416w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">F\u00f3rmula del porcentaje:<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img data-dominant-color=\"96b3c2\" data-has-transparency=\"true\" style=\"--dominant-color: #96b3c2;\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"64\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-19-1024x64.avif\" alt=\"\" class=\"wp-image-25147 has-transparency\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-19-1024x64.avif 1024w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-19-300x19.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-19-768x48.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-19-1536x96.avif 1536w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-19-600x38.avif 600w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-19-png.avif 1854w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>=SI.ERROR(Asistencias \/ (Asistencias + Faltas), 0)<br><\/code><\/pre>\n\n\n\n<p>Esto asegura que si no hay datos a\u00fan, el resultado ser\u00e1 cero en lugar de un error.<\/p>\n\n\n\n<p>\u00a1\ud83d\udea8 Atenci\u00f3n! Si al copiar f\u00f3rmulas en Excel tus resultados cambian y no sabes por qu\u00e9, necesitas ver el <strong><a href=\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/referencia-fija\/\" target=\"_blank\" rel=\"noreferrer noopener\">Tutorial de FIJAR REFERENCIA<\/a><\/strong>. En este video aprender\u00e1s a usar correctamente los signos de d\u00f3lar ($) para mantener celdas fijas al copiar f\u00f3rmulas. \ud83d\udccc Dominar este concepto es fundamental para trabajar con tablas, c\u00e1lculos y automatizaci\u00f3n sin errores.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-paso-4-colores-automaticos-con-formato-condicional-para-unregistro-de-asistencia-dinamico-en-excel\">Paso 4: Colores autom\u00e1ticos con formato condicional para unRegistro de asistencia din\u00e1mico en Excel<\/h2>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img data-dominant-color=\"90ac91\" data-has-transparency=\"true\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"408\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-18-1024x408.avif\" alt=\"\" class=\"wp-image-25146 has-transparency\" style=\"--dominant-color: #90ac91; width:668px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-18-1024x408.avif 1024w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-18-300x119.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-18-768x306.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-18-600x239.avif 600w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-18-png.avif 1366w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Para mejorar la visualizaci\u00f3n del registro, aplica <strong>formato condicional<\/strong> seg\u00fan el valor:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Verde para asistencias<\/li>\n\n\n\n<li>Rojo para faltas<\/li>\n\n\n\n<li>Azul oscuro para justificaciones<\/li>\n\n\n\n<li>Azul claro para atenciones<\/li>\n<\/ul>\n\n\n\n<p>Esto ayuda a identificar patrones r\u00e1pidamente y mejora la presentaci\u00f3n.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-paso-5-funciona-en-linea-y-desde-el-celular\">Paso 5: Funciona en l\u00ednea y desde el celular<\/h2>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img data-dominant-color=\"798777\" data-has-transparency=\"false\" loading=\"lazy\" decoding=\"async\" width=\"431\" height=\"919\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-20-png.avif\" alt=\"\" class=\"wp-image-25148 not-transparent\" style=\"--dominant-color: #798777; width:227px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-20-png.avif 431w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/image-20-141x300.avif 141w\" sizes=\"(max-width: 431px) 100vw, 431px\" \/><\/figure>\n\n\n\n<p>Una gran ventaja de este sistema es que puedes trabajar desde cualquier lugar. Al estar dise\u00f1ado con f\u00f3rmulas universales, es compatible con:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Excel Online<\/strong><\/li>\n\n\n\n<li><strong>Google Sheets<\/strong><\/li>\n\n\n\n<li><strong>Excel desde celular o tablet<\/strong><\/li>\n<\/ul>\n\n\n\n<p>\u00a1No sigas pagando de m\u00e1s por licencias de software! \ud83d\udcb8 En <strong><a href=\"https:\/\/www.keysfan.com\/spring-sale-dh.html?ksf=jddh\" target=\"_blank\" rel=\"noreferrer noopener\">Keysfan<\/a><\/strong> puedes conseguir <strong>Windows 11, Office 2021 y muchos otros programas<\/strong> a precios s\u00faper accesibles \ud83d\udcbb\ud83d\udd11 y con activaci\u00f3n 100% legal \u2705. Es la opci\u00f3n ideal si quieres ahorrar sin arriesgarte con copias piratas \u26a0\ufe0f. Adem\u00e1s, usando el <strong>c\u00f3digo de descuento DH66<\/strong> \ud83c\udff7\ufe0f obtienes a\u00fan m\u00e1s rebaja en tu compra. \u00a1Aprovecha esta oportunidad y actualiza tu PC como se debe! \ud83d\ude80\ud83d\udd25<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusi\u00f3n<\/h2>\n\n\n\n<p>Crear un <strong>registro de asistencia din\u00e1mico en Excel<\/strong> no solo es posible, sino que adem\u00e1s puede ser muy \u00fatil para profesores, empresas, universidades y cualquier organizaci\u00f3n que necesite llevar un control claro y automatizado. Este tipo de sistema es f\u00e1cil de adaptar, compatible con cualquier versi\u00f3n de Excel y completamente gratuito.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>\u00bf<strong>Te peleas con Excel cada vez que lo abres?<\/strong> \ud83d\ude29\ud83d\udcca No te preocupes, no est\u00e1s solo. Con este <strong><a href=\"https:\/\/dostinhurtado.com\/site\/Categoria\/cursos-gratis\/excel-curso-basico-intermedio\/\" target=\"_blank\" rel=\"noreferrer noopener\">Curso de Excel<\/a><\/strong> vas a aprender <strong>paso a paso<\/strong> y a tu ritmo, desde lo m\u00e1s b\u00e1sico hasta trucos que te van a facilitar la vida \ud83d\ude4c\ud83d\udca1. Es hora de que <strong>Excel trabaje para ti<\/strong>, y no al rev\u00e9s \ud83d\udcbb\u2705.<\/p>\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-67ad7896 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-0c31bc3e \" 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>\u00bfD\u00f3nde puedo descargar el archivo del registro de asistencia?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Puedes descargar el archivo desde la descripci\u00f3n del video en YouTube, donde se explica paso a paso c\u00f3mo usarlo.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-86dc7681 \" 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>\u00bfFunciona en Excel sin licencia?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>S\u00ed, puedes abrirlo en Excel Online o Google Sheets. Sin embargo, para usarlo en tu PC sin restricciones, puedes conseguir una licencia vitalicia con descuento usando el c\u00f3digo <strong>DH66<\/strong> en Keysfan.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-cbbccdc3 \" 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\">\u00bfPuedo cambiar los c\u00f3digos de asistencia?<\/span><\/div><div class=\"uagb-faq-content\"><p>Claro que s\u00ed. Puedes modificar las letras por cualquier otro texto (como \u00abS\u00bb por \u00abS\u00ed asisti\u00f3\u00bb) y las f\u00f3rmulas seguir\u00e1n funcionando autom\u00e1ticamente.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-5cb1fb32 \" 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 separar la hoja de asistencia y las estad\u00edsticas?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>S\u00ed. Puedes tener una hoja para ingresar datos y otra hoja separada para mostrar estad\u00edsticas y gr\u00e1ficos, sin afectar el funcionamiento.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-8da94c59 \" 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 puede usar el registro para varios cursos o grupos?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>S\u00ed. Puedes duplicar la hoja dentro del mismo archivo y renombrarla con el nombre de cada curso o grupo. As\u00ed tendr\u00e1s un registro separado para cada uno sin necesidad de crear archivos nuevos. Tambi\u00e9n puedes agregar una hoja resumen para ver las estad\u00edsticas generales de todos los grupos.<\/p><\/div><\/div><\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"h-\"><\/h3>\n","protected":false},"excerpt":{"rendered":"<p>Crea tu propio registro de asistencia din\u00e1mico en Excel con validaciones, estad\u00edsticas y colores. \u00a1compatible con todas las versiones!<\/p>\n","protected":false},"author":3,"featured_media":22931,"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":[225,344,365,2531],"class_list":["post-22926","post","type-post","status-publish","format-video","has-post-thumbnail","hentry","category-tutoriales-excel","tag-excel","tag-microsoft","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>Registro de asistencia din\u00e1mico en Excel - Dostin Hurtado<\/title>\n<meta name=\"description\" content=\"Crea tu propio registro de asistencia din\u00e1mico en Excel con validaciones, estad\u00edsticas y colores. \u00a1compatible con todas las versiones!\" \/>\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\/como-crear-un-control-de-asistencia-dinamico-en-excel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Registro de asistencia din\u00e1mico en Excel f\u00e1cil\" \/>\n<meta property=\"og:description\" content=\"Aprende a crear un registro de asistencia din\u00e1mico en Excel. Descarga gratis el archivo y mejora tu control de asistencia.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/como-crear-un-control-de-asistencia-dinamico-en-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Dostin Hurtado\" \/>\n<meta property=\"article:published_time\" content=\"2024-10-23T17:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-04T20:38:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Control-de-Asistencias-Dinamico-miniatura-04-jpg.avif\" \/>\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=\"Registro de asistencia din\u00e1mico en Excel gratuito\" \/>\n<meta name=\"twitter:description\" content=\"Aprende a crear un registro de asistencia din\u00e1mico en Excel. Descarga el archivo gratuito y personal\u00edzalo a tu gusto.\" \/>\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=\"6 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\\\/como-crear-un-control-de-asistencia-dinamico-en-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/como-crear-un-control-de-asistencia-dinamico-en-excel\\\/\"},\"author\":{\"name\":\"Dostin Hurtado\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/4cccf51633cffba81a46211a8ab89daa\"},\"headline\":\"Registro de asistencia din\u00e1mico en Excel\",\"datePublished\":\"2024-10-23T17:30:00+00:00\",\"dateModified\":\"2025-04-04T20:38:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/como-crear-un-control-de-asistencia-dinamico-en-excel\\\/\"},\"wordCount\":840,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/6bc1fbb1a73635ac2e186182146d04e9\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/como-crear-un-control-de-asistencia-dinamico-en-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Control-de-Asistencias-Dinamico-miniatura-04-jpg.avif\",\"keywords\":[\"Excel\",\"Microsoft\",\"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\\\/como-crear-un-control-de-asistencia-dinamico-en-excel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/como-crear-un-control-de-asistencia-dinamico-en-excel\\\/\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/como-crear-un-control-de-asistencia-dinamico-en-excel\\\/\",\"name\":\"Registro de asistencia din\u00e1mico en Excel - Dostin Hurtado\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/como-crear-un-control-de-asistencia-dinamico-en-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/como-crear-un-control-de-asistencia-dinamico-en-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Control-de-Asistencias-Dinamico-miniatura-04-jpg.avif\",\"datePublished\":\"2024-10-23T17:30:00+00:00\",\"dateModified\":\"2025-04-04T20:38:22+00:00\",\"description\":\"Crea tu propio registro de asistencia din\u00e1mico en Excel con validaciones, estad\u00edsticas y colores. \u00a1compatible con todas las versiones!\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/como-crear-un-control-de-asistencia-dinamico-en-excel\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/como-crear-un-control-de-asistencia-dinamico-en-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/como-crear-un-control-de-asistencia-dinamico-en-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Control-de-Asistencias-Dinamico-miniatura-04-jpg.avif\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Control-de-Asistencias-Dinamico-miniatura-04-jpg.avif\",\"width\":500,\"height\":375,\"caption\":\"Control de Asistencias Din\u00e1mico\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/como-crear-un-control-de-asistencia-dinamico-en-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Registro de asistencia din\u00e1mico 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\\\/4cccf51633cffba81a46211a8ab89daa\",\"name\":\"Dostin Hurtado\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/275749aad03534aea916e76323728243.jpg?ver=1780927217\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/275749aad03534aea916e76323728243.jpg?ver=1780927217\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/275749aad03534aea916e76323728243.jpg?ver=1780927217\",\"caption\":\"Dostin Hurtado\"},\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/author\\\/daniel\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Registro de asistencia din\u00e1mico en Excel - Dostin Hurtado","description":"Crea tu propio registro de asistencia din\u00e1mico en Excel con validaciones, estad\u00edsticas y colores. \u00a1compatible con todas las versiones!","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\/como-crear-un-control-de-asistencia-dinamico-en-excel\/","og_locale":"es_ES","og_type":"article","og_title":"Registro de asistencia din\u00e1mico en Excel f\u00e1cil","og_description":"Aprende a crear un registro de asistencia din\u00e1mico en Excel. Descarga gratis el archivo y mejora tu control de asistencia.","og_url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/como-crear-un-control-de-asistencia-dinamico-en-excel\/","og_site_name":"Dostin Hurtado","article_published_time":"2024-10-23T17:30:00+00:00","article_modified_time":"2025-04-04T20:38:22+00:00","og_image":[{"width":500,"height":375,"url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Control-de-Asistencias-Dinamico-miniatura-04-jpg.avif","type":"image\/jpeg"}],"author":"Dostin Hurtado","twitter_card":"summary_large_image","twitter_title":"Registro de asistencia din\u00e1mico en Excel gratuito","twitter_description":"Aprende a crear un registro de asistencia din\u00e1mico en Excel. Descarga el archivo gratuito y personal\u00edzalo a tu gusto.","twitter_misc":{"Escrito por":"Dostin Hurtado","Tiempo de lectura":"6 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/como-crear-un-control-de-asistencia-dinamico-en-excel\/#article","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/como-crear-un-control-de-asistencia-dinamico-en-excel\/"},"author":{"name":"Dostin Hurtado","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/4cccf51633cffba81a46211a8ab89daa"},"headline":"Registro de asistencia din\u00e1mico en Excel","datePublished":"2024-10-23T17:30:00+00:00","dateModified":"2025-04-04T20:38:22+00:00","mainEntityOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/como-crear-un-control-de-asistencia-dinamico-en-excel\/"},"wordCount":840,"commentCount":0,"publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/6bc1fbb1a73635ac2e186182146d04e9"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/como-crear-un-control-de-asistencia-dinamico-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Control-de-Asistencias-Dinamico-miniatura-04-jpg.avif","keywords":["Excel","Microsoft","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\/como-crear-un-control-de-asistencia-dinamico-en-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/como-crear-un-control-de-asistencia-dinamico-en-excel\/","url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/como-crear-un-control-de-asistencia-dinamico-en-excel\/","name":"Registro de asistencia din\u00e1mico en Excel - Dostin Hurtado","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/como-crear-un-control-de-asistencia-dinamico-en-excel\/#primaryimage"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/como-crear-un-control-de-asistencia-dinamico-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Control-de-Asistencias-Dinamico-miniatura-04-jpg.avif","datePublished":"2024-10-23T17:30:00+00:00","dateModified":"2025-04-04T20:38:22+00:00","description":"Crea tu propio registro de asistencia din\u00e1mico en Excel con validaciones, estad\u00edsticas y colores. \u00a1compatible con todas las versiones!","breadcrumb":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/como-crear-un-control-de-asistencia-dinamico-en-excel\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/como-crear-un-control-de-asistencia-dinamico-en-excel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/como-crear-un-control-de-asistencia-dinamico-en-excel\/#primaryimage","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Control-de-Asistencias-Dinamico-miniatura-04-jpg.avif","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Control-de-Asistencias-Dinamico-miniatura-04-jpg.avif","width":500,"height":375,"caption":"Control de Asistencias Din\u00e1mico"},{"@type":"BreadcrumbList","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/como-crear-un-control-de-asistencia-dinamico-en-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/dostinhurtado.com\/site\/"},{"@type":"ListItem","position":2,"name":"Registro de asistencia din\u00e1mico 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\/4cccf51633cffba81a46211a8ab89daa","name":"Dostin Hurtado","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/275749aad03534aea916e76323728243.jpg?ver=1780927217","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/275749aad03534aea916e76323728243.jpg?ver=1780927217","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/275749aad03534aea916e76323728243.jpg?ver=1780927217","caption":"Dostin Hurtado"},"url":"https:\/\/dostinhurtado.com\/site\/author\/daniel\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Control-de-Asistencias-Dinamico-miniatura-04-jpg.avif",500,375,false],"thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Control-de-Asistencias-Dinamico-miniatura-04-150x150.avif",150,150,true],"medium":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Control-de-Asistencias-Dinamico-miniatura-04-300x225.avif",300,225,true],"medium_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Control-de-Asistencias-Dinamico-miniatura-04-jpg.avif",500,375,false],"large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Control-de-Asistencias-Dinamico-miniatura-04-jpg.avif",500,375,false],"1536x1536":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Control-de-Asistencias-Dinamico-miniatura-04-jpg.avif",500,375,false],"2048x2048":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Control-de-Asistencias-Dinamico-miniatura-04-jpg.avif",500,375,false],"ultp_layout_landscape_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Control-de-Asistencias-Dinamico-miniatura-04-jpg.avif",500,375,false],"ultp_layout_landscape":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Control-de-Asistencias-Dinamico-miniatura-04-jpg.avif",500,375,false],"ultp_layout_portrait":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Control-de-Asistencias-Dinamico-miniatura-04-jpg.avif",500,375,false],"ultp_layout_square":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Control-de-Asistencias-Dinamico-miniatura-04-jpg.avif",500,375,false],"woocommerce_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Control-de-Asistencias-Dinamico-miniatura-04-400x375.avif",400,375,true],"woocommerce_single":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Control-de-Asistencias-Dinamico-miniatura-04-jpg.avif",500,375,false],"woocommerce_gallery_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Control-de-Asistencias-Dinamico-miniatura-04-100x100.avif",100,100,true]},"uagb_author_info":{"display_name":"Dostin Hurtado","author_link":"https:\/\/dostinhurtado.com\/site\/author\/daniel\/"},"uagb_comment_info":0,"uagb_excerpt":"Crea tu propio registro de asistencia din\u00e1mico en Excel con validaciones, estad\u00edsticas y colores. \u00a1compatible con todas las versiones!","_links":{"self":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/22926","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\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/comments?post=22926"}],"version-history":[{"count":2,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/22926\/revisions"}],"predecessor-version":[{"id":25149,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/22926\/revisions\/25149"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media\/22931"}],"wp:attachment":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media?parent=22926"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/categories?post=22926"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/tags?post=22926"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}