{"id":7129,"date":"2018-04-26T00:00:49","date_gmt":"2018-04-26T05:00:49","guid":{"rendered":"https:\/\/dostinhurtado.com\/site\/?p=7129"},"modified":"2024-09-06T14:40:07","modified_gmt":"2024-09-06T19:40:07","slug":"excel-avanzado-capitulo-17","status":"publish","type":"post","link":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-17\/","title":{"rendered":"Excel Avanzado &#8211; Capitulo 17"},"content":{"rendered":"<h3 style=\"text-align: center;\"><span style=\"vertical-align: inherit;\"><span style=\"vertical-align: inherit;\">CICLO FOR &#8211; OCULTAR FILAS AUTOM\u00c1TICAMENTE<\/span><\/span><\/h3>\n<div class=\"ast-oembed-container \" style=\"height: 100%;\"><iframe title=\"Curso Excel Avanzado - Capitulo 17, Ciclo FOR - Ocultar filas Autom\u00e1ticamente\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/lv9ujKTn8nA?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<p>Con el ciclo For podremos repetir un c\u00f3digo (bucles) las veces que sea necesario y al aplicarlo en excel podemos navegar por las celdas e ir aplicando el c\u00f3digo que requieran. En este caso ocultaremos o mostraremos las filas que no tengan datos para mejorar el aspecto visual. Sin embargo, este ciclo lo podremos usar para cualquier tipo de ejercicio donde requieran hacer varias veces una tarea.<\/p>\n<p>En este ejercicio miraremos un sencillo ejemplo del uso FOR en conjunto con la condici\u00f3n IF que vimos en cap\u00edtulos pasados. Como ven es muy simple de usar y solo requiere practica para mejorar la l\u00f3gica aplicada.<\/p>\n<hr \/>\n<h5 style=\"text-align: center;\"><strong>DESCARGAR MATERIAL DE APOYO<\/strong><\/h5>\n<h6 style=\"text-align: center;\">Descarga el archivo que vemos en el v\u00eddeo desde los siguientes enlaces<\/h6>\n<p style=\"text-align: center;\"><a href=\"https:\/\/mega.nz\/#!i4YUlYpC!LpcGY-aXj9RTBNCF0Pi6sm9hy9es6Thc7798a8fPL5M\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"alignnone wp-image-3936 size-full\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/icono_mega.png\" alt=\"Descargar desde Mega\" width=\"185\" height=\"47\" \/><\/a>\u00a0<a href=\"https:\/\/www.mediafire.com\/file\/llfd3thbmml8bqv\/curso_excel_avanzado_capitulo_17.zip\/file\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"alignnone wp-image-3938 size-full\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/icono_mediafire.png\" alt=\"Descargar desde MediaFire\" width=\"185\" height=\"47\" \/><\/a><\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/dostinhurtado.com\/material_de_apoyo\/curso_excel_avanzado\/curso_excel_avanzado_capitulo_17.zip\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"aligncenter wp-image-3937 size-full\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/icono_directa.png\" alt=\"Descarga Directa\" width=\"185\" height=\"47\" \/><\/a><\/p>\n<h6 style=\"text-align: center;\"><strong><a href=\"https:\/\/mega.nz\/#!i4YUlYpC!LpcGY-aXj9RTBNCF0Pi6sm9hy9es6Thc7798a8fPL5M\" target=\"_blank\" rel=\"noopener noreferrer\">Mega<\/a> | <a href=\"https:\/\/www.mediafire.com\/file\/llfd3thbmml8bqv\/curso_excel_avanzado_capitulo_17.zip\/file\" target=\"_blank\" rel=\"noopener noreferrer\">MediaFire <\/a>| <a href=\"https:\/\/dostinhurtado.com\/material_de_apoyo\/curso_excel_avanzado\/curso_excel_avanzado_capitulo_17.zip\" target=\"_blank\" rel=\"noopener noreferrer\">Descarga Directa<\/a><\/strong><\/h6>\n<hr \/>\n<p style=\"text-align: center;\"><a class=\"btn btn-default\" href=\"https:\/\/dostinhurtado.com\/site\/cursos\/curso-excel-avanzado\/excel-avanzado-capitulo-16\/\">Capitulo Anterior<\/a>\u00a0<a class=\"btn btn-primary\" href=\"https:\/\/dostinhurtado.com\/site\/Categoria\/cursos\/curso-excel-avanzado\/\">Lista de Capitulos<\/a>\u00a0<a class=\"btn btn-default\" href=\"https:\/\/dostinhurtado.com\/site\/descargas\/microsoft-office\/\">Descargar Office<\/a><\/p>\n<hr \/>\n","protected":false},"excerpt":{"rendered":"<p>CICLO FOR &#8211; OCULTAR FILAS AUTOM\u00c1TICAMENTE Con el ciclo For podremos repetir un c\u00f3digo (bucles) las veces que sea necesario [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":7131,"comment_status":"open","ping_status":"open","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":[60],"tags":[225,226,331,365,492,506],"class_list":["post-7129","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-curso-excel-avanzado","tag-excel","tag-excel-avanzado","tag-macros","tag-office","tag-userform","tag-visual-basic"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.9 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Excel Avanzado - Capitulo 17 - 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\/curso-excel-avanzado\/excel-avanzado-capitulo-17\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Avanzado - Capitulo 17\" \/>\n<meta property=\"og:description\" content=\"CICLO FOR &#8211; OCULTAR FILAS AUTOM\u00c1TICAMENTE Con el ciclo For podremos repetir un c\u00f3digo (bucles) las veces que sea necesario [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-17\/\" \/>\n<meta property=\"og:site_name\" content=\"Dostin Hurtado\" \/>\n<meta property=\"article:published_time\" content=\"2018-04-26T05:00:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-06T19:40:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/05\/avanzado_17.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"376\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Dostin Hurtado\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter: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=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-17\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-17\\\/\"},\"author\":{\"name\":\"Dostin Hurtado\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/8ce550788514b771f2fd0ab59d1694f2\"},\"headline\":\"Excel Avanzado &#8211; Capitulo 17\",\"datePublished\":\"2018-04-26T05:00:49+00:00\",\"dateModified\":\"2024-09-06T19:40:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-17\\\/\"},\"wordCount\":154,\"commentCount\":7,\"publisher\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/19f7f0caccebab406700992c37c9583d\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-17\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2019\\\/05\\\/avanzado_17.jpg\",\"keywords\":[\"Excel\",\"Excel Avanzado\",\"Macros\",\"office\",\"userform\",\"Visual Basic\"],\"articleSection\":[\"Curso de Excel Avanzado\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-17\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-17\\\/\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-17\\\/\",\"name\":\"Excel Avanzado - Capitulo 17 - Dostin Hurtado\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-17\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-17\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2019\\\/05\\\/avanzado_17.jpg\",\"datePublished\":\"2018-04-26T05:00:49+00:00\",\"dateModified\":\"2024-09-06T19:40:07+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-17\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-17\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-17\\\/#primaryimage\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2019\\\/05\\\/avanzado_17.jpg\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2019\\\/05\\\/avanzado_17.jpg\",\"width\":500,\"height\":376,\"caption\":\"Ciclo For\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-17\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Avanzado &#8211; Capitulo 17\"}]},{\"@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\\\/19f7f0caccebab406700992c37c9583d\"},\"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\\\/19f7f0caccebab406700992c37c9583d\",\"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\\\/8ce550788514b771f2fd0ab59d1694f2\",\"name\":\"Dostin Hurtado\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1776088205\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1776088205\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1776088205\",\"caption\":\"Dostin Hurtado\"},\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/author\\\/moderador\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Excel Avanzado - Capitulo 17 - 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\/curso-excel-avanzado\/excel-avanzado-capitulo-17\/","og_locale":"es_ES","og_type":"article","og_title":"Excel Avanzado - Capitulo 17","og_description":"CICLO FOR &#8211; OCULTAR FILAS AUTOM\u00c1TICAMENTE Con el ciclo For podremos repetir un c\u00f3digo (bucles) las veces que sea necesario [&hellip;]","og_url":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-17\/","og_site_name":"Dostin Hurtado","article_published_time":"2018-04-26T05:00:49+00:00","article_modified_time":"2024-09-06T19:40:07+00:00","og_image":[{"width":500,"height":376,"url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/05\/avanzado_17.jpg","type":"image\/jpeg"}],"author":"Dostin Hurtado","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Dostin Hurtado","Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-17\/#article","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-17\/"},"author":{"name":"Dostin Hurtado","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/8ce550788514b771f2fd0ab59d1694f2"},"headline":"Excel Avanzado &#8211; Capitulo 17","datePublished":"2018-04-26T05:00:49+00:00","dateModified":"2024-09-06T19:40:07+00:00","mainEntityOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-17\/"},"wordCount":154,"commentCount":7,"publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-17\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/05\/avanzado_17.jpg","keywords":["Excel","Excel Avanzado","Macros","office","userform","Visual Basic"],"articleSection":["Curso de Excel Avanzado"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-17\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-17\/","url":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-17\/","name":"Excel Avanzado - Capitulo 17 - Dostin Hurtado","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-17\/#primaryimage"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-17\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/05\/avanzado_17.jpg","datePublished":"2018-04-26T05:00:49+00:00","dateModified":"2024-09-06T19:40:07+00:00","breadcrumb":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-17\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-17\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-17\/#primaryimage","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/05\/avanzado_17.jpg","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/05\/avanzado_17.jpg","width":500,"height":376,"caption":"Ciclo For"},{"@type":"BreadcrumbList","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-17\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/dostinhurtado.com\/site\/"},{"@type":"ListItem","position":2,"name":"Excel Avanzado &#8211; Capitulo 17"}]},{"@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\/19f7f0caccebab406700992c37c9583d"},"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\/19f7f0caccebab406700992c37c9583d","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\/8ce550788514b771f2fd0ab59d1694f2","name":"Dostin Hurtado","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1776088205","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1776088205","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1776088205","caption":"Dostin Hurtado"},"url":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/05\/avanzado_17.jpg",500,376,false],"thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/05\/avanzado_17-150x150.jpg",150,150,true],"medium":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/05\/avanzado_17-300x226.jpg",300,226,true],"medium_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/05\/avanzado_17.jpg",500,376,false],"large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/05\/avanzado_17.jpg",500,376,false],"1536x1536":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/05\/avanzado_17.jpg",500,376,false],"2048x2048":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/05\/avanzado_17.jpg",500,376,false],"ultp_layout_landscape_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/05\/avanzado_17.jpg",500,376,false],"ultp_layout_landscape":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/05\/avanzado_17.jpg",500,376,false],"ultp_layout_portrait":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/05\/avanzado_17.jpg",500,376,false],"ultp_layout_square":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/05\/avanzado_17.jpg",500,376,false],"woocommerce_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/05\/avanzado_17-400x376.jpg",400,376,true],"woocommerce_single":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/05\/avanzado_17.jpg",500,376,false],"woocommerce_gallery_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/05\/avanzado_17-100x100.jpg",100,100,true]},"uagb_author_info":{"display_name":"Dostin Hurtado","author_link":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"},"uagb_comment_info":7,"uagb_excerpt":"CICLO FOR &#8211; OCULTAR FILAS AUTOM\u00c1TICAMENTE Con el ciclo For podremos repetir un c\u00f3digo (bucles) las veces que sea necesario [&hellip;]","_links":{"self":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/7129","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=7129"}],"version-history":[{"count":0,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/7129\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media\/7131"}],"wp:attachment":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media?parent=7129"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/categories?post=7129"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/tags?post=7129"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}