{"id":4007,"date":"2018-04-26T05:00:21","date_gmt":"2018-04-26T10:00:21","guid":{"rendered":"https:\/\/dostinhurtado.com\/site\/?p=4007"},"modified":"2024-09-06T14:39:31","modified_gmt":"2024-09-06T19:39:31","slug":"excel-avanzado-capitulo-15","status":"publish","type":"post","link":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-15\/","title":{"rendered":"Excel Avanzado &#8211; Capitulo 15"},"content":{"rendered":"<h3 style=\"text-align: center;\"><span style=\"vertical-align: inherit;\"><span style=\"vertical-align: inherit;\">SELECT CASE (SWICH)<\/span><\/span><\/h3>\n<div class=\"ast-oembed-container \" style=\"height: 100%;\"><iframe title=\"Curso Excel Avanzado - Capitulo 15, Condicional Select Case (Swich)\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/BoWX0iFtqN4?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>Esta funci\u00f3n podemos clasificarla como una variaci\u00f3n de la condicional IF (funcion si), es necesaria y por cierto muy \u00fatil cuando se requiere hacer varias condiciones que si llegamos a realizarlo con solo IF aparte de demorarnos el c\u00f3digo ser\u00eda mucho m\u00e1s \u00abenredado\u00bb y complicado. La idea siempre es ser eficientes y esta funci\u00f3n est\u00e1 hecha para eso.<\/p>\n<p>Es imposible decirles con certeza en qu\u00e9 campo usarla, sin embargo s\u00ed puedo decirles cu\u00e1ndo usarla&#8230; en el cap\u00edtulo les doy un simple ejemplo de c\u00f3mo ser\u00eda realizar un trabajo con IF y otro con Select Case para que hagan sus propias comparaciones y decidan por cual usar.<\/p>\n<p><a href=\"https:\/\/goo.gl\/RsaZkN\">Esta es la P\u00e1gina de Ejemplo\u00a0que muestro en el video.<\/a><\/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\/#!2wIGWDzT!e-RPnuT3fjvxullxLgQfCZrg0XtQEJ7SPxgALLWXe8M\" 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=\"http:\/\/www.mediafire.com\/file\/4cxwe0y707elc2u\/curso_excel_avanzado_capitulo_15.zip\" 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_15.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\/#!2wIGWDzT!e-RPnuT3fjvxullxLgQfCZrg0XtQEJ7SPxgALLWXe8M\" target=\"_blank\" rel=\"noopener noreferrer\">Mega<\/a> | <a href=\"http:\/\/www.mediafire.com\/file\/4cxwe0y707elc2u\/curso_excel_avanzado_capitulo_15.zip\" target=\"_blank\" rel=\"noopener noreferrer\">MediaFire <\/a>| <a href=\"https:\/\/dostinhurtado.com\/material_de_apoyo\/curso_excel_avanzado\/curso_excel_avanzado_capitulo_15.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-14\/\">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\/cursos\/curso-excel-avanzado\/excel-avanzado-capitulo-16\/\">Capitulo Siguiente<\/a><\/p>\n<hr \/>\n","protected":false},"excerpt":{"rendered":"<p>SELECT CASE (SWICH) Esta funci\u00f3n podemos clasificarla como una variaci\u00f3n de la condicional IF (funcion si), es necesaria y por [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":4375,"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,260,264,267,331,365,492,494,506],"class_list":["post-4007","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-curso-excel-avanzado","tag-excel","tag-excel-avanzado","tag-funcion-if","tag-funcion-si","tag-funciones-condicionales","tag-macros","tag-office","tag-userform","tag-validaciones","tag-visual-basic"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Excel Avanzado - Capitulo 15 - 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-15\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Avanzado - Capitulo 15 - Dostin Hurtado\" \/>\n<meta property=\"og:description\" content=\"SELECT CASE (SWICH) Esta funci\u00f3n podemos clasificarla como una variaci\u00f3n de la condicional IF (funcion si), es necesaria y por [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-15\/\" \/>\n<meta property=\"og:site_name\" content=\"Dostin Hurtado\" \/>\n<meta property=\"article:published_time\" content=\"2018-04-26T10:00:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-06T19:39:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_15.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-15\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-15\\\/\"},\"author\":{\"name\":\"Dostin Hurtado\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/95509baa94d6c69583eddaece41011cc\"},\"headline\":\"Excel Avanzado &#8211; Capitulo 15\",\"datePublished\":\"2018-04-26T10:00:21+00:00\",\"dateModified\":\"2024-09-06T19:39:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-15\\\/\"},\"wordCount\":168,\"commentCount\":3,\"publisher\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/6bc1fbb1a73635ac2e186182146d04e9\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-15\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/avanzado_15.jpg\",\"keywords\":[\"Excel\",\"Excel Avanzado\",\"funcion if\",\"funcion si\",\"Funciones Condicionales\",\"Macros\",\"office\",\"userform\",\"Validaciones\",\"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-15\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-15\\\/\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-15\\\/\",\"name\":\"Excel Avanzado - Capitulo 15 - Dostin Hurtado\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-15\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-15\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/avanzado_15.jpg\",\"datePublished\":\"2018-04-26T10:00:21+00:00\",\"dateModified\":\"2024-09-06T19:39:31+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-15\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-15\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-15\\\/#primaryimage\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/avanzado_15.jpg\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/avanzado_15.jpg\",\"width\":500,\"height\":376,\"caption\":\"Curso de Excel Avanzado - Cap\u00edtulo 15\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/curso-excel-avanzado\\\/excel-avanzado-capitulo-15\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Avanzado &#8211; Capitulo 15\"}]},{\"@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":"Excel Avanzado - Capitulo 15 - 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-15\/","og_locale":"es_ES","og_type":"article","og_title":"Excel Avanzado - Capitulo 15 - Dostin Hurtado","og_description":"SELECT CASE (SWICH) Esta funci\u00f3n podemos clasificarla como una variaci\u00f3n de la condicional IF (funcion si), es necesaria y por [&hellip;]","og_url":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-15\/","og_site_name":"Dostin Hurtado","article_published_time":"2018-04-26T10:00:21+00:00","article_modified_time":"2024-09-06T19:39:31+00:00","og_image":[{"width":500,"height":376,"url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_15.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-15\/#article","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-15\/"},"author":{"name":"Dostin Hurtado","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/95509baa94d6c69583eddaece41011cc"},"headline":"Excel Avanzado &#8211; Capitulo 15","datePublished":"2018-04-26T10:00:21+00:00","dateModified":"2024-09-06T19:39:31+00:00","mainEntityOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-15\/"},"wordCount":168,"commentCount":3,"publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/6bc1fbb1a73635ac2e186182146d04e9"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-15\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_15.jpg","keywords":["Excel","Excel Avanzado","funcion if","funcion si","Funciones Condicionales","Macros","office","userform","Validaciones","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-15\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-15\/","url":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-15\/","name":"Excel Avanzado - Capitulo 15 - Dostin Hurtado","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-15\/#primaryimage"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-15\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_15.jpg","datePublished":"2018-04-26T10:00:21+00:00","dateModified":"2024-09-06T19:39:31+00:00","breadcrumb":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-15\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-15\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-15\/#primaryimage","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_15.jpg","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_15.jpg","width":500,"height":376,"caption":"Curso de Excel Avanzado - Cap\u00edtulo 15"},{"@type":"BreadcrumbList","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/curso-excel-avanzado\/excel-avanzado-capitulo-15\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/dostinhurtado.com\/site\/"},{"@type":"ListItem","position":2,"name":"Excel Avanzado &#8211; Capitulo 15"}]},{"@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\/2018\/04\/avanzado_15.jpg",500,376,false],"thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_15-150x150.jpg",150,150,true],"medium":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_15-300x226.jpg",300,226,true],"medium_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_15.jpg",500,376,false],"large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_15.jpg",500,376,false],"1536x1536":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_15.jpg",500,376,false],"2048x2048":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_15.jpg",500,376,false],"ultp_layout_landscape_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_15.jpg",500,376,false],"ultp_layout_landscape":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_15.jpg",500,376,false],"ultp_layout_portrait":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_15.jpg",500,376,false],"ultp_layout_square":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_15.jpg",500,376,false],"woocommerce_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_15-400x376.jpg",400,376,true],"woocommerce_single":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_15.jpg",500,376,false],"woocommerce_gallery_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/avanzado_15-100x100.jpg",100,100,true]},"uagb_author_info":{"display_name":"Dostin Hurtado","author_link":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"},"uagb_comment_info":3,"uagb_excerpt":"SELECT CASE (SWICH) Esta funci\u00f3n podemos clasificarla como una variaci\u00f3n de la condicional IF (funcion si), es necesaria y por [&hellip;]","_links":{"self":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/4007","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=4007"}],"version-history":[{"count":0,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/4007\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media\/4375"}],"wp:attachment":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media?parent=4007"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/categories?post=4007"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/tags?post=4007"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}