{"id":13783,"date":"2026-09-23T11:39:08","date_gmt":"2026-09-23T09:39:08","guid":{"rendered":"https:\/\/trabajosocialnavarra.org\/?post_type=project&#038;p=13783"},"modified":"2026-09-23T11:39:27","modified_gmt":"2026-09-23T09:39:27","slug":"excel-en-erabilera-kasuen-eta-erregistroen-kudeaketa","status":"publish","type":"project","link":"https:\/\/trabajosocialnavarra.org\/eu\/portafolio\/excel-en-erabilera-kasuen-eta-erregistroen-kudeaketa\/","title":{"rendered":"Excel-en erabilera: kasuen jarraipena, alertak eta adierazleak"},"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;900px&#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@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF90aXRsZSIsInNldHRpbmdzIjp7ImJlZm9yZSI6IiIsImFmdGVyIjoiIn19@[\/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@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF9jYXRlZ29yaWVzIiwic2V0dGluZ3MiOnsiYmVmb3JlIjoiIiwiYWZ0ZXIiOiIiLCJsaW5rX3RvX3Rlcm1fcGFnZSI6Im9uIiwic2VwYXJhdG9yIjoiIHwgIiwiY2F0ZWdvcnlfdHlwZSI6InByb2plY3RfY2F0ZWdvcnkifX0=@[\/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; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p style=\"text-align: left;\">Datuak erabaki bihurtu: zer begiratu eta noiz jardun dakizunean, jarraipena aurrera egiteko tresna<br \/>\nbihurtzen da.<\/p>\n<p style=\"text-align: left;\">Excel jarraipenerako tresna gisa erabiltzen ikasiko duzu, datak eta erregistroak abisu eta adierazle bihurtuz, zain dauden kasuak, hurrengo jarduerak eta arreta behar duten egoera azkar identifikatzeko aukera ematen dutenak<\/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; global_colors_info=&#8221;{}&#8221;][et_pb_tab title=&#8221;Data eta ordutegia&#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>6 orduko ikastaroa: azaroaren 10ean eta 17an 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; 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>Jarraipenerako datak eta epeak kudeatu.<\/li>\n<li style=\"margin-bottom: 10px;\"><span style=\"color: #e02b20; font-size: 20px; margin-right: 8px;\"><\/span>Alerta bisualak sortu formatu baldintzatuaren bidez.<\/li>\n<li style=\"margin-bottom: 10px;\"><span style=\"color: #e02b20; font-size: 20px; margin-right: 8px;\"><\/span>Funtzioak erabili erregistroak sailkatzeko, zenbatzeko eta aztertzeko.<\/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; global_colors_info=&#8221;{}&#8221;]<strong style=\"display: block; margin-top: 10px; margin-bottom: -3px; padding-left: 20px;\">ALERTA-SISTEMAK SORTU<\/strong><br \/>\n<span style=\"color: #e02b20; font-size: 10px; margin-right: 8px; margin-left: 28px;\">\u25cf<\/span>Formatu baldintzatua.<br \/>\n<span style=\"color: #e02b20; font-size: 10px; margin-right: 8px; margin-left: 28px;\">\u25cf<\/span>Jarraipenerako semaforoak.<br \/>\n<strong style=\"display: block; margin-top: 10px; margin-bottom: -3px; padding-left: 20px;\">JARRAIPENA EGITEKO FUNTZIOAK<\/strong><br \/>\n<span style=\"color: #e02b20; font-size: 10px; margin-right: 8px; margin-left: 28px;\">\u25cf<\/span>CONTAR.SI.<br \/>\n<span style=\"color: #e02b20; font-size: 10px; margin-right: 8px; margin-left: 28px;\">\u25cf<\/span>CONTAR.SI.CONJUNTO.<br \/>\n<span style=\"color: #e02b20; font-size: 10px; margin-right: 8px; margin-left: 28px;\">\u25cf<\/span>SUMAR.SI.<br \/>\n<span style=\"color: #e02b20; font-size: 10px; margin-right: 8px; margin-left: 28px;\">\u25cf<\/span>SUMAR.SI.CONJUNTO.<br \/>\n<span style=\"color: #e02b20; font-size: 10px; margin-right: 8px; margin-left: 28px;\">\u25cf<\/span>PROMEDIO.SI.<br \/>\n<span style=\"color: #e02b20; font-size: 10px; margin-right: 8px; margin-left: 28px;\">\u25cf<\/span>SI, SI.CONJUNTO.<br \/>\n<span style=\"color: #e02b20; font-size: 10px; margin-right: 8px; margin-left: 28px;\">\u25cf<\/span>Y \/ O.<br \/>\n<strong style=\"display: block; margin-top: 10px; margin-bottom: -3px; padding-left: 20px;\">TAULA DINAMIKOEI SARRERA<\/strong><br \/>\n<span style=\"color: #e02b20; font-size: 10px; margin-right: 8px; margin-left: 28px;\">\u25cf<\/span>Zer den taula dinamiko bat.<br \/>\n<span style=\"color: #e02b20; font-size: 10px; margin-right: 8px; margin-left: 28px;\">\u25cf<\/span>Taula dinamiko bat sortu.<br \/>\n<span style=\"color: #e02b20; font-size: 10px; margin-right: 8px; margin-left: 28px;\">\u25cf<\/span>Eremuak antolatu.<br \/>\n<span style=\"color: #e02b20; font-size: 10px; margin-right: 8px; margin-left: 28px;\">\u25cf<\/span>Informazioa iragazi.<br \/>\n<span style=\"color: #e02b20; font-size: 10px; margin-right: 8px; margin-left: 28px;\">\u25cf<\/span>Zenbaketak lortu.<br \/>\n<span style=\"color: #e02b20; font-size: 10px; margin-right: 8px; margin-left: 28px;\">\u25cf<\/span>Emaitzak eguneratu.[\/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; 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>Epea zabalik azaroaren 3ra 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\/FORMACIONES-2SEM-2026-3-2.png&#8221; title_text=&#8221;PRESTAKUNTZAK (2026ko 2. SEIHILEKOA) (3)&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.27.9&#8243; _module_preset=&#8221;default&#8221; border_radii=&#8221;on|16px|16px|16px|16px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_image][et_pb_button button_url=&#8221;https:\/\/forms.gle\/MnRoK2cdjmbniAAf6&#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; global_colors_info=&#8221;{}&#8221;][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>PrestakuntzaEmaten du: Eneko R\u00edpodasDatuak erabaki bihurtu: zer begiratu eta noiz jardun dakizunean, jarraipena aurrera egiteko tresna bihurtzen da. Excel jarraipenerako tresna gisa erabiltzen ikasiko duzu, datak eta erregistroak abisu eta adierazle bihurtuz, zain dauden kasuak, hurrengo jarduerak eta arreta behar duten egoera azkar identifikatzeko aukera ematen dutenak 6 orduko ikastaroa: azaroaren 10ean eta 17an izango [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":13788,"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-13783","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\/13783","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=13783"}],"version-history":[{"count":22,"href":"https:\/\/trabajosocialnavarra.org\/eu\/wp-json\/wp\/v2\/project\/13783\/revisions"}],"predecessor-version":[{"id":13841,"href":"https:\/\/trabajosocialnavarra.org\/eu\/wp-json\/wp\/v2\/project\/13783\/revisions\/13841"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/trabajosocialnavarra.org\/eu\/wp-json\/wp\/v2\/media\/13788"}],"wp:attachment":[{"href":"https:\/\/trabajosocialnavarra.org\/eu\/wp-json\/wp\/v2\/media?parent=13783"}],"wp:term":[{"taxonomy":"project_category","embeddable":true,"href":"https:\/\/trabajosocialnavarra.org\/eu\/wp-json\/wp\/v2\/project_category?post=13783"},{"taxonomy":"project_tag","embeddable":true,"href":"https:\/\/trabajosocialnavarra.org\/eu\/wp-json\/wp\/v2\/project_tag?post=13783"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}