{"id":3859,"date":"2018-04-26T07:00:12","date_gmt":"2018-04-26T12:00:12","guid":{"rendered":"https:\/\/dostinhurtado.com\/site\/?p=3859"},"modified":"2024-09-06T14:39:28","modified_gmt":"2024-09-06T19:39:28","slug":"excel-capitulo-7","status":"publish","type":"post","link":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-basico-intermedio\/excel-capitulo-7\/","title":{"rendered":"Excel &#8211; Cap\u00edtulo 7"},"content":{"rendered":"<h3 style=\"text-align: center;\"><span style=\"vertical-align: inherit;\"><span style=\"vertical-align: inherit;\">LLAMADO DE DATOS (BuscarV)<\/span><\/span><\/h3>\n<div class=\"ast-oembed-container \" style=\"height: 100%;\"><iframe title=\"Curso Excel - Cap\u00edtulo 7, Funci\u00f3n BuscarV (Llamado de Datos - Audio Mejorado)\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/09d5OQ9yDXw?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>Aprende la funci\u00f3n BuscarV para el llamado de datos, esto es usado en casi todas las empresas, consiste en por ejemplo con el c\u00f3digo de barras de un producto obtener su nombre, precio, peso, tama\u00f1o, etc&#8230;, la funci\u00f3n solo se realiza una vez y luego basta con cambiar dicho c\u00f3digo para que busque de nuevo cualquier tipo de producto, persona o empresa.<\/p>\n<p>Es tema un poco mas \u00abavanzado\u00bb, este tema se titula Llamado de datos, por que en realidad lo que hace es eso, traer datos desde una base de datos a la tabla u hoja que desee.<\/p>\n<p>Recuerda que esta funci\u00f3n tambi\u00e9n trabaja con libros, osea puedes tener la base de datos en otro documento y aun as\u00ed funcionara de la misma manera.<\/p>\n<p><strong>NOTA IMPORTANTE:<\/strong><\/p>\n<ul>\n<li>Algunas versiones 2010 el nombre\u00a0<strong>BuscarV<\/strong>\u00a0cambia por\u00a0<strong>CONSULTAV<\/strong>.<\/li>\n<li>Si no funciona su\u00a0<strong>tecla F4<\/strong>, h\u00e1galo manual. Ej: A1 = $A$1<\/li>\n<li>Si tiene dudas sobre Fijar Celdas (Referencia Fija) <a href=\"#\"><strong>Mira este tutorial.<\/strong><\/a><\/li>\n<\/ul>\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\/#!r1pHnLbJ!vZ4_JDAfyiSByw85x8D1cwQZgGCD0k5Q7FCxhNXdjBA\" 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\/vi33gcvp17cq2wm\/curso_excel_basic_capitulo_7.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_basico\/curso_excel_basic_capitulo_7.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\/#!r1pHnLbJ!vZ4_JDAfyiSByw85x8D1cwQZgGCD0k5Q7FCxhNXdjBA\" target=\"_blank\" rel=\"noopener noreferrer\">Mega<\/a> | <a href=\"http:\/\/www.mediafire.com\/file\/vi33gcvp17cq2wm\/curso_excel_basic_capitulo_7.zip\" target=\"_blank\" rel=\"noopener noreferrer\">MediaFire <\/a>| <a href=\"https:\/\/dostinhurtado.com\/material_de_apoyo\/curso_excel_basico\/curso_excel_basic_capitulo_7.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\/excel-basico-intermedio\/excel-capitulo-6\/\">Capitulo Anterior<\/a>\u00a0<a class=\"btn btn-primary\" href=\"https:\/\/dostinhurtado.com\/site\/Categoria\/cursos\/excel-basico-intermedio\/\">Lista de Capitulos<\/a>\u00a0<a class=\"btn btn-default\" href=\"https:\/\/dostinhurtado.com\/site\/cursos\/excel-basico-intermedio\/excel-capitulo-8\/\">Capitulo Siguiente<\/a><\/p>\n<hr \/>\n","protected":false},"excerpt":{"rendered":"<p>LLAMADO DE DATOS (BuscarV) Aprende la funci\u00f3n BuscarV para el llamado de datos, esto es usado en casi todas las [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":3845,"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":[49],"tags":[116,225,227,256,257,327,365],"class_list":["post-3859","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-basico-intermedio","tag-base-de-datos","tag-excel","tag-excel-basico","tag-funcion","tag-funcion-buscarv","tag-llamado-de-datos","tag-office"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.0 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Excel - Cap\u00edtulo 7 - 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-basico-intermedio\/excel-capitulo-7\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel - Cap\u00edtulo 7 - Dostin Hurtado\" \/>\n<meta property=\"og:description\" content=\"LLAMADO DE DATOS (BuscarV) Aprende la funci\u00f3n BuscarV para el llamado de datos, esto es usado en casi todas las [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-basico-intermedio\/excel-capitulo-7\/\" \/>\n<meta property=\"og:site_name\" content=\"Dostin Hurtado\" \/>\n<meta property=\"article:published_time\" content=\"2018-04-26T12:00:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-06T19:39:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/cap7.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\\\/excel-basico-intermedio\\\/excel-capitulo-7\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-basico-intermedio\\\/excel-capitulo-7\\\/\"},\"author\":{\"name\":\"Dostin Hurtado\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/95509baa94d6c69583eddaece41011cc\"},\"headline\":\"Excel &#8211; Cap\u00edtulo 7\",\"datePublished\":\"2018-04-26T12:00:12+00:00\",\"dateModified\":\"2024-09-06T19:39:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-basico-intermedio\\\/excel-capitulo-7\\\/\"},\"wordCount\":206,\"commentCount\":58,\"publisher\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/6bc1fbb1a73635ac2e186182146d04e9\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-basico-intermedio\\\/excel-capitulo-7\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/cap7.jpg\",\"keywords\":[\"Base de Datos\",\"Excel\",\"Excel Basico\",\"funcion\",\"Funcion BuscarV\",\"Llamado de Datos\",\"office\"],\"articleSection\":[\"Excel B\u00e1sico e Intermedio\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-basico-intermedio\\\/excel-capitulo-7\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-basico-intermedio\\\/excel-capitulo-7\\\/\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-basico-intermedio\\\/excel-capitulo-7\\\/\",\"name\":\"Excel - Cap\u00edtulo 7 - Dostin Hurtado\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-basico-intermedio\\\/excel-capitulo-7\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-basico-intermedio\\\/excel-capitulo-7\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/cap7.jpg\",\"datePublished\":\"2018-04-26T12:00:12+00:00\",\"dateModified\":\"2024-09-06T19:39:28+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-basico-intermedio\\\/excel-capitulo-7\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-basico-intermedio\\\/excel-capitulo-7\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-basico-intermedio\\\/excel-capitulo-7\\\/#primaryimage\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/cap7.jpg\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/cap7.jpg\",\"width\":500,\"height\":376,\"caption\":\"Curso de Excel - Capitulo 7\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/cursos-gratis\\\/excel-basico-intermedio\\\/excel-capitulo-7\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel &#8211; Cap\u00edtulo 7\"}]},{\"@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=1783951342\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1783951342\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1783951342\",\"caption\":\"Dostin Hurtado\"},\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/author\\\/moderador\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel - Cap\u00edtulo 7 - 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-basico-intermedio\/excel-capitulo-7\/","og_locale":"es_ES","og_type":"article","og_title":"Excel - Cap\u00edtulo 7 - Dostin Hurtado","og_description":"LLAMADO DE DATOS (BuscarV) Aprende la funci\u00f3n BuscarV para el llamado de datos, esto es usado en casi todas las [&hellip;]","og_url":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-basico-intermedio\/excel-capitulo-7\/","og_site_name":"Dostin Hurtado","article_published_time":"2018-04-26T12:00:12+00:00","article_modified_time":"2024-09-06T19:39:28+00:00","og_image":[{"width":500,"height":376,"url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/cap7.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\/excel-basico-intermedio\/excel-capitulo-7\/#article","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-basico-intermedio\/excel-capitulo-7\/"},"author":{"name":"Dostin Hurtado","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/95509baa94d6c69583eddaece41011cc"},"headline":"Excel &#8211; Cap\u00edtulo 7","datePublished":"2018-04-26T12:00:12+00:00","dateModified":"2024-09-06T19:39:28+00:00","mainEntityOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-basico-intermedio\/excel-capitulo-7\/"},"wordCount":206,"commentCount":58,"publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/6bc1fbb1a73635ac2e186182146d04e9"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-basico-intermedio\/excel-capitulo-7\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/cap7.jpg","keywords":["Base de Datos","Excel","Excel Basico","funcion","Funcion BuscarV","Llamado de Datos","office"],"articleSection":["Excel B\u00e1sico e Intermedio"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-basico-intermedio\/excel-capitulo-7\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-basico-intermedio\/excel-capitulo-7\/","url":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-basico-intermedio\/excel-capitulo-7\/","name":"Excel - Cap\u00edtulo 7 - Dostin Hurtado","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-basico-intermedio\/excel-capitulo-7\/#primaryimage"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-basico-intermedio\/excel-capitulo-7\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/cap7.jpg","datePublished":"2018-04-26T12:00:12+00:00","dateModified":"2024-09-06T19:39:28+00:00","breadcrumb":{"@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-basico-intermedio\/excel-capitulo-7\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-basico-intermedio\/excel-capitulo-7\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-basico-intermedio\/excel-capitulo-7\/#primaryimage","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/cap7.jpg","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/cap7.jpg","width":500,"height":376,"caption":"Curso de Excel - Capitulo 7"},{"@type":"BreadcrumbList","@id":"https:\/\/dostinhurtado.com\/site\/cursos-gratis\/excel-basico-intermedio\/excel-capitulo-7\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/dostinhurtado.com\/site\/"},{"@type":"ListItem","position":2,"name":"Excel &#8211; Cap\u00edtulo 7"}]},{"@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=1783951342","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1783951342","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1783951342","caption":"Dostin Hurtado"},"url":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/cap7.jpg",500,376,false],"thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/cap7-150x150.jpg",150,150,true],"medium":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/cap7-300x226.jpg",300,226,true],"medium_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/cap7.jpg",500,376,false],"large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/cap7.jpg",500,376,false],"1536x1536":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/cap7.jpg",500,376,false],"2048x2048":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/cap7.jpg",500,376,false],"ultp_layout_landscape_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/cap7.jpg",500,376,false],"ultp_layout_landscape":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/cap7.jpg",500,376,false],"ultp_layout_portrait":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/cap7.jpg",500,376,false],"ultp_layout_square":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/cap7.jpg",500,376,false],"woocommerce_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/cap7-400x376.jpg",400,376,true],"woocommerce_single":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/cap7.jpg",500,376,false],"woocommerce_gallery_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/04\/cap7-100x100.jpg",100,100,true]},"uagb_author_info":{"display_name":"Dostin Hurtado","author_link":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"},"uagb_comment_info":58,"uagb_excerpt":"LLAMADO DE DATOS (BuscarV) Aprende la funci\u00f3n BuscarV para el llamado de datos, esto es usado en casi todas las [&hellip;]","_links":{"self":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/3859","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=3859"}],"version-history":[{"count":0,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/3859\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media\/3845"}],"wp:attachment":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media?parent=3859"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/categories?post=3859"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/tags?post=3859"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}