{"id":249802,"date":"2024-01-15T16:51:29","date_gmt":"2024-01-15T15:51:29","guid":{"rendered":"https:\/\/cintecx.uvigo.es\/?post_type=tribe_events&#038;p=249802"},"modified":"2024-02-27T15:03:31","modified_gmt":"2024-02-27T14:03:31","slug":"249802","status":"publish","type":"tribe_events","link":"https:\/\/cintecx.uvigo.es\/es\/event\/249802\/","title":{"rendered":"Curso Excel Medio II"},"content":{"rendered":"<p>Los d\u00edas 11, 13, 15, 18, 20 y 22 de diciembre de 9:00 a 11:30h tendr\u00e1 lugar el curso de formaci\u00f3n de EXCEL MEDIO II,  para el personal investigador, en la sala de Xuntas de CINTECX.<\/p>\n<p>Temario del curso:<\/p>\n<ol>\n\t<strong>1. Herramientas Excel<\/strong><\/p>\n<p>\tManejo de funciones; principales funciones de Excel; manejo de tipos de referencias.<br \/>\n\tTablas din\u00e1micas<br \/>\n\tGr\u00e1ficos din\u00e1micos<br \/>\n\tValidaci\u00f3n avanzada de datos<br \/>\n\tFormato condicional avanzado<\/p>\n<p>\t<strong>2. Tratamiento y an\u00e1lisis de datos<\/strong><\/p>\n<p>\tIntroducci\u00f3n al concepto de modelo de datos.<br \/>\n\tIntroducci\u00f3n al uso de PowerQuery para importaci\u00f3n, transformaci\u00f3n y preparaci\u00f3n de datos.<br \/>\n\tIntroducci\u00f3n al uso de PowerPivot para el establecimiento del modelo de datos.<br \/>\n\tCuadros de mando avanzados.<br \/>\n\tSegmentaci\u00f3n de datos.<br \/>\n\tTablas din\u00e1micas avanzadas a partir del modelo de datos de PowerPivot.<\/p>\n<p>\t<strong>3. Macros<\/strong><\/p>\n<p>\tConcepto de Macro.<br \/>\n\tAplicaci\u00f3n de las Macros no programadas en VBA.<br \/>\n\tCompilaci\u00f3n y ejecuci\u00f3n de Macros.<\/ol>\n<p>Las inscripciones pueden realizarse a trav\u00e9s del siguiente <a href=\"https:\/\/docs.google.com\/forms\/d\/e\/1FAIpQLSdq8PEClcEVi4XW2q6LpaBLzgYKgRRZSJpCC4w_MHCYpEYeDQ\/viewform\"><strong>Formulario<\/strong> <\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Los d\u00edas 11, 13, 15, 18, 20 y 22 de diciembre de 9:00 a 11:30h tendr\u00e1 lugar el curso de formaci\u00f3n de EXCEL MEDIO II, &hellip; <a class=\"excerpt_more\" href=\"https:\/\/cintecx.uvigo.es\/es\/event\/249802\/\">Contin\u00faa<\/a><\/p>\n","protected":false},"author":10,"featured_media":249817,"template":"","meta":{"inline_featured_image":false,"_tribe_events_status":"","_tribe_events_status_reason":"","footnotes":""},"tags":[],"tribe_events_cat":[209,211,244],"class_list":["post-249802","tribe_events","type-tribe_events","status-publish","has-post-thumbnail","hentry","tribe_events_cat-curso","tribe_events_cat-evento","tribe_events_cat-formacion","cat_curso","cat_evento","cat_formacion"],"_links":{"self":[{"href":"https:\/\/cintecx.uvigo.es\/es\/wp-json\/wp\/v2\/tribe_events\/249802","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cintecx.uvigo.es\/es\/wp-json\/wp\/v2\/tribe_events"}],"about":[{"href":"https:\/\/cintecx.uvigo.es\/es\/wp-json\/wp\/v2\/types\/tribe_events"}],"author":[{"embeddable":true,"href":"https:\/\/cintecx.uvigo.es\/es\/wp-json\/wp\/v2\/users\/10"}],"version-history":[{"count":7,"href":"https:\/\/cintecx.uvigo.es\/es\/wp-json\/wp\/v2\/tribe_events\/249802\/revisions"}],"predecessor-version":[{"id":249830,"href":"https:\/\/cintecx.uvigo.es\/es\/wp-json\/wp\/v2\/tribe_events\/249802\/revisions\/249830"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cintecx.uvigo.es\/es\/wp-json\/wp\/v2\/media\/249817"}],"wp:attachment":[{"href":"https:\/\/cintecx.uvigo.es\/es\/wp-json\/wp\/v2\/media?parent=249802"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cintecx.uvigo.es\/es\/wp-json\/wp\/v2\/tags?post=249802"},{"taxonomy":"tribe_events_cat","embeddable":true,"href":"https:\/\/cintecx.uvigo.es\/es\/wp-json\/wp\/v2\/tribe_events_cat?post=249802"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}