{"id":18386,"date":"2022-02-06T08:40:00","date_gmt":"2022-02-06T13:40:00","guid":{"rendered":"https:\/\/dostinhurtado.com\/site\/?p=18386"},"modified":"2026-01-13T10:40:44","modified_gmt":"2026-01-13T15:40:44","slug":"validacion-de-datos","status":"publish","type":"post","link":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/validacion-de-datos\/","title":{"rendered":"Validaci\u00f3n de datos"},"content":{"rendered":"<h2>VALIDACI\u00d3N DE DATOS<\/h2>\n<div class=\"ast-oembed-container \" style=\"height: 100%;\"><iframe title=\"Nuevo Curso de Excel - Cap\u00edtulo 9, Validaci\u00f3n de Datos \ud83c\udf93 Dostin Hurtado\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/DoGKgI1z4pY?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><\/div>\n<h2>DESCRIPCI\u00d3N<\/h2>\n<p>Hoy aprender\u00e1n a usar la validaci\u00f3n de datos en Excel, esta nos sirve para limitar o restringir los datos que puedan ingresar a Excel, as\u00ed tendremos Listas o cuadros combinados, limitaciones de n\u00fameros enteros, decimales, cantidad de caracteres, fechas e incluso validaciones personalizadas como correos electr\u00f3nicos. La validaci\u00f3n de datos es una herramienta que deben utilizar en todos los documentos futuros que realicen, teniendo en cuenta que evitaremos el ingreso de datos mal ingresados a Excel.<\/p>\n<p>La validaci\u00f3n de datos es algo sencillo, pero les sugiero ver el v\u00eddeo completo para que conozcan todos los tipos de validaci\u00f3n que pueden usar, las opciones que les da y la formas de aplicarla, recuerden que si les gusto el v\u00eddeo pueden darle me gusta, dejar en los comentarios cualquier duda que tengan y compartir este v\u00eddeo a quien crean que pueda servirle \u00a1El conocimiento es para todos!<\/p>\n<p>Al final les he dejado una tarea donde podr\u00e1n poner a prueba todo el conocimiento que les he ense\u00f1ado, lo ideal es que la resuelvan ustedes mismo, pero si se les dificulta les he dejado aqu\u00ed mismo la soluci\u00f3n a la tarea.<\/p>\n<h5 style=\"text-align: center;\"><strong>DESCARGAR MATERIAL DE APOYO<\/strong><\/h5>\n<p><a href=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/05\/capitulo_9.xlsx\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/icono_directa.png\" alt=\"\" width=\"185\" height=\"47\" \/><\/a><\/p>\n<h2>TAREA RESUELTA<\/h2>\n<div class=\"ast-oembed-container \" style=\"height: 100%;\"><iframe title=\"Nuevo Curso de Excel - Cap\u00edtulo 9, Tarea \ud83c\udf93 Dostin Hurtado\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/a83pmrsvyRs?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><\/div>\n<h2>DESCRIPCI\u00d3N<\/h2>\n<p>He creado esta tarea con el fin de que puedan practicar lo aprendido en el cap\u00edtulo de validaci\u00f3n de datos del nuevo curso de Excel. Recomiendo siempre mirar estos videos, ya que adicionalmente explico algunos temas extras que en el cap\u00edtulo por cuestiones de tiempo no he alcanzado a aclarar.<\/p>\n<p>En esta tarea vamos a llenar un formulario de solicitud de cita y limitaremos las celdas con validaci\u00f3n de datos, no se salten el v\u00eddeo y m\u00edrenlo completo para comprender como se resuelve cada caso.<\/p>\n<p>La parte de \u00abProgramador\u00bb o \u00abDesarrollador\u00bb, son temas de \u00abExcel Avanzado\u00bb o las famosas Macros de Excel. Es un tema m\u00e1s avanzado y para este caso, solo hemos usado el control \u00abCheckBox\u00bb de manera visual.<\/p>\n<h5 style=\"text-align: center;\"><strong>DESCARGAR TAREA<\/strong><\/h5>\n<p><a href=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/05\/capitulo_9-tarea.xlsx\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/icono_directa.png\" alt=\"\" width=\"185\" height=\"47\" \/><\/a><\/p>\n<p><a role=\"button\" href=\"https:\/\/dostinhurtado.com\/site\/cursos\/excel-curso-basico-intermedio\/formato-condicional\/\"><br \/>\nCAP\u00cdTULO ANTERIOR<br \/>\n<\/a><br \/>\n<a role=\"button\" href=\"https:\/\/dostinhurtado.com\/site\/Categoria\/cursos\/excel-curso-basico-intermedio\/\"><br \/>\nLISTA DE CAP\u00cdTULOS<br \/>\n<\/a><br \/>\n<a role=\"button\" href=\"https:\/\/dostinhurtado.com\/site\/cursos\/\"><br \/>\nTODOS LOS CURSOS<br \/>\n<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hoy aprender\u00e1n a usar la validaci\u00f3n de datos en Excel, esta nos sirve para limitar o restringir los datos que puedan ingresar a Excel,  as\u00ed tendremos Listas o cuadros combinados, limitaciones de n\u00fameros enteros, decimales, cantidad de caracteres, fechas e incluso validaciones personalizadas como correos electr\u00f3nicos. La validaci\u00f3n de datos es una herramienta que deben utilizar en todos los documentos futuros que realicen, teniendo en cuenta que evitaremos el ingreso de datos mal ingresados a Excel.<\/p>\n","protected":false},"author":4,"featured_media":27279,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","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":[1714],"tags":[1805,1892,562,186,225,232,247,277,539,1769,570,486],"class_list":["post-18386","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-curso-basico-intermedio","tag-1805","tag-aprende-excel","tag-curso","tag-datos","tag-excel","tag-facil","tag-formato-condicional","tag-gratis","tag-gratuito","tag-nuevo-curso","tag-recomendado","tag-tutorial"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Validaci\u00f3n de datos - Dostin Hurtado<\/title>\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\/cursos-gratis\/excel-curso-basico-intermedio\/validacion-de-datos\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Validaci\u00f3n de datos - Dostin Hurtado\" \/>\n<meta property=\"og:description\" content=\"Hoy aprender\u00e1n a usar la validaci\u00f3n de datos en Excel, esta nos sirve para limitar o restringir los datos que puedan ingresar a Excel, as\u00ed tendremos Listas o cuadros combinados, limitaciones de n\u00fameros enteros, decimales, cantidad de caracteres, fechas e incluso validaciones personalizadas como correos electr\u00f3nicos. La validaci\u00f3n de datos es una herramienta que deben utilizar en todos los documentos futuros que realicen, teniendo en cuenta que evitaremos el ingreso de datos mal ingresados a Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/validacion-de-datos\/\" \/>\n<meta property=\"og:site_name\" content=\"Dostin Hurtado\" \/>\n<meta property=\"article:published_time\" content=\"2022-02-06T13:40:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-13T15:40:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-9.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: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=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-curso-basico-intermedio\\\/validacion-de-datos\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-curso-basico-intermedio\\\/validacion-de-datos\\\/\"},\"author\":{\"name\":\"Dostin Hurtado\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/95509baa94d6c69583eddaece41011cc\"},\"headline\":\"Validaci\u00f3n de datos\",\"datePublished\":\"2022-02-06T13:40:00+00:00\",\"dateModified\":\"2026-01-13T15:40:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-curso-basico-intermedio\\\/validacion-de-datos\\\/\"},\"wordCount\":368,\"commentCount\":12,\"publisher\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/6bc1fbb1a73635ac2e186182146d04e9\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-curso-basico-intermedio\\\/validacion-de-datos\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2026\\\/01\\\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-9.avif\",\"keywords\":[\"2022\",\"aprende excel\",\"Curso\",\"Datos\",\"Excel\",\"Facil\",\"Formato Condicional\",\"Gratis\",\"Gratuito\",\"nuevo curso\",\"recomendado\",\"Tutorial\"],\"articleSection\":[\"Nuevo Curso de Excel B\u00e1sico e Intermedio\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-curso-basico-intermedio\\\/validacion-de-datos\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-curso-basico-intermedio\\\/validacion-de-datos\\\/\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-curso-basico-intermedio\\\/validacion-de-datos\\\/\",\"name\":\"Validaci\u00f3n de datos - Dostin Hurtado\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-curso-basico-intermedio\\\/validacion-de-datos\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-curso-basico-intermedio\\\/validacion-de-datos\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2026\\\/01\\\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-9.avif\",\"datePublished\":\"2022-02-06T13:40:00+00:00\",\"dateModified\":\"2026-01-13T15:40:44+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-curso-basico-intermedio\\\/validacion-de-datos\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-curso-basico-intermedio\\\/validacion-de-datos\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-curso-basico-intermedio\\\/validacion-de-datos\\\/#primaryimage\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2026\\\/01\\\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-9.avif\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2026\\\/01\\\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-9.avif\",\"width\":500,\"height\":375,\"caption\":\"validaci\u00f3n de datos en Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-curso-basico-intermedio\\\/validacion-de-datos\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Validaci\u00f3n de datos\"}]},{\"@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=1780927217\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1780927217\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1780927217\",\"caption\":\"Dostin Hurtado\"},\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/author\\\/moderador\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Validaci\u00f3n de datos - Dostin Hurtado","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\/cursos-gratis\/excel-curso-basico-intermedio\/validacion-de-datos\/","og_locale":"es_ES","og_type":"article","og_title":"Validaci\u00f3n de datos - Dostin Hurtado","og_description":"Hoy aprender\u00e1n a usar la validaci\u00f3n de datos en Excel, esta nos sirve para limitar o restringir los datos que puedan ingresar a Excel, as\u00ed tendremos Listas o cuadros combinados, limitaciones de n\u00fameros enteros, decimales, cantidad de caracteres, fechas e incluso validaciones personalizadas como correos electr\u00f3nicos. La validaci\u00f3n de datos es una herramienta que deben utilizar en todos los documentos futuros que realicen, teniendo en cuenta que evitaremos el ingreso de datos mal ingresados a Excel.","og_url":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/validacion-de-datos\/","og_site_name":"Dostin Hurtado","article_published_time":"2022-02-06T13:40:00+00:00","article_modified_time":"2026-01-13T15:40:44+00:00","og_image":[{"width":500,"height":375,"url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-9.avif","type":"image\/jpeg"}],"author":"Dostin Hurtado","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Dostin Hurtado","Tiempo de lectura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/validacion-de-datos\/#article","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/validacion-de-datos\/"},"author":{"name":"Dostin Hurtado","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/95509baa94d6c69583eddaece41011cc"},"headline":"Validaci\u00f3n de datos","datePublished":"2022-02-06T13:40:00+00:00","dateModified":"2026-01-13T15:40:44+00:00","mainEntityOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/validacion-de-datos\/"},"wordCount":368,"commentCount":12,"publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/6bc1fbb1a73635ac2e186182146d04e9"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/validacion-de-datos\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-9.avif","keywords":["2022","aprende excel","Curso","Datos","Excel","Facil","Formato Condicional","Gratis","Gratuito","nuevo curso","recomendado","Tutorial"],"articleSection":["Nuevo Curso de Excel B\u00e1sico e Intermedio"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/validacion-de-datos\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/validacion-de-datos\/","url":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/validacion-de-datos\/","name":"Validaci\u00f3n de datos - Dostin Hurtado","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/validacion-de-datos\/#primaryimage"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/validacion-de-datos\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-9.avif","datePublished":"2022-02-06T13:40:00+00:00","dateModified":"2026-01-13T15:40:44+00:00","breadcrumb":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/validacion-de-datos\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/validacion-de-datos\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/validacion-de-datos\/#primaryimage","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-9.avif","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-9.avif","width":500,"height":375,"caption":"validaci\u00f3n de datos en Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-curso-basico-intermedio\/validacion-de-datos\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/dostinhurtado.com\/site\/"},{"@type":"ListItem","position":2,"name":"Validaci\u00f3n de datos"}]},{"@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=1780927217","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1780927217","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1780927217","caption":"Dostin Hurtado"},"url":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-9.avif",500,375,false],"thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-9-150x150.avif",150,150,true],"medium":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-9-300x225.avif",300,225,true],"medium_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-9.avif",500,375,false],"large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-9.avif",500,375,false],"1536x1536":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-9.avif",500,375,false],"2048x2048":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-9.avif",500,375,false],"ultp_layout_landscape_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-9.avif",500,375,false],"ultp_layout_landscape":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-9.avif",500,375,false],"ultp_layout_portrait":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-9.avif",500,375,false],"ultp_layout_square":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-9.avif",500,375,false],"woocommerce_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-9-400x375.avif",400,375,true],"woocommerce_single":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-9.avif",500,375,false],"woocommerce_gallery_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2026\/01\/Curso-de-Excel-2026_Mesa-de-trabajo-1-copia-9-100x100.avif",100,100,true]},"uagb_author_info":{"display_name":"Dostin Hurtado","author_link":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"},"uagb_comment_info":12,"uagb_excerpt":"Hoy aprender\u00e1n a usar la validaci\u00f3n de datos en Excel, esta nos sirve para limitar o restringir los datos que puedan ingresar a Excel, as\u00ed tendremos Listas o cuadros combinados, limitaciones de n\u00fameros enteros, decimales, cantidad de caracteres, fechas e incluso validaciones personalizadas como correos electr\u00f3nicos. La validaci\u00f3n de datos es una herramienta que deben&hellip;","_links":{"self":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/18386","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=18386"}],"version-history":[{"count":2,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/18386\/revisions"}],"predecessor-version":[{"id":27290,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/18386\/revisions\/27290"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media\/27279"}],"wp:attachment":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media?parent=18386"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/categories?post=18386"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/tags?post=18386"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}