Obiettivi del corso
<p style='margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family:"Aptos",sans-serif;text-align:justify;line-height:115%;' data-pasted="true"><span style='font-family:"Arial",sans-serif;'>Questo corso ha lo scopo di affrontare tutti i più importanti strumenti dell’interfaccia Microsoft Excel. L’obiettivo è quello di <strong>comprendere la logica di funzionamento del programma Excel e imparare ad utilizzare gli strumenti più importanti</strong>. Lo strumento si configura oggi come uno strumento imprescindibile e trasversale, impiegato nelle diverse funzioni organizzative (amministrazione, contabilità, segreteria, area commerciale, gestione dei team, ricerca e sviluppo, ecc). Acquisire conoscenza e padronanza di Excel è un asset importante nella propria crescita professionale dal momento che è sicuramente il programma informatico maggiormente utilizzato e, di conseguenza, il più importante nel lavoro di oggi.</span></p>
Contenuti del corso
<div style='margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family:"Aptos",sans-serif;' data-pasted="true"><ul style="margin-bottom:0cm;list-style-type: disc;"><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><b><span style='font-family:"Arial",sans-serif;'>Concetti base</span></b></li></ul></div><div style='margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family:"Aptos",sans-serif;'><ul style="margin-bottom:0cm;list-style-type: circle;margin-left: 43.4px;"><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Interfaccia</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Selezione e visualizzazione dei dati</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Operazioni su interi fogli</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Personalizzazione interfaccia</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Tabelle e stampa</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Formattazione celle</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Indirizzamento relativo, assoluto e misto</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Riempimento automatico dati</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Formattazione condizionale</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Sintassi delle formule<br/> <br/> </span></li></ul></div><div style='margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family:"Aptos",sans-serif;'><ul style="margin-bottom:0cm;list-style-type: disc;"><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><b><span style='font-family:"Arial",sans-serif;'>Funzioni</span></b></li></ul></div><div style='margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family:"Aptos",sans-serif;'><ul style="margin-bottom:0cm;list-style-type: circle;margin-left: 43.4px;"><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Annullamento e ripristino operazioni</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Appunti</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Ordinamento dei dati</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Filtri</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Ricerca e sostituzione</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Subtotali</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Modulo inserimento dati</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Funzioni MAX e MIN<br/> <br/> </span></li></ul></div><div style='margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family:"Aptos",sans-serif;'><ul style="margin-bottom:0cm;list-style-type: disc;"><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><b><span style='font-family:"Arial",sans-serif;'>Funzioni avanzate</span></b></li></ul></div><div style='margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family:"Aptos",sans-serif;'><ul style="margin-bottom:0cm;list-style-type: circle;margin-left: 43.4px;"><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Funzioni Annidate</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Funzioni logiche</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Codici di errore</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Funzioni di controllo errori</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Categorie di funzioni</span></li><div style='margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family:"Aptos",sans-serif;'><ul style="margin-bottom: 0cm;list-style-type: square;"><li style="margin-top: 0cm;margin-right: 0cm;margin-bottom: 8pt;font-size:15px;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Testo</span></li><li style="margin-top: 0cm;margin-right: 0cm;margin-bottom: 8pt;font-size:15px;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Ricerca e riferimento</span></li><li style="margin-top: 0cm;margin-right: 0cm;margin-bottom: 8pt;font-size:15px;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Conteggio</span></li><li style="margin-top: 0cm;margin-right: 0cm;margin-bottom: 8pt;font-size:15px;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Arrotondamento</span></li></ul></div></ul></div><p style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family:"Aptos",sans-serif;line-height:115%;"></p><div style='margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family:"Aptos",sans-serif;'><ul style="margin-bottom:0cm;list-style-type: disc;"><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><b><span style='font-family:"Arial",sans-serif;'>Calcoli fattore temporale</span></b></li></ul></div><div style='margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family:"Aptos",sans-serif;'><ul style="margin-bottom:0cm;list-style-type: circle;margin-left: 43.4px;"><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Protezione delle celle</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Logica temporale</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Categorie di funzioni – data e ora<br/> <br/> </span></li></ul></div><div style='margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family:"Aptos",sans-serif;'><ul style="margin-bottom:0cm;list-style-type: disc;"><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><b><span style='font-family:"Arial",sans-serif;'>Importazione e Gestione dati</span></b></li></ul></div><div style='margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family:"Aptos",sans-serif;'><ul style="margin-bottom:0cm;list-style-type: circle;margin-left: 43.4px;"><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Altri formati di dati</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Testo in colonne</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Importazione dei dati<br/> <br/> </span></li></ul></div><div style='margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family:"Aptos",sans-serif;'><ul style="margin-bottom:0cm;list-style-type: disc;"><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><b><span style='font-family:"Arial",sans-serif;'>Grafici</span></b></li></ul></div><div style='margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family:"Aptos",sans-serif;'><ul style="margin-bottom:0cm;list-style-type: circle;margin-left: 43.4px;"><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Utilità dei grafici</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Tipi di grafici</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Grafici SparkLine<br/> <br/> </span></li></ul></div><div style='margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family:"Aptos",sans-serif;'><ul style="margin-bottom:0cm;list-style-type: disc;"><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><b><span style='font-family:"Arial",sans-serif;'>Analisi consolidata</span></b></li></ul></div><div style='margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family:"Aptos",sans-serif;'><ul style="margin-bottom:0cm;list-style-type: circle;margin-left: 43.4px;"><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Strutturare i dati in un foglio</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Inserire le righe di riepilogo (SUBTOTALE)</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Impostazioni di raggruppamento</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Convalida Dati</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Consolidare i dati in più fogli di lavoro</span></li></ul></div><p style="margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:36.0pt;font-size:11.0pt;font-family:"Aptos",sans-serif;line-height:115%;"></p><div style='margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family:"Aptos",sans-serif;'><ul style="margin-bottom:0cm;list-style-type: disc;"><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><b><span style='font-family:"Arial",sans-serif;'>Tabella Pivot</span></b></li></ul></div><div style='margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family:"Aptos",sans-serif;'><ul style="margin-bottom:0cm;list-style-type: circle;margin-left: 43.4px;"><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Scopo di una tabella Pivot</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Creazione di una tabella Pivot</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Scegliere il giusto formato per i campi</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Ordinare i dati in una Pivot</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Modificare la visualizzazione dei dati</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Sequenza temporale</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Filtri</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Campi calcolati</span></li><li style="margin-top:0cm;margin-right:0cm;margin-bottom:8.0pt;margin-left:0cm;font-size:11.0pt;font-family: initial;"><span style='font-family:"Arial",sans-serif;'>Aggiungere e aggiornare i dati</span></li></ul></div>
