{"IssuedOn":"03/11/2021 23:00:00","LearnerEmail":"tramontano.melissa@gmail.com","UriAssertion":"https://api.cboxiqc.com/api/v1/OpenBadge/Assertion?idassertion=21797","Name":"Masterclass Excel for Finance | Advanced | Streaming","Description":"<div>Il badge è rilasciato ai soli partecipanti alla Masterclass in Streaming che hanno completato la fruizione dei contenuti.</div>\n<br class=\"t-last-br\" />\n<br />\n<br class=\"t-last-br\" />\n<br />\n<br />","BadgeType":"Competence Badge","LinkIssuer":"https://www.cboxiqc.com/Companies/ProfileById/1152","EventDateStart":"01/11/2021 23:00:00","HoursDuration":"10","Objectives":"<p>L'attestato testimonia la partecipazione alla Masterclass Excel for Finance di livello Advanced, tenuta in modalità Streaming.</p>\n<p>Il partecipante, con la guida del docente Francesco Strano, già manager in multinazionali di telecomunicazioni, è stato guidato attraverso i principali strumenti di Excel per utilizzarlo al massimo delle potenzialità, fino alla costruzione \"passo passo\" di una Dashboard aziendale, grafici avanzati, e alla realizzazione di analisi su portafogli diversificati di azioni. </p>","Knowledge":"<p dir=\"ltr\" id=\"docs-internal-guid-31ac63a9-7fff-f951-b8e6-da7e1ec6e26d\" style=\"margin-top: 12pt; margin-bottom: 12pt; line-height: 1.38;\">EXCEL COME FOGLIO DI CALCOLO </p>\n<p dir=\"ltr\" style=\"margin-top: 12pt; margin-bottom: 12pt; line-height: 1.38;\">Data Base & Template</p>\n<ul style=\"margin-top: 0px; margin-bottom: 0px;\">\n <li dir=\"ltr\" aria-level=\"1\" style=\"color: #000000; background-color: transparent; list-style-type: disc; text-decoration: none;\">\n <p dir=\"ltr\" role=\"presentation\" style=\"margin-top: 12pt; margin-bottom: 0pt; line-height: 1.38;\">Un Template, step by step: dal disegno alla realizzazione</p>\n </li>\n <li dir=\"ltr\" aria-level=\"1\" style=\"color: #000000; background-color: transparent; list-style-type: disc; text-decoration: none;\">\n <p dir=\"ltr\" role=\"presentation\" style=\"margin-top: 0pt; margin-bottom: 0pt; line-height: 1.38;\">Gli strumenti avanzati di Excel</p>\n <ul style=\"margin-top: 0px; margin-bottom: 0px;\">\n <li dir=\"ltr\" aria-level=\"2\" style=\"color: #000000; background-color: transparent; list-style-type: circle; text-decoration: none;\">\n <p dir=\"ltr\" role=\"presentation\" style=\"margin-top: 0pt; margin-bottom: 0pt; line-height: 1.38;\">Dai range alle tabelle dati</p>\n </li>\n <li dir=\"ltr\" aria-level=\"2\" style=\"color: #000000; background-color: transparent; list-style-type: circle; text-decoration: none;\">\n <p dir=\"ltr\" role=\"presentation\" style=\"margin-top: 0pt; margin-bottom: 0pt; line-height: 1.38;\">Dai filtri agli slicer</p>\n </li>\n <li dir=\"ltr\" aria-level=\"2\" style=\"color: #000000; background-color: transparent; list-style-type: circle; text-decoration: none;\">\n <p dir=\"ltr\" role=\"presentation\" style=\"margin-top: 0pt; margin-bottom: 0pt; line-height: 1.38;\">Dalle pivot alle power pivot</p>\n </li>\n <li dir=\"ltr\" aria-level=\"2\" style=\"color: #000000; background-color: transparent; list-style-type: circle; text-decoration: none;\">\n <p dir=\"ltr\" role=\"presentation\" style=\"margin-top: 0pt; margin-bottom: 0pt; line-height: 1.38;\">Funzioni “avanzate”: Indice, Confronta, Se.errore</p>\n </li>\n <li dir=\"ltr\" aria-level=\"2\" style=\"color: #000000; background-color: transparent; list-style-type: circle; text-decoration: none;\">\n <p dir=\"ltr\" role=\"presentation\" style=\"margin-top: 0pt; margin-bottom: 0pt; line-height: 1.38;\">Gli strumenti di protezione di un template</p>\n <ul style=\"margin-top: 0px; margin-bottom: 0px;\">\n <li dir=\"ltr\" aria-level=\"3\" style=\"color: #000000; background-color: transparent; list-style-type: square; text-decoration: none;\">\n <p dir=\"ltr\" role=\"presentation\" style=\"margin-top: 0pt; margin-bottom: 0pt; line-height: 1.38;\">Esercitazione #1:Template per il confronto tra la performance di due azioni</p>\n </li>\n <li dir=\"ltr\" aria-level=\"3\" style=\"color: #000000; background-color: transparent; list-style-type: square; text-decoration: none;\">\n <p dir=\"ltr\" role=\"presentation\" style=\"margin-top: 0pt; margin-bottom: 12pt; line-height: 1.38;\">Esercitazione #2:Template per consuntivazione performance (parte 1)</p>\n </li>\n </ul>\n </li>\n </ul>\n </li>\n</ul>\n<p dir=\"ltr\" style=\"margin-top: 12pt; margin-bottom: 12pt; line-height: 1.38;\">EXCEL COME STRUMENTO PER LA “DATA ANALYSIS” E LA “DATA VISUALIZATION”</p>\n<p dir=\"ltr\" style=\"margin-top: 12pt; margin-bottom: 12pt; line-height: 1.38;\">Dashboard</p>\n<ul style=\"margin-top: 0px; margin-bottom: 0px;\">\n <li dir=\"ltr\" aria-level=\"1\" style=\"color: #000000; background-color: transparent; list-style-type: disc; text-decoration: none;\">\n <p dir=\"ltr\" role=\"presentation\" style=\"margin-top: 12pt; margin-bottom: 0pt; line-height: 1.38;\">Dal Template …alla Dashboard</p>\n <ul style=\"margin-top: 0px; margin-bottom: 0px;\">\n <li dir=\"ltr\" aria-level=\"2\" style=\"color: #000000; background-color: transparent; list-style-type: circle; text-decoration: none;\">\n <p dir=\"ltr\" role=\"presentation\" style=\"margin-top: 0pt; margin-bottom: 0pt; line-height: 1.38;\">Grafici avanzati</p>\n </li>\n <li dir=\"ltr\" aria-level=\"2\" style=\"color: #000000; background-color: transparent; list-style-type: circle; text-decoration: none;\">\n <p dir=\"ltr\" role=\"presentation\" style=\"margin-top: 0pt; margin-bottom: 0pt; line-height: 1.38;\">Grafici Pivot e grafici dinamici</p>\n </li>\n <li dir=\"ltr\" aria-level=\"2\" style=\"color: #000000; background-color: transparent; list-style-type: circle; text-decoration: none;\">\n <p dir=\"ltr\" role=\"presentation\" style=\"margin-top: 0pt; margin-bottom: 0pt; line-height: 1.38;\">I “semafori”</p>\n <ul style=\"margin-top: 0px; margin-bottom: 0px;\">\n <li dir=\"ltr\" aria-level=\"3\" style=\"color: #000000; background-color: transparent; list-style-type: square; text-decoration: none;\">\n <p dir=\"ltr\" role=\"presentation\" style=\"margin-top: 0pt; margin-bottom: 0pt; line-height: 1.38;\">Esercitazione #3: Grafico dinamico di due azioni</p>\n </li>\n <li dir=\"ltr\" aria-level=\"3\" style=\"color: #000000; background-color: transparent; list-style-type: square; text-decoration: none;\">\n <p dir=\"ltr\" role=\"presentation\" style=\"margin-top: 0pt; margin-bottom: 12pt; line-height: 1.38;\">Esercitazione #4: una dashboard aziendale per sintesi KPI</p>\n </li>\n </ul>\n </li>\n </ul>\n </li>\n</ul>\n<p dir=\"ltr\" style=\"margin-top: 12pt; margin-bottom: 12pt; line-height: 1.38;\">EXCEL COME AMBIENTE DI SVILUPPO</p>\n<p dir=\"ltr\" style=\"margin-top: 12pt; margin-bottom: 12pt; line-height: 1.38;\">La prima MACRO</p>\n<ul style=\"margin-top: 0px; margin-bottom: 0px;\">\n <li dir=\"ltr\" aria-level=\"1\" style=\"color: #000000; background-color: transparent; list-style-type: disc; text-decoration: none;\">\n <p dir=\"ltr\" role=\"presentation\" style=\"margin-top: 12pt; margin-bottom: 0pt; line-height: 1.38;\">3 tipologie di MACRO</p>\n </li>\n <li dir=\"ltr\" aria-level=\"1\" style=\"color: #000000; background-color: transparent; list-style-type: disc; text-decoration: none;\">\n <p dir=\"ltr\" role=\"presentation\" style=\"margin-top: 0pt; margin-bottom: 0pt; line-height: 1.38;\">il registratore di MACRO e i pulsanti</p>\n <ul style=\"margin-top: 0px; margin-bottom: 0px;\">\n <li dir=\"ltr\" aria-level=\"2\" style=\"color: #000000; background-color: transparent; list-style-type: circle; text-decoration: none;\">\n <p dir=\"ltr\" role=\"presentation\" style=\"margin-top: 0pt; margin-bottom: 12pt; line-height: 1.38;\">Esercitazione #5: Macro per aggiornamento di una Dashboard/Pivot, tramite pulsante</p>\n </li>\n </ul>\n </li>\n</ul>\nEsercitazione #6: Macro per convertire un file .csv in formato .xls in un click<br />","Valutation":"Tracciamento della fruizione ad opera del tutor.","Teacher":"Francesco Strano, già Head of Innovative Solutions & Go-to Market Vodafone, ora\n<div class=\"text-body-medium break-words\"> Digital Solutions in Piramis.<br class=\"t-last-br\" />\n</div>","OtherInfo":"<p style=\"text-align: center;\"><a class=\"button force-shadow color1 text-center\" style=\"color: #ffffff;\nbackground-color: #4963ae; height: auto; margin: 0px 3px 0.75rem 0px; padding: 0.55rem 1.5rem; border:\n2px solid #4963ae; text-align: center; letter-spacing: 1px;\" href=\"https://shop.startingfinance.com/collections/masterclass/products/investing-insights-starter-streaming\" target=\"-blank\" rel=\"noopener noreferrer\" data-cp-link=\"1\" data-icon=\"fa-edit\">CLICCA QUI per la pagina Masterclass</a></p>"}