{"id":23376,"date":"2025-01-24T11:52:25","date_gmt":"2025-01-24T11:52:25","guid":{"rendered":"https:\/\/abexis.es\/index.php\/product\/excel-avanzado\/"},"modified":"2025-06-16T12:08:03","modified_gmt":"2025-06-16T12:08:03","slug":"excel-avanzado","status":"publish","type":"product","link":"https:\/\/abexis.es\/index.php\/product\/excel-avanzado\/","title":{"rendered":"EXCEL AVANZADO"},"content":{"rendered":"

1. FUNCIONES
\n 1.1. Anidar funciones<\/p>\n

2. BASES DE DATOS
\n 2.1. Filtros avanzados
\n 2.2. Validaci\u00f3n de datos
\n 2.3. Depurar bases de datos: valores \u00fanicos<\/p>\n

3. FORMULARIOS: BOTONES DE FORMULARIOS<\/p>\n

4. VISTAS
\n 4.1. Agrupar y desagrupar
\n 4.2. Autoesquema<\/p>\n

5. ESTRUCTURAS DE CONTROL
\n 5.1. Dominio de tablas din\u00e1micas
\n 5.2. Consolidaci\u00f3n de datos<\/p>\n

6. AN\u00c1LISIS DE DATOS
\n 6.1. Buscar objetivo
\n 6.2. Escenarios
\n 6.3. Tablas de una y dos variables<\/p>\n

7. SOLVER: PLANTILLAS<\/p>\n

8. MACROS
\n 8.1. Grabaci\u00f3n de macros. Creaci\u00f3n de macros
\n 8.2. Reproducci\u00f3n de macros
\n 8.3. Eliminaci\u00f3n de macros
\n 8.4. Crear iconos y botones que ejecuten macros
\n 8.5. Seguridad de macros<\/p>\n

9. OBTENCI\u00d3N DE DATOS EXTERNOS
\n 9.1. Desde Access
\n 9.2. Desde texto.
\n 9.3. Otras posibilidades
\n 9.4. Conexi\u00f3n con Access: Importaci\u00f3n. Vinculaci\u00f3n<\/p>\n

10. RANGOS
\n 10.1. Nombres
\n 10.2. Modificar rangos
\n 10.3. Quitar duplicados<\/p>\n

11. INSERCI\u00d3N DE OBJETOS<\/p>\n","protected":false},"excerpt":{"rendered":"

Aplicaci\u00f3n y dise\u00f1o de funciones avanzadas de Excel, trabajo con datos externos e interconexi\u00f3n de Excel y Access.<\/p>\n","protected":false},"featured_media":23320,"template":"","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":""},"product_brand":[],"product_cat":[34],"product_tag":[],"class_list":["post-23376","product","type-product","status-publish","has-post-thumbnail","product_cat-administracion-y-gestion","first","instock","virtual","taxable","purchasable","product-type-simple"],"yoast_head":"\nEXCEL AVANZADO -<\/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:\/\/abexis.es\/index.php\/product\/excel-avanzado\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"EXCEL AVANZADO -\" \/>\n<meta property=\"og:description\" content=\"Aplicaci\u00f3n y dise\u00f1o de funciones avanzadas de Excel, trabajo con datos externos e interconexi\u00f3n de Excel y Access.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/abexis.es\/index.php\/product\/excel-avanzado\/\" \/>\n<meta property=\"og:site_name\" content=\"Formaliser\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-16T12:08:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/abexis.es\/wp-content\/uploads\/2025\/01\/AYG-scaled-e1737924816750.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2000\" \/>\n\t<meta property=\"og:image:height\" content=\"1737\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/excel-avanzado\\\/\",\"url\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/excel-avanzado\\\/\",\"name\":\"EXCEL AVANZADO -\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/abexis.es\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/excel-avanzado\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/excel-avanzado\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/abexis.es\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/AYG-scaled-e1737924816750.jpg\",\"datePublished\":\"2025-01-24T11:52:25+00:00\",\"dateModified\":\"2025-06-16T12:08:03+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/excel-avanzado\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/excel-avanzado\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/excel-avanzado\\\/#primaryimage\",\"url\":\"https:\\\/\\\/abexis.es\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/AYG-scaled-e1737924816750.jpg\",\"contentUrl\":\"https:\\\/\\\/abexis.es\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/AYG-scaled-e1737924816750.jpg\",\"width\":2000,\"height\":1737,\"caption\":\"Mockup computer laptop on wooden table\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/product\\\/excel-avanzado\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/abexis.es\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cursos\",\"item\":\"https:\\\/\\\/abexis.es\\\/index.php\\\/cursos-online-profesionales-y-subvencionados\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"EXCEL AVANZADO\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/abexis.es\\\/#website\",\"url\":\"https:\\\/\\\/abexis.es\\\/\",\"name\":\"Formaliser\",\"description\":\"Formaci\u00f3n\",\"publisher\":{\"@id\":\"https:\\\/\\\/abexis.es\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/abexis.es\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/abexis.es\\\/#organization\",\"name\":\"Formaliser\",\"url\":\"https:\\\/\\\/abexis.es\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/abexis.es\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/abexis.es\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/cropped-LOGO-web.png\",\"contentUrl\":\"https:\\\/\\\/abexis.es\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/cropped-LOGO-web.png\",\"width\":1000,\"height\":295,\"caption\":\"Formaliser\"},\"image\":{\"@id\":\"https:\\\/\\\/abexis.es\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"EXCEL AVANZADO -","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:\/\/abexis.es\/index.php\/product\/excel-avanzado\/","og_locale":"es_ES","og_type":"article","og_title":"EXCEL AVANZADO -","og_description":"Aplicaci\u00f3n y dise\u00f1o de funciones avanzadas de Excel, trabajo con datos externos e interconexi\u00f3n de Excel y Access.","og_url":"https:\/\/abexis.es\/index.php\/product\/excel-avanzado\/","og_site_name":"Formaliser","article_modified_time":"2025-06-16T12:08:03+00:00","og_image":[{"width":2000,"height":1737,"url":"https:\/\/abexis.es\/wp-content\/uploads\/2025\/01\/AYG-scaled-e1737924816750.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/abexis.es\/index.php\/product\/excel-avanzado\/","url":"https:\/\/abexis.es\/index.php\/product\/excel-avanzado\/","name":"EXCEL AVANZADO -","isPartOf":{"@id":"https:\/\/abexis.es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/abexis.es\/index.php\/product\/excel-avanzado\/#primaryimage"},"image":{"@id":"https:\/\/abexis.es\/index.php\/product\/excel-avanzado\/#primaryimage"},"thumbnailUrl":"https:\/\/abexis.es\/wp-content\/uploads\/2025\/01\/AYG-scaled-e1737924816750.jpg","datePublished":"2025-01-24T11:52:25+00:00","dateModified":"2025-06-16T12:08:03+00:00","breadcrumb":{"@id":"https:\/\/abexis.es\/index.php\/product\/excel-avanzado\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/abexis.es\/index.php\/product\/excel-avanzado\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/abexis.es\/index.php\/product\/excel-avanzado\/#primaryimage","url":"https:\/\/abexis.es\/wp-content\/uploads\/2025\/01\/AYG-scaled-e1737924816750.jpg","contentUrl":"https:\/\/abexis.es\/wp-content\/uploads\/2025\/01\/AYG-scaled-e1737924816750.jpg","width":2000,"height":1737,"caption":"Mockup computer laptop on wooden table"},{"@type":"BreadcrumbList","@id":"https:\/\/abexis.es\/index.php\/product\/excel-avanzado\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/abexis.es\/"},{"@type":"ListItem","position":2,"name":"Cursos","item":"https:\/\/abexis.es\/index.php\/cursos-online-profesionales-y-subvencionados\/"},{"@type":"ListItem","position":3,"name":"EXCEL AVANZADO"}]},{"@type":"WebSite","@id":"https:\/\/abexis.es\/#website","url":"https:\/\/abexis.es\/","name":"Formaliser","description":"Formaci\u00f3n","publisher":{"@id":"https:\/\/abexis.es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/abexis.es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/abexis.es\/#organization","name":"Formaliser","url":"https:\/\/abexis.es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/abexis.es\/#\/schema\/logo\/image\/","url":"https:\/\/abexis.es\/wp-content\/uploads\/2024\/12\/cropped-LOGO-web.png","contentUrl":"https:\/\/abexis.es\/wp-content\/uploads\/2024\/12\/cropped-LOGO-web.png","width":1000,"height":295,"caption":"Formaliser"},"image":{"@id":"https:\/\/abexis.es\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/abexis.es\/index.php\/wp-json\/wp\/v2\/product\/23376","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/abexis.es\/index.php\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/abexis.es\/index.php\/wp-json\/wp\/v2\/types\/product"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/abexis.es\/index.php\/wp-json\/wp\/v2\/media\/23320"}],"wp:attachment":[{"href":"https:\/\/abexis.es\/index.php\/wp-json\/wp\/v2\/media?parent=23376"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/abexis.es\/index.php\/wp-json\/wp\/v2\/product_brand?post=23376"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/abexis.es\/index.php\/wp-json\/wp\/v2\/product_cat?post=23376"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/abexis.es\/index.php\/wp-json\/wp\/v2\/product_tag?post=23376"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}