{"id":20200,"date":"2021-06-23T14:58:44","date_gmt":"2021-06-23T12:58:44","guid":{"rendered":"https:\/\/entefire.it\/fire\/?post_type=product&p=20200"},"modified":"2024-05-03T16:33:36","modified_gmt":"2024-05-03T14:33:36","slug":"d2-15","status":"publish","type":"product","link":"https:\/\/entefire.it\/fire\/corsi\/d2-15\/","title":{"rendered":"[D2-15] Microsoft Excel 2 (uso dei pacchetti operativi Win)"},"content":{"rendered":"

[et_pb_section fb_built=”1″ fullwidth=”on” custom_padding_last_edited=”on|desktop” disabled_on=”on|off|off” admin_label=”Banner superiore” _builder_version=”4.5.0″ background_color=”#ffffff” max_width_tablet=”” max_width_phone=”” max_width_last_edited=”on|phone” custom_padding_tablet=”2px|0|2px|0|true|” custom_padding_phone=”” bottom_divider_color=”#ffffff” bottom_divider_height=”60px” bottom_divider_flip=”horizontal” animation_style=”slide” animation_direction=”top” animation_duration=”500ms” border_radii=”on|40px|40px|40px|40px” border_width_all=”4px” border_color_all=”#ffffff” box_shadow_style=”preset3″ padding_mobile=”off” global_module=”17110″ saved_tabs=”all” locked=”off” collapsed=”on” global_colors_info=”{}”][et_pb_fullwidth_slider show_content_on_mobile=”off” show_cta_on_mobile=”off” use_text_overlay=”off” arrows_custom_color=”#ffffff” dot_nav_custom_color=”#ffffff” disabled_on=”on|on|off” admin_label=”Fullwidth Slider” _builder_version=”4.17.4″ _dynamic_attributes=”link_option_url” header_level=”h1″ header_font=”Source Sans Pro|700|||||||” header_text_color=”#ffffff” header_font_size=”54px” body_font=”|600|||||||” body_text_color=”#ffffff” body_font_size=”24px” body_line_height=”1.4em” background_color=”#ffffff” background_enable_image=”off” min_height=”400px” height=”400px” max_height=”400px” custom_padding=”70px||70px||true|” custom_padding_tablet=”|||” custom_padding_phone=”|||” filter_brightness=”105%” auto=”on” auto_speed=”6000″ auto_ignore_hover=”on” hover_transition_duration=”1000ms” hover_transition_delay=”100ms” hover_transition_speed_curve=”ease-out” link_option_url=”@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF9saW5rX3VybF9wYWdlIiwic2V0dGluZ3MiOnsicG9zdF9pZCI6IjE5NDczIn19@” header_text_shadow_style=”preset1″ body_text_shadow_style=”preset1″ border_radii=”on|40px|40px|40px|40px” box_shadow_style=”preset3″ box_shadow_color=”rgba(0,0,0,0.1)” global_colors_info=”{}” button_text_size__hover_enabled=”off” button_one_text_size__hover_enabled=”off” button_two_text_size__hover_enabled=”off” button_text_color__hover_enabled=”off” button_one_text_color__hover_enabled=”off” button_two_text_color__hover_enabled=”off” button_border_width__hover_enabled=”off” button_one_border_width__hover_enabled=”off” button_two_border_width__hover_enabled=”off” button_border_color__hover_enabled=”off” button_one_border_color__hover_enabled=”off” button_two_border_color__hover_enabled=”off” button_border_radius__hover_enabled=”off” button_one_border_radius__hover_enabled=”off” button_two_border_radius__hover_enabled=”off” button_letter_spacing__hover_enabled=”off” button_one_letter_spacing__hover_enabled=”off” button_two_letter_spacing__hover_enabled=”off” button_bg_color__hover_enabled=”off” button_one_bg_color__hover_enabled=”off” button_two_bg_color__hover_enabled=”off”][et_pb_slide heading=”Formazione per la ripresa” button_text=”Torna all’elenco dei corsi” button_link=”@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF9saW5rX3VybF9wYWdlIiwic2V0dGluZ3MiOnsicG9zdF9pZCI6IjE5NDczIn19@” use_bg_overlay=”off” use_text_overlay=”on” text_overlay_color=”rgba(127,0,93,0.64)” arrows_custom_color=”#ffffff” dot_nav_custom_color=”#ffffff” text_border_radius=”60px” _builder_version=”4.17.4″ _dynamic_attributes=”button_link” header_font=”Source Sans Pro||||||||” header_text_color=”#ffffff” header_font_size=”60px” body_font=”||||||||” body_text_color=”#ffffff” body_font_size=”20px” body_line_height=”2.1em” background_enable_color=”off” background_image=”https:\/\/entefire.it\/fire\/wp-content\/uploads\/Formazione-per-la-ripresa-2.png” background_enable_image=”on” parallax=”on” parallax_method=”off” background_enable_video_mp4=”off” background_enable_video_webm=”off” custom_button=”on” button_use_icon=”on” button_icon=”H||divi||400″ button_icon_placement=”left” button_on_hover=”on” filter_saturate=”127%” header_font_size_tablet=”42px” header_font_size_phone=”30px” header_font_size_last_edited=”on|desktop” body_font_size_tablet=”20px” body_font_size_phone=”16px” body_font_size_last_edited=”on|desktop” body_line_height_tablet=”1.5em” body_line_height_phone=”” body_line_height_last_edited=”on|desktop” background_last_edited=”on|desktop” parallax_tablet=”off” background_size_tablet=”cover” background_position_tablet=”bottom_center” background_position_phone=”bottom_center” button_text_size_tablet=”22px” button_text_size_phone=”22px” button_text_size_last_edited=”on|tablet” global_colors_info=”{}” button_text_size__hover_enabled=”off” button_one_text_size__hover_enabled=”off” button_two_text_size__hover_enabled=”off” button_text_color__hover_enabled=”off” button_one_text_color__hover_enabled=”off” button_two_text_color__hover_enabled=”off” button_border_width__hover_enabled=”off” button_one_border_width__hover_enabled=”off” button_two_border_width__hover_enabled=”off” button_border_color__hover_enabled=”off” button_one_border_color__hover_enabled=”off” button_two_border_color__hover_enabled=”off” button_border_radius__hover_enabled=”off” button_one_border_radius__hover_enabled=”off” button_two_border_radius__hover_enabled=”off” button_letter_spacing__hover_enabled=”off” button_one_letter_spacing__hover_enabled=”off” button_two_letter_spacing__hover_enabled=”off” button_bg_color__hover_enabled=”off” button_one_bg_color__hover_enabled=”off” button_two_bg_color__hover_enabled=”off” sticky_transition=”on”]<\/p>\n

Corsi a voucher gratuiti | Cataloghi D1 \u2013 D2<\/span><\/p>\n

[\/et_pb_slide][\/et_pb_fullwidth_slider][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.16″ _module_preset=”default” locked=”off” global_colors_info=”{}”][et_pb_row _builder_version=”4.16″ _module_preset=”default” custom_padding=”50px|||||” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_wc_title _builder_version=”4.16″ _module_preset=”default” header_font=”|600|||||||” header_line_height=”1.4em” global_colors_info=”{}”][\/et_pb_wc_title][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_divider divider_weight=”3px” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.16″ _module_preset=”default” custom_padding=”0px||28px||false|false” locked=”off” global_colors_info=”{}”][et_pb_row column_structure=”3_5,2_5″ _builder_version=”4.16″ custom_padding=”||0px|||” global_colors_info=”{}”][et_pb_column type=”3_5″ _builder_version=”4.16″ global_colors_info=”{}”][et_pb_image src=”https:\/\/entefire.it\/fire\/wp-content\/uploads\/tag-iscrizioni-chiuse@large.png” alt=”Pre-iscrizioni aperte” title_text=”tag iscrizioni chiuse@large” _builder_version=”4.19.1″ _module_preset=”default” width=”80%” hover_enabled=”0″ locked=”off” global_colors_info=”{}” sticky_enabled=”0″][\/et_pb_image][et_pb_wc_meta separator=”|” _builder_version=”4.16″ global_colors_info=”{}”][\/et_pb_wc_meta][et_pb_wc_rating _builder_version=”4.16″ _module_preset=”default” rating_font_size=”20px” body_text_color=”#087ad7″ body_font_size=”15px” global_colors_info=”{}”][\/et_pb_wc_rating][et_pb_text _builder_version=”4.16″ text_line_height=”1.4em” global_colors_info=”{}”]<\/p>\n

Approfondisci la tua conoscenza di Excel!<\/p>\n

Questo corso inizia con un\u2019analisi approfondita delle principali funzioni di livello avanzato, ovvero le funzioni di data e ora, quelle di testo, funzioni logiche e condizionali, le importantissime funzioni di ricerca e riferimento.<\/p>\n

Si passa poi allo strumento pi\u00f9 potente per l\u2019analisi dei dati: le tabelle e i grafici Pivot che rappresentano il vero salto di qualit\u00e0 rispetto alla conoscenza base di Excel.<\/p>\n

Questo corso non tralascia neanche\u00a0le nuove funzioni della\u00a0versione 2020<\/strong>\u00a0di Excel 365: la potentissima e rivoluzionaria\u00a0CERCA.X(), che sostituir\u00e0 in pieno l\u2019obsoleta CERCA.VERT(), oltre alle funzioni\u00a0DATI.ORDINA(),\u00a0 UNICI(),\u00a0 TESTO.UNISCI(), CONCAT(),\u00a0FILTRO()\u00a0e l\u2019utilizzo delle\u00a0matrici dinamiche\u00a0che rivoluzioner\u00e0 il modo di calcolare per i prossimi 15 anni!<\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.16″ global_colors_info=”{}”][et_pb_image src=”https:\/\/entefire.it\/fire\/wp-content\/uploads\/xls2@2x.png” alt=”Comunicazione efficace” title_text=”xls2@2x” _builder_version=”4.16″ global_colors_info=”{}”][\/et_pb_image][et_pb_image src=”https:\/\/entefire.it\/fire\/wp-content\/uploads\/Corso-online@2x.png” alt=”Corso online” title_text=”Corso online” _builder_version=”4.16″ custom_margin=”||8px|||” custom_padding=”20px||20px||true|false” global_colors_info=”{}”][\/et_pb_image][et_pb_image src=”https:\/\/entefire.it\/fire\/wp-content\/uploads\/attestato@2x.png” title_text=”attestato@2x” _builder_version=”4.16″ custom_margin=”||12px|||” custom_padding=”20px||20px||true|false” global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ _module_preset=”default” locked=”off” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_testimonial author=”Mariagrazia” job_title=”Comune di Genova” portrait_url=”https:\/\/entefire.it\/fire\/wp-content\/uploads\/Logo-Comune-GE@2x.png” portrait_width=”110px” portrait_height=”110px” use_icon_font_size=”on” icon_font_size=”43px” _builder_version=”4.16″ _module_preset=”default” author_font=”|700|on||||||” author_font_size=”16px” position_font=”|600|||||||” position_text_color=”#087ad7″ custom_margin=”||||false|false” box_shadow_style=”preset2″ locked=”off” global_colors_info=”{}” transform_styles__hover_enabled=”off|desktop” transform_scale__hover_enabled=”off|desktop” transform_translate__hover_enabled=”off|desktop” transform_rotate__hover_enabled=”off|desktop” transform_skew__hover_enabled=”off|desktop” transform_origin__hover_enabled=”off|desktop” transform_scale__hover=”105%|105%”]<\/p>\n

Imparando ad utilizzare alcune potenzialit\u00e0 del programma che prima non conoscevo potr\u00f2 gestire ed interrogare i file di excel con metodi pi\u00f9 efficaci e certezza del risultato, le tabelle di pivot, per esempio, sono state una graditissima scoperta che migliorer\u00e0 il mio modo di lavorare, inoltre il docente \u00e8 preparato, disponibile e paziente. Consiglier\u00f2 il corso ai miei colleghi!!!!<\/span><\/p>\n

[\/et_pb_testimonial][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.16″ _module_preset=”default” background_color=”rgba(0,0,0,0.1)” width=”100%” max_width=”100%” module_alignment=”center” custom_margin=”10px||10px||false|false” custom_padding=”20px||9px||false|false” border_radii=”on|60px|60px|60px|60px” border_width_all=”2px” border_color_all=”#087ad7″ box_shadow_style=”preset2″ locked=”off” global_colors_info=”{}”][et_pb_row column_structure=”1_3,1_3,1_3″ _builder_version=”4.16″ background_enable_color=”off” custom_padding=”14px||6px|||” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”4.16″ global_colors_info=”{}”][et_pb_blurb title=”Durata” use_icon=”on” font_icon=”||divi||400″ icon_placement=”left” image_icon_width=”45px” _builder_version=”4.16″ icon_font_size=”45px” global_colors_info=”{}”]<\/p>\n

15 ore<\/strong><\/p>\n

[\/et_pb_blurb][\/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.16″ global_colors_info=”{}”][et_pb_blurb title=”Frequenza” use_icon=”on” font_icon=”||divi||400″ icon_placement=”left” image_icon_width=”45px” _builder_version=”4.16″ icon_font_size=”45px” global_colors_info=”{}”]<\/p>\n

5 lezioni da 3 ore<\/strong>
1 volta a settimana<\/p>\n

[\/et_pb_blurb][\/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.16″ global_colors_info=”{}”][et_pb_blurb title=”Orari” use_icon=”on” font_icon=”||divi||400″ icon_placement=”left” image_icon_width=”45px” _builder_version=”4.16″ icon_font_size=”45px” global_colors_info=”{}”]<\/p>\n

9.30-12.30<\/strong>\u00a0oppure
<\/span>14.30-17.30<\/strong><\/p>\n

[\/et_pb_blurb][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ _module_preset=”default” custom_padding=”13px||0px|||” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_divider _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_divider][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”1_3,1_3,1_3″ _builder_version=”4.16″ _module_preset=”default” custom_padding=”0px||5px|||” global_colors_info=”{}”][et_pb_column type=”1_3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_blurb title=”Costo” use_icon=”on” font_icon=”||divi||400″ icon_placement=”left” image_icon_width=”45px” _builder_version=”4.16″ icon_font_size=”45px” global_colors_info=”{}”]<\/p>\n

Il corso \u00e8 gratuito<\/strong><\/p>\n

[\/et_pb_blurb][\/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_blurb title=”Modalit\u00e0” use_icon=”on” font_icon=”||divi||400″ icon_placement=”left” image_icon_width=”45px” _builder_version=”4.16″ icon_font_size=”45px” locked=”off” global_colors_info=”{}”]<\/p>\n

On-line<\/strong> live<\/strong> con il docente<\/p>\n

[\/et_pb_blurb][\/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_blurb title=”Assenze” use_icon=”on” font_icon=”||divi||400″ icon_placement=”left” image_icon_width=”45px” _builder_version=”4.16″ icon_font_size=”45px” locked=”off” global_colors_info=”{}”]<\/p>\n

Max 1 lezione<\/strong> (3 ore)<\/span><\/p>\n

[\/et_pb_blurb][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ _module_preset=”default” custom_padding=”13px||0px|||” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_divider _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_divider][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”2_3,1_3″ _builder_version=”4.16″ background_enable_color=”off” custom_padding=”4px||0px|||” global_colors_info=”{}”][et_pb_column type=”2_3″ _builder_version=”4.16″ global_colors_info=”{}”][et_pb_blurb title=”Competenze ingresso” use_icon=”on” font_icon=”||divi||400″ icon_placement=”left” image_icon_width=”45px” _builder_version=”4.16″ icon_font_size=”45px” global_colors_info=”{}”]<\/p>\n

\n
\n
\n

Conoscenza base di Excel oppure partecipazione al modulo 1<\/strong><\/a><\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n

[\/et_pb_blurb][\/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.16″ global_colors_info=”{}”][et_pb_blurb title=”Difficolt\u00e0” use_icon=”on” font_icon=”||divi||400″ icon_placement=”left” image_icon_width=”45px” _builder_version=”4.16″ icon_font_size=”45px” global_colors_info=”{}”]<\/p>\n

\"\"<\/p>\n

[\/et_pb_blurb][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ _module_preset=”default” custom_padding=”14px||0px|||” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_divider _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_divider][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”2_3,1_3″ _builder_version=”4.5.0″ _module_preset=”default” custom_margin=”4px|auto||auto||” custom_padding=”0px||12px|||” global_module=”20804″ saved_tabs=”all” locked=”off” global_colors_info=”{}”][et_pb_column type=”2_3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_blurb title=”Destinatari” use_icon=”on” font_icon=”||divi||400″ icon_placement=”left” image_icon_width=”45px” content_max_width=”100%” _builder_version=”4.16″ custom_margin=”0px||0px||false|false” custom_padding=”||8px||false|false” icon_font_size=”45px” locked=”off” global_colors_info=”{}”]<\/p>\n

12 persone fisiche occupate <\/strong>(ovvero: dipendenti \/ soci \/ titolari di micro, piccole, medie, grandi imprese e liberi professionisti), anche se in cassa integrazione, residenti e\/o domiciliati in Liguria, la cui azienda abbia almeno una sede in Regione Liguria.<\/p>\n

[\/et_pb_blurb][\/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_button button_url=”@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF9saW5rX3VybF9wYWdlIiwic2V0dGluZ3MiOnsicG9zdF9pZCI6IjE5NDczIn19@” button_text=”Pi\u00f9 informazioni” button_alignment=”center” _builder_version=”4.16″ _dynamic_attributes=”button_url” _module_preset=”default” custom_margin=”31px||||false|false” custom_padding=”||||false|false” global_colors_info=”{}”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ _module_preset=”default” custom_padding=”17px||0px|||” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_divider _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_divider][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”2_3,1_3″ _builder_version=”4.16″ _module_preset=”default” custom_margin=”4px|auto||auto||” custom_padding=”0px||0px|||” global_module=”24931″ saved_tabs=”all” locked=”off” global_colors_info=”{}”][et_pb_column type=”2_3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_blurb title=”Iscrizione e date” use_icon=”on” font_icon=”||divi||400″ icon_placement=”left” image_icon_width=”45px” content_max_width=”100%” _builder_version=”4.19.0″ custom_margin=”0px||0px||false|false” custom_padding=”||31px||false|false” icon_font_size=”45px” locked=”off” global_colors_info=”{}”]<\/p>\n

Il catalogo chiuder\u00e0 il 30 novembre<\/strong>, quindi ci sono pochi pochi disponibili, tutti con partenza tra gennaio e febbraio.<\/strong> Per sapere a quale edizione puoi partecipare, mandaci una mail cliccando sul pulsante.<\/p>\n

[\/et_pb_blurb][\/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_button button_url=”mailto:formazione@entefire.it” button_text=”Invia mail di richiesta” button_alignment=”center” _builder_version=”4.19.0″ _module_preset=”default” custom_margin=”31px||||false|false” custom_padding=”||||false|false” global_colors_info=”{}”][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.16″ _module_preset=”default” custom_padding=”30px||33px||false|false” locked=”off” global_colors_info=”{}”][et_pb_row column_structure=”3_5,2_5″ admin_label=”Descrizione e immagini del corso” _builder_version=”4.16″ collapsed=”off” global_colors_info=”{}”][et_pb_column type=”3_5″ _builder_version=”4.16″ global_colors_info=”{}”][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n

Programma del corso<\/h2>\n

[\/et_pb_text][et_pb_accordion _builder_version=”4.16″ border_width_all=”3px” border_color_all=”#c1c1c1″ locked=”off” global_colors_info=”{}”][et_pb_accordion_item title=”Introduzione al corso” open=”on” _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n

    \n
  • Ripasso sulla sintassi di formule e funzioni, riferimenti relativi ed assoluti<\/li>\n
  • Novit\u00e0 365\/2020: le nuovissime matrici dinamiche (come cambia il metodo di lavoro)<\/li>\n<\/ul>\n

    [\/et_pb_accordion_item][et_pb_accordion_item title=”Funzioni di data e ora” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” open=”off”]<\/p>\n

      \n
    • L\u2019importanza di gestire date e orari<\/li>\n
    • Calcoli aritmetici sulle date<\/li>\n
    • Funzioni di data<\/strong>: GIORNI(), GIORNO(), MESE(), ANNO(), FINE.MESE(), GIORNO.SETTIMANA(), GIORNI.LAVORIATIVI.TOT.INTL(), GIORNO.LAVORATIVO.INTL()<\/li>\n
    • Funzioni di ora<\/strong>:\u00a0OGGI(), ADESSO(), ORARIO(), ORA(), MINUTO(), SECONDO(), ORARIO.VALORE()<\/li>\n
    • Lavorare con date e orari contemporaneamente<\/li>\n
    • Il calcolo della Pasqua<\/li>\n<\/ul>\n

      [\/et_pb_accordion_item][et_pb_accordion_item title=”Funzioni di testo” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” open=”off”]<\/p>\n

        \n
      • L\u2019importanza delle funzioni di testo (esempi pratici)<\/li>\n
      • Le funzioni di testo: LUNGHEZZA(), CONCATENA(), TESTO(), SINISTRA(), DESTRA(), STRINGA.ESTRAI(), TROVA(), RICERCA(), SOSTITUISCI()<\/li>\n
      • Novit\u00e0 365\/2020<\/strong>: TESTO.UNISCI(), CONCAT()<\/li>\n<\/ul>\n

        [\/et_pb_accordion_item][et_pb_accordion_item title=”Funzioni logiche e condizionali” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” open=”off”]<\/p>\n

          \n
        • Cosa sono le funzioni logiche<\/li>\n
        • Gli operatori di confronto<\/li>\n
        • Funzioni logiche: E(), O(), NON()<\/li>\n
        • Funzioni condizionali di base: SE(), SOMMA.SE(), CONTA.SE(), MEDIA.SE()<\/li>\n
        • Funzioni condizionali avanzate: SOMMA.PIU.SE(), MEDIA.PIU.SE(), CONTA.PIU.SE()<\/li>\n
        • Novit\u00e0 365\/2020<\/strong>: PIU.SE(), MIN.PIU.SE(), MAX.PIU.SE()<\/li>\n<\/ul>\n

          [\/et_pb_accordion_item][et_pb_accordion_item title=”Funzioni di ricerca ed estrazione” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” open=”off”]<\/p>\n

            \n
          • Panoramica delle funzioni di ricerca e analisi dei limiti<\/li>\n
          • Funzioni di ricerca: CERCA.VERT(), CERCA.ORIZZ(), INDICE(), CONFRONTA()<\/li>\n
          • Superare i limiti di Excel con le nuove funzioni\u00a0365\/2020<\/strong>: CERCA.X(), UNICI(), FILTRO(), DATI.ORDINA()<\/li>\n
          • Le nuove matrici dinamiche<\/li>\n<\/ul>\n

            [\/et_pb_accordion_item][et_pb_accordion_item title=”Tabelle e grafici Pivot” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” open=”off”]<\/p>\n

              \n
            • Tabelle Pivot<\/li>\n
            • Le funzioni nelle tabelle Pivot<\/li>\n
            • Interpretare i dati nelle tabelle Pivot<\/li>\n
            • Filtri standard e filtri avanzati<\/li>\n
            • Tre tipi di Pivot<\/li>\n
            • I grafici Pivot<\/li>\n<\/ul>\n

              <\/h3>\n

              [\/et_pb_accordion_item][\/et_pb_accordion][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.16″ global_colors_info=”{}”][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n

              Recensioni<\/h2>\n

              [\/et_pb_text][et_pb_wc_reviews show_avatar=”off” show_count=”off” disabled_on=”off|off|off” _builder_version=”4.5.0″ _module_preset=”default” form_field_background_color=”#ffffff” form_field_text_color=”#0148aa” form_field_custom_margin=”8px||||false|false” header_font=”|700|||||||” header_text_align=”center” header_text_color=”#494949″ title_text_color=”#494949″ meta_text_color=”#da2c2a” meta_line_height=”2em” body_text_color=”#494949″ rating_text_color=”#da2c2a” rating_font_size=”24px” background_color=”#ffd954″ button_alignment=”center” custom_margin=”||40px|||” custom_padding=”17px|15px|0px|15px|false|false” animation_style=”slide” animation_direction=”right” border_radii=”on|30px|30px|30px|30px” border_width_all=”3px” border_color_all=”#ffffff” border_radii_fields=”on|10px|10px|10px|10px” border_width_all_fields=”1px” border_color_all_fields=”#c1c1c1″ box_shadow_style=”preset2″ box_shadow_style_fields=”preset3″ global_module=”15197″ saved_tabs=”all” locked=”off” global_colors_info=”{}”][\/et_pb_wc_reviews][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.9.10″ _module_preset=”default” custom_padding=”50px||18px|||” global_module=”20800″ saved_tabs=”all” global_colors_info=”{}”][et_pb_row column_structure=”2_5,3_5″ _builder_version=”4.16″ _module_preset=”default” custom_margin=”-17px|auto||auto||” custom_padding=”||7px|||” locked=”off” global_colors_info=”{}”][et_pb_column type=”2_5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.16″ text_orientation=”center” custom_margin=”||||false|false” custom_padding=”4px|||24px|false|false” locked=”off” global_colors_info=”{}”]<\/p>\n

              I corsi sono finanziati dal Programma Operativo Regione Liguria Fondo Sociale Europeo 2014-2020 Asse I “Occupazione – Formazione per la Ripresa”<\/p>\n

              [\/et_pb_text][\/et_pb_column][et_pb_column type=”3_5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_image src=”https:\/\/entefire.it\/fire\/wp-content\/uploads\/Loghi-regione.png” alt=”Loghi Istituzioni” title_text=”Loghi Istituzioni” align=”center” _builder_version=”4.16″ width=”400px” custom_margin=”8px||0px||false|false” custom_padding=”0px||0px||false|false” locked=”off” global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_divider _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

              Corsi a voucher gratuiti | Cataloghi D1 \u2013 D2Approfondisci la tua conoscenza di Excel! Questo corso inizia con un\u2019analisi approfondita delle principali funzioni di livello avanzato, ovvero le funzioni di data e ora, quelle di testo, funzioni logiche e condizionali, le importantissime funzioni di ricerca e riferimento. Si passa poi allo strumento pi\u00f9 potente per […]<\/p>\n","protected":false},"featured_media":22218,"comment_status":"open","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":""},"product_brand":[],"product_cat":[281,54],"product_tag":[172,205,176],"class_list":{"0":"post-20200","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-corsi-finanziati","7":"product_cat-corsi-online","8":"product_tag-excel","9":"product_tag-foglio-elettronico","10":"product_tag-windows","12":"first","13":"outofstock","14":"virtual","15":"taxable","16":"product-type-simple"},"_links":{"self":[{"href":"https:\/\/entefire.it\/fire\/wp-json\/wp\/v2\/product\/20200","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/entefire.it\/fire\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/entefire.it\/fire\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/entefire.it\/fire\/wp-json\/wp\/v2\/comments?post=20200"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/entefire.it\/fire\/wp-json\/wp\/v2\/media\/22218"}],"wp:attachment":[{"href":"https:\/\/entefire.it\/fire\/wp-json\/wp\/v2\/media?parent=20200"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/entefire.it\/fire\/wp-json\/wp\/v2\/product_brand?post=20200"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/entefire.it\/fire\/wp-json\/wp\/v2\/product_cat?post=20200"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/entefire.it\/fire\/wp-json\/wp\/v2\/product_tag?post=20200"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}