{"id":14037,"date":"2026-09-23T13:48:49","date_gmt":"2026-09-23T11:48:49","guid":{"rendered":"https:\/\/trabajosocialnavarra.org\/?post_type=project&#038;p=14037"},"modified":"2026-09-23T14:10:42","modified_gmt":"2026-09-23T12:10:42","slug":"excel-en-kudeaketa-informazioa-bilatu-konparatu-eta-gurutzatzea","status":"publish","type":"project","link":"https:\/\/trabajosocialnavarra.org\/eu\/portafolio\/excel-en-kudeaketa-informazioa-bilatu-konparatu-eta-gurutzatzea\/","title":{"rendered":"Excel-en kudeaketa: zeregin errepikakorren automatizazioa"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;cabecera&#8221; _builder_version=&#8221;4.27.7&#8243; background_color=&#8221;#E02B20&#8243; background_enable_image=&#8221;off&#8221; background_position=&#8221;bottom_center&#8221; background_vertical_offset=&#8221;-15%&#8221; background_repeat=&#8221;space&#8221; background_blend=&#8221;overlay&#8221; custom_margin=&#8221;||0px||false|false&#8221; custom_margin_tablet=&#8221;|0px||&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; custom_padding=&#8221;0vw||0vw||true|false&#8221; top_divider_height=&#8221;14vw&#8221; top_divider_repeat=&#8221;0.5x&#8221; top_divider_flip=&#8221;horizontal&#8221; bottom_divider_style=&#8221;wave2&#8243; bottom_divider_color=&#8221;#f7f7f7&#8243; bottom_divider_height=&#8221;2vw&#8221; bottom_divider_repeat=&#8221;0.5x&#8221; bottom_divider_flip=&#8221;horizontal&#8221; da_disable_devices=&#8221;off|off|off&#8221; border_color_all=&#8221;#f7f7f7&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221;][et_pb_row _builder_version=&#8221;4.27.7&#8243; custom_margin=&#8221;||0px||false|false&#8221; custom_padding=&#8221;||||false|false&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text admin_label=&#8221;Texto&#8221; _builder_version=&#8221;4.27.7&#8243; text_font=&#8221;Ubuntu||||||||&#8221; text_text_color=&#8221;#FFFFFF&#8221; text_font_size=&#8221;19px&#8221; text_line_height=&#8221;2em&#8221; header_font=&#8221;Ubuntu|500|||||||&#8221; header_line_height=&#8221;1.4em&#8221; header_3_font=&#8221;Ubuntu||||||||&#8221; header_3_text_color=&#8221;#000000&#8243; header_3_line_height=&#8221;1.8em&#8221; max_width=&#8221;682px&#8221; min_height=&#8221;26px&#8221; custom_margin=&#8221;0px||0px||false|false&#8221; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;14px&#8221; text_font_size_last_edited=&#8221;on|desktop&#8221; border_color_bottom=&#8221;#E02B20&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Prestakuntza<\/p>\n<p>[\/et_pb_text][et_pb_text admin_label=&#8221;Texto&#8221; _builder_version=&#8221;4.27.7&#8243; _dynamic_attributes=&#8221;content&#8221; text_font=&#8221;Ubuntu|700|||||||&#8221; text_text_color=&#8221;#FFFFFF&#8221; text_font_size=&#8221;36px&#8221; text_line_height=&#8221;2em&#8221; link_text_color=&#8221;#FFFFFF&#8221; header_font=&#8221;Ubuntu|500|||||||&#8221; header_line_height=&#8221;1.4em&#8221; header_3_font=&#8221;Ubuntu||||||||&#8221; header_3_text_color=&#8221;#000000&#8243; header_3_line_height=&#8221;1.8em&#8221; max_width=&#8221;969px&#8221; min_height=&#8221;74px&#8221; custom_margin=&#8221;-15px||25px||false|false&#8221; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;14px&#8221; text_font_size_last_edited=&#8221;on|desktop&#8221; border_width_bottom=&#8221;3px&#8221; border_color_bottom=&#8221;#FFFFFF&#8221; global_colors_info=&#8221;{}&#8221;]@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF90aXRsZSIsInNldHRpbmdzIjp7ImJlZm9yZSI6IiIsImFmdGVyIjoiIiwiZW5hYmxlX2h0bWwiOiJvZmYifX0=@[\/et_pb_text][et_pb_text admin_label=&#8221;Texto&#8221; _builder_version=&#8221;4.27.7&#8243; _dynamic_attributes=&#8221;content&#8221; text_font=&#8221;Ubuntu||||||||&#8221; text_text_color=&#8221;#FFFFFF&#8221; text_font_size=&#8221;19px&#8221; text_line_height=&#8221;2em&#8221; link_text_color=&#8221;#FFFFFF&#8221; header_font=&#8221;Ubuntu|500|||||||&#8221; header_text_color=&#8221;#FFFFFF&#8221; header_line_height=&#8221;1.4em&#8221; header_3_font=&#8221;Ubuntu||||||||&#8221; header_3_text_color=&#8221;#000000&#8243; header_3_line_height=&#8221;1.8em&#8221; max_width=&#8221;682px&#8221; custom_margin=&#8221;-23px||0px||false|false&#8221; custom_padding=&#8221;0px||0px||false|false&#8221; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;14px&#8221; text_font_size_last_edited=&#8221;on|desktop&#8221; border_color_bottom=&#8221;#E02B20&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF9jYXRlZ29yaWVzIiwic2V0dGluZ3MiOnsiYmVmb3JlIjoiIiwiYWZ0ZXIiOiIiLCJsaW5rX3RvX3Rlcm1fcGFnZSI6Im9uIiwic2VwYXJhdG9yIjoiIHwgIiwiY2F0ZWdvcnlfdHlwZSI6InByb2plY3RfY2F0ZWdvcnkiLCJlbmFibGVfaHRtbCI6Im9mZiJ9fQ==@[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;idea fuerza&#8221; module_id=&#8221;ongietorria&#8221; _builder_version=&#8221;4.27.7&#8243; background_color=&#8221;#f7f7f7&#8243; custom_margin=&#8221;||||false|false&#8221; custom_margin_tablet=&#8221;|0px||&#8221; custom_margin_last_edited=&#8221;off|desktop&#8221; custom_padding=&#8221;30px||0vw||false|false&#8221; top_divider_height=&#8221;14vw&#8221; top_divider_repeat=&#8221;0.5x&#8221; top_divider_flip=&#8221;horizontal&#8221; bottom_divider_style=&#8221;wave2&#8243; bottom_divider_color=&#8221;#FFFFFF&#8221; bottom_divider_height=&#8221;14vw&#8221; bottom_divider_repeat=&#8221;0.5x&#8221; bottom_divider_flip=&#8221;vertical&#8221; da_popup_slug=&#8221;bienvenida&#8221; da_disable_devices=&#8221;off|off|off&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221;][et_pb_row column_structure=&#8221;2_3,1_3&#8243; _builder_version=&#8221;4.27.6&#8243; min_height=&#8221;637.7px&#8221; animation_style=&#8221;fade&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;2_3&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.27.9&#8243; text_font=&#8221;Ubuntu||||||||&#8221; text_text_color=&#8221;#E02B20&#8243; text_font_size=&#8221;18px&#8221; header_font=&#8221;||||||||&#8221; header_font_size=&#8221;24px&#8221; header_2_line_height=&#8221;1.2em&#8221; custom_margin=&#8221;||0px||false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Ematen du: Eneko R\u00edpodas<\/p>\n<p>[\/et_pb_text][et_pb_divider color=&#8221;#E02B20&#8243; divider_position=&#8221;center&#8221; divider_weight=&#8221;3px&#8221; _builder_version=&#8221;4.27.9&#8243; max_width=&#8221;300px&#8221; module_alignment=&#8221;left&#8221; height=&#8221;0px&#8221; custom_margin=&#8221;5px||20px||false|false&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][et_pb_text _builder_version=&#8221;4.27.9&#8243; text_font=&#8221;||||||||&#8221; text_font_size=&#8221;13px&#8221; text_line_height=&#8221;1.8em&#8221; text_orientation=&#8221;center&#8221; hover_enabled=&#8221;0&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<p style=\"text-align: left;\">Automatizatzea da zereginak errepikatzen ematen duzun denbora aurrera egiteko, aztertzeko eta erabaki hobeak hartzeko denbora bihurtzea.<\/p>\n<p style=\"text-align: left;\">Prozesu errepikakorrak identifikatzen eta eskuzko lana murrizten duten kalkulu-orriak diseinatzen ikasiko da. Helburua izango da formula, adierazle eta emaitzak informazio berria txertatzean eguneratzea. <\/p>\n<p>[\/et_pb_text][et_pb_tabs active_tab_background_color=&#8221;#E02B20&#8243; active_tab_text_color=&#8221;#FFFFFF&#8221; admin_label=&#8221;Pesta\u00f1as&#8221; module_class=&#8221;tabs-curso&#8221; _builder_version=&#8221;4.27.9&#8243; _module_preset=&#8221;default&#8221; tab_font=&#8221;Ubuntu||||||||&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; sticky_enabled=&#8221;0&#8243;][et_pb_tab title=&#8221;Data eta ordutegia&#8221; _builder_version=&#8221;4.27.9&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<ul style=\"list-style: none; padding-left: 0;\">\n<li style=\"margin-bottom: 10px;\"><span style=\"color: #e02b20; font-size: 20px; margin-right: 8px;\"><\/span>6 orduko ikastaroa: otsailaren 16an eta 23an izango diren bi prestakuntza-saiotan banatuta, 16:30etatik 19:30etara.<span style=\"color: #e02b20; font-size: 20px; margin-right: 8px;\"><\/span><\/li>\n<\/ul>\n<p>[\/et_pb_tab][et_pb_tab title=&#8221;Modalitatea&#8221; _builder_version=&#8221;4.27.9&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<ul style=\"list-style: none; padding-left: 0;\">\n<li style=\"margin-bottom: 10px;\"><span style=\"color: #e02b20; font-size: 20px; margin-right: 8px;\"><\/span>Online: Webex bidez.<span style=\"color: #e02b20; font-size: 20px; margin-right: 8px;\"><\/span><\/li>\n<\/ul>\n<p>[\/et_pb_tab][et_pb_tab title=&#8221;Irakaslea&#8221; _builder_version=&#8221;4.27.9&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<ul style=\"list-style: none; padding-left: 0;\">\n<li style=\"margin-bottom: 10px;\"><span style=\"color: #e02b20; font-size: 20px; margin-right: 8px;\"><\/span>Eneko R\u00edpodas.<\/li>\n<\/ul>\n<p>[\/et_pb_tab][et_pb_tab title=&#8221;Helburuak&#8221; _builder_version=&#8221;4.27.9&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<ul style=\"list-style: none; padding-left: 0;\">\n<li style=\"margin-bottom: 10px;\"><span style=\"color: #e02b20; font-size: 20px; margin-right: 8px;\"><\/span>Automatizatzeko moduko zereginak identifikatzea.<\/li>\n<li style=\"margin-bottom: 10px;\"><span style=\"color: #e02b20; font-size: 20px; margin-right: 8px;\"><\/span>Berrerabil daitezkeen formulak eta egiturak sortzea.<\/li>\n<li style=\"margin-bottom: 10px;\"><span style=\"color: #e02b20; font-size: 20px; margin-right: 8px;\"><\/span>Erreferentziak, taulak eta funtzioak erabiltzea kalkuluak automatizatzeko.<\/li>\n<li style=\"margin-bottom: 10px;\"><span style=\"color: #e02b20; font-size: 20px; margin-right: 8px;\"><\/span>Power Query-k prozesu periodikoetarako eskaintzen dituen aukerak ezagutzea.<\/li>\n<\/ul>\n<p>[\/et_pb_tab][et_pb_tab title=&#8221;Programa&#8221; _builder_version=&#8221;4.27.9&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; sticky_enabled=&#8221;0&#8243;]<strong style=\"display: block; margin-top: 10px; margin-bottom: -3px; padding-left: 20px;\">AUTOMATIZATU AURRETIK PENTSATU<\/strong><br \/>\n<span style=\"color: #e02b20; font-size: 10px; margin-right: 8px; margin-left: 28px;\">\u25cf<\/span>Zeregin errepikakorrak identifikatzea.<br \/>\n<span style=\"color: #e02b20; font-size: 10px; margin-right: 8px; margin-left: 28px;\">\u25cf<\/span>Zer merezi duen automatizatzea.<br \/>\n<strong style=\"display: block; margin-top: 10px; margin-bottom: -3px; padding-left: 20px;\">INFORMAZIOA GARBITZEA ETA ERALDATZEA POWERQUERY-REKIN<\/strong><br \/>\n<span style=\"color: #e02b20; font-size: 10px; margin-right: 8px; margin-left: 28px;\">\u25cf<\/span>Power Query-rako sarrera<br \/>\n<span style=\"color: #e02b20; font-size: 10px; margin-right: 8px; margin-left: 28px;\">\u25cf<\/span>Datuak inportatzea.<br \/>\n<span style=\"color: #e02b20; font-size: 10px; margin-right: 8px; margin-left: 28px;\">\u25cf<\/span>Informazioa garbitzea.<br \/>\n<span style=\"color: #e02b20; font-size: 10px; margin-right: 8px; margin-left: 28px;\">\u25cf<\/span>Beharrezkoak ez diren zutabeak ezabatzea.<br \/>\n<span style=\"color: #e02b20; font-size: 10px; margin-right: 8px; margin-left: 28px;\">\u25cf<\/span>Formatuak eraldatzea.<br \/>\n<span style=\"color: #e02b20; font-size: 10px; margin-right: 8px; margin-left: 28px;\">\u25cf<\/span>Fitxategiak konbinatzea.[\/et_pb_tab][et_pb_tab title=&#8221;Metodologia&#8221; _builder_version=&#8221;4.27.9&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<ul style=\"list-style: none; padding-left: 0;\">\n<li style=\"margin-bottom: 10px;\"><span style=\"color: #e02b20; font-size: 20px; margin-right: 8px;\"><\/span>Hizlariaren azalpena eta parte-hartzailea.<\/li>\n<\/ul>\n<p>[\/et_pb_tab][et_pb_tab title=&#8221;Prezioa&#8221; _builder_version=&#8221;4.27.9&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<ul style=\"list-style: none; padding-left: 0;\">\n<li style=\"margin-bottom: 10px;\"><span style=\"color: #e02b20; font-size: 20px; margin-right: 8px;\"><\/span>Kolegiatu eta prekolegiatu pertsonak: 50 \u20ac<\/li>\n<li style=\"margin-bottom: 10px;\"><span style=\"color: #e02b20; font-size: 20px; margin-right: 8px;\"><\/span>Kolegiatuta ez dauden pertsonak: 75 \u20ac<span style=\"color: #e02b20; font-size: 20px; margin-right: 8px;\"><\/span><\/li>\n<\/ul>\n<p>[\/et_pb_tab][et_pb_tab title=&#8221;Izena emateko epea&#8221; _builder_version=&#8221;4.27.9&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<ul style=\"list-style: none; padding-left: 0;\">\n<li style=\"margin-bottom: 10px;\"><span style=\"color: #e02b20; font-size: 20px; margin-right: 8px;\"><\/span>Epea zabalik otsailaren 9ra arte.<\/li>\n<\/ul>\n<p>[\/et_pb_tab][\/et_pb_tabs][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_button button_url=&#8221;https:\/\/trabajosocialnavarra.org\/eu\/prestakuntza\/&#8221; button_text=&#8221;IKASTARO GUZTIAK IKUSI&#8221; button_alignment=&#8221;right&#8221; _builder_version=&#8221;4.27.6&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][et_pb_image src=&#8221;https:\/\/trabajosocialnavarra.org\/wp-content\/uploads\/2026\/09\/17.png&#8221; title_text=&#8221;17&#8243; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.27.9&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; border_radii=&#8221;on|16px|16px|16px|16px&#8221; global_colors_info=&#8221;{}&#8221; sticky_enabled=&#8221;0&#8243;][\/et_pb_image][et_pb_button button_url=&#8221;https:\/\/forms.gle\/FvAo5omPnu9bkhnx8&#8243; url_new_window=&#8221;on&#8221; button_text=&#8221;IKASTAROAN IZENA EMAN&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.27.9&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;14px&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; sticky_enabled=&#8221;0&#8243;][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>PrestakuntzaEmaten du: Eneko R\u00edpodasAutomatizatzea da zereginak errepikatzen ematen duzun denbora aurrera egiteko, aztertzeko eta erabaki hobeak hartzeko denbora bihurtzea. Prozesu errepikakorrak identifikatzen eta eskuzko lana murrizten duten kalkulu-orriak diseinatzen ikasiko da. Helburua izango da formula, adierazle eta emaitzak informazio berria txertatzean eguneratzea. 6 orduko ikastaroa: otsailaren 16an eta 23an izango diren bi prestakuntza-saiotan banatuta, 16:30etatik [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":13970,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"project_category":[513,519],"project_tag":[],"class_list":["post-14037","project","type-project","status-publish","has-post-thumbnail","hentry","project_category-online-prestakuntza","project_category-prestakuntza"],"acf":[],"_links":{"self":[{"href":"https:\/\/trabajosocialnavarra.org\/eu\/wp-json\/wp\/v2\/project\/14037","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trabajosocialnavarra.org\/eu\/wp-json\/wp\/v2\/project"}],"about":[{"href":"https:\/\/trabajosocialnavarra.org\/eu\/wp-json\/wp\/v2\/types\/project"}],"author":[{"embeddable":true,"href":"https:\/\/trabajosocialnavarra.org\/eu\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/trabajosocialnavarra.org\/eu\/wp-json\/wp\/v2\/comments?post=14037"}],"version-history":[{"count":15,"href":"https:\/\/trabajosocialnavarra.org\/eu\/wp-json\/wp\/v2\/project\/14037\/revisions"}],"predecessor-version":[{"id":14129,"href":"https:\/\/trabajosocialnavarra.org\/eu\/wp-json\/wp\/v2\/project\/14037\/revisions\/14129"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/trabajosocialnavarra.org\/eu\/wp-json\/wp\/v2\/media\/13970"}],"wp:attachment":[{"href":"https:\/\/trabajosocialnavarra.org\/eu\/wp-json\/wp\/v2\/media?parent=14037"}],"wp:term":[{"taxonomy":"project_category","embeddable":true,"href":"https:\/\/trabajosocialnavarra.org\/eu\/wp-json\/wp\/v2\/project_category?post=14037"},{"taxonomy":"project_tag","embeddable":true,"href":"https:\/\/trabajosocialnavarra.org\/eu\/wp-json\/wp\/v2\/project_tag?post=14037"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}