{"id":249802,"global_id":"cintecx.uvigo.es\/es\/?id=249802","global_id_lineage":["cintecx.uvigo.es\/es\/?id=249802"],"author":"10","status":"publish","date":"2024-01-15 16:51:29","date_utc":"2024-01-15 15:51:29","modified":"2024-02-27 15:03:31","modified_utc":"2024-02-27 14:03:31","url":"https:\/\/cintecx.uvigo.es\/es\/event\/249802\/","rest_url":"https:\/\/cintecx.uvigo.es\/es\/wp-json\/tribe\/events\/v1\/events\/249802","title":"Curso Excel Medio II","description":"<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>","excerpt":"","slug":"249802","image":{"url":"https:\/\/cintecx.uvigo.es\/wp-content\/uploads\/2024\/01\/curso-excel-e1705333737839.png","id":249817,"extension":"png","width":1326,"height":808,"filesize":640745,"sizes":{"medium":{"width":300,"height":183,"mime-type":"image\/png","filesize":25527,"url":"https:\/\/cintecx.uvigo.es\/wp-content\/uploads\/2024\/01\/curso-excel-e1705333737839-300x183.png"},"large":{"width":1024,"height":624,"mime-type":"image\/png","filesize":427410,"url":"https:\/\/cintecx.uvigo.es\/wp-content\/uploads\/2024\/01\/curso-excel-e1705333737839-1024x624.png"},"thumbnail":{"width":150,"height":150,"mime-type":"image\/png","filesize":12642,"url":"https:\/\/cintecx.uvigo.es\/wp-content\/uploads\/2024\/01\/curso-excel-e1705333737839-150x150.png"},"medium_large":{"width":768,"height":468,"mime-type":"image\/png","filesize":215613,"url":"https:\/\/cintecx.uvigo.es\/wp-content\/uploads\/2024\/01\/curso-excel-e1705333737839-768x468.png"},"1536x1536":{"width":1536,"height":996,"mime-type":"image\/png","filesize":656704,"url":"https:\/\/cintecx.uvigo.es\/wp-content\/uploads\/2024\/01\/curso-excel-1536x996.png"},"2048x2048":{"width":2048,"height":1328,"mime-type":"image\/png","filesize":599261,"url":"https:\/\/cintecx.uvigo.es\/wp-content\/uploads\/2024\/01\/curso-excel-2048x1328.png"},"post-thumbnail":{"width":445,"height":250,"mime-type":"image\/png","filesize":59556,"url":"https:\/\/cintecx.uvigo.es\/wp-content\/uploads\/2024\/01\/curso-excel-e1705333737839-445x250.png"},"featured-thumbnail-2x":{"width":1400,"height":844,"mime-type":"image\/png","filesize":685241,"url":"https:\/\/cintecx.uvigo.es\/wp-content\/uploads\/2024\/01\/curso-excel-e1705333702427-1400x844.png"},"featured-thumbnail":{"width":800,"height":450,"mime-type":"image\/png","filesize":237000,"url":"https:\/\/cintecx.uvigo.es\/wp-content\/uploads\/2024\/01\/curso-excel-e1705333737839-800x450.png"},"slider-image":{"width":1326,"height":540,"mime-type":"image\/png","filesize":461656,"url":"https:\/\/cintecx.uvigo.es\/wp-content\/uploads\/2024\/01\/curso-excel-e1705333737839-1326x540.png"},"gallery-image":{"width":400,"height":400,"mime-type":"image\/png","filesize":94344,"url":"https:\/\/cintecx.uvigo.es\/wp-content\/uploads\/2024\/01\/curso-excel-e1705333737839-400x400.png"},"gallery-image-slide":{"width":1280,"height":720,"mime-type":"image\/png","filesize":652624,"url":"https:\/\/cintecx.uvigo.es\/wp-content\/uploads\/2024\/01\/curso-excel-e1705333737839-1280x720.png"},"mailpoet_newsletter_max":{"width":1320,"height":804,"mime-type":"image\/png","filesize":728999,"url":"https:\/\/cintecx.uvigo.es\/wp-content\/uploads\/2024\/01\/curso-excel-e1705333737839-1320x804.png"}}},"all_day":false,"start_date":"2023-12-11 09:00:00","start_date_details":{"year":"2023","month":"12","day":"11","hour":"09","minutes":"00","seconds":"00"},"end_date":"2023-12-22 11:30:00","end_date_details":{"year":"2023","month":"12","day":"22","hour":"11","minutes":"30","seconds":"00"},"utc_start_date":"2023-12-11 08:00:00","utc_start_date_details":{"year":"2023","month":"12","day":"11","hour":"08","minutes":"00","seconds":"00"},"utc_end_date":"2023-12-22 10:30:00","utc_end_date_details":{"year":"2023","month":"12","day":"22","hour":"10","minutes":"30","seconds":"00"},"timezone":"Europe\/Madrid","timezone_abbr":"CET","cost":"","cost_details":{"currency_symbol":"","currency_code":"","currency_position":"prefix","values":[]},"website":"","show_map":true,"show_map_link":true,"hide_from_listings":false,"sticky":false,"featured":false,"categories":[{"name":"Curso","slug":"curso","term_group":0,"term_taxonomy_id":209,"taxonomy":"tribe_events_cat","description":"","parent":0,"count":74,"filter":"raw","term_order":"0","id":209,"urls":{"self":"https:\/\/cintecx.uvigo.es\/es\/wp-json\/tribe\/events\/v1\/categories\/209","collection":"https:\/\/cintecx.uvigo.es\/es\/wp-json\/tribe\/events\/v1\/categories"}},{"name":"Evento","slug":"evento","term_group":0,"term_taxonomy_id":211,"taxonomy":"tribe_events_cat","description":"","parent":0,"count":87,"filter":"raw","term_order":"0","id":211,"urls":{"self":"https:\/\/cintecx.uvigo.es\/es\/wp-json\/tribe\/events\/v1\/categories\/211","collection":"https:\/\/cintecx.uvigo.es\/es\/wp-json\/tribe\/events\/v1\/categories"}},{"name":"Formaci\u00f3n","slug":"formacion","term_group":0,"term_taxonomy_id":244,"taxonomy":"tribe_events_cat","description":"","parent":0,"count":104,"filter":"raw","term_order":"0","id":244,"urls":{"self":"https:\/\/cintecx.uvigo.es\/es\/wp-json\/tribe\/events\/v1\/categories\/244","collection":"https:\/\/cintecx.uvigo.es\/es\/wp-json\/tribe\/events\/v1\/categories"}}],"tags":[],"venue":[],"organizer":[],"custom_fields":[],"json_ld":{"@context":"http:\/\/schema.org","@type":"Event","name":"Curso Excel Medio II","description":"&lt;p&gt;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; &lt;a class=&quot;excerpt_more&quot; href=&quot;https:\/\/cintecx.uvigo.es\/es\/event\/249802\/&quot;&gt;Contin\u00faa&lt;\/a&gt;&lt;\/p&gt;\\n","image":"https:\/\/cintecx.uvigo.es\/wp-content\/uploads\/2024\/01\/curso-excel-e1705333737839.png","url":"https:\/\/cintecx.uvigo.es\/es\/event\/249802\/","eventAttendanceMode":"https:\/\/schema.org\/OfflineEventAttendanceMode","eventStatus":"https:\/\/schema.org\/EventScheduled","startDate":"2023-12-11T09:00:00+01:00","endDate":"2023-12-22T11:30:00+01:00","performer":"Organization"}}